开发语言：nodejs
框架：Express
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：VS code/HBuilder X
浏览器：谷歌浏览器
数据库脚本：
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/picture1.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discussxinxifabu`
—
DROP TABLE IF EXISTS `discussxinxifabu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussxinxifabu` (
`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=157 DEFAULT CHARSET=utf8 COMMENT=’信息发布评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussxinxifabu`
—
LOCK TABLES `discussxinxifabu` WRITE;
/*!40000 ALTER TABLE `discussxinxifabu` DISABLE KEYS */;
INSERT INTO `discussxinxifabu` VALUES (151,’2022-06-15 06:56:46′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(152,’2022-06-15 06:56:46′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(153,’2022-06-15 06:56:46′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(154,’2022-06-15 06:56:46′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(155,’2022-06-15 06:56:46′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(156,’2022-06-15 06:56:46′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discussxinxifabu` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `messages`
—
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`userid` bigint(20) NOT NULL COMMENT ‘留言人id’,
`username` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`content` longtext NOT NULL COMMENT ‘留言内容’,
`cpicture` varchar(200) DEFAULT NULL COMMENT ‘留言图片’,
`reply` longtext COMMENT ‘回复内容’,
`rpicture` varchar(200) DEFAULT NULL COMMENT ‘回复图片’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 COMMENT=’留言反馈’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `messages`
—
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (141,’2022-06-15 06:56:46′,1,’用户名1′,’留言内容1′,’upload/messages_cpicture1.jpg’,’回复内容1′,’upload/messages_rpicture1.jpg’),(142,’2022-06-15 06:56:46′,2,’用户名2′,’留言内容2′,’upload/messages_cpicture2.jpg’,’回复内容2′,’upload/messages_rpicture2.jpg’),(143,’2022-06-15 06:56:46′,3,’用户名3′,’留言内容3′,’upload/messages_cpicture3.jpg’,’回复内容3′,’upload/messages_rpicture3.jpg’),(144,’2022-06-15 06:56:46′,4,’用户名4′,’留言内容4′,’upload/messages_cpicture4.jpg’,’回复内容4′,’upload/messages_rpicture4.jpg’),(145,’2022-06-15 06:56:46′,5,’用户名5′,’留言内容5′,’upload/messages_cpicture5.jpg’,’回复内容5′,’upload/messages_rpicture5.jpg’),(146,’2022-06-15 06:56:46′,6,’用户名6′,’留言内容6′,’upload/messages_cpicture6.jpg’,’回复内容6′,’upload/messages_rpicture6.jpg’);
/*!40000 ALTER TABLE `messages` 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=137 DEFAULT CHARSET=utf8 COMMENT=’通知公告’;
/*!40101 SET character_set_client = @saved_cs_client */;