開發語言：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 */;
