开发语言：Java
框架：springboot
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库代码：
DROP TABLE IF EXISTS `discussxiaoshuoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussxiaoshuoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`refid` bigint(20) NOT NULL COMMENT ‘关联表id’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`nickname` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`content` longtext NOT NULL COMMENT ‘评论内容’,
`reply` longtext COMMENT ‘回复内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993771583 DEFAULT CHARSET=utf8 COMMENT=’小说信息评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussxiaoshuoxinxi`
—
LOCK TABLES `discussxiaoshuoxinxi` WRITE;
/*!40000 ALTER TABLE `discussxiaoshuoxinxi` DISABLE KEYS */;
INSERT INTO `discussxiaoshuoxinxi` VALUES (81,’2022-05-08 07:03:01′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(82,’2022-05-08 07:03:01′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(83,’2022-05-08 07:03:01′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(84,’2022-05-08 07:03:01′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(85,’2022-05-08 07:03:01′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(86,’2022-05-08 07:03:01′,6,6,’用户名6′,’评论内容6′,’回复内容6′),(1651993771582,’2022-05-08 07:09:31′,1651993640777,1651993560872,’111′,’4352345′,’67567′);
/*!40000 ALTER TABLE `discussxiaoshuoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `forum`
—
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`title` varchar(200) DEFAULT NULL COMMENT ‘帖子标题’,
`content` longtext NOT NULL COMMENT ‘帖子内容’,
`parentid` bigint(20) DEFAULT NULL COMMENT ‘父节点id’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`username` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`isdone` varchar(200) DEFAULT NULL COMMENT ‘状态’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993754603 DEFAULT CHARSET=utf8 COMMENT=’交流论坛’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `forum`
—
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (51,’2022-05-08 07:03:01′,’帖子标题1′,’帖子内容1′,0,1,’用户名1′,’开放’),(52,’2022-05-08 07:03:01′,’帖子标题2′,’帖子内容2′,0,2,’用户名2′,’开放’),(53,’2022-05-08 07:03:01′,’帖子标题3′,’帖子内容3′,0,3,’用户名3′,’开放’),(54,’2022-05-08 07:03:01′,’帖子标题4′,’帖子内容4′,0,4,’用户名4′,’开放’),(55,’2022-05-08 07:03:01′,’帖子标题5′,’帖子内容5′,0,5,’用户名5′,’开放’),(56,’2022-05-08 07:03:01′,’帖子标题6′,’帖子内容6′,0,6,’用户名6′,’开放’),(1651993745867,’2022-05-08 07:09:05′,’交流’,'<p>请输入内容22</p>’,0,1651993560872,’111′,’开放’),(1651993754602,’2022-05-08 07:09:13′,NULL,’而他也容易吐’,51,1651993560872,’111′,NULL);
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `huiyuan`
—
DROP TABLE IF EXISTS `huiyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huiyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`huiyuanzhanghao` varchar(200) NOT NULL COMMENT ‘会员账号’,
`mima` varchar(200) NOT NULL COMMENT ‘密码’,
`huiyuanxingming` varchar(200) NOT NULL COMMENT ‘会员姓名’,
`xingbie` varchar(200) DEFAULT NULL COMMENT ‘性别’,
`huiyuandianhua` varchar(200) DEFAULT NULL COMMENT ‘会员电话’,
`touxiang` varchar(200) DEFAULT NULL COMMENT ‘头像’,
PRIMARY KEY (`id`),
UNIQUE KEY `huiyuanzhanghao` (`huiyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993560873 DEFAULT CHARSET=utf8 COMMENT=’会员’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `huiyuan`
—
LOCK TABLES `huiyuan` WRITE;
/*!40000 ALTER TABLE `huiyuan` DISABLE KEYS */;
INSERT INTO `huiyuan` VALUES (11,’2022-05-08 07:03:01′,’会员账号1′,’123456′,’会员姓名1′,’男’,’13823888881′,’upload/huiyuan_touxiang1.jpg’),(12,’2022-05-08 07:03:01′,’会员账号2′,’123456′,’会员姓名2′,’男’,’13823888882′,’upload/huiyuan_touxiang2.jpg’),(13,’2022-05-08 07:03:01′,’会员账号3′,’123456′,’会员姓名3′,’男’,’13823888883′,’upload/huiyuan_touxiang3.jpg’),(14,’2022-05-08 07:03:01′,’会员账号4′,’123456′,’会员姓名4′,’男’,’13823888884′,’upload/huiyuan_touxiang4.jpg’),(15,’2022-05-08 07:03:01′,’会员账号5′,’123456′,’会员姓名5′,’男’,’13823888885′,’upload/huiyuan_touxiang5.jpg’),(16,’2022-05-08 07:03:01′,’会员账号6′,’123456′,’会员姓名6′,’男’,’13823888886′,’upload/huiyuan_touxiang6.jpg’),(1651993560872,’2022-05-08 07:06:00′,’111′,’111′,’张宇’,’女’,’13655555526′,’upload/1651993560320.jpg’);
/*!40000 ALTER TABLE `huiyuan` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `news`
—
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`title` varchar(200) NOT NULL COMMENT ‘标题’,
`introduction` longtext COMMENT ‘简介’,
`picture` varchar(200) NOT NULL COMMENT ‘图片’,
`content` longtext NOT NULL COMMENT ‘内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993705748 DEFAULT CHARSET=utf8 COMMENT=’公告资讯’;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`refid` bigint(20) DEFAULT NULL COMMENT ‘收藏id’,
`tablename` varchar(200) DEFAULT NULL COMMENT ‘表名’,
`name` varchar(200) NOT NULL COMMENT ‘收藏名称’,
`picture` varchar(200) NOT NULL COMMENT ‘收藏图片’,
`type` varchar(200) DEFAULT ‘1’ COMMENT ‘类型(1:收藏,21:赞,22:踩)’,
`inteltype` varchar(200) DEFAULT NULL COMMENT ‘推荐类型’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651993763052 DEFAULT CHARSET=utf8 COMMENT=’收藏表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `storeup`
—
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
INSERT INTO `storeup` VALUES (1651993763051,’2022-05-08 07:09:22′,1651993560872,1651993640777,’xiaoshuoxinxi’,’杀神’,’upload/1651993586756.png’,’1′,NULL);
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `token`
—
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`username` varchar(100) NOT NULL COMMENT ‘用户名’,
`tablename` varchar(100) DEFAULT NULL COMMENT ‘表名’,
`role` varchar(100) DEFAULT NULL COMMENT ‘角色’,
`token` varchar(200) NOT NULL COMMENT ‘密码’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘新增时间’,
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘过期时间’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT=’token表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `token`
—
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1,’abo’,’users’,’管理员’,’jevka6rnge8q6ucf8yyeqstq7a4pglb7′,’2022-05-08 07:05:43′,’2022-05-08 08:10:31′),(2,1651993560872,’111′,’huiyuan’,’会员’,’bhrxdgq754fe1a8flolih3ifgu17hi8p’,’2022-05-08 07:08:50′,’2022-05-08 08:10:48′);
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `users`
—
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`username` varchar(100) NOT NULL COMMENT ‘用户名’,
`password` varchar(100) NOT NULL COMMENT ‘密码’,
`role` varchar(100) DEFAULT ‘管理员’ COMMENT ‘角色’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘新增时间’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=’用户表’;
/*!40101 SET character_set_client = @saved_cs_client */;