开发语言：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 `dianzixinxiziyuan`
—
DROP TABLE IF EXISTS `dianzixinxiziyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dianzixinxiziyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`ziyuanmingcheng` varchar(200) DEFAULT NULL COMMENT ‘资源名称’,
`ziyuanleixing` varchar(200) DEFAULT NULL COMMENT ‘资源类型’,
`ziyuantupian` varchar(200) DEFAULT NULL COMMENT ‘资源图片’,
`ziyuanwenjian` varchar(200) DEFAULT NULL COMMENT ‘资源文件’,
`ziyuanjieshao` longtext COMMENT ‘资源介绍’,
`faburiqi` date DEFAULT NULL COMMENT ‘发布日期’,
`yonghuming` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT=’电子信息资源’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `dianzixinxiziyuan`
—
LOCK TABLES `dianzixinxiziyuan` WRITE;
/*!40000 ALTER TABLE `dianzixinxiziyuan` DISABLE KEYS */;
INSERT INTO `dianzixinxiziyuan` VALUES (51,’2022-04-07 13:08:48′,’资源名称1′,’资源类型1′,’upload/dianzixinxiziyuan_ziyuantupian1.jpg’,”,’资源介绍1′,’2022-04-07′,’用户名1′),(52,’2022-04-07 13:08:48′,’资源名称2′,’资源类型2′,’upload/dianzixinxiziyuan_ziyuantupian2.jpg’,”,’资源介绍2′,’2022-04-07′,’用户名2′),(53,’2022-04-07 13:08:48′,’资源名称3′,’资源类型3′,’upload/dianzixinxiziyuan_ziyuantupian3.jpg’,”,’资源介绍3′,’2022-04-07′,’用户名3′),(54,’2022-04-07 13:08:48′,’资源名称4′,’资源类型4′,’upload/dianzixinxiziyuan_ziyuantupian4.jpg’,”,’资源介绍4′,’2022-04-07′,’用户名4′),(55,’2022-04-07 13:08:48′,’资源名称5′,’资源类型5′,’upload/dianzixinxiziyuan_ziyuantupian5.jpg’,”,’资源介绍5′,’2022-04-07′,’用户名5′),(56,’2022-04-07 13:08:48′,’资源名称6′,’资源类型6′,’upload/dianzixinxiziyuan_ziyuantupian6.jpg’,”,’资源介绍6′,’2022-04-07′,’用户名6′);
/*!40000 ALTER TABLE `dianzixinxiziyuan` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discussdianzixinxiziyuan`
—
DROP TABLE IF EXISTS `discussdianzixinxiziyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdianzixinxiziyuan` (
`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=137 DEFAULT CHARSET=utf8 COMMENT=’电子信息资源评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussdianzixinxiziyuan`
—
LOCK TABLES `discussdianzixinxiziyuan` WRITE;
/*!40000 ALTER TABLE `discussdianzixinxiziyuan` DISABLE KEYS */;
INSERT INTO `discussdianzixinxiziyuan` VALUES (131,’2022-04-07 13:08:48′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(132,’2022-04-07 13:08:48′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(133,’2022-04-07 13:08:48′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(134,’2022-04-07 13:08:48′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(135,’2022-04-07 13:08:48′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(136,’2022-04-07 13:08:48′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discussdianzixinxiziyuan` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discusstushuxinxi`
—
DROP TABLE IF EXISTS `discusstushuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusstushuxinxi` (
`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=117 DEFAULT CHARSET=utf8 COMMENT=’图书信息评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discusstushuxinxi`
—
LOCK TABLES `discusstushuxinxi` WRITE;
/*!40000 ALTER TABLE `discusstushuxinxi` DISABLE KEYS */;
INSERT INTO `discusstushuxinxi` VALUES (111,’2022-04-07 13:08:48′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(112,’2022-04-07 13:08:48′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(113,’2022-04-07 13:08:48′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(114,’2022-04-07 13:08:48′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(115,’2022-04-07 13:08:48′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(116,’2022-04-07 13:08:48′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discusstushuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discussyonghufenxiang`
—
DROP TABLE IF EXISTS `discussyonghufenxiang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyonghufenxiang` (
`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=127 DEFAULT CHARSET=utf8 COMMENT=’用户分享评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussyonghufenxiang`
—
LOCK TABLES `discussyonghufenxiang` WRITE;
/*!40000 ALTER TABLE `discussyonghufenxiang` DISABLE KEYS */;
INSERT INTO `discussyonghufenxiang` VALUES (121,’2022-04-07 13:08:48′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(122,’2022-04-07 13:08:48′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(123,’2022-04-07 13:08:48′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(124,’2022-04-07 13:08:48′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(125,’2022-04-07 13:08:48′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(126,’2022-04-07 13:08:48′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discussyonghufenxiang` 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=77 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 (71,’2022-04-07 13:08:48′,’帖子标题1′,’帖子内容1′,0,1,’用户名1′,’开放’),(72,’2022-04-07 13:08:48′,’帖子标题2′,’帖子内容2′,0,2,’用户名2′,’开放’),(73,’2022-04-07 13:08:48′,’帖子标题3′,’帖子内容3′,0,3,’用户名3′,’开放’),(74,’2022-04-07 13:08:48′,’帖子标题4′,’帖子内容4′,0,4,’用户名4′,’开放’),(75,’2022-04-07 13:08:48′,’帖子标题5′,’帖子内容5′,0,5,’用户名5′,’开放’),(76,’2022-04-07 13:08:48′,’帖子标题6′,’帖子内容6′,0,6,’用户名6′,’开放’);
/*!40000 ALTER TABLE `forum` 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=107 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 (101,’2022-04-07 13:08:48′,1,’用户名1′,’留言内容1′,’upload/messages_cpicture1.jpg’,’回复内容1′,’upload/messages_rpicture1.jpg’),(102,’2022-04-07 13:08:48′,2,’用户名2′,’留言内容2′,’upload/messages_cpicture2.jpg’,’回复内容2′,’upload/messages_rpicture2.jpg’),(103,’2022-04-07 13:08:48′,3,’用户名3′,’留言内容3′,’upload/messages_cpicture3.jpg’,’回复内容3′,’upload/messages_rpicture3.jpg’),(104,’2022-04-07 13:08:48′,4,’用户名4′,’留言内容4′,’upload/messages_cpicture4.jpg’,’回复内容4′,’upload/messages_rpicture4.jpg’),(105,’2022-04-07 13:08:48′,5,’用户名5′,’留言内容5′,’upload/messages_cpicture5.jpg’,’回复内容5′,’upload/messages_rpicture5.jpg’),(106,’2022-04-07 13:08:48′,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=97 DEFAULT CHARSET=utf8 COMMENT=’公告信息’;
/*!40101 SET character_set_client = @saved_cs_client */;