311[计算机毕业设计]基于SSM游戏账号交易系统-源码-视频讲解-LW-PPT.rar

/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50553 Source Host : localhost:3306 Source Schema : jspjzzlc Target Server Type : MySQL Target Server Version : 50553 File Encoding : 65001 Date: 21/10/2020 11:24:37 */ 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, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `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 = 1603250489063 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客服聊天表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of chat -- ---------------------------- INSERT INTO `chat` VALUES (1, '2020-10-21 08:54:27', 1, 1, '提问1', '回复1', 1); INSERT INTO `chat` VALUES (2, '2020-10-21 08:54:28', 2, 2, '提问2', '回复2', 2); INSERT INTO `chat` VALUES (3, '2020-10-21 08:54:28', 3, 3, '提问3', '回复3', 3); INSERT INTO `chat` VALUES (1603250020351, '2020-10-21 11:13:39', 1603244734231, NULL, '‍客服功能忘记演示了 不好意思\r\n', '嘿嘿\r\n', 0); INSERT INTO `chat` VALUES (1603250489062, '2020-10-21 11:21:28', 1603244734231, NULL, '嘿嘿', NULL, 1); -- ---------------------------- -- Table structure for config -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `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 = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Compact; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES (7, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603244320863.jpg'); INSERT INTO `config` VALUES (8, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603244337794.jpg'); INSERT INTO `config` VALUES (9, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603244351559.jpg'); INSERT INTO `config` VALUES (10, '首页轮播图', 'http://localhost:8080/jspjZZlC/upload/1603250401188.jpg'); -- ---------------------------- -- Table structure for discussdixiachengyuyongshi -- ---------------------------- DROP TABLE IF EXISTS `discussdixiachengyuyongshi`; CREATE TABLE `discussdixiachengyuyongshi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `refid` bigint(20) NOT NULL COMMENT '关联表id', `content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容', `userid` bigint(20) NOT NULL COMMENT '用户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1603249564409 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地下城与勇士评论表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of discussdixiachengyuyongshi -- ---------------------------- INSERT INTO `discussdixiachengyuyongshi` VALUES (1, '2020-10-21 08:54:28', 1, '评论内容1', 1); INSERT INTO `discussdixiachengyuyongshi` VALUES (2, '2020-10-21 08:54:28', 2, '评论内容2', 2); INSERT INTO `discussdixiachengyuyongshi` VALUES (3, '2020-10-21 08:54:28', 3, '评论内容3', 3); INSERT INTO `discussdixiachengyuyongshi` VALUES (1603249564408, '2020-10-21 11:06:04', 1603244913224, '这个账号很棒啊', 1603244734231); -- ---------------------------- -- Table structure for discussyingxionglianmeng -- ---------------------------- DROP TABLE IF EXISTS `discussyingxionglianmeng`; CREATE TABLE `discussyingxionglianmeng` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `refid` bigint(20) NOT NULL COMMENT '关联表id', `content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容', `userid` bigint(20) NOT NULL COMMENT '用户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '英雄联盟评论表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of discussyingxionglianmeng -- ---------------------------- INSERT INTO `discussyingxionglianmeng` VALUES (1, '2020-10-21 08:54:28', 1, '评论内容1', 1); INSERT INTO `discussyingxionglianmeng` VALUES (2, '2020-10-21 08:54:28', 2, '评论内容2', 2); INSERT INTO `discussyingxionglianmeng` VALUES (3, '2020-10-21 08:54:28', 3, '评论内容3', 3); -- ---------------------------- -- Table structure for discussyouxizhanghao -- ---------------------------- DROP TABLE IF EXISTS `discussyouxizhanghao`; CREATE TABLE `discussyouxizhanghao` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `refid` bigint(20) NOT NULL COMMENT '关联表id', `content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容', `userid` bigint(20) NOT NULL COMMENT '用户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '游戏账号评论表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of discussyouxizhanghao -- ---------------------------- INSERT INTO `discussyouxizhanghao` VALUES (1, '2020-10-21 08:54:29', 1, '评论内容1', 1); INSERT INTO `discussyouxizhanghao` VALUES (2, '2020-10-21 08:54:29', 2, '评论内容2', 2); INSERT INTO `discussyouxizhanghao` VALUES (3, '2020-10-21 08:54:29', 3, '评论内容3', 3); -- ---------------------------- -- Table structure for dixiachengsixinhuifu -- ---------------------------- DROP TABLE IF EXISTS `dixiachengsixinhuifu`; CREATE TABLE `dixiachengsixinhuifu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `shangpinbianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编号', `maijiazhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '卖家账号', `maijiahuifu` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '卖家回复', `yonghuming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `yonghuhuifu` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '用户回复', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1603249917931 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地下城私信回复' ROW_FORMAT = Compact; -- ---------------------------- -- Records of dixiachengsixinhuifu -- ---------------------------- INSERT INTO `dixiachengsixinhuifu` VALUES (1603249255265, '2020-10-21 11:00:55', '1603244813', '01', '好的', '001', ''); INSERT INTO `dixiachengsixinhuifu` VALUES (1603249917930, '2020-10-21 11:11:57', '1603244813', '01', '爪巴', '001', ''); -- ---------------------------- -- Table structure for dixiachengsixinliaotian -- ---------------------------- DROP TABLE IF EXISTS `dixiachengsixinliaotian`; CREATE TABLE `dixiachengsixinliaotian` ( `id` bigint(20) NOT NULL AUTO_INCREMENT,