基于nodejs的預(yù)約上門維修服務(wù)系統(tǒng)設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼+LW文檔
開發(fā)語言：nodejs
框架：Express
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：VS code/HBuilder X
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫腳本：
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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COMMENT='信息發(fā)布評論表';
/*!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','評論內(nèi)容1','回復(fù)內(nèi)容1'),(152,'2022-06-15 06:56:46',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(153,'2022-06-15 06:56:46',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(154,'2022-06-15 06:56:46',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(155,'2022-06-15 06:56:46',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(156,'2022-06-15 06:56:46',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時間',
? `userid` bigint(20) NOT NULL COMMENT '留言人id',
? `username` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '留言內(nèi)容',
? `cpicture` varchar(200) DEFAULT NULL COMMENT '留言圖片',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? `rpicture` varchar(200) DEFAULT NULL COMMENT '回復(fù)圖片',
? 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','留言內(nèi)容1','upload/messages_cpicture1.jpg','回復(fù)內(nèi)容1','upload/messages_rpicture1.jpg'),(142,'2022-06-15 06:56:46',2,'用戶名2','留言內(nèi)容2','upload/messages_cpicture2.jpg','回復(fù)內(nèi)容2','upload/messages_rpicture2.jpg'),(143,'2022-06-15 06:56:46',3,'用戶名3','留言內(nèi)容3','upload/messages_cpicture3.jpg','回復(fù)內(nèi)容3','upload/messages_rpicture3.jpg'),(144,'2022-06-15 06:56:46',4,'用戶名4','留言內(nèi)容4','upload/messages_cpicture4.jpg','回復(fù)內(nèi)容4','upload/messages_rpicture4.jpg'),(145,'2022-06-15 06:56:46',5,'用戶名5','留言內(nèi)容5','upload/messages_cpicture5.jpg','回復(fù)內(nèi)容5','upload/messages_rpicture5.jpg'),(146,'2022-06-15 06:56:46',6,'用戶名6','留言內(nèi)容6','upload/messages_cpicture6.jpg','回復(fù)內(nèi)容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 '創(chuàng)建時間',
? `title` varchar(200) NOT NULL COMMENT '標題',
? `introduction` longtext COMMENT '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='通知公告';
/*!40101 SET character_set_client = @saved_cs_client */;
