-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: localhost    Database: deartrainer
-- ------------------------------------------------------
-- Server version	8.0.22

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `administratorinfo`
--

DROP TABLE IF EXISTS `administratorinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `administratorinfo` (
  `administratorId` int NOT NULL AUTO_INCREMENT,
  `administratorPassword` char(20) NOT NULL DEFAULT '0',
  `administratorImage` char(100) DEFAULT NULL,
  `administratorName` char(50) NOT NULL,
  `administratorPhone` char(20) DEFAULT NULL,
  PRIMARY KEY (`administratorId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `administratorinfo`
--

LOCK TABLES `administratorinfo` WRITE;
/*!40000 ALTER TABLE `administratorinfo` DISABLE KEYS */;
INSERT INTO `administratorinfo` VALUES (1,'gao123456',NULL,'高老板','15225249001'),(2,'wang123456',NULL,'王老板','15225249002'),(3,'xu123456',NULL,'徐老板','15225249003');
/*!40000 ALTER TABLE `administratorinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budgetinfo`
--

DROP TABLE IF EXISTS `budgetinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budgetinfo` (
  `itemId` int NOT NULL AUTO_INCREMENT,
  `userId` int DEFAULT NULL,
  `itemType` enum('充值','消费','退款') DEFAULT NULL,
  `itemDateTime` datetime DEFAULT NULL,
  `itemMoney` float DEFAULT NULL COMMENT '该条目的金额',
  `currentUseBalance` float DEFAULT NULL COMMENT '当前条目之后的余额',
  PRIMARY KEY (`itemId`),
  KEY `budgetInfo_FK` (`userId`),
  CONSTRAINT `budgetInfo_FK` FOREIGN KEY (`userId`) REFERENCES `usersinfo` (`userId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='收支记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budgetinfo`
--

LOCK TABLES `budgetinfo` WRITE;
/*!40000 ALTER TABLE `budgetinfo` DISABLE KEYS */;
INSERT INTO `budgetinfo` VALUES (1,1,'充值','2020-01-02 12:11:11',200,1200),(2,1,'充值','2021-07-01 13:44:33',50,2657),(3,1,'充值','2021-07-04 13:44:33',23,2680),(4,1,'充值','2021-07-07 13:44:25',500,3180),(5,1,'充值','2021-07-01 13:44:33',500,3680),(6,1,'消费','2021-07-01 13:44:33',223.23,3456.77),(7,1,'消费','2021-07-01 13:54:33',223.23,3233.54),(8,1,'消费','2021-07-02 14:10:13',285,2948.54),(9,1,'充值','2021-07-02 14:10:47',50,2998.54),(10,1,'充值','2020-01-02 12:11:11',200,1200);
/*!40000 ALTER TABLE `budgetinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chat`
--

DROP TABLE IF EXISTS `chat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chat` (
  `chatId` int NOT NULL AUTO_INCREMENT,
  `sourceId` int NOT NULL,
  `targetId` int DEFAULT NULL,
  `Column1` datetime NOT NULL,
  `content` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`chatId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chat`
--

LOCK TABLES `chat` WRITE;
/*!40000 ALTER TABLE `chat` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `courseinfo`
--

DROP TABLE IF EXISTS `courseinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `courseinfo` (
  `courseId` int NOT NULL AUTO_INCREMENT,
  `courseName` char(50) NOT NULL,
  `courseHours` int NOT NULL DEFAULT '20',
  `courseTypeId` int NOT NULL,
  `trainerId` int NOT NULL,
  `coursePrice` float(10,2) NOT NULL DEFAULT '500.00',
  `courseMaxStudents` int NOT NULL DEFAULT '20',
  `courseStudents` int NOT NULL DEFAULT '0',
  `courseDescription` varchar(500) DEFAULT NULL,
  `coursePhoto` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '/images/course.jpg' COMMENT '封面图片',
  `courseStartTime` date NOT NULL DEFAULT '2021-07-01',
  `courseEndDate` date NOT NULL DEFAULT '2022-07-02',
  `courseStartHour` char(10) DEFAULT '19:00',
  `courseEndHour` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '21:00',
  PRIMARY KEY (`courseId`),
  KEY `courseInfo_FK` (`trainerId`),
  KEY `courseinfo_FK1` (`courseTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `courseinfo`
--

LOCK TABLES `courseinfo` WRITE;
/*!40000 ALTER TABLE `courseinfo` DISABLE KEYS */;
INSERT INTO `courseinfo` VALUES (5,'环湖跑',5,2,1,330.00,300,95,'环境好，是AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA级别的景区。','/images/course.jpg','2021-07-07','2021-07-07','19:00','21:00'),(6,'跑步',10,1,1,223.23,222,13,' 跑步可以让你瘦下来，而瘦下来的自己，五官会更加立体，人变得更加好看。坚持跑步训练，可以促进细胞新陈代谢，排出体内毒素，让皮肤保持紧致弹性状态，减少皱纹的出现，拥有逆龄的容易。 我们可以发现：跑步与人生状态是相辅相成的。','/images/course.jpg','2021-07-18','2022-07-02','18:00','20:00'),(7,'球球大作战',22,5,1,288.00,122,33,' 跑步可以让你瘦下来，而瘦下来的自己，五官会更加立体，人变得更加好看。坚持跑步训练，可以促进细胞新陈代谢，排出体内毒素，让皮肤保持紧致弹性状态，减少皱纹的出现，拥有逆龄的容易。 我们可以发现：跑步与人生状态是相辅相成的。','/images/course.jpg','2021-07-03','2022-07-02','9:00','10:00'),(8,'球球大作战2',22,1,6,222.00,212,23,' 跑步可以让你瘦下来，而瘦下来的自己，五官会更加立体，人变得更加好看。坚持跑步训练，可以促进细胞新陈代谢，排出体内毒素，让皮肤保持紧致弹性状态，减少皱纹的出现，拥有逆龄的容易。 我们可以发现：跑步与人生状态是相辅相成的。','/images/course.jpg','2021-07-09','2022-07-02','19:00','21:00'),(9,'轮椅大作战',30,12,3,343.00,212,26,' 跑步可以让你瘦下来，而瘦下来的自己，五官会更加立体，人变得更加好看。坚持跑步训练，可以促进细胞新陈代谢，排出体内毒素，让皮肤保持紧致弹性状态，减少皱纹的出现，拥有逆龄的容易。 我们可以发现：跑步与人生状态是相辅相成的。','/images/course.jpg','2021-07-07','2022-07-02','14:00','16:00'),(10,'轮椅大作战2',33,1,3,122.00,133,22,' 跑步可以让你瘦下来，而瘦下来的自己，五官会更加立体，人变得更加好看。坚持跑步训练，可以促进细胞新陈代谢，排出体内毒素，让皮肤保持紧致弹性状态，减少皱纹的出现，拥有逆龄的容易。 我们可以发现：跑步与人生状态是相辅相成的。','/images/course.jpg','2021-07-17','2022-07-02','19:00','21:00'),(11,'砸手机运动',50,10,1,220.00,200,0,'大家一起快乐地砸手机吧，摆脱手机的控制，锻炼手腕的力量。','/images/course.jpg','2021-07-18','2021-07-25','13:00','15:00'),(12,'砸电脑运动之豌豆诞生',23,3,1,285.00,22,1,'砸手机的孪生兄弟','/images/5.jpg','2021-08-01','2021-08-08','19:33','21:31');
/*!40000 ALTER TABLE `courseinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `courseselections`
--

DROP TABLE IF EXISTS `courseselections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `courseselections` (
  `userId` int NOT NULL,
  `courseId` int NOT NULL,
  `paidDate` date NOT NULL DEFAULT '2020-01-01',
  PRIMARY KEY (`userId`,`courseId`),
  KEY `courseSelections_FK_1` (`courseId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户选课表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `courseselections`
--

LOCK TABLES `courseselections` WRITE;
/*!40000 ALTER TABLE `courseselections` DISABLE KEYS */;
INSERT INTO `courseselections` VALUES (1,5,'2021-07-01'),(1,6,'2021-07-01'),(1,7,'2020-01-01'),(1,8,'2021-06-30'),(1,9,'2021-06-30'),(1,10,'2021-06-30'),(1,11,'2020-01-01'),(1,12,'2021-07-02'),(2,5,'2020-01-01'),(2,6,'2020-01-01'),(2,7,'2020-01-01'),(2,11,'2020-01-01'),(3,5,'2020-01-01'),(3,6,'2020-01-01'),(3,7,'2020-01-01'),(4,6,'2020-01-01'),(4,12,'2020-01-01'),(5,6,'2020-01-01'),(5,12,'2020-01-01'),(6,6,'2020-01-01'),(6,12,'2020-01-01'),(8,7,'2020-01-01'),(8,12,'2020-01-01'),(11,7,'2020-01-01'),(11,12,'2020-01-01'),(12,12,'2020-01-01');
/*!40000 ALTER TABLE `courseselections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `coursetypecode`
--

DROP TABLE IF EXISTS `coursetypecode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `coursetypecode` (
  `courseTypeId` int NOT NULL AUTO_INCREMENT,
  `courseType` char(50) NOT NULL,
  PRIMARY KEY (`courseTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='课程类型号';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `coursetypecode`
--

LOCK TABLES `coursetypecode` WRITE;
/*!40000 ALTER TABLE `coursetypecode` DISABLE KEYS */;
INSERT INTO `coursetypecode` VALUES (1,'大众健身操'),(2,'有氧舞蹈'),(3,'搏击健美操'),(4,'动感单车(SPINNING)'),(5,'健身球'),(6,'水中韵律操'),(7,'街舞'),(8,'瑜伽(YOGA)'),(9,'芭蕾'),(10,'太极'),(11,'跆搏'),(12,'其它');
/*!40000 ALTER TABLE `coursetypecode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trainerappraisal`
--

DROP TABLE IF EXISTS `trainerappraisal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trainerappraisal` (
  `appraisalId` int NOT NULL AUTO_INCREMENT,
  `trainerId` int NOT NULL,
  `userId` int NOT NULL,
  `appraisalumber` int NOT NULL DEFAULT '0',
  `appraisalScores` float(3,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`appraisalId`),
  KEY `trainerAppraisal_FK` (`trainerId`),
  KEY `trainerAppraisal_FK_1` (`userId`),
  CONSTRAINT `trainerAppraisal_FK` FOREIGN KEY (`trainerId`) REFERENCES `trainersinfo` (`trainerId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `trainerAppraisal_FK_1` FOREIGN KEY (`userId`) REFERENCES `usersinfo` (`userId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trainerappraisal`
--

LOCK TABLES `trainerappraisal` WRITE;
/*!40000 ALTER TABLE `trainerappraisal` DISABLE KEYS */;
/*!40000 ALTER TABLE `trainerappraisal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `trainersinfo`
--

DROP TABLE IF EXISTS `trainersinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `trainersinfo` (
  `trainerId` int NOT NULL AUTO_INCREMENT COMMENT '教练id',
  `trainerName` char(50) NOT NULL COMMENT '教练姓名（实名）',
  `trainerImage` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '/images/trainer.jpg' COMMENT '教练头像路径，后期加默认',
  `trainerAge` int DEFAULT NULL COMMENT '教练年龄',
  `trainerSex` enum('男','女') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '男' COMMENT '教练性别',
  `trainerOnJobTime` date NOT NULL DEFAULT '2020-10-10' COMMENT '教练入职时间',
  `trainerExperience` int NOT NULL DEFAULT '0' COMMENT '教练职业经验',
  `trainerPhone` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '教练手机号',
  `trainerPassword` char(20) NOT NULL DEFAULT '123456' COMMENT '教练帐号密码',
  `trainerPhilosophy` varchar(1000) DEFAULT NULL COMMENT '执教理念',
  PRIMARY KEY (`trainerId`),
  UNIQUE KEY `trainersinfo_un` (`trainerPhone`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='教练信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `trainersinfo`
--

LOCK TABLES `trainersinfo` WRITE;
/*!40000 ALTER TABLE `trainersinfo` DISABLE KEYS */;
INSERT INTO `trainersinfo` VALUES (1,'高大霞','/images/1.jpg',20,'女','2010-10-11',10,'12345678','123456','小孩愣了一下，抬头看我，眼珠子滴溜转圈。他不哭了，试探性的问，“那我喊你哥哥？”'),(2,'徐教练','/images/author.jpg',37,'男','2020-10-12',6,'2324325','123456','小孩愣了一下，抬头看我，眼珠子滴溜转圈。他不哭了，试探性的问，“那我喊你哥哥？”'),(3,'李白','/images/author.jpg',33,'男','1010-10-10',23,'111111','222222','小孩愣了一下，抬头看我，眼珠子滴溜转圈。他不哭了，试探性的问，“那我喊你哥哥？”'),(4,'李目','/images/author.jpg',22,'女','1011-11-11',11,'11243254','24355','小孩愣了一下，抬头看我，眼珠子滴溜转圈。他不哭了，试探性的问，“那我喊你哥哥？”'),(6,'杜甫','/images/10.jpg',27,'男','2020-01-01',21,'123321','123123','小孩愣了一下，抬头看我，眼珠子滴溜转圈。他不哭了，试探性的问，“那我喊你哥哥？”'),(8,'夕夕','/images/author.jpg',34,'女','2020-08-07',12,'12344321','1111222','小孩愣了一下，抬头看我，眼珠子滴溜转圈。他不哭了，试探性的问，“那我喊你哥哥？”'),(9,'宝强','/images/author.jpg',23,'男','2021-05-05',4,'1782839127','123123','小孩愣了一下，抬头看我，眼珠子滴溜转圈。他不哭了，试探性的问，“那我喊你哥哥？”'),(11,'李白','/images/trainer.jpg',33,'男','1010-10-10',23,'325165376243','3334444',NULL);
/*!40000 ALTER TABLE `trainersinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `userperference`
--

DROP TABLE IF EXISTS `userperference`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `userperference` (
  `userId` int NOT NULL AUTO_INCREMENT,
  `courseTypeId` int NOT NULL,
  `preference` int NOT NULL DEFAULT '5',
  KEY `userPerference_FK` (`userId`),
  KEY `userPerference_FK_1` (`courseTypeId`),
  CONSTRAINT `userPerference_FK` FOREIGN KEY (`userId`) REFERENCES `usersinfo` (`userId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `userPerference_FK_1` FOREIGN KEY (`courseTypeId`) REFERENCES `coursetypecode` (`courseTypeId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `userperference`
--

LOCK TABLES `userperference` WRITE;
/*!40000 ALTER TABLE `userperference` DISABLE KEYS */;
/*!40000 ALTER TABLE `userperference` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usersinfo`
--

DROP TABLE IF EXISTS `usersinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `usersinfo` (
  `userId` int NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `userNickname` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `userPassword` char(20) NOT NULL,
  `userImage` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '/images/author.jpg',
  `userName` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `userSex` enum('男','女','保密') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '保密',
  `userSignType` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '用户名注册' COMMENT '注册方式',
  `userSignDate` date DEFAULT NULL,
  `userAccountBalance` float(10,2) NOT NULL DEFAULT '0.00',
  `userAge` int DEFAULT NULL,
  `userPhone` char(20) DEFAULT NULL,
  PRIMARY KEY (`userId`),
  UNIQUE KEY `usersinfo_un` (`userName`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usersinfo`
--

LOCK TABLES `usersinfo` WRITE;
/*!40000 ALTER TABLE `usersinfo` DISABLE KEYS */;
INSERT INTO `usersinfo` VALUES (1,'游离','111111','/images/10.jpg','王保保','保密','用户名注册','2020-11-11',2998.54,33,'000000000'),(2,'木叶','123456789','/images/author.jpg','漩涡鸣人','保密','用户名注册',NULL,214.41,23,'423525'),(3,'七代火影','15747124689','/images/author.jpg','路飞','保密','用户名注册','1999-10-10',124.99,22,'12345678909'),(4,'天上','dqdyqfgiywq','/images/author.jpg','索隆','保密','用户名注册',NULL,234.00,12,'252534654'),(5,'松山','iloiloilo','/images/author.jpg','娜美','女','用户名注册',NULL,565.00,34,'346465745'),(6,'离散','佐佐木','/images/author.jpg','佐佐木','保密','用户名注册',NULL,7657.00,35,'2524663'),(8,'白色','12345678','/images/author.jpg','卡卡罗特','保密','用户名注册',NULL,567.00,34,'25326436'),(12,'水平','123','/images/author.jpg','abc','女','用户名注册',NULL,244.00,23,'1414235'),(13,'沙发','666666','/images/author.jpg','123','保密','用户名注册',NULL,345.00,12,'14214235');
/*!40000 ALTER TABLE `usersinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'deartrainer'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-07-09 23:13:38