-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: ssm1r8yp
-- ------------------------------------------------------
-- 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 */;
--
-- Table structure for table `chongzhixinxi`
--
DROP TABLE IF EXISTS `chongzhixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chongzhixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`chongzhijine` int(11) DEFAULT NULL COMMENT '充值金额',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`dingdanshengchengshijian` datetime DEFAULT NULL COMMENT '订单生成时间',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='充值信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chongzhixinxi`
--
LOCK TABLES `chongzhixinxi` WRITE;
/*!40000 ALTER TABLE `chongzhixinxi` DISABLE KEYS */;
INSERT INTO `chongzhixinxi` VALUES (31,'2021-04-10 14:17:26',1,'用户名1','2021-04-10 22:17:26','是','','未支付'),(32,'2021-04-10 14:17:26',2,'用户名2','2021-04-10 22:17:26','是','','未支付'),(33,'2021-04-10 14:17:26',3,'用户名3','2021-04-10 22:17:26','是','','未支付'),(34,'2021-04-10 14:17:26',4,'用户名4','2021-04-10 22:17:26','是','','未支付'),(35,'2021-04-10 14:17:26',5,'用户名5','2021-04-10 22:17:26','是','','未支付'),(36,'2021-04-10 14:17:26',6,'用户名6','2021-04-10 22:17:26','是','','未支付');
/*!40000 ALTER TABLE `chongzhixinxi` 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=7 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','http://localhost:8080/ssm1r8yp/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssm1r8yp/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssm1r8yp/upload/picture3.jpg'),(6,'homepage',NULL);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discussshangpin`
--
DROP TABLE IF EXISTS `discussshangpin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussshangpin` (
`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=167 DEFAULT CHARSET=utf8 COMMENT='商品评论表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `discussshangpin`
--
LOCK TABLES `discussshangpin` WRITE;
/*!40000 ALTER TABLE `discussshangpin` DISABLE KEYS */;
INSERT INTO `discussshangpin` VALUES (161,'2021-04-10 14:17:26',1,1,'用户名1','评论内容1','回复内容1'),(162,'2021-04-10 14:17:26',2,2,'用户名2','评论内容2','回复内容2'),(163,'2021-04-10 14:17:26',3,3,'用户名3','评论内容3','回复内容3'),(164,'2021-04-10 14:17:26',4,4,'用户名4','评论内容4','回复内容4'),(165,'2021-04-10 14:17:26',5,5,'用户名5','评论内容5','回复内容5'),(166,'2021-04-10 14:17:26',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussshangpin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `goumaixinxi`
--
DROP TABLE IF EXISTS `goumaixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goumaixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`shangpinming` varchar(200) DEFAULT NULL COMMENT '商品名',
`fenlei` varchar(200) DEFAULT NULL COMMENT '分类',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`jiage` varchar(200) DEFAULT NULL COMMENT '价格',
`kucun` varchar(200) DEFAULT NULL COMMENT '库存',
`zongjine` int(11) DEFAULT NULL COMMENT '总金额',
`dingdanshengchengshijian` datetime DEFAULT NULL COMMENT '订单生成时间',
`yonghuming` 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=97 DEFAULT CHARSET=utf8 COMMENT='购买信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `goumaixinxi`
--
LOCK TABLES `goumaixinxi` WRITE;
/*!40000 ALTER TABLE `goumaixinxi` DISABLE KEYS */;
INSERT INTO `goumaixinxi` VALUES (91,'2021-04-10 14:17:26','订单编号1','商品名1','分类1','规格1','价格1','库存1',1,'2021-04-10 22:17:26','用户名1','是','','未支付'),(92,'2021-04-10 14:17:26','订单编号2','商品名2','分类2','规格2','价格2','库存2',2,'2021-04-10 22:17:26','用户名2','是','','未支付'),(93,'2021-04-10 14:17:26','订单编号3','商品名3','分类3','规格3','价格3','库存3',3,'2021-04-10 22:17:26','用户名3','是','','未支付'),(94,'2021-04-10 14:17:26','订单编号4','商品名4','分类4','规格4','价格4','库存4',4,'2021-04-10 22:17:26','用户名4','是','','未支付'),(95,'2021-04-10 14:17:26','订单编号5','商品名5','分类5','规格5','价格5','库存5',5,'2021-04-10 22:17:26','用户名5','是','','未支付'),(96,'2021-04-10 14:17:26','订单编号6','商品名6','分类6','规格6','价格6','库存6',6,'2021-04-10 22:17:26','用户名6','是','','未支付');
/*!40000 ALTER TABLE `goumaixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `huiyuanxinxi`
--
DROP TABLE IF EXISTS `huiyuanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `huiyuanxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`huiyuandengji` varchar(200) DEFAULT NULL COMMENT '会员等级',
`kahao` varchar(200) DEFAULT NULL COMMENT '卡号',
`bankariqi` datetime DEFAULT NULL COMMENT '办卡日期',
`yue` varchar