基于spring boot 速食消费品网络营销系统.rar

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: springbooty7n1w -- ------------------------------------------------------ -- 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: `springbooty7n1w` -- /*!40000 DROP DATABASE IF EXISTS `springbooty7n1w`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbooty7n1w` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `springbooty7n1w`; -- -- Table structure for table `aboutus` -- DROP TABLE IF EXISTS `aboutus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `aboutus` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) NOT NULL COMMENT '标题', `subtitle` varchar(200) DEFAULT NULL COMMENT '副标题', `content` longtext NOT NULL COMMENT '内容', `picture1` longtext COMMENT '图片1', `picture2` longtext COMMENT '图片2', `picture3` longtext COMMENT '图片3', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `aboutus` -- LOCK TABLES `aboutus` WRITE; /*!40000 ALTER TABLE `aboutus` DISABLE KEYS */; INSERT INTO `aboutus` VALUES (1,'2023-03-05 14:27:10','关于我们','ABOUT US','<p>编辑23232。</p>','upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg'); /*!40000 ALTER TABLE `aboutus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cangkuxinxi` -- DROP TABLE IF EXISTS `cangkuxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cangkuxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `cangkumingcheng` varchar(200) NOT NULL COMMENT '仓库名称', `cangkudizhi` varchar(200) NOT NULL COMMENT '仓库地址', `fuzeren` varchar(200) NOT NULL COMMENT '负责人', `lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1678027043880 DEFAULT CHARSET=utf8 COMMENT='仓库信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cangkuxinxi` -- LOCK TABLES `cangkuxinxi` WRITE; /*!40000 ALTER TABLE `cangkuxinxi` DISABLE KEYS */; INSERT INTO `cangkuxinxi` VALUES (41,'2023-03-05 14:27:10','仓库名称1','仓库地址1','负责人1','13823888881'),(42,'2023-03-05 14:27:10','仓库名称2','仓库地址2','负责人2','13823888882'),(43,'2023-03-05 14:27:10','仓库名称3','仓库地址3','负责人3','13823888883'),(44,'2023-03-05 14:27:10','仓库名称4','仓库地址4','负责人4','13823888884'),(45,'2023-03-05 14:27:10','仓库名称5','仓库地址5','负责人5','13823888885'),(46,'2023-03-05 14:27:10','仓库名称6','仓库地址6','负责人6','13823888886'),(47,'2023-03-05 14:27:10','仓库名称7','仓库地址7','负责人7','13823888887'),(48,'2023-03-05 14:27:10','仓库名称8','仓库地址8','负责人8','13823888888'),(1678027043879,'2023-03-05 14:37:23','某仓库','某地址','王五','13333322321'); /*!40000 ALTER TABLE `cangkuxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chanpindingdan` -- DROP TABLE IF EXISTS `chanpindingdan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chanpindingdan` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号', `chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT '产品名称', `chanpinfenlei` varchar(200) DEFAULT NULL COMMENT '产品分类', `pinpai` varchar(200) DEFAULT NULL COMMENT '品牌', `danjia` float DEFAULT NULL COMMENT '单价', `shuliang` int(11) DEFAULT NULL COMMENT '购买数量', `yingfujine` float DEFAULT NULL COMMENT '应付金额', `qiyemingcheng` varchar(200) DEFAULT NULL COMMENT '企业名称', `qiyedizhi` varchar(200) DEFAULT NULL COMMENT '企业地址', `xiadanshijian` datetime DEFAULT NULL COMMENT '下单时间', `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码', `shouhuodizhi` varchar(200) DEFAULT NULL COMMENT '收货地址', `dingdanzhuangtai` varchar(200) DEFAULT NULL COMMENT '订单状态', `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核', `shhf` longtext COMMENT '审核回复', `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`), UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=1678026929168 DEFAULT CHARSET=utf8 COMMENT='产品订单'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chanpindingdan` -- LOCK TABLES `chanpindingdan` WRITE; /*!40000 ALTER TABLE `chanpindingdan` DISABLE KEYS */; INSERT INTO `chanpindingdan` VALUES (61,'2023-03-05 14:27:10','1111111111','产品名称1','产品分类1','品牌1',1,1,1,'企业名称1','企业地址1','2023-03-05 22:27:10','账号1','姓名1','手机号码1','收货地址1','已发货','是','','未支付'),(62,'2023-03-05 14:27:10','2222222222','产品名称2','产品分类2','品牌2',2,2,2,'企业名称2','企业地址2','2023-03-05 22:27:10','账号2','姓名2','手机号码2','收货地址2','已发货','是','','未支付'),(63,'2023-03-05 14:27:10','3333333333','产品名称3','产品分类3','品牌3',3,3,3,'企业名称3','企业地址3','2023-03-05 22:27:10','账号3','姓名3','手机号码3','收货地址3','已发货','是','','未支付'),(64,'2023-03-05 14:27:10','4444444444','产品名称4','产品分类4','品牌4',4,4,4,'企业名称4','企业地址4','2023-03-05 22:27:10','账号4','姓名4','手机号码4','收货地址4','已发货','是','','未支付'),(65,'2023-03-05 14:27:10','5555555555','产品名称5','产品分类5','品牌5',5,5,5,'企业名称5','企业地址5','2023-03-05 22:27:10','账号5','姓名5','手机号码5','收货地址5','已发货','是','','未支付'),(66,'2023-03-05 14:27:10','6666666666','产品名称6','产品分类6','品牌6',6,6,6,'企业名称6','企业地址6','2023-03-05 22:27:10','账号6','姓名6','手机号码6','收货地址6','已发货','是','','未支付'),(67,'2023-03-05 14:27:10','7777777777','产品名称7','产品分类7','品牌7',7,7,7,'企业名称7','企业地址7','2023-03-05 22:27:10','账号7','姓名7','手机号码7','收货地址7','已发货','是','','未支付'),(68,'2023-03-05 14:27:10','8888888888','产品名称8','产品分类8','品牌8',8,8,8,'企业名称8','企业地址8','2023-03-05 22:27:10','账号8','姓名8','手机号码8','收货地址8','已发货','是','','未支付'),(1678026929167,'2023-03-05 14:35:28','1678026918607','产品名称2','产品分类2','品牌2',2,1,2,'企业名称2','企业地址2','2023-03-05 22:35:18','11','张三','13111111111','某地址，购买产品的地方','已发货','是','这里是审核客户的购买订单的地方，并进行发货','已支付'); /*!40000 AL