基于springboot框架+layui框架的特产商城系统+数据库sql

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: springboote80z4 -- ------------------------------------------------------ -- 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: `springboote80z4` -- /*!40000 DROP DATABASE IF EXISTS `springboote80z4`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboote80z4` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `springboote80z4`; -- -- Table structure for table `address` -- DROP TABLE IF EXISTS `address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `address` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `address` varchar(200) NOT NULL COMMENT '地址', `name` varchar(200) NOT NULL COMMENT '收货人', `phone` varchar(200) NOT NULL COMMENT '电话', `isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1646885541865 DEFAULT CHARSET=utf8 COMMENT='地址'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `address` -- LOCK TABLES `address` WRITE; /*!40000 ALTER TABLE `address` DISABLE KEYS */; INSERT INTO `address` VALUES (1,'2022-03-10 04:07:25',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-03-10 04:07:25',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-03-10 04:07:25',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-03-10 04:07:25',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-03-10 04:07:25',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-03-10 04:07:25',16,'宇宙银河系月球1号','月某','13823888886','是'),(1646885541864,'2022-03-10 04:12:20',1646885473330,'浙江杭州保利一号','杨洋','15219187575','是'); /*!40000 ALTER TABLE `address` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cart` -- DROP TABLE IF EXISTS `cart`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cart` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `tablename` varchar(200) DEFAULT 'rexiaotechan' COMMENT '商品表名', `userid` bigint(20) NOT NULL COMMENT '用户id', `goodid` bigint(20) NOT NULL COMMENT '商品id', `goodname` varchar(200) DEFAULT NULL COMMENT '商品名称', `picture` varchar(200) DEFAULT NULL COMMENT '图片', `buynumber` int(11) NOT NULL COMMENT '购买数量', `price` float DEFAULT NULL COMMENT '单价', `discountprice` float DEFAULT NULL COMMENT '会员价', `goodtype` varchar(200) DEFAULT NULL COMMENT '商品类型', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1646885511625 DEFAULT CHARSET=utf8 COMMENT='购物车表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cart` -- LOCK TABLES `cart` WRITE; /*!40000 ALTER TABLE `cart` DISABLE KEYS */; INSERT INTO `cart` VALUES (1646885511624,'2022-03-10 04:11:51','rexiaotechan',1646885473330,31,'特产名称1','upload/rexiaotechan_fengmian1.jpg',1,99.9,0,'特产分类1'); /*!40000 ALTER TABLE `cart` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat` -- DROP TABLE IF EXISTS `chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id', `ask` longtext COMMENT '提问', `reply` longtext COMMENT '回复', `isreply` int(11) DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1646886057018 DEFAULT CHARSET=utf8 COMMENT='在线客服'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat` -- LOCK TABLES `chat` WRITE; /*!40000 ALTER TABLE `chat` DISABLE KEYS */; INSERT INTO `chat` VALUES (41,'2022-03-10 04:07:25',1,1,'提问1','回复1',1),(42,'2022-03-10 04:07:25',2,2,'提问2','回复2',2),(43,'2022-03-10 04:07:25',3,3,'提问3','回复3',3),(44,'2022-03-10 04:07:25',4,4,'提问4','回复4',4),(45,'2022-03-10 04:07:25',5,5,'提问5','回复5',5),(46,'2022-03-10 04:07:25',6,6,'提问6','回复6',6),(1646885729774,'2022-03-10 04:15:29',1646885473330,NULL,'请问丽水最有名的特产是什么，有什么推荐？',NULL,0),(1646885744784,'2022-03-10 04:15:44',1646885473330,NULL,'这里可作为售前咨询，也可以作为售后，提出异义',NULL,0),(1646885968333,'2022-03-10 04:19:28',1646885473330,1,NULL,'豆腐娘！',0),(1646885981506,'2022-03-10 04:19:40',1646885473330,1,NULL,'同意退货，如果有异议的话',0),(1646886057017,'2022-03-10 04:20:56',1646885473330,NULL,'666',NULL,1); /*!40000 ALTER TABLE `chat` 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/1646885931538.png'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discussrexiaotechan` -- DROP TABLE IF EXISTS `discussrexiaotechan`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussrexiaotechan` ( `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=1646886051322 DEFAULT CHARSET=utf8 COMMENT='热销特产评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussrexiaotechan` -- LOCK TABLES `discussrexiaotechan` WRITE; /*!40000 ALTER TABLE `discussrexiaotechan` DISABLE KEYS */; INSERT INTO `discussrexiaotechan` VALUES (101,'2022-03-10 04:07:25',1,1,'用户名1','评论内容1','回复内容1'),(102,'2022-03-10 04:07:25',2,2,'用户名2','评论内容2','回复内容2'),(103,'2022-03-10 04:07:25',3,3,'用户名3','评论内容3','回复内容3'),(104,'2022-03-10 04:07:25',4,4,'用户名4','评论内容4','回复内容4'),(1