功能介绍
本系统的主要功能包括管理员以及普通用户，国产动漫论坛里不可能只有一位工作人员，管理员可以安排设置更多的管理员，管理员可以对国产动漫论坛中的信息分类、论坛版块、动漫视频信息以及帖子信息等进行管理；普通用户可以查看国产动漫论坛里所有的论坛信息可以进行在线发言交流，查看自己的收藏信息以及进行发布帖子等。
数据库脚本
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmw8k4a` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE `ssmw8k4a`;---- Table structure for table `config`--DROP TABLE IF EXISTS `config`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `config` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`name` varchar(100) NOT NULL COMMENT '配置参数名称',`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `config`--LOCK TABLES `config` WRITE;/*!40000 ALTER TABLE `config` DISABLE KEYS */;INSERT INTO `config` VALUES (1,'picture1','upload/1646403807250.png'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');/*!40000 ALTER TABLE `config` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `discussdongmanshipin`--DROP TABLE IF EXISTS `discussdongmanshipin`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `discussdongmanshipin` (`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=1646404023997 DEFAULT CHARSET=utf8 COMMENT='动漫视频评论表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `discussdongmanshipin`--LOCK TABLES `discussdongmanshipin` WRITE;/*!40000 ALTER TABLE `discussdongmanshipin` DISABLE KEYS */;INSERT INTO `discussdongmanshipin` VALUES (91,'-03-04 14:05:01',1,1,'用户名1','评论内容1','回复内容1'),(92,'-03-04 14:05:01',2,2,'用户名2','评论内容2','回复内容2'),(93,'-03-04 14:05:01',3,3,'用户名3','评论内容3','回复内容3'),(94,'-03-04 14:05:01',4,4,'用户名4','评论内容4','回复内容4'),(95,'-03-04 14:05:01',5,5,'用户名5','评论内容5','回复内容5'),(96,'-03-04 14:05:01',6,6,'用户名6','评论内容6','回复内容6'),(1646404023996,'-03-04 14:27:03',1646403725157,1646403949892,'111','国产动漫论坛小程序','');/*!40000 ALTER TABLE `discussdongmanshipin` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `discussdongmantupian`--DROP TABLE IF EXISTS `discussdongmantupian`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `discussdongmantupian` (`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=1646404039118 DEFAULT CHARSET=utf8 COMMENT='动漫图片评论表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `discussdongmantupian`--LOCK TABLES `discussdongmantupian` WRITE;/*!40000 ALTER TABLE `discussdongmantupian` DISABLE KEYS */;INSERT INTO `discussdongmantupian` VALUES (101,'-03-04 14:05:01',1,1,'用户名1','评论内容1','回复内容1'),(102,'-03-04 14:05:01',2,2,'用户名2','评论内容2','回复内容2'),(103,'-03-04 14:05:01',3,3,'用户名3','评论内容3','回复内容3'),(104,'-03-04 14:05:01',4,4,'用户名4','评论内容4','回复内容4'),(105,'-03-04 14:05:01',5,5,'用户名5','评论内容5','回复内容5'),(106,'-03-04 14:05:01',6,6,'用户名6','评论内容6','回复内容6'),(1646404039117,'-03-04 14:27:18',1646403750720,1646403949892,'111','国产动漫论坛小程序','');/*!40000 ALTER TABLE `discussdongmantupian` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `discussdongmanwenzhang`--DROP TABLE IF EXISTS `discussdongmanwenzhang`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `discussdongmanwenzhang` (`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=1646404055198 DEFAULT CHARSET=utf8 COMMENT='动漫文章评论表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `discussdongmanwenzhang`--LOCK TABLES `discussdongmanwenzhang` WRITE;/*!40000 ALTER TABLE `discussdongmanwenzhang` DISABLE KEYS */;INSERT INTO `discussdongmanwenzhang` VALUES (111,'-03-04 14:05:01',1,1,'用户名1','评论内容1','回复内容1'),(112,'-03-04 14:05:01',2,2,'用户名2','评论内容2','回复内容2'),(113,'-03-04 14:05:01',3,3,'用户名3','评论内容3','回复内容3'),(114,'-03-04 14:05:01',4,4,'用户名4','评论内容4','回复内容4'),(115,'-03-04 14:05:01',5,5,'用户名5','评论内容5','回复内容5'),(116,'-03-04 14:05:01',6,6,'用户名6','评论内容6','回复内容6'),(1646404055197,'-03-04 14:27:34',1646403793258,1646403949892,'111','国产动漫论坛小程序','');/*!40000 ALTER TABLE `discussdongmanwenzhang` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `dongmanfenlei`--DROP TABLE IF EXISTS `dongmanfenlei`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `dongmanfenlei` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`dongmanfenlei` varchar(200) NOT NULL COMMENT '动漫分类',PRIMARY KEY (`id`),UNIQUE KEY `dongmanfenlei` (`dongmanfenlei`)) ENGINE=InnoDB AUTO_INCREMENT=1646403612221 DEFAULT CHARSET=utf8 COMMENT='动漫分类';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `dongmanfenlei`--LOCK TABLES `dongmanfenlei` WRITE;/*!40000 ALTER TABLE `dongmanfenlei` DISABLE KEYS */;INSERT INTO `dongmanfenlei` VALUES (21,'-03-04 14:05:01','动漫分类1'),(22,'-03-04 14:05:01','动漫分类2'),(23,'-03-04 14:05:01','动漫分类3'),(24,'-03-04 14:05:01','动漫分类4'),(25,'-03-04 14:05:01','动漫分类5'),(26,'-03-04 14:05:01','动漫分类6'),(1646403612220,'-03-04 14:20:11','科幻');/*!40000 ALTER TABLE `dongmanfenlei` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `dongmanshipin`--DROP TABLE IF EXISTS `dongmanshipin`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `dongmanshipin` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`dongmanmingcheng` varchar(200) NOT NULL COMMENT '动漫名称',`dongmanfenlei` varchar(200) NOT NULL COMMENT '动漫分类',`zhangjie` varchar(200) DEFAULT NULL COMMENT '章节',`biaoqian` varchar(200) NOT NULL COMMENT '标签',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`zhuangtai` varchar(200) DEFAULT NULL COMMENT '状态',`zuozhe` varchar(200) DEFAULT NULL COMMENT '作者',`shipin` varchar(200) DEFAULT NULL COMMENT '视频',`gengxinriqi` datetime DEFAULT NULL COMMENT '更新日期',`neirongjieshao` longtext COMMENT '内容介绍',`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1646403725158 DEFAULT CHARSET=utf8 COMMENT='动漫视频';/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `dongmantupian`--DROP TABLE IF EXISTS `dongmantupian`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `dongmantupian` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`dongmanmingcheng` varchar(200) NOT NULL COMMENT '动漫名称',`dongmanfenlei` varchar(200) NOT NULL COMMENT '动漫分类',`biaoqian` varchar(200) NOT NULL COMMENT '标签',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`zuozhe` varchar(200) DEFAULT NULL COMMENT '作者',`gengxinriqi` datetime DEFAULT NULL COMMENT '更新日期',`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1646403750721 DEFAULT CHARSET=utf8 COMMENT='动漫图片';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `dongmantupian`--LOCK TABLES `dongmantupian` WRITE;/*!40000 ALTER TABLE `dongmantupian` DISABLE KEYS */;INSERT INTO `dongmantupian` VALUES (41,'-03-04 14:05:01','动漫名称1','动漫分类1','标签1','upload/dongmantupian_tupian1.jpg','作者1','-03-04 22:05:01','-03-04 22:05:01',1),(42,'-03-04 14:05:01','动漫名称2','动漫分类2','标签2','upload/dongmantupian_tupian2.jpg','作者2','-03-04 22:05:01','-03-04 22:05:01',2),(43,'-03-04 14:05:01','动漫名称3','动漫分类3','标签3','upload/dongmantupian_tupian3.jpg','作者3','-03-04 22:05:01','-03-04 22:05:01',3),(44,'-03-04 14:05:01','动漫名称4','动漫分类4','标签4','upload/dongmantupian_tupian4.jpg','作者4','-03-04 22:05:01','-03-04 22:05:01',4),(45,'-03-04 14:05:01','动漫名称5','动漫分类5','标签5','upload/dongmantupian_tupian5.jpg','作者5','-03-04 22:05:01','-03-04 22:05:01',5),(46,'-03-04 14:05:01','动漫名称6','动漫分类6','标签6','upload/dongmantupian_tupian6.jpg','作者6','-03-04 22:05:01','-03-04 22:05:01',6),(1646403750720,'-03-04 14:22:30','七龙珠','科幻','召唤神龙','upload/1646403736261.jpg','李凯','-03-04 22:29:00','-03-04 22:27:50',3);/*!40000 ALTER TABLE `dongmantupian` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `dongmanwenzhang`--DROP TABLE IF EXISTS `dongmanwenzhang`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `dongmanwenzhang` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`dongmanmingcheng` varchar(200) NOT NULL COMMENT '动漫名称',`dongmanfenlei` varchar(200) NOT NULL COMMENT '动漫分类',`biaoqian` varchar(200) NOT NULL COMMENT '标签',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`zuozhe` varchar(200) DEFAULT NULL COMMENT '作者',`gengxinriqi` datetime DEFAULT NULL COMMENT '更新日期',`zhengwen` longtext COMMENT '正文',`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1646403793259 DEFAULT CHARSET=utf8 COMMENT='动漫文章';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `dongmanwenzhang`------ 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=1646404003739 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 (61,'-03-04 14:05:01','帖子标题1','帖子内容1',0,1,'用户名1','开放'),(62,'-03-04 14:05:01','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(63,'-03-04 14:05:01','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(64,'-03-04 14:05:01','帖子标题4','帖子内容4',0,4,'用户名4','开放'),(65,'-03-04 14:05:01','帖子标题5','帖子内容5',0,5,'用户名5','开放'),(66,'-03-04 14:05:01','帖子标题6','帖子内容6',0,6,'用户名6','开放'),(1646403992338,'-03-04 14:26:31',NULL,'国产动漫论坛小程序',61,1646403949892,'111',NULL),(1646404003738,'-03-04 14:26:43','','国产动漫论坛小程序国产动漫论坛小程序',0,1646403949892,'111','开放');/*!40000 ALTER TABLE `forum` 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=1646403827692 DEFAULT CHARSET=utf8 COMMENT='动漫资讯';/*!40101 SET character_set_client = @saved_cs_client */;---- Table structure for table `storeup`--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=1646404050945 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 (1646404015052,'-03-04 14:26:55',1646403949892,1646403725157,'dongmanshipin','樱桃小丸子','upload/1646403658803.jpg','1',NULL),(1646404035274,'-03-04 14:27:14',1646403949892,1646403750720,'dongmantupian','七龙珠','upload/1646403736261.jpg','1',NULL),(1646404050944,'-03-04 14:27:30',1646403949892,1646403793258,'dongmanwenzhang','七龙珠','upload/1646403760340.jpg','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','管理员','hwjtldkihmsa210cwdzn6zseiitm9yqs','-03-04 14:19:51','-03-04 15:19:51'),(2,1646403949892,'111','yonghu','用户','dxczh4a7soqmy1rtaskxzoqkj547m7zx','-03-04 14:25:53','-03-04 15:25:54');/*!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 */;---- Dumping data for table `users`--LOCK TABLES `users` WRITE;/*!40000 ALTER TABLE `users` DISABLE KEYS */;INSERT INTO `users` VALUES (1,'abo','abo','管理员','-03-04 14:05:01');/*!40000 ALTER TABLE `users` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `yonghu`--DROP TABLE IF EXISTS `yonghu`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `yonghu` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',`yonghuxingming` varchar(200) NOT NULL COMMENT '用户姓名',`mima` varchar(200) NOT NULL COMMENT '密码',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`nianling` int(11) DEFAULT NULL COMMENT '年龄',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',PRIMARY KEY (`id`),UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)) ENGINE=InnoDB AUTO_INCREMENT=1646403949893 DEFAULT CHARSET=utf8 COMMENT='用户';/*!40101 SET character_set_client = @saved_cs_client */;
