功能介绍
管理员:首页,个人中心,用户管理,音乐类型管理,音乐信息管理,音乐专辑管理,fm电台管理,音乐论坛管理,系统管理等
普通用户:登录注册、首页、音乐信息、音乐专辑、音乐论坛、我的等
数据库脚本
/*
Navicat Premium Data Transfer
Source Server : root
Source Server Type : MySQL
Source Server Version : 50726
Source Host : localhost:3306
Source Schema : ssmxtg83
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 25/04/2022 10:45:29
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`adminid` bigint(20) NULL DEFAULT NULL COMMENT '管理员id',
`ask` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '提问',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复',
`isreply` int(11) NULL DEFAULT NULL COMMENT '是否回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1645177432898 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线咨询' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES (61, '2022-04-23 17:33:23', 1, 1, '提问1', '回复1', 1);
INSERT INTO `chat` VALUES (62, '2022-04-23 17:33:23', 2, 2, '提问2', '回复2', 2);
INSERT INTO `chat` VALUES (63, '2022-04-23 17:33:23', 3, 3, '提问3', '回复3', 3);
INSERT INTO `chat` VALUES (64, '2022-04-23 17:33:23', 4, 4, '提问4', '回复4', 4);
INSERT INTO `chat` VALUES (65, '2022-04-23 17:33:23', 5, 5, '提问5', '回复5', 5);
INSERT INTO `chat` VALUES (66, '2022-04-23 17:33:23', 6, 6, '提问6', '回复6', 6);
INSERT INTO `chat` VALUES (1645177246670, '2022-04-23 17:33:23', 1645177126939, NULL, '的发是发多少', NULL, 0);
INSERT INTO `chat` VALUES (1645177432897, '2022-04-23 17:33:23', 1645177126939, 1, NULL, '时代发顺丰电商6655', NULL);
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称',
`value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (1, 'picture1', 'upload/1645177096014.jpg');
INSERT INTO `config` VALUES (2, 'picture2', 'upload/picture2.jpg');
INSERT INTO `config` VALUES (3, 'picture3', 'upload/picture3.jpg');
-- ----------------------------
-- Table structure for discussfmdiantai
-- ----------------------------
DROP TABLE IF EXISTS `discussfmdiantai`;
CREATE TABLE `discussfmdiantai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1645177221747 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'fm电台评论表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of discussfmdiantai
-- ----------------------------
INSERT INTO `discussfmdiantai` VALUES (121, '2022-04-23 17:33:23', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussfmdiantai` VALUES (122, '2022-04-23 17:33:23', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussfmdiantai` VALUES (123, '2022-04-23 17:33:23', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussfmdiantai` VALUES (124, '2022-04-23 17:33:23', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussfmdiantai` VALUES (125, '2022-04-23 17:33:23', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussfmdiantai` VALUES (126, '2022-04-23 17:33:23', 6, 6, '用户名6', '评论内容6', '回复内容6');
INSERT INTO `discussfmdiantai` VALUES (1645177221746, '2022-04-23 17:33:23', 1645177087228, 1645177126939, '11', '水电费时代444', '');
-- ----------------------------
-- Table structure for discussyinlexinxi
-- ----------------------------
DROP TABLE IF EXISTS `discussyinlexinxi`;
CREATE TABLE `discussyinlexinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1645177169903 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '音乐信息评论表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of discussyinlexinxi
-- ----------------------------
INSERT INTO `discussyinlexinxi` VALUES (101, '2022-04-23 17:33:23', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussyinlexinxi` VALUES (102, '2022-04-23 17:33:23', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussyinlexinxi` VALUES (103, '2022-04-23 17:33:23', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussyinlexinxi` VALUES (104, '2022-04-23 17:33:23', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussyinlexinxi` VALUES (105, '2022-04-23 17:33:23', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussyinlexinxi` VALUES (106, '2022-04-23 17:33:23', 6, 6, '用户名6', '评论内容6', '回复内容6');
INSERT