/*
 Navicat Premium Data Transfer

 Source Server         : 114.55.37.219
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : 114.55.37.219:3306
 Source Schema         : yc

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 13/05/2023 20:00:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for active
-- ----------------------------
DROP TABLE IF EXISTS `active`;
CREATE TABLE `active`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `active_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动名称',
  `start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动详情',
  `man_number` int(0) NULL DEFAULT 0 COMMENT '男士人数',
  `woman_number` int(0) NULL DEFAULT 0 COMMENT '女士人数',
  `man_money` int(0) NULL DEFAULT 0 COMMENT '男士报名收费',
  `woman_money` int(0) NULL DEFAULT 0 COMMENT '女士报名收费',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '咨询电话',
  `mobile_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '咨询手机号',
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动地点',
  `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动展示图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 213 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of active
-- ----------------------------
INSERT INTO `active` VALUES (1, 'g', '2023-05-04 16:00:00', '2023-05-05 16:00:00', 'fh', 0, 0, 100, 100, '178998798', '178998798', 'h', NULL);
INSERT INTO `active` VALUES (4, '1', '2023-05-03 16:00:00', '2023-05-24 16:00:00', '123', 1, 5, 123, 123, '1', '1', '1', NULL);
INSERT INTO `active` VALUES (7, '2', '2023-05-04 16:00:00', '2023-05-11 16:00:00', '1', 2, 0, 1, 1, '12345678900', '12345678900', '1', NULL);
INSERT INTO `active` VALUES (213, '12321', '2023-05-03 16:00:00', '2023-05-09 16:00:00', NULL, 0, 0, 0, 0, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for classify
-- ----------------------------
DROP TABLE IF EXISTS `classify`;
CREATE TABLE `classify`  (
  `mid` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类名',
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '缩略名',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`mid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of classify
-- ----------------------------
INSERT INTO `classify` VALUES (1, '爱情故事', 'Love is everything', '爱情故事', '2023-04-23 09:50:19');
INSERT INTO `classify` VALUES (2, '恋爱宝典', 'A treasure book of love', '恋爱宝典', '2023-04-23 09:52:43');
INSERT INTO `classify` VALUES (3, '新手上路', 'Newbies hit the road', '新手上路', '2023-04-23 09:53:23');
INSERT INTO `classify` VALUES (6, '人工', 'g\'f', 'g\'f\'dgfd', '2023-05-05 10:16:24');
INSERT INTO `classify` VALUES (9, '婚姻法规', 'Marriage statutes ', '婚姻法规', '2023-04-23 09:55:51');

-- ----------------------------
-- Table structure for contents
-- ----------------------------
DROP TABLE IF EXISTS `contents`;
CREATE TABLE `contents`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `mid` int(0) NULL DEFAULT NULL COMMENT '分类id',
  `cover_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文章封面',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文章标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文章内容',
  `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文章视频',
  `img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文章图片',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of contents
-- ----------------------------
INSERT INTO `contents` VALUES (1, 2, 'http://114.55.37.219:9090/files/36a052a267d24a9f93336e2063cc13ee.jpg', '一起学习爱情', '学习123\n学习222\n学习3；\n学习4；\n0000', 'http://114.55.37.219:9090/files/7085a46be9dd4a3192e0daef978747f6.mp4', 'http://114.55.37.219:9090/files/0d87a101349e40fc86229cfb2b60c845.jpg', '2023-04-23 11:18:02');
INSERT INTO `contents` VALUES (2, 1, 'http://114.55.37.219:9090/files/974d739e329046b8940f84d04a6f4c1f.jpg', '标题', '内容内容内容内容内容内容', 'http://114.55.37.219:9090/files/6599c2d846d748208973eb6affcc8378.mp4', 'http://114.55.37.219:9090/files/56889fbe7969483192dec1a7d26f8805.jpg', '2023-04-25 20:16:06');
INSERT INTO `contents` VALUES (3, 1, 'http://114.55.37.219:9090/files/a20a456fa49e44f19c5d898511e121e7.jpg', '标题', '内容内容内容内容内容内容', 'http://114.55.37.219:9090/files/8c1a01c214dc4009868fc9a17ac501f5.mp4', 'http://114.55.37.219:9090/files/eda3bc4898564fe08849b725fe36e7a5.jpg', '2023-04-25 20:16:28');
INSERT INTO `contents` VALUES (20, 1, 'http://114.55.37.219:9090/files/cf8d4c9877ae44a2930d41f8c508cd75.jpg', '如何才能找到生命中的另一半呢？', NULL, 'http://114.55.37.219:9090/files/a197b2ee92894a7eadadcac8a0fab0c3.mp4', 'http://114.55.37.219:9090/files/394e8273f1d942c3ba1c797c7cf46b2e.jpg', '2023-05-05 08:21:38');
INSERT INTO `contents` VALUES (21, 6, 'http://114.55.37.219:9090/files/ac0e58f3ebb64fa2bfec914e374aede2.jpg', 'f\'b', 'fb', 'http://114.55.37.219:9090/files/3dfc71096cd344f2ae1c417a19983c4e.mp4', 'http://114.55.37.219:9090/files/e789097684094565867cb6de2fa87264.jpg', '2023-05-05 10:17:06');

-- ----------------------------
-- Table structure for details
-- ----------------------------
DROP TABLE IF EXISTS `details`;
CREATE TABLE `details`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(0) NOT NULL COMMENT '用户id',
  `registered_aim` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登记目的',
  `parents_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '父母状况',
  `live` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '与Ta父母住',
  `children_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '子女情况',
  `sibling` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '兄弟姐妹',
  `work_industry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '工作行业',
  `workplace` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单位类型',
  `graduate_school` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '毕业院校',
  `property_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '房产位置',
  `smoking` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否吸烟',
  `drinking` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否饮酒',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '我的标签',
  `standard` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '择偶标准',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of details
-- ----------------------------
INSERT INTO `details` VALUES (1, 1, 'string', 'string', 'string', 'string', 'string', 'string', '1111', 'string', 'string', 'string', 'string', 'string', 'string', '2023-04-21 00:09:36');

-- ----------------------------
-- Table structure for mate
-- ----------------------------
DROP TABLE IF EXISTS `mate`;
CREATE TABLE `mate`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名字',
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像',
  `appellation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '称号',
  `profile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '简介',
  `mate_number` int(0) NULL DEFAULT 0 COMMENT '配对人数',
  `wechat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '电话',
  `qq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'QQ',
  `good_number` int(0) NULL DEFAULT 0 COMMENT '好评个数',
  `bad_number` int(0) NULL DEFAULT 0 COMMENT '差评个数',
  `mod_number` int(0) NULL DEFAULT 0 COMMENT '中评个数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of mate
-- ----------------------------
INSERT INTO `mate` VALUES (1, 'w', NULL, 'e', 'w', 0, 'e', 'f', 'fd', 0, 0, 0);
INSERT INTO `mate` VALUES (2, '张老师', 'http://www.qzh365.com/up/p/crm/2020/12/1607496777yrg_b.jpg', '高端婚恋顾问', '善于运用心灵匹配性格相容、价值观接近、关系互动和谐的原则，以专业耐心的服务宗旨，成功牵线无以计数的单身人士，拥有良好的口碑。', 0, '397228891 ', '0574-27818520 ', '397228891 ', 0, 0, 0);
INSERT INTO `mate` VALUES (4, '000', 'http://114.55.37.219:9090/files/c024390e2bcb428ebf145a76f6fb3716.jpg', '高级婚恋顾问', '积极向上', 0, '1454545454', '122222222', '1456464454', 0, 0, 0);
INSERT INTO `mate` VALUES (5, '李老师', 'http://114.55.37.219:9090/files/2719762600e64a8da5de983d039aca24.jpg', '高级感情顾问', '健康向上', 0, '177777777', '178998798', '177777777', 0, 0, 0);
INSERT INTO `mate` VALUES (22, '朱老师', 'http://114.55.37.219:9090/files/a10b5a3a149e4af7bb68a227b7e8ef73.webp', '高级感情顾问', '积极向上，充满阳光', 0, '123456', '987654', '123456', 0, 0, 0);
INSERT INTO `mate` VALUES (24, '王五', 'http://114.55.37.219:9090/files/291ef23c61a242e68c9254527fb154d8.png', '高级感情顾问', '积极向上', 0, '1111111', '11111111', '111111', 0, 0, 0);

-- ----------------------------
-- Table structure for request
-- ----------------------------
DROP TABLE IF EXISTS `request`;
CREATE TABLE `request`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(0) NOT NULL COMMENT 'uid',
  `marital_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '婚况',
  `min_age` int(0) NULL DEFAULT NULL COMMENT '最小年龄',
  `max_age` int(0) NULL DEFAULT NULL COMMENT '最大年龄',
  `min_height` double NULL DEFAULT NULL COMMENT '最小身高',
  `max_height` double NULL DEFAULT NULL COMMENT '最大身高',
  `min_xueli` int(0) NULL DEFAULT NULL COMMENT '最低学历',
  `min_income` int(0) NULL DEFAULT NULL COMMENT '最低收入',
  `house` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '房子',
  `cart` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车子',
  `huji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '户籍地区',
  `other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '其他要求',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of request
-- ----------------------------
INSERT INTO `request` VALUES (2, 2, '未婚', NULL, NULL, NULL, NULL, NULL, NULL, '', '有车', '', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (3, 1, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '浙江杭州', '', '2023-04-26 08:22:18');
INSERT INTO `request` VALUES (5, 3, '未婚', 18, 30, 140, 180, 1, 2, '有房', '有车', '浙江', NULL, '2023-04-26 23:58:29');
INSERT INTO `request` VALUES (6, 4, '离异', 20, 35, 160, 170, 3, 3, '有房', '无车', '河北', NULL, '2023-04-27 08:27:30');
INSERT INTO `request` VALUES (7, 10, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '浙江杭州', '', '2023-04-26 08:22:18');
INSERT INTO `request` VALUES (8, 17, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '浙江杭州', '', '2023-04-26 08:22:18');
INSERT INTO `request` VALUES (9, 18, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '浙江杭州', '', '2023-04-26 08:22:18');
INSERT INTO `request` VALUES (10, 19, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '浙江杭州', '', '2023-04-26 08:22:18');
INSERT INTO `request` VALUES (11, 14, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '河北', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (12, 15, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '河北', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (13, 16, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '河北', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (14, 5, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '河北', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (15, 6, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '河北', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (16, 7, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '河北', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (17, 8, '未婚', 18, 40, 150, 180, 2, 1, '有房', '有车', '河北', NULL, '2023-04-23 00:53:04');
INSERT INTO `request` VALUES (18, 20, '未婚', 18, 30, 140, 153, 4, 4, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-27 09:30:11');
INSERT INTO `request` VALUES (19, 31, '未婚', 18, 30, 140, 153, 2, 2, '有房', '有车', '河北省-石家庄市-长安区', NULL, '2023-04-27 10:52:10');
INSERT INTO `request` VALUES (20, 33, '未婚', 18, 30, 140, 153, 1, 1, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-27 11:00:54');
INSERT INTO `request` VALUES (21, 33, '未婚', 19, 19, 150, 180, 2, 1, '有房', '有车', '', NULL, '2023-04-27 11:02:04');
INSERT INTO `request` VALUES (22, 33, '未婚', 18, 18, 150, 180, 2, 1, '有房', '有车', '', NULL, '2023-04-27 11:03:10');
INSERT INTO `request` VALUES (23, 33, '未婚', 18, 18, 140, 180, 2, 1, '有房', '有车', '', NULL, '2023-04-27 11:13:25');
INSERT INTO `request` VALUES (24, 33, '未婚', 18, 18, 140, 180, 2, 1, '有房', '有车', '', NULL, '2023-04-27 11:17:42');
INSERT INTO `request` VALUES (25, 33, '未婚', 18, 18, 140, 180, 2, 1, '有房', '有车', '', NULL, '2023-04-27 11:20:49');
INSERT INTO `request` VALUES (26, 34, '未婚', 0, 0, 150, 153, 2, 1, '有房', '有车', '', NULL, '2023-04-27 11:24:54');
INSERT INTO `request` VALUES (27, 34, '未婚', 0, 0, 150, 153, 4, 1, '有房', '有车', '', NULL, '2023-04-27 11:25:57');
INSERT INTO `request` VALUES (28, 37, '未婚', 19, 30, 140, 153, 5, 6, '有房', '有车', '湖南省-长沙市-雨花区', NULL, '2023-04-27 22:26:45');
INSERT INTO `request` VALUES (29, 3, '未婚', 18, 18, 140, 140, 1, 5, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-27 22:43:39');
INSERT INTO `request` VALUES (30, 3, '未婚', 18, 28, 140, 190, 1, 8, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-27 22:45:05');
INSERT INTO `request` VALUES (31, 3, '未婚', 18, 30, 140, 190, 1, 5, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-27 22:46:46');
INSERT INTO `request` VALUES (32, 38, '未婚', 18, 30, 140, 190, 1, 8, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-27 22:54:24');
INSERT INTO `request` VALUES (33, 38, '', 19, 0, 0, 0, 0, 0, '有房', '有车', '', NULL, '2023-04-27 23:00:26');
INSERT INTO `request` VALUES (34, 38, '', 18, 0, 0, 0, 0, 0, '有房', '有车', '', NULL, '2023-04-27 23:02:43');
INSERT INTO `request` VALUES (35, 38, '', 18, 0, 0, 0, 0, 0, '有房', '有车', '', NULL, '2023-04-27 23:05:25');
INSERT INTO `request` VALUES (36, 38, '', 18, 0, 0, 0, 0, 0, '有房', '有车', '', NULL, '2023-04-27 23:06:22');
INSERT INTO `request` VALUES (37, 31, '未婚', 18, 30, 140, 190, 1, 1, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-27 23:39:58');
INSERT INTO `request` VALUES (38, 39, '未婚', 18, 30, 140, 190, 1, 2, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-28 08:08:33');
INSERT INTO `request` VALUES (39, 40, '未婚', 18, 30, 140, 153, 1, 1, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-28 08:11:33');
INSERT INTO `request` VALUES (40, 41, '未婚', 18, 30, 140, 153, 1, 1, '有房', '有车', '北京市-市辖区-东城区', NULL, '2023-04-28 08:46:53');
INSERT INTO `request` VALUES (41, 42, '未婚', 18, 18, 140, 190, 1, 1, NULL, NULL, '北京市-市辖区-东城区', NULL, '2023-04-28 09:09:20');
INSERT INTO `request` VALUES (42, 46, '', 0, 0, 0, 0, 0, 0, NULL, NULL, '', NULL, '2023-05-03 15:58:39');
INSERT INTO `request` VALUES (43, 46, '', 0, 0, 0, 0, 0, 0, NULL, NULL, '', NULL, '2023-05-03 16:03:33');
INSERT INTO `request` VALUES (44, 42, '未婚', 18, 18, 140, 140, 1, 1, NULL, NULL, '北京市-市辖区-东城区', NULL, '2023-05-03 17:11:49');
INSERT INTO `request` VALUES (45, 46, '', 0, 0, 0, 0, 0, 0, NULL, NULL, '', NULL, '2023-05-05 08:02:50');
INSERT INTO `request` VALUES (46, 46, '未婚', 0, 0, 0, 0, 0, 0, NULL, NULL, '', NULL, '2023-05-05 08:28:33');
INSERT INTO `request` VALUES (47, 46, '', 0, 0, 0, 0, 0, 0, NULL, NULL, '', NULL, '2023-05-05 08:36:05');
INSERT INTO `request` VALUES (48, 51, '离异', 21, 18, 140, 140, 6, 1, NULL, NULL, '北京市-市辖区-东城区', NULL, '2023-05-05 08:43:54');
INSERT INTO `request` VALUES (49, 49, '未婚', 18, 18, 140, 140, 1, 1, NULL, NULL, '北京市-市辖区-东城区', NULL, '2023-05-05 09:03:09');
INSERT INTO `request` VALUES (50, 52, '未婚', 18, 18, 140, 140, 1, 1, NULL, NULL, '北京市-市辖区-东城区', NULL, '2023-05-05 10:12:47');
INSERT INTO `request` VALUES (51, 53, '其它', 18, 18, 140, 144, 1, 4, NULL, NULL, '黑龙江省-哈尔滨市-道里区', NULL, '2023-05-05 10:28:44');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '昵称',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '电话号码',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
  `birthday` datetime(0) NULL DEFAULT NULL COMMENT '生日',
  `work_place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '工作地区',
  `huji_place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '户籍地区',
  `hunyin_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '婚姻状况',
  `height` double NULL DEFAULT NULL COMMENT '身高',
  `weight` double NULL DEFAULT NULL COMMENT '体重',
  `xueli` int(0) NULL DEFAULT NULL COMMENT '学历',
  `month_income` int(0) NULL DEFAULT NULL COMMENT '月收入',
  `career` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '职业',
  `house_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '住房情况',
  `cart_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '购车情况',
  `married_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '期望结婚时间',
  `introduce_yourself` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '自我介绍',
  `weixin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信',
  `weixin_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '微信二维码',
  `qq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'QQ号',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
  `state` tinyint(0) NOT NULL DEFAULT 1 COMMENT '审核状态(0:表示审核 1表示通过审核)',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色',
  `is_deleted` tinyint(0) NOT NULL DEFAULT 0 COMMENT '删除标记（0:可用 1:已删除）',
  PRIMARY KEY (`id`, `username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (2, 'http://114.55.37.219:9090/files/1d7d8f793031487ea134993cdbd08de9.webp', 'admin1', '女', '120', 'fcea920f7412b5da7be0cf42b8c93759', '2002-10-10 00:00:00', '河北石家庄', '北京市-市辖区-东城区', '未婚', 162, 54, 5, 3, '医生', '有房', '有车', NULL, NULL, '123', NULL, '456', '616342388@qq.com', 1, '2023-04-20 09:44:44', 'ROLE_ADMIN', 0);
INSERT INTO `sys_user` VALUES (6, 'http://114.55.37.219:9090/files/4fce4a70365548199dbc83f41a69ff32.webp', 'admin123', '男', '789', 'fcea920f7412b5da7be0cf42b8c93759', '2002-10-10 00:00:00', '河北', '北京市-市辖区-东城区', '未婚', 188, 89, 4, 3, 'coder', '有房', '无车', NULL, NULL, '1111', NULL, NULL, NULL, 1, '2023-04-24 20:41:06', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (7, 'http://114.55.37.219:9090/files/a2276b22d7fc485c9c71b7cb4fcd55ae.webp', 'admin', '女', '199', 'e10adc3949ba59abbe56e057f20f883e', '2002-10-10 00:00:00', '河北', '北京市-市辖区-东城区', '未婚', 166, 180, 4, 2, '199', '有房', '无车', NULL, NULL, '199', NULL, NULL, NULL, 1, '2023-04-24 20:52:03', 'ROLE_ADMIN', 0);
INSERT INTO `sys_user` VALUES (8, 'http://114.55.37.219:9090/files/5db7b490cd6840c7b14730746edc2c83.webp', 'admin1', '男', '199', 'e10adc3949ba59abbe56e057f20f883e', '2002-10-10 00:00:00', '浙江杭州', '北京市-市辖区-东城区', '已婚', 177, 80, 3, 6, '学生', '有房', '无车', NULL, NULL, '199', NULL, NULL, NULL, 1, '2023-04-25 08:40:11', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (14, 'http://114.55.37.219:9090/files/6d5da3a53f894caea6f3547fecd68227.jpg', '3', '女', '120', 'fcea920f7412b5da7be0cf42b8c93759', '2002-10-10 00:00:00', '河北石家庄', '北京市-市辖区-东城区', '未婚', 162, 54, 5, 3, '医生', '有房', '有车', NULL, NULL, '123', NULL, '456', '616342388@qq.com', 1, '2023-04-20 09:44:44', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (15, 'http://114.55.37.219:9090/files/bdd534ef0ad6420d9ec78838991cb997.jpeg', '4', '男', '120', 'fcea920f7412b5da7be0cf42b8c93759', '2002-10-10 00:00:00', '河北石家庄', '北京市-市辖区-东城区', '离异', 162, 54, 5, 3, '医生', '有房(有贷款)', '有能力购车', '1年内', NULL, '123', NULL, '456', '616342388@qq.com', 1, '2023-04-20 09:44:44', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (16, 'http://114.55.37.219:9090/files/bdd534ef0ad6420d9ec78838991cb997.jpeg', '很意外', '女', '120', 'fcea920f7412b5da7be0cf42b8c93759', '2002-10-10 00:00:00', '河北石家庄', '北京市-市辖区-东城区', '未婚', 162, 54, 5, 3, '医生', '有房', '有车', NULL, NULL, '123', NULL, '456', '616342388@qq.com', 1, '2023-04-20 09:44:44', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (17, 'http://114.55.37.219:9090/files/532b180f164f43a9b42ca9e75fbb8663.webp', 'dddd', '男', '110', 'fcea920f7412b5da7be0cf42b8c93759', '2002-10-10 00:00:00', '浙江省宁波市', '北京市-市辖区-东城区', '未婚', 168, 54, 2, 4, '医生', '有房', '有车', '随时', '123', '123', NULL, '456', '616342388@qq.com', 1, '2023-04-20 09:10:28', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (19, 'http://114.55.37.219:9090/files/6d5da3a53f894caea6f3547fecd68227.jpg', '哈哈', '男', '123456789', '8d5e957f297893487bd98fa830fa6413', '2002-10-10 00:00:00', '浙江杭州', '北京市-市辖区-东城区', '未婚', 185, 140, 1, 2, NULL, '有房', '有车', NULL, '啊啊啊啊', '1345', NULL, '123456', '123456@qq.com', 1, '2023-04-25 10:18:00', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (20, 'http://114.55.37.219:9090/files/5db7b490cd6840c7b14730746edc2c83.webp', '9', '女', NULL, 'e10adc3949ba59abbe56e057f20f883e', '2001-01-01 00:00:00', NULL, '北京市-市辖区-东城区', '未婚', 162, 45, 4, 4, '计算机/互联网/IT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2970611239@qq.com', 1, '2023-04-27 09:16:36', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (42, 'http://114.55.37.219:9090/files/cbc1edc4b0814d8eb09a1f57f0b914e7.jpg', 'hhh', '男', NULL, '202cb962ac59075b964b07152d234b70', '1997-01-01 00:00:00', '北京市-市辖区-东城区', '北京市-市辖区-东城区', '未婚', 160, 45, 1, 1, '财会/审计/统计', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2634774152@qq.com', 1, '2023-04-28 09:07:56', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (43, NULL, '456', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2023-04-28 09:34:39', 'ROLE_ADMIN', 0);
INSERT INTO `sys_user` VALUES (44, NULL, '4444', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1326384347@qq.com', 1, '2023-04-28 09:42:09', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (45, NULL, 'iii', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'iii', NULL, NULL, NULL, NULL, 1, '2023-04-28 10:17:33', 'ROLE_ADMIN', 0);
INSERT INTO `sys_user` VALUES (46, 'http://114.55.37.219:9090/files/fe89ac0632d84b4c8661507a2a5445e5.jpg', '17815965357', '男', NULL, '202cb962ac59075b964b07152d234b70', '2003-01-01 00:00:00', '', '吉林省-长春市-南关区', '', 0, 0, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1796901790@qq.com', 1, '2023-05-03 15:57:17', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (47, NULL, '0000', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2023-05-03 16:04:46', 'ROLE_ADMIN', 0);
INSERT INTO `sys_user` VALUES (48, NULL, 'admin', NULL, NULL, '202cb962ac59075b964b07152d234b70', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2023-05-04 20:47:33', 'ROLE_ADMIN', 0);
INSERT INTO `sys_user` VALUES (49, 'http://114.55.37.219:9090/files/95c336fa81fc4524af053fa82db16222.jpg', '1', '女', NULL, 'c4ca4238a0b923820dcc509a6f75849b', '1997-01-01 00:00:00', '北京市-市辖区-东城区', '北京市-市辖区-东城区', '未婚', 160, 45, 1, 1, '财会/审计/统计', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '592293364@qq.com', 1, '2023-05-04 23:28:38', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (50, NULL, 'admin9', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2023-05-05 08:39:33', 'ROLE_ADMIN', 0);
INSERT INTO `sys_user` VALUES (51, 'http://114.55.37.219:9090/files/7de35dbc03dc4bacb842b2eaf6b6af89.jpg', 'nb', '女', NULL, 'ae5eb824ef87499f644c3f11a7176157', '1997-01-01 00:00:00', '北京市-市辖区-东城区', '北京市-市辖区-东城区', '离异', 160, 45, 4, 7, '服务业', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '20308331@qq.com', 1, '2023-05-05 08:41:53', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (52, 'http://114.55.37.219:9090/files/f798fea16b8f404fa73c2c9ec089d9c5.jpg', '张三', '男', NULL, '202cb962ac59075b964b07152d234b70', '1997-01-01 00:00:00', '北京市-市辖区-东城区', '北京市-市辖区-东城区', '未婚', 160, 45, 1, 1, '财会/审计/统计', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2642166032@qq.com', 1, '2023-05-05 10:09:24', 'ROLE_USER', 0);
INSERT INTO `sys_user` VALUES (53, 'http://114.55.37.219:9090/files/ccb78b6ea5e3490f9636667e4c990b76.jpg', 'PNNY', '男', NULL, '81dc9bdb52d04dc20036dbd8313ed055', '1997-01-01 00:00:00', '北京市-市辖区-东城区', '北京市-市辖区-东城区', '未婚', 160, 65, 1, 1, '工程/项目', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2059622345@qq.com', 1, '2023-05-05 10:26:10', 'ROLE_USER', 0);

-- ----------------------------
-- Table structure for t_comment
-- ----------------------------
DROP TABLE IF EXISTS `t_comment`;
CREATE TABLE `t_comment`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '内容',
  `user_id` int(0) NULL DEFAULT NULL COMMENT '评论人id',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '评论时间',
  `pid` int(0) NULL DEFAULT NULL COMMENT '父id',
  `origin_id` int(0) NULL DEFAULT NULL COMMENT '最上级评论id',
  `article_id` int(0) NULL DEFAULT NULL COMMENT '关联文章的id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_comment
-- ----------------------------
INSERT INTO `t_comment` VALUES (1, '11111', NULL, '2023-04-26 21:08:57', NULL, NULL, NULL);
INSERT INTO `t_comment` VALUES (26, '评论', 25, '2023-02-26 14:43:30', NULL, NULL, NULL);
INSERT INTO `t_comment` VALUES (27, '评论', 25, '2023-02-26 14:43:44', NULL, NULL, NULL);
INSERT INTO `t_comment` VALUES (28, '评论', 25, '2023-02-26 14:43:48', NULL, NULL, NULL);
INSERT INTO `t_comment` VALUES (29, '评论', 25, '2023-02-26 14:44:38', NULL, NULL, NULL);
INSERT INTO `t_comment` VALUES (41, '评论', 25, '2023-02-26 14:54:27', 40, 40, 2);
INSERT INTO `t_comment` VALUES (43, '评论', 1, '2023-02-26 15:42:56', NULL, NULL, 2);
INSERT INTO `t_comment` VALUES (45, '评论', 2, '2023-02-28 07:58:23', 43, 43, 2);
INSERT INTO `t_comment` VALUES (46, '评论', 2, '2023-02-28 07:58:27', NULL, NULL, 2);
INSERT INTO `t_comment` VALUES (47, 'string', 2, '2023-04-24 13:30:30', 46, 46, 2);

-- ----------------------------
-- Table structure for user_active
-- ----------------------------
DROP TABLE IF EXISTS `user_active`;
CREATE TABLE `user_active`  (
  `active_id` int(0) NOT NULL COMMENT '活动id',
  `user_id` int(0) NOT NULL COMMENT '用户id'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_active
-- ----------------------------
INSERT INTO `user_active` VALUES (1, 2);
INSERT INTO `user_active` VALUES (1, 3);
INSERT INTO `user_active` VALUES (2, 3);
INSERT INTO `user_active` VALUES (2, 7);
INSERT INTO `user_active` VALUES (2, 7);
INSERT INTO `user_active` VALUES (2, 7);
INSERT INTO `user_active` VALUES (2, 31);
INSERT INTO `user_active` VALUES (2, 38);
INSERT INTO `user_active` VALUES (1, 42);
INSERT INTO `user_active` VALUES (4, 49);
INSERT INTO `user_active` VALUES (4, 49);
INSERT INTO `user_active` VALUES (4, 49);
INSERT INTO `user_active` VALUES (4, 49);
INSERT INTO `user_active` VALUES (4, 49);
INSERT INTO `user_active` VALUES (4, 49);
INSERT INTO `user_active` VALUES (4, 52);
INSERT INTO `user_active` VALUES (7, 53);
INSERT INTO `user_active` VALUES (7, 53);

-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名称',
  `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '视频地址',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `state` int(0) NULL DEFAULT 0 COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of video
-- ----------------------------
INSERT INTO `video` VALUES (2, 'lyj1', 'http://114.55.37.219:9090/files/651de2a524e341099f828826e9e2e9bb.mp4', '2023-04-26 19:48:23', 1);
INSERT INTO `video` VALUES (7, 'zqm', 'http://114.55.37.219:9090/files/6461c4ac47d94c388ac68cb894b88134.mp4', '2023-04-27 22:17:57', 1);
INSERT INTO `video` VALUES (12, 'lyj8', 'http://114.55.37.219:9090/files/651de2a524e341099f828826e9e2e9bb.mp4', '2023-04-28 08:25:41', 1);
INSERT INTO `video` VALUES (15, '17815965357', 'http://114.55.37.219:9090/files/dc77423ed1b24906a1247d00aff6328f.mp4', '2023-05-03 16:06:26', 1);
INSERT INTO `video` VALUES (16, 'admin', 'http://114.55.37.219:9090/files/bd59c9a3a4734054bdf0193dfa549215.mp4', '2023-05-04 22:40:40', 1);
INSERT INTO `video` VALUES (17, '1', 'http://114.55.37.219:9090/files/7717693692e34a39803e7448b146824d.mp4', '2023-05-05 08:20:10', 1);
INSERT INTO `video` VALUES (18, 'nb', 'http://114.55.37.219:9090/files/5fcd81a60a0747ecb9be519cf6976e15.mp4', '2023-05-05 08:45:05', 1);
INSERT INTO `video` VALUES (19, '1', 'http://114.55.37.219:9090/files/30e2865c74184a6897e434d8468b5964.mp4', '2023-05-05 09:12:08', 1);
INSERT INTO `video` VALUES (20, '张三', 'http://114.55.37.219:9090/files/e91a2ded1e63421483859d825d150575.mp4', '2023-05-05 10:13:52', 1);
INSERT INTO `video` VALUES (21, 'PNNY', 'http://114.55.37.219:9090/files/94e59cc187b64e1ea843a6dfe857f2b9.mp4', '2023-05-05 10:31:56', 1);

SET FOREIGN_KEY_CHECKS = 1;