2021040205_春之梦理发店管理系统的设计与实现.rar

-- 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