springboot727结合疫情情况的婚恋系统.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: springbootd3x17 -- ------------------------------------------------------ -- 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: `springbootd3x17` -- /*!40000 DROP DATABASE IF EXISTS `springbootd3x17`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootd3x17` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `springbootd3x17`; -- -- 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=1651575374876 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-05-03 10:47:03',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-05-03 10:47:03',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-05-03 10:47:03',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-05-03 10:47:03',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-05-03 10:47:03',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-05-03 10:47:03',16,'宇宙银河系月球1号','月某','13823888886','是'),(1651575374875,'2022-05-03 10:56:14',1651575032166,'湖南省','小下坡','13613613666','是'); /*!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 'liwushangcheng' 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=1651575351560 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 (1651575351559,'2022-05-03 10:55:51','liwushangcheng',1651575032166,1651575139271,'护肤品','upload/1651575129305.jpg',1,66,0,NULL); /*!40000 ALTER TABLE `cart` 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/1651575255397.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dianyingfenlei` -- DROP TABLE IF EXISTS `dianyingfenlei`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dianyingfenlei` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `dianyingfenlei` varchar(200) NOT NULL COMMENT '电影分类', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1651575149593 DEFAULT CHARSET=utf8 COMMENT='电影分类'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dianyingfenlei` -- LOCK TABLES `dianyingfenlei` WRITE; /*!40000 ALTER TABLE `dianyingfenlei` DISABLE KEYS */; INSERT INTO `dianyingfenlei` VALUES (71,'2022-05-03 10:47:03','电影分类1'),(72,'2022-05-03 10:47:03','电影分类2'),(73,'2022-05-03 10:47:03','电影分类3'),(74,'2022-05-03 10:47:03','电影分类4'),(75,'2022-05-03 10:47:03','电影分类5'),(76,'2022-05-03 10:47:03','电影分类6'),(1651575149592,'2022-05-03 10:52:28','爱情片'); /*!40000 ALTER TABLE `dianyingfenlei` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dianyinggoupiao` -- DROP TABLE IF EXISTS `dianyinggoupiao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dianyinggoupiao` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `goupiaobianhao` varchar(200) DEFAULT NULL COMMENT '购票编号', `dianyingmingcheng` varchar(200) DEFAULT NULL COMMENT '电影名称', `dianyingfenlei` varchar(200) DEFAULT NULL COMMENT '电影分类', `piaojia` int(11) DEFAULT NULL COMMENT '票价', `shuliang` int(11) DEFAULT NULL COMMENT '数量', `zongjiage` int(11) DEFAULT NULL COMMENT '总价格', `goupiaoshijian` date DEFAULT NULL COMMENT '购票时间', `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号', `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名', `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`), UNIQUE KEY `goupiaobianhao` (`goupiaobianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=1651575412836 DEFAULT CHARSET=utf8 COMMENT='电影购票'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dianyinggoupiao` -- LOCK TABLES `dianyinggoupiao` WRITE; /*!40000 ALTER TABLE `dianyinggoupiao` DISABLE KEYS */; INSERT INTO `dianyinggoupiao` VALUES (91,'2022-05-03 10:47:03','1111111111','电影名称1','电影分类1',1,1,1,'2022-05-03','用户账号1','用户姓名1','未支付'),(92,'2022-05-03 10:47:03','2222222222','电影名称2','电影分类2',2,2,2,'2022-05-03','用户账号2','用户姓名2','未支付'),(93,'2022-05-03 10:47:03','3333333333','电影名称3','电影分类3',3,3,3,'2022-05-03','用户账号3','用户姓名3','未支付'),(94,'2022-05-03 10:47:03','4444444444','电影名称4','电影分类4',4,4,4,'2022-05-03','用户账号4','用户姓名4','未支付'),(95,'2022-05-03