开发语言：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 */;
