(源码)基于Spring Boot框架的材料分类及多模块管理系统.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspm6bj04 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `jspm6bj04` -- /*!40000 DROP DATABASE IF EXISTS `jspm6bj04`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jspm6bj04` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `jspm6bj04`; -- -- Table structure for table `cailiaofenlei` -- DROP TABLE IF EXISTS `cailiaofenlei`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cailiaofenlei` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `cailiaofenlei` varchar(200) NOT NULL COMMENT '材料分类', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='材料分类'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cailiaofenlei` -- LOCK TABLES `cailiaofenlei` WRITE; /*!40000 ALTER TABLE `cailiaofenlei` DISABLE KEYS */; INSERT INTO `cailiaofenlei` VALUES (21,'2022-04-22 15:09:05','材料分类1'),(22,'2022-04-22 15:09:05','材料分类2'),(23,'2022-04-22 15:09:05','材料分类3'),(24,'2022-04-22 15:09:05','材料分类4'),(25,'2022-04-22 15:09:05','材料分类5'),(26,'2022-04-22 15:09:05','材料分类6'); /*!40000 ALTER TABLE `cailiaofenlei` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `config` -- 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 `dingdanxinxi` -- DROP TABLE IF EXISTS `dingdanxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dingdanxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号', `cailiaomingcheng` varchar(200) NOT NULL COMMENT '材料名称', `cailiaoleixing` varchar(200) NOT NULL COMMENT '材料类型', `jiage` float NOT NULL COMMENT '价格', `shuliang` int(11) NOT NULL COMMENT '数量', `zongjiage` float DEFAULT NULL COMMENT '总价格', `xiadanshijian` datetime DEFAULT NULL COMMENT '下单时间', `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', `dizhi` varchar(200) NOT NULL COMMENT '地址', `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`), UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='订单信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dingdanxinxi` -- LOCK TABLES `dingdanxinxi` WRITE; /*!40000 ALTER TABLE `dingdanxinxi` DISABLE KEYS */; INSERT INTO `dingdanxinxi` VALUES (41,'2022-04-22 15:09:05','1111111111','材料名称1','材料类型1',1,1,1,'2022-04-22 23:09:05','用户名1','姓名1','13823888881','地址1','未支付'),(42,'2022-04-22 15:09:05','2222222222','材料名称2','材料类型2',2,2,2,'2022-04-22 23:09:05','用户名2','姓名2','13823888882','地址2','未支付'),(43,'2022-04-22 15:09:05','3333333333','材料名称3','材料类型3',3,3,3,'2022-04-22 23:09:05','用户名3','姓名3','13823888883','地址3','未支付'),(44,'2022-04-22 15:09:05','4444444444','材料名称4','材料类型4',4,4,4,'2022-04-22 23:09:05','用户名4','姓名4','13823888884','地址4','未支付'),(45,'2022-04-22 15:09:05','5555555555','材料名称5','材料类型5',5,5,5,'2022-04-22 23:09:05','用户名5','姓名5','13823888885','地址5','未支付'),(46,'2022-04-22 15:09:05','6666666666','材料名称6','材料类型6',6,6,6,'2022-04-22 23:09:05','用户名6','姓名6','13823888886','地址6','未支付'); /*!40000 ALTER TABLE `dingdanxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discussgongchengxinxi` -- DROP TABLE IF EXISTS `discussgongchengxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussgongchengxinxi` ( `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=107 DEFAULT CHARSET=utf8 COMMENT='工程信息评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussgongchengxinxi` -- LOCK TABLES `discussgongchengxinxi` WRITE; /*!40000 ALTER TABLE `discussgongchengxinxi` DISABLE KEYS */; INSERT INTO `discussgongchengxinxi` VALUES (101,'2022-04-22 15:09:05',1,1,'用户名1','评论内容1','回复内容1'),(102,'2022-04-22 15:09:05',2,2,'用户名2','评论内容2','回复内容2'),(103,'2022-04-22 15:09:05',3,3,'用户名3','评论内容3','回复内容3'),(104,'2022-04-22 15:09:05',4,4,'用户名4','评论内容4','回复内容4'),(105,'2022-04-22 15:09:05',5,5,'用户名5','评论内容5','回复内容5'),(106,'2022-04-22 15:09:05',6,6,'用户名6','评论内容6','回复内容6'); /*!40000 ALTER TABLE `discussgongchengxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discusszhuangxiucailiao` -- DROP TABLE IF EXISTS `discusszhuangxiucailiao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discusszhuangxiucailiao` ( `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=97 DEFAULT CHARSET=utf8 COMMENT='装修材料评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discusszhuangxiucailiao` -- LOCK TABLES `discusszhuangxiucailiao` WRITE; /*!40000 ALTER TABLE `discusszhuangxiucailiao` DISABLE KEYS */; INSERT INTO `discusszhua