/*
 Navicat MySQL Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : xq_pug_travels

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

 Date: 09/04/2022 14:13:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book_rob
-- ----------------------------
DROP TABLE IF EXISTS `book_rob`;
CREATE TABLE `book_rob`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `book_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '书籍编号',
  `rob_time` datetime(0) NULL DEFAULT NULL COMMENT '抢购时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 153 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '书籍抢购记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book_rob
-- ----------------------------
INSERT INTO `book_rob` VALUES (2, 10010, 'BS20190421001', '2019-04-22 22:49:05');
INSERT INTO `book_rob` VALUES (147, 10040, 'BS20190421001', '2019-04-22 23:28:05');
INSERT INTO `book_rob` VALUES (148, 10042, 'BS20190421001', '2019-04-22 23:28:05');
INSERT INTO `book_rob` VALUES (149, 10041, 'BS20190421001', '2019-04-22 23:28:05');
INSERT INTO `book_rob` VALUES (150, 10045, 'BS20190421001', '2019-04-22 23:28:05');
INSERT INTO `book_rob` VALUES (151, 10043, 'BS20190421001', '2019-04-22 23:28:05');
INSERT INTO `book_rob` VALUES (152, 10044, 'BS20190421001', '2019-04-22 23:28:05');

-- ----------------------------
-- Table structure for book_stock
-- ----------------------------
DROP TABLE IF EXISTS `book_stock`;
CREATE TABLE `book_stock`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `book_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '书籍编号',
  `stock` int(255) NOT NULL COMMENT '库存',
  `is_active` tinyint(255) NULL DEFAULT 1 COMMENT '是否上架（1=是；0=否）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '书籍库存表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book_stock
-- ----------------------------
INSERT INTO `book_stock` VALUES (1, 'BS20190421001', 4, 1);

-- ----------------------------
-- Table structure for item
-- ----------------------------
DROP TABLE IF EXISTS `item`;
CREATE TABLE `item`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编号',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `create_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of item
-- ----------------------------
INSERT INTO `item` VALUES (1, 'book_10010', '分布式中间件实战', '2019-03-17 17:21:16');

-- ----------------------------
-- Table structure for kss_banner
-- ----------------------------
DROP TABLE IF EXISTS `kss_banner`;
CREATE TABLE `kss_banner`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `hreflink` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接地址',
  `opentype` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打开方式',
  `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  `img` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面图标',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '排序字段',
  `status` int(11) NULL DEFAULT 0 COMMENT '发布状态',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
  `starttime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开始时间',
  `endtime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结束时间',
  `avatar` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者头像',
  `categoryid` bigint(20) NULL DEFAULT NULL COMMENT '分类',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '轮播图表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_banner
-- ----------------------------
INSERT INTO `kss_banner` VALUES (1495311339505463297, 'xxxx', NULL, NULL, NULL, NULL, NULL, 0, '2022-02-20 16:16:20', '2022-02-20 16:16:20', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495311612747669506, 'xxxx', NULL, NULL, NULL, NULL, NULL, 0, '2022-02-20 16:17:25', '2022-02-20 16:17:25', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495311996387987457, 'xxxx', NULL, NULL, NULL, NULL, NULL, 1, '2022-02-20 16:18:56', '2022-03-03 14:07:25', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495312755859005441, 'xxxx', NULL, NULL, NULL, NULL, NULL, 1, '2022-02-20 16:21:57', '2022-03-03 14:07:25', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495313286325329921, 'xxxx', NULL, NULL, NULL, NULL, NULL, 1, '2022-02-20 16:24:04', '2022-03-03 14:07:24', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495313654635433986, 'xxxx', NULL, NULL, NULL, NULL, NULL, 1, '2022-02-20 16:25:32', '2022-03-03 14:07:24', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495315568387416066, 'xxxx', NULL, NULL, NULL, NULL, NULL, 1, '2022-02-20 16:33:08', '2022-03-03 14:07:23', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495316606070706178, 'xxxx', NULL, NULL, NULL, NULL, NULL, 1, '2022-02-20 16:37:15', '2022-03-03 14:07:22', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495316890599690241, 'xxxx', NULL, NULL, NULL, NULL, NULL, 0, '2022-02-20 16:38:23', '2022-03-03 14:07:31', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495316979992891394, 'xxxx', NULL, NULL, NULL, NULL, NULL, 0, '2022-02-20 16:38:44', '2022-03-03 14:07:27', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495388615270117378, '12', 'xxxxxxxx', NULL, NULL, NULL, NULL, 0, '2022-02-20 21:23:24', '2022-03-03 14:07:30', 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_banner` VALUES (1495390170677465090, '111111', 'https://www.baidu.com', NULL, NULL, NULL, NULL, 1, '2022-02-20 21:29:34', '2022-03-03 14:07:16', NULL, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for kss_hotel
-- ----------------------------
DROP TABLE IF EXISTS `kss_hotel`;
CREATE TABLE `kss_hotel`  (
  `id` bigint(20) NOT NULL,
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `img` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `imglists` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `price` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `realprice` decimal(10, 2) NULL DEFAULT NULL,
  `status` int(1) NULL DEFAULT NULL,
  `isdelete` int(1) NULL DEFAULT NULL,
  `views` int(11) NULL DEFAULT NULL,
  `collects` int(11) NULL DEFAULT NULL,
  `buynum` int(11) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  `lan` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lgt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `contury` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `area` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `starlevel` int(1) NULL DEFAULT NULL,
  `hotel_category_id` bigint(20) NULL DEFAULT NULL,
  `tags` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `hotel_brand_id` bigint(20) NULL DEFAULT NULL,
  `hotel_brand_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `hotel_category_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `advice` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `hotel_service_item` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `comments` int(11) NULL DEFAULT NULL,
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_hotel
-- ----------------------------
INSERT INTO `kss_hotel` VALUES (1, '卡米酒店', 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380', '10.00', 10.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (2, '慕尚卡米酒店 (万家丽地铁店)2', 'https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '20.00', 20.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (3, '慕尚卡米酒店 (万家丽地铁店)3', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '30.00', 300.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (4, '慕尚卡米酒店 (万家丽地铁店)4', 'https://dimg11.c-ctrip.com/images/020691200082co240B8EA_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '40.00', 400.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (5, '慕尚卡米酒店 (万家丽地铁店)5', 'https://dimg11.c-ctrip.com/images/hotel/1000/10/d185c983e00945e1b9037ce5fa7528e3_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '50.00', 500.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (6, '慕尚卡米酒店 (万家丽地铁店)6', 'https://dimg11.c-ctrip.com/images/200l0z000000nokhrF75F_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '60.00', 300.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (7, '慕尚卡米酒店 (万家丽地铁店)7', 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '70.00', 240.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (8, '慕尚卡米酒店 (万家丽地铁店)8', 'https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '80.00', 180.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (9, '慕尚卡米酒店 (万家丽地铁店)9', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '90.00', 210.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (10, '慕尚卡米酒店 (万家丽地铁店)10', 'https://dimg11.c-ctrip.com/images/020691200082co240B8EA_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '100.00', 320.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (11, '慕尚卡米酒店 (万家丽地铁店)11', 'https://dimg11.c-ctrip.com/images/hotel/1000/10/d185c983e00945e1b9037ce5fa7528e3_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '110.00', 480.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');
INSERT INTO `kss_hotel` VALUES (12, '慕尚卡米酒店 (万家丽地铁店)12', 'https://dimg11.c-ctrip.com/images/200l0z000000nokhrF75F_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '芙蓉中路380号汇金国际银座(近地铁1,4号)', '120.00', 490.00, 1, 0, 0, 0, 0, '2022-03-19 17:26:31', '2022-03-19 17:26:34', '116.296165', '23.197266', '中国', '长沙', '芙蓉区', '湖南', 4, 1, '舒适', 1, '七天', '大床房', NULL, '[{\"title\":\"WIFI\",\"icon\":\"/pagessub/static/images/wifi.png\",\"sort\":4},{\"title\":\"中餐厅\",\"icon\":\"/pagessub/static/images/food.png\",\"sort\":2},{\"title\":\"叫醒服务\",\"icon\":\"/pagessub/static/images/clock.png\",\"sort\":1},{\"title\":\"泳池\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":3},{\"title\":\"免费停车\",\"icon\":\"/pagessub/static/images/parking.png\",\"sort\":5}]', NULL, '长沙芙蓉区五一大道东501室', '0731-125897841');

-- ----------------------------
-- Table structure for kss_hotel_brand
-- ----------------------------
DROP TABLE IF EXISTS `kss_hotel_brand`;
CREATE TABLE `kss_hotel_brand`  (
  `id` bigint(20) NOT NULL COMMENT '主健',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌的名称',
  `description` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌的描述',
  `starlevel` int(1) NULL DEFAULT NULL COMMENT '品牌的星级',
  `status` int(1) NULL DEFAULT NULL COMMENT '发布状态 0未发布 1发布',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态',
  `logo` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌的logo',
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌的地址',
  `netlink` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌的官网',
  `telephone` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '品牌的联系方式',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_hotel_brand
-- ----------------------------

-- ----------------------------
-- Table structure for kss_hotel_category
-- ----------------------------
DROP TABLE IF EXISTS `kss_hotel_category`;
CREATE TABLE `kss_hotel_category`  (
  `id` bigint(20) NOT NULL COMMENT '主健',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `description` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  `status` int(1) NULL DEFAULT NULL COMMENT '状态 0未发布 1发布',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态0未删除1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_hotel_category
-- ----------------------------

-- ----------------------------
-- Table structure for kss_hotel_comment
-- ----------------------------
DROP TABLE IF EXISTS `kss_hotel_comment`;
CREATE TABLE `kss_hotel_comment`  (
  `id` bigint(20) NOT NULL COMMENT '主健',
  `content` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评论内容',
  `userid` bigint(20) NULL DEFAULT NULL COMMENT '评论用户id',
  `usernickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评论用户昵称',
  `useravatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评论用户头像',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新hijack',
  `reply_userid` bigint(20) NULL DEFAULT NULL COMMENT '回复用户id',
  `reply_usernickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复用户昵称',
  `reply_useravatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '回复用户头像',
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '评论的层级0第一级 1第二级',
  `hotel_id` bigint(20) NULL DEFAULT NULL COMMENT '酒店ID',
  `zannum` int(11) NULL DEFAULT NULL COMMENT '点赞数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_hotel_comment
-- ----------------------------
INSERT INTO `kss_hotel_comment` VALUES (1506462657548800002, '234234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:47:41', '2022-03-23 10:47:41', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', 1506462646308065282, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1506462668089085954, '234234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:47:43', '2022-03-23 10:47:43', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', 1506462646308065282, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1506462677316554754, '234234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:47:46', '2022-03-23 10:47:46', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', 1506462646308065282, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1506462695515639810, '234234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:47:50', '2022-03-23 10:47:50', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', 1506462646308065282, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1506464376672374786, '33333', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:54:31', '2022-03-23 10:54:31', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', 1506464362944417794, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1506464388647112705, '322323', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:54:34', '2022-03-23 10:54:34', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', 1506464362944417794, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1506464490560311298, '34234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:54:58', '2022-03-23 10:54:58', NULL, NULL, NULL, 0, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1506464495778025473, '234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:54:59', '2022-03-23 10:54:59', NULL, NULL, NULL, 0, 1, 2);
INSERT INTO `kss_hotel_comment` VALUES (1506464500324651010, '234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:55:00', '2022-03-23 10:55:00', NULL, NULL, NULL, 0, 1, 1);
INSERT INTO `kss_hotel_comment` VALUES (1506464506632884226, '234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:55:02', '2022-03-23 10:55:02', NULL, NULL, NULL, 0, 1, 2);
INSERT INTO `kss_hotel_comment` VALUES (1506464512966283265, '234234', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-23 10:55:03', '2022-03-23 10:55:03', NULL, NULL, NULL, 0, 1, 0);
INSERT INTO `kss_hotel_comment` VALUES (1507261646187724802, '11111111111', 1507049814038626306, '微信用户', 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', '2022-03-25 15:42:35', '2022-03-25 15:42:35', NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO `kss_hotel_comment` VALUES (1507388795481686018, '24234234', 1507049814038626306, '微信用户', 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', '2022-03-26 00:07:49', '2022-03-26 00:07:49', NULL, NULL, NULL, 0, 1, NULL);
INSERT INTO `kss_hotel_comment` VALUES (1507695550359089154, '11111111111', 1500331998711320578, '越野小天', 'https://vkceyugu.cdn.bspapp.com/VKCEYUGU-a8cf392b-611a-4c97-826e-4bb382856d05/4c630245-1e92-4cdb-aa7e-44255208508f.jpg', '2022-03-26 20:26:45', '2022-03-26 20:26:45', 1507049814038626306, '微信用户', 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', 1506464512966283265, 1, NULL);

-- ----------------------------
-- Table structure for kss_hotel_comment_user_zans
-- ----------------------------
DROP TABLE IF EXISTS `kss_hotel_comment_user_zans`;
CREATE TABLE `kss_hotel_comment_user_zans`  (
  `id` bigint(20) NOT NULL COMMENT '主健',
  `userid` bigint(20) NULL DEFAULT NULL COMMENT '评论用户id',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `comment_id` bigint(20) NULL DEFAULT NULL COMMENT '点赞的评论id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_hotel_comment_user_zans
-- ----------------------------
INSERT INTO `kss_hotel_comment_user_zans` VALUES (1506479931974365186, 1500331998711320578, '2022-03-23 11:56:19', 1506464506632884226);
INSERT INTO `kss_hotel_comment_user_zans` VALUES (1506481295475539970, 1500331998711320578, '2022-03-23 12:01:45', 1506464495778025473);
INSERT INTO `kss_hotel_comment_user_zans` VALUES (1506481469484630018, 13900010001, '2022-03-23 12:02:26', 1506464495778025473);
INSERT INTO `kss_hotel_comment_user_zans` VALUES (1506481473188200450, 13900010001, '2022-03-23 12:02:27', 1506464506632884226);
INSERT INTO `kss_hotel_comment_user_zans` VALUES (1506481477416058881, 13900010001, '2022-03-23 12:02:28', 1506464500324651010);

-- ----------------------------
-- Table structure for kss_hotel_type
-- ----------------------------
DROP TABLE IF EXISTS `kss_hotel_type`;
CREATE TABLE `kss_hotel_type`  (
  `id` bigint(20) NOT NULL COMMENT '主健',
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `img` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面图',
  `imglists` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '图集',
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  `price` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房型价格',
  `realprice` decimal(10, 2) NULL DEFAULT NULL COMMENT '房型成交价格',
  `hotel_id` bigint(20) NULL DEFAULT NULL COMMENT '酒店',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `status` int(1) NULL DEFAULT NULL COMMENT '发布状态1发布0未发布',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '排序字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_hotel_type
-- ----------------------------
INSERT INTO `kss_hotel_type` VALUES (1, '大床房1', 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '无早餐 30m 大床 2人入住 有窗', '350', 0.01, 1, '2022-03-21 21:59:00', '2022-03-21 21:59:03', 1, 1);
INSERT INTO `kss_hotel_type` VALUES (2, '大床房2', 'https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '无早餐 30m 大床 2人入住 有窗', '350', 0.01, 1, '2022-03-21 21:59:00', '2022-03-21 21:59:03', 1, 1);
INSERT INTO `kss_hotel_type` VALUES (3, '大床房3', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '无早餐 30m 大床 2人入住 有窗', '350', 0.01, 1, '2022-03-21 21:59:00', '2022-03-21 21:59:03', 1, 1);
INSERT INTO `kss_hotel_type` VALUES (4, '大床房4', 'https://dimg11.c-ctrip.com/images/020691200082co240B8EA_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '无早餐 30m 大床 2人入住 有窗', '350', 0.01, 1, '2022-03-21 21:59:00', '2022-03-21 21:59:03', 1, 1);
INSERT INTO `kss_hotel_type` VALUES (5, '大床房5', 'https://dimg11.c-ctrip.com/images/hotel/1000/10/d185c983e00945e1b9037ce5fa7528e3_R_300_120.jpg', 'https://dimg04.c-ctrip.com/images/02053120008whtqp29D16_R_300_225_R5_Q70_D.jpg,https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg,https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '无早餐 30m 大床 2人入住 有窗', '350', 0.01, 1, '2022-03-21 21:59:00', '2022-03-21 21:59:03', 1, 1);

-- ----------------------------
-- Table structure for kss_user_collect_hotel
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_collect_hotel`;
CREATE TABLE `kss_user_collect_hotel`  (
  `id` bigint(20) NOT NULL COMMENT ' ',
  `userid` bigint(20) NULL DEFAULT NULL,
  `hotelid` bigint(20) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_collect_hotel
-- ----------------------------

-- ----------------------------
-- Table structure for kss_user_fans
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_fans`;
CREATE TABLE `kss_user_fans`  (
  `id` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `vloger_id` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作家用户id',
  `fan_id` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '粉丝用户id',
  `is_fan_friend_of_mine` int(1) NOT NULL COMMENT '粉丝是否是vloger的朋友，如果成为朋友，则本表的双方此字段都需要设置为1，如果有一人取关，则两边都需要设置为0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `writer_id`(`vloger_id`, `fan_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '粉丝表\n\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_fans
-- ----------------------------
INSERT INTO `kss_user_fans` VALUES ('2110057Y9ADR26A8', '1001', '2110057Y6PN9WMK4', 1);
INSERT INTO `kss_user_fans` VALUES ('2110057YB9CM344H', '211003H4SG5Y1ZF8', '2110057Y6PN9WMK4', 0);
INSERT INTO `kss_user_fans` VALUES ('21100580ADHWKCDP', '2110057Y6PN9WMK4', '211005800N0W837C', 0);
INSERT INTO `kss_user_fans` VALUES ('21100580AY07ZFY8', '1001', '211005800N0W837C', 1);
INSERT INTO `kss_user_fans` VALUES ('2110058171C7F2RP', '211005800N0W837C', '1001', 1);
INSERT INTO `kss_user_fans` VALUES ('21100581BZ779AW0', '2110057Y6PN9WMK4', '1001', 1);
INSERT INTO `kss_user_fans` VALUES ('2110058C23BKGC00', '2110057Y6PN9WMK4', '2110058BX246X39P', 1);
INSERT INTO `kss_user_fans` VALUES ('2110058C2F52KAFW', '1001', '2110058BX246X39P', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058DD1GGRZF8', '2110058BX246X39P', '2110058D0KPZSCH0', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058DD9WMRKAW', '2110057Y6PN9WMK4', '2110058D0KPZSCH0', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058DFRZGG25P', '1001', '2110058D0KPZSCH0', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058F9H8K2S14', '2110058D0KPZSCH0', '2110058DPP1ZPKKP', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058FA2Y7YF5P', '2110058BX246X39P', '2110058DPP1ZPKKP', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058FA86T1WH0', '2110057Y6PN9WMK4', '2110058DPP1ZPKKP', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058FAMAZM1S8', '1001', '2110058DPP1ZPKKP', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058GGB535K1P', '2110058D0KPZSCH0', '2110058FN9GYCFNC', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058GGHNAN1GC', '2110058BX246X39P', '2110058FN9GYCFNC', 1);
INSERT INTO `kss_user_fans` VALUES ('2110058GH0NSZ3F8', '2110057Y6PN9WMK4', '2110058FN9GYCFNC', 0);
INSERT INTO `kss_user_fans` VALUES ('2110058GH99NK4ZC', '1001', '2110058FN9GYCFNC', 1);
INSERT INTO `kss_user_fans` VALUES ('2110058M200GKA5P', '2110058FN9GYCFNC', '1001', 1);
INSERT INTO `kss_user_fans` VALUES ('211005932XF95YW0', '2110058FN9GYCFNC', '211005929C8GTNTC', 0);
INSERT INTO `kss_user_fans` VALUES ('2110059339D1PGMW', '2110058D0KPZSCH0', '211005929C8GTNTC', 0);
INSERT INTO `kss_user_fans` VALUES ('21100593496A8Y3C', '1001', '211005929C8GTNTC', 1);
INSERT INTO `kss_user_fans` VALUES ('211005941R2R577C', '211005929C8GTNTC', '21100593CR144MK4', 0);
INSERT INTO `kss_user_fans` VALUES ('2110059431ARNSRP', '1001', '21100593CR144MK4', 1);
INSERT INTO `kss_user_fans` VALUES ('21100597H22W1N0H', '1001', '211005967WASBB9P', 1);
INSERT INTO `kss_user_fans` VALUES ('21100597SX02ZB9P', '211005929C8GTNTC', '1001', 1);
INSERT INTO `kss_user_fans` VALUES ('2110059G1KRDX7HH', '2110058BX246X39P', '2110057Y6PN9WMK4', 1);
INSERT INTO `kss_user_fans` VALUES ('2110059HN0NPHNHH', '2110058D0KPZSCH0', '211005800N0W837C', 0);
INSERT INTO `kss_user_fans` VALUES ('211005A5787HKN0H', '211005967WASBB9P', '2110058BX246X39P', 0);
INSERT INTO `kss_user_fans` VALUES ('211005A5ASRR725P', '2110058FN9GYCFNC', '2110058BX246X39P', 1);
INSERT INTO `kss_user_fans` VALUES ('211005AF10KRPNHH', '21100598TZ9XG6RP', '2110058D0KPZSCH0', 0);
INSERT INTO `kss_user_fans` VALUES ('211006GN2H4DW84H', '211005967WASBB9P', '1001', 1);
INSERT INTO `kss_user_fans` VALUES ('2110077K60T3CZC0', '21100593CR144MK4', '1001', 1);

-- ----------------------------
-- Table structure for kss_user_like_video
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_like_video`;
CREATE TABLE `kss_user_like_video`  (
  `id` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
  `vlog_id` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '喜欢的短视频id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `writer_id`(`user_id`, `vlog_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点赞短视频关联表\n' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_like_video
-- ----------------------------
INSERT INTO `kss_user_like_video` VALUES ('211004HM4NYMM9YW', '1001', '2110048SH1BRRP94');
INSERT INTO `kss_user_like_video` VALUES ('21100582BHRD31WH', '1001', '2110057ZG1394940');
INSERT INTO `kss_user_like_video` VALUES ('211005ASYXSKZ3TC', '1001', '2110058DBZ4RSWZC');
INSERT INTO `kss_user_like_video` VALUES ('211005AGFBMMFZXP', '1001', '2110058GDGCAZDYW');
INSERT INTO `kss_user_like_video` VALUES ('211005AGF6T1251P', '1001', '211005931KAH325P');
INSERT INTO `kss_user_like_video` VALUES ('211005AGDXYT0ARP', '1001', '2110059373F4ADWH');
INSERT INTO `kss_user_like_video` VALUES ('211005AGDRYHM04H', '1001', '21100594K819846W');
INSERT INTO `kss_user_like_video` VALUES ('211005AGDKMN90BC', '1001', '211005956F0BN7R4');
INSERT INTO `kss_user_like_video` VALUES ('211005987B5Y9CDP', '1001', '21100597F3ABW0ZC');
INSERT INTO `kss_user_like_video` VALUES ('211005987KZS2N2W', '1001', '21100597NPC09FCH');
INSERT INTO `kss_user_like_video` VALUES ('2110070WZ0DG6B7C', '1001', '21100599C6HCGXAW');
INSERT INTO `kss_user_like_video` VALUES ('211005AGCC0FBRS8', '1001', '21100599X82DARAW');
INSERT INTO `kss_user_like_video` VALUES ('2110057YBF7X9A5P', '2110057Y6PN9WMK4', '211003HC19CASM3C');
INSERT INTO `kss_user_like_video` VALUES ('2110057YFZ7G5GR4', '2110057Y6PN9WMK4', '2110048PYTNFGCZC');
INSERT INTO `kss_user_like_video` VALUES ('2110059G217MZXP0', '2110057Y6PN9WMK4', '2110057ZG1394940');
INSERT INTO `kss_user_like_video` VALUES ('2110059G1B0KC8DP', '2110057Y6PN9WMK4', '2110058CKB0R4S5P');
INSERT INTO `kss_user_like_video` VALUES ('2110059FZS015YW0', '2110057Y6PN9WMK4', '2110058DBZ4RSWZC');
INSERT INTO `kss_user_like_video` VALUES ('2110059FZDH3R1AW', '2110057Y6PN9WMK4', '2110058GDGCAZDYW');
INSERT INTO `kss_user_like_video` VALUES ('2110059FRB334RGC', '2110057Y6PN9WMK4', '2110059373F4ADWH');
INSERT INTO `kss_user_like_video` VALUES ('2110059FR4FF3D8H', '2110057Y6PN9WMK4', '21100594K819846W');
INSERT INTO `kss_user_like_video` VALUES ('2110059FNCBRMXYW', '2110057Y6PN9WMK4', '211005956F0BN7R4');
INSERT INTO `kss_user_like_video` VALUES ('2110059FKZ2RH280', '2110057Y6PN9WMK4', '21100597F3ABW0ZC');
INSERT INTO `kss_user_like_video` VALUES ('2110059FGRZNF800', '2110057Y6PN9WMK4', '21100597NPC09FCH');
INSERT INTO `kss_user_like_video` VALUES ('2110059FDK79NC94', '2110057Y6PN9WMK4', '21100599C6HCGXAW');
INSERT INTO `kss_user_like_video` VALUES ('2110059F78SM90PH', '2110057Y6PN9WMK4', '21100599X82DARAW');
INSERT INTO `kss_user_like_video` VALUES ('2110059M91DSYMCH', '211005800N0W837C', '2109307DX5GFABXP');
INSERT INTO `kss_user_like_video` VALUES ('2110059M8MB5ZNF8', '211005800N0W837C', '211001BKH355BGHH');
INSERT INTO `kss_user_like_video` VALUES ('2110059M3NKFYGTC', '211005800N0W837C', '2110048R6R5WW0M8');
INSERT INTO `kss_user_like_video` VALUES ('2110059M14HWGB0H', '211005800N0W837C', '2110048RAYSPYG54');
INSERT INTO `kss_user_like_video` VALUES ('2110059KPD61Z91P', '211005800N0W837C', '2110048RMXYN8KYW');
INSERT INTO `kss_user_like_video` VALUES ('2110059KNDG262CH', '211005800N0W837C', '2110048RS1AK5N0H');
INSERT INTO `kss_user_like_video` VALUES ('2110059KM74MY800', '211005800N0W837C', '2110048RXXDD2F5P');
INSERT INTO `kss_user_like_video` VALUES ('2110059KHR35KSK4', '211005800N0W837C', '2110048S5RK2BB9P');
INSERT INTO `kss_user_like_video` VALUES ('2110059K4BK2GF80', '211005800N0W837C', '2110048S95SXG2W0');
INSERT INTO `kss_user_like_video` VALUES ('2110059K0MBB0094', '211005800N0W837C', '2110048SBFZ8N25P');
INSERT INTO `kss_user_like_video` VALUES ('2110059HYDNRMA80', '211005800N0W837C', '2110048SF3RC8W4H');
INSERT INTO `kss_user_like_video` VALUES ('2110059HWGHFFYK4', '211005800N0W837C', '2110048SH1BRRP94');
INSERT INTO `kss_user_like_video` VALUES ('2110059HWAMNMFW0', '211005800N0W837C', '2110057Z0WAZWBC0');
INSERT INTO `kss_user_like_video` VALUES ('2110059HTY9A8FA8', '211005800N0W837C', '2110057ZG1394940');
INSERT INTO `kss_user_like_video` VALUES ('2110059HN85Y40ZC', '211005800N0W837C', '2110058CKB0R4S5P');
INSERT INTO `kss_user_like_video` VALUES ('2110059HMS2473TC', '211005800N0W837C', '2110058DBZ4RSWZC');
INSERT INTO `kss_user_like_video` VALUES ('2110059HMFF037C0', '211005800N0W837C', '2110058GDGCAZDYW');
INSERT INTO `kss_user_like_video` VALUES ('2110059HHWG9PPX4', '211005800N0W837C', '211005931KAH325P');
INSERT INTO `kss_user_like_video` VALUES ('2110059HH85S09S8', '211005800N0W837C', '2110059373F4ADWH');
INSERT INTO `kss_user_like_video` VALUES ('2110059HGY5WTTC0', '211005800N0W837C', '21100594K819846W');
INSERT INTO `kss_user_like_video` VALUES ('2110059HFX75B7R4', '211005800N0W837C', '211005956F0BN7R4');
INSERT INTO `kss_user_like_video` VALUES ('2110059HFN3AK028', '211005800N0W837C', '21100597F3ABW0ZC');
INSERT INTO `kss_user_like_video` VALUES ('2110059HF8X7C7TC', '211005800N0W837C', '21100597NPC09FCH');
INSERT INTO `kss_user_like_video` VALUES ('2110059H8GTNBDKP', '211005800N0W837C', '21100599C6HCGXAW');
INSERT INTO `kss_user_like_video` VALUES ('2110059H17A79494', '211005800N0W837C', '21100599X82DARAW');
INSERT INTO `kss_user_like_video` VALUES ('211005A6R4MGZXAW', '2110058BX246X39P', '211003HC19CASM3C');
INSERT INTO `kss_user_like_video` VALUES ('211005A6P1T35968', '2110058BX246X39P', '2110048PYTNFGCZC');
INSERT INTO `kss_user_like_video` VALUES ('211005A6MXYBFNR4', '2110058BX246X39P', '2110048R6R5WW0M8');
INSERT INTO `kss_user_like_video` VALUES ('211005A6K9M1MXYW', '2110058BX246X39P', '2110048RAYSPYG54');
INSERT INTO `kss_user_like_video` VALUES ('211005A645DH52A8', '2110058BX246X39P', '2110048RMXYN8KYW');
INSERT INTO `kss_user_like_video` VALUES ('211005A62HMZ3WPH', '2110058BX246X39P', '2110048RS1AK5N0H');
INSERT INTO `kss_user_like_video` VALUES ('211005A619A3D8H0', '2110058BX246X39P', '2110048RXXDD2F5P');
INSERT INTO `kss_user_like_video` VALUES ('211005A60BTH0NHH', '2110058BX246X39P', '2110048S5RK2BB9P');
INSERT INTO `kss_user_like_video` VALUES ('211005A5Z51D5N0H', '2110058BX246X39P', '2110048S95SXG2W0');
INSERT INTO `kss_user_like_video` VALUES ('211005A5XYPX2WM8', '2110058BX246X39P', '2110048SBFZ8N25P');
INSERT INTO `kss_user_like_video` VALUES ('211005A5W3PFMW94', '2110058BX246X39P', '2110048SF3RC8W4H');
INSERT INTO `kss_user_like_video` VALUES ('211005A5TRH37K68', '2110058BX246X39P', '2110048SH1BRRP94');
INSERT INTO `kss_user_like_video` VALUES ('211005A5TFMTZC94', '2110058BX246X39P', '2110057Z0WAZWBC0');
INSERT INTO `kss_user_like_video` VALUES ('211005A5T67MZPDP', '2110058BX246X39P', '2110057ZG1394940');
INSERT INTO `kss_user_like_video` VALUES ('211005A5RPANXZTC', '2110058BX246X39P', '2110058CKB0R4S5P');
INSERT INTO `kss_user_like_video` VALUES ('211005A5CRWC1G2W', '2110058BX246X39P', '2110058DBZ4RSWZC');
INSERT INTO `kss_user_like_video` VALUES ('211005A5ARHAAWZC', '2110058BX246X39P', '2110058GDGCAZDYW');
INSERT INTO `kss_user_like_video` VALUES ('211005A5972HDFRP', '2110058BX246X39P', '211005931KAH325P');
INSERT INTO `kss_user_like_video` VALUES ('211005A591SX6WZC', '2110058BX246X39P', '2110059373F4ADWH');
INSERT INTO `kss_user_like_video` VALUES ('211005A58SD99T7C', '2110058BX246X39P', '21100594K819846W');
INSERT INTO `kss_user_like_video` VALUES ('211005A58GPCWW4H', '2110058BX246X39P', '211005956F0BN7R4');
INSERT INTO `kss_user_like_video` VALUES ('211005A57BM7N6CH', '2110058BX246X39P', '21100597F3ABW0ZC');
INSERT INTO `kss_user_like_video` VALUES ('211005A54F5X4S5P', '2110058BX246X39P', '21100597NPC09FCH');
INSERT INTO `kss_user_like_video` VALUES ('211005A4DD8433F8', '2110058BX246X39P', '21100599C6HCGXAW');
INSERT INTO `kss_user_like_video` VALUES ('211005AFD2KGW3HH', '2110058D0KPZSCH0', '211003HC19CASM3C');
INSERT INTO `kss_user_like_video` VALUES ('211005AFCWYBX9GC', '2110058D0KPZSCH0', '2110048PYTNFGCZC');
INSERT INTO `kss_user_like_video` VALUES ('211005AFCNG93RD4', '2110058D0KPZSCH0', '2110048R6R5WW0M8');
INSERT INTO `kss_user_like_video` VALUES ('211005AFCDZYYFFW', '2110058D0KPZSCH0', '2110048RAYSPYG54');
INSERT INTO `kss_user_like_video` VALUES ('211005AFC93PC0ZC', '2110058D0KPZSCH0', '2110048RMXYN8KYW');
INSERT INTO `kss_user_like_video` VALUES ('211005AFC4RZY140', '2110058D0KPZSCH0', '2110048RS1AK5N0H');
INSERT INTO `kss_user_like_video` VALUES ('211005AFC03PHNHH', '2110058D0KPZSCH0', '2110048RXXDD2F5P');
INSERT INTO `kss_user_like_video` VALUES ('211005AFBPXYD4ZC', '2110058D0KPZSCH0', '2110048S5RK2BB9P');
INSERT INTO `kss_user_like_video` VALUES ('211005AFBD9XPTF8', '2110058D0KPZSCH0', '2110048S95SXG2W0');
INSERT INTO `kss_user_like_video` VALUES ('211005AFB7K8TM5P', '2110058D0KPZSCH0', '2110048SBFZ8N25P');
INSERT INTO `kss_user_like_video` VALUES ('211005AFB2K1PGMW', '2110058D0KPZSCH0', '2110048SF3RC8W4H');
INSERT INTO `kss_user_like_video` VALUES ('211005AFAKG74XD4', '2110058D0KPZSCH0', '2110048SH1BRRP94');
INSERT INTO `kss_user_like_video` VALUES ('211005AFABWZ2W00', '2110058D0KPZSCH0', '2110057Z0WAZWBC0');
INSERT INTO `kss_user_like_video` VALUES ('211005AFA6ANKBF8', '2110058D0KPZSCH0', '2110057ZG1394940');
INSERT INTO `kss_user_like_video` VALUES ('211005AFA0GX8K8H', '2110058D0KPZSCH0', '2110058CKB0R4S5P');
INSERT INTO `kss_user_like_video` VALUES ('211005ADZTH87GHH', '2110058D0KPZSCH0', '2110058DBZ4RSWZC');
INSERT INTO `kss_user_like_video` VALUES ('211005AF9NSK3KGC', '2110058D0KPZSCH0', '2110058GDGCAZDYW');
INSERT INTO `kss_user_like_video` VALUES ('211005AF9F646H4H', '2110058D0KPZSCH0', '211005931KAH325P');
INSERT INTO `kss_user_like_video` VALUES ('211005AF99S68ZC0', '2110058D0KPZSCH0', '2110059373F4ADWH');
INSERT INTO `kss_user_like_video` VALUES ('211005AF93ZS6S14', '2110058D0KPZSCH0', '21100594K819846W');
INSERT INTO `kss_user_like_video` VALUES ('211005AF618CYXKP', '2110058D0KPZSCH0', '211005956F0BN7R4');
INSERT INTO `kss_user_like_video` VALUES ('211005AF5TC28568', '2110058D0KPZSCH0', '21100597F3ABW0ZC');
INSERT INTO `kss_user_like_video` VALUES ('211005AF5M6D1KAW', '2110058D0KPZSCH0', '21100597NPC09FCH');
INSERT INTO `kss_user_like_video` VALUES ('211005AF5DW02BXP', '2110058D0KPZSCH0', '21100599C6HCGXAW');
INSERT INTO `kss_user_like_video` VALUES ('211005AF12ZYBB9P', '2110058D0KPZSCH0', '21100599X82DARAW');
INSERT INTO `kss_user_like_video` VALUES ('2110058FF2ATHK8H', '2110058DPP1ZPKKP', '2110058DBZ4RSWZC');
INSERT INTO `kss_user_like_video` VALUES ('21100594N2SB046W', '21100593CR144MK4', '21100594K819846W');
INSERT INTO `kss_user_like_video` VALUES ('21100599DG25CG0H', '21100598TZ9XG6RP', '21100599C6HCGXAW');
INSERT INTO `kss_user_like_video` VALUES ('2110059A3CGXN1WH', '21100598TZ9XG6RP', '21100599X82DARAW');

-- ----------------------------
-- Table structure for kss_user_message_order
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_message_order`;
CREATE TABLE `kss_user_message_order`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `message_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1512093071550402562 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_message_order
-- ----------------------------
INSERT INTO `kss_user_message_order` VALUES (1512093058925547521, '624edc69c3c4c80e4455f737', 1511758403479158785, '2022-04-07 23:40:53', '2022-04-07 23:40:53');
INSERT INTO `kss_user_message_order` VALUES (1512093071550402561, '624dcf2443eab570c8964482', 1511758403479158785, '2022-04-07 23:40:56', '2022-04-07 23:40:56');

-- ----------------------------
-- Table structure for kss_user_message_sys
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_message_sys`;
CREATE TABLE `kss_user_message_sys`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `message_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_message_sys
-- ----------------------------

-- ----------------------------
-- Table structure for kss_user_message_user
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_message_user`;
CREATE TABLE `kss_user_message_user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `message_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_message_user
-- ----------------------------

-- ----------------------------
-- Table structure for kss_user_order
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_order`;
CREATE TABLE `kss_user_order`  (
  `id` bigint(20) NOT NULL COMMENT '主健',
  `orderno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单编号 微信支付和阿里支付 用来退款',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '下单用户id',
  `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下单用户的昵称',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下单用户的头像',
  `status` int(1) NULL DEFAULT NULL COMMENT '订单状态 -1 失效的订单 0 未支付的订单 1 已支付 2已完成',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `paymoney` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下单金额',
  `hotel_id` bigint(20) NULL DEFAULT NULL COMMENT '酒店id',
  `hotel_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店封面',
  `hotel_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店标题',
  `hotel_desc` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店描述',
  `hotel_detail_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店房型标题',
  `hotel_detail_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店房型图标',
  `hotel_detail_id` bigint(20) NULL DEFAULT NULL COMMENT '酒店房型id',
  `tradeno` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易号，微信支付和阿里支付 方便退款',
  `openid` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单金额',
  `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付IP地址',
  `ipaddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付用户的IP具体地址',
  `paytype` int(1) NULL DEFAULT NULL COMMENT '支付方式 1 微信支付 2 支付支付 3 待定',
  `hotel_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店地址',
  `hotel_tel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店联系方式',
  `hotel_lgt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店经度',
  `hotel_lan` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '酒店纬度',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_order
-- ----------------------------
INSERT INTO `kss_user_order` VALUES (1511759255258439682, '961438779749699584', 1511758403479158785, '小伴', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 0, '2022-04-07 01:34:28', '2022-04-07 01:34:28', '0.01', 1, 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '卡米酒店', '芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380', '大床房4', 'https://dimg11.c-ctrip.com/images/020691200082co240B8EA_R_300_120.jpg', 4, '', 'ofkpG5ZGkG9rw46KtNy93G9roDoQ', NULL, '', 1, '长沙芙蓉区五一大道东501室', '0731-125897841', '23.197266', '116.296165');
INSERT INTO `kss_user_order` VALUES (1512048380637265922, '961727905271123968', 1511758403479158785, '小伴', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 0, '2022-04-07 20:43:21', '2022-04-07 20:43:21', '0.01', 1, 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '卡米酒店', '芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380', '大床房1', 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', 1, '', 'ofkpG5ZGkG9rw46KtNy93G9roDoQ', NULL, '', 1, '长沙芙蓉区五一大道东501室', '0731-125897841', '23.197266', '116.296165');
INSERT INTO `kss_user_order` VALUES (1512055115187990529, '961734639674986496', 1511758403479158785, '小伴', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 0, '2022-04-07 21:10:07', '2022-04-07 21:10:07', '0.01', 1, 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '卡米酒店', '芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380', '大床房4', 'https://dimg11.c-ctrip.com/images/020691200082co240B8EA_R_300_120.jpg', 4, '', 'ofkpG5ZGkG9rw46KtNy93G9roDoQ', NULL, '', 1, '长沙芙蓉区五一大道东501室', '0731-125897841', '23.197266', '116.296165');
INSERT INTO `kss_user_order` VALUES (1512055495330344962, '961735020224188416', 1511758403479158785, '小伴', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 0, '2022-04-07 21:11:37', '2022-04-07 21:11:37', '0.01', 1, 'https://dimg11.c-ctrip.com/images/0200n1200098tif1v8AE0_R_300_120.jpg', '卡米酒店', '芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380号汇金国际银座(近地铁1,4号)芙蓉中路380', '大床房4', 'https://dimg11.c-ctrip.com/images/020691200082co240B8EA_R_300_120.jpg', 4, '', 'ofkpG5ZGkG9rw46KtNy93G9roDoQ', NULL, '', 1, '长沙芙蓉区五一大道东501室', '0731-125897841', '23.197266', '116.296165');

-- ----------------------------
-- Table structure for kss_user_order_error
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_order_error`;
CREATE TABLE `kss_user_order_error`  (
  `id` bigint(20) NOT NULL COMMENT '主健',
  `orderno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单编号',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '下单用户id',
  `nickname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下单用户的昵称',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下单用户的头像',
  `status` int(1) NULL DEFAULT NULL COMMENT '订单状态 -1 失效的订单 0 未支付的订单 1 已支付 2已完成',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `paymoney` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下单金额',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user_order_error
-- ----------------------------
INSERT INTO `kss_user_order_error` VALUES (1510296152138252290, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, -1, '2022-04-03 00:40:37', '2022-04-03 00:40:58', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510296262922403841, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 1, '2022-04-03 00:41:04', '2022-04-03 00:41:04', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510303324041605121, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:09:07', '2022-04-03 01:09:07', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510303431818440706, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:09:33', '2022-04-03 01:09:33', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510303457424666625, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:09:39', '2022-04-03 01:09:39', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510303593303302146, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:10:11', '2022-04-03 01:10:11', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510303840133885953, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:11:10', '2022-04-03 01:11:10', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510304001375526914, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:11:49', '2022-04-03 01:11:49', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510304402141339650, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:13:24', '2022-04-03 01:13:24', NULL);
INSERT INTO `kss_user_order_error` VALUES (1510304768467660802, 'Adl23sdflkjlkf', 10000, 'test用户', NULL, 0, '2022-04-03 01:14:52', '2022-04-03 01:14:52', NULL);

-- ----------------------------
-- Table structure for kss_users
-- ----------------------------
DROP TABLE IF EXISTS `kss_users`;
CREATE TABLE `kss_users`  (
  `id` bigint(20) NOT NULL,
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称，媒体号',
  `idcode` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '唯一标识',
  `avatar` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  `sex` int(11) NULL DEFAULT NULL COMMENT '性别 1:男  0:女  2:保密',
  `birthday` date NULL DEFAULT NULL COMMENT '生日',
  `country` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家',
  `province` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份',
  `city` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市',
  `district` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区县',
  `description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简介',
  `bg_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '个人介绍的背景图',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间 创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间 更新时间',
  `status` int(1) NULL DEFAULT NULL COMMENT '激活状态 1 激活 0未激活',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `openid` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信登录openid',
  `unionid` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信登录unionid',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `mobile`(`phone`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_users
-- ----------------------------
INSERT INTO `kss_users` VALUES (13800040004, '13800040004', '越野小天', 'Jeep123', '111111111.jpg', 0, '1970-01-27', '中国', '河北省', '保定市', '', '这家伙很懒，什么都没留下~', '111111111.jpg', '2021-10-05 11:56:40', '2022-03-19 13:34:45', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13800050005, '13800050005', '用户：13******005', '用户：13******005', 'http://39.105.38.113:9000/abc/2110058HSCZ3MAY8/1633406595.jpg', 2, '1900-01-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/2110058HSCZ3MAY8/1633406607.jpg', '2021-10-05 12:03:00', '2021-10-05 12:03:00', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13900010001, '13900010001', '王多鱼', '00010001', 'http://39.105.38.113:9000/abc/2110058BX246X39P/1633405706.jpg', 1, '1900-01-01', '中国', '上海市', '徐汇区', '', '233333，xswl', 'http://39.105.38.113:9000/abc/2110058BX246X39P/1633405718.jpg', '2021-10-05 11:48:16', '2021-10-05 11:48:16', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13900060006, '13900060006', '吃点东西吧', 'Eatalot', 'http://39.105.38.113:9000/abc/211005929C8GTNTC/1633409027.jpg', 0, '1970-01-01', '中国', '江苏省', '南通市', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/211005929C8GTNTC/1633409035.jpg', '2021-10-05 12:43:38', '2021-10-05 12:43:38', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13900070007, '13900070007', '爱车一族', 'Lovecar', 'http://39.105.38.113:9000/abc/21100593CR144MK4/1633409282.jpg', 1, '1973-04-04', '中国', '内蒙古自治区', '鄂尔多斯市', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/21100593CR144MK4/1633409325.jpg', '2021-10-05 12:47:00', '2021-10-05 12:47:00', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13900080008, '13900080008', '绿色的花', 'Lvhuaa', 'http://39.105.38.113:9000/abc/211005967WASBB9P/1633409866.jpg', 2, '1974-05-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/211005967WASBB9P/1633409828.jpg', '2021-10-05 12:55:29', '2021-10-05 12:55:29', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13900090009, '13900090009', '咩咩羊', 'miemei', 'http://39.105.38.113:9000/abc/21100598TZ9XG6RP/1633410206.jpg', 0, '1976-06-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/21100598TZ9XG6RP/1633410261.jpg', '2021-10-05 13:03:13', '2021-10-05 13:03:13', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13912312311, '13912312311', '樱木花道', 'sakura', 'http://39.105.38.113:9000/abc/211005800N0W837C/photo_001.jpg', 1, '1970-01-01', '中国', '黑龙江省', '佳木斯市', '', '我是灌篮高手！啊呀呀呀呀呀呀呀', 'http://39.105.38.113:9000/abc/211005800N0W837C/1633404391.jpg', '2021-10-05 11:12:37', '2021-10-05 11:12:37', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13912345678, '13912345678', '风间影月', 'imooc-test', 'http://39.105.38.113:9000/abc/1001/1632969079.jpg', 2, '2021-08-08', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/1001/1632969089.jpg', '2021-09-29 23:44:51', '2021-09-29 23:44:51', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13961111111, '13961111111', '顾晓梦', 'guumee', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 0, '1900-01-01', '中国', '', '', '', '哈哈哈哈 有意思！！！', 'http://39.105.38.113:9000/abc/211005800N0W837C/1633404391.jpg', '2021-10-05 11:07:16', '2021-10-05 11:07:16', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13961610002, '13961610002', '朱一龙', 'Longlong', 'http://39.105.38.113:9000/abc/2110058D0KPZSCH0/1633405958.jpg', 1, '1900-01-01', '中国', '天津市', '和平区', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/2110058D0KPZSCH0/1633405944.jpg', '2021-10-05 11:51:39', '2021-10-05 11:51:39', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13961888888, '13961888888', '小城大牛', 'daniu123', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 2, '1900-01-01', '中国', '', '', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/211005800N0W837C/1633404391.jpg', '2021-10-03 22:39:32', '2021-10-03 22:39:32', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (13966660003, '13966660003', '夏侯惇', 'guumee', 'http://39.105.38.113:9000/abc/2110058DPP1ZPKKP/1633406052.jpg', 1, '1984-03-01', '中国', '浙江省', '温州市', '', '这家伙很懒，什么都没留下~', 'http://39.105.38.113:9000/abc/2110058DPP1ZPKKP/1633406083.jpg', '2021-10-05 11:53:48', '2021-10-05 11:53:48', 1, '6f69bc15a78e679021ceef633f5d5d55', NULL, NULL);
INSERT INTO `kss_users` VALUES (1511758403479158785, '15074816437', '小伴', '220407129C0RDGR4', 'http://122.152.205.72:88/group1/M00/00/05/CpoxxF6ZUySASMbOAABBAXhjY0Y649.png', 2, NULL, '中国', '', '', '', 'Ta什么都没有留下...', 'http://39.105.38.113:9000/abc/2110058DPP1ZPKKP/1633406083.jpg', '2022-04-07 01:31:05', '2022-04-07 21:10:05', 1, '', 'ofkpG5ZGkG9rw46KtNy93G9roDoQ', 'o86dO56KflAXRgl3dTuOyywN1WTs');

-- ----------------------------
-- Table structure for mq_order
-- ----------------------------
DROP TABLE IF EXISTS `mq_order`;
CREATE TABLE `mq_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '下单记录id',
  `business_time` datetime(0) NULL DEFAULT NULL COMMENT '失效下单记录的时间',
  `memo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'RabbitMQ失效下单记录的历史记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of mq_order
-- ----------------------------
INSERT INTO `mq_order` VALUES (3, 6, '2019-04-12 23:48:04', '更新失效当前用户下单记录Id,orderId=6');
INSERT INTO `mq_order` VALUES (4, 7, '2019-04-13 10:28:43', '更新失效当前用户下单记录Id,orderId=7');

-- ----------------------------
-- Table structure for praise
-- ----------------------------
DROP TABLE IF EXISTS `praise`;
CREATE TABLE `praise`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `blog_id` int(11) NOT NULL COMMENT '博客id',
  `user_id` int(11) NOT NULL COMMENT '点赞人',
  `praise_time` datetime(0) NULL DEFAULT NULL COMMENT '点赞时间',
  `status` int(11) NULL DEFAULT 1 COMMENT '状态(1=正常;0=取消点赞)',
  `is_active` int(11) NULL DEFAULT 1 COMMENT '是否有效(1=是;0=否)',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点赞表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of praise
-- ----------------------------
INSERT INTO `praise` VALUES (35, 2, 101, '2019-05-04 15:18:04', 1, 1, '2019-05-04 15:18:03', NULL);
INSERT INTO `praise` VALUES (37, 1, 103, '2019-05-04 19:27:22', 1, 1, '2019-05-04 19:27:22', NULL);
INSERT INTO `praise` VALUES (38, 1, 104, '2019-05-04 19:27:24', 1, 1, '2019-05-04 19:27:24', NULL);
INSERT INTO `praise` VALUES (40, 3, 101, '2019-05-04 19:29:13', 1, 1, '2019-05-04 19:29:12', NULL);
INSERT INTO `praise` VALUES (41, 3, 102, '2019-05-04 19:29:15', 1, 1, '2019-05-04 19:29:15', NULL);
INSERT INTO `praise` VALUES (42, 3, 103, '2019-05-04 19:29:17', 1, 1, '2019-05-04 19:29:17', NULL);
INSERT INTO `praise` VALUES (43, 4, 101, '2019-05-04 19:30:19', 1, 1, '2019-05-04 19:30:18', NULL);
INSERT INTO `praise` VALUES (44, 5, 101, '2019-05-04 19:30:39', 1, 1, '2019-05-04 19:30:39', NULL);
INSERT INTO `praise` VALUES (45, 1, 101, '2019-05-04 19:32:26', 1, 1, '2019-05-04 19:32:26', NULL);
INSERT INTO `praise` VALUES (46, 1, 102, '2019-05-04 19:33:17', 1, 1, '2019-05-04 19:33:16', NULL);
INSERT INTO `praise` VALUES (47, 2, 102, '2019-05-04 19:33:27', 1, 1, '2019-05-04 19:33:27', NULL);
INSERT INTO `praise` VALUES (48, 2, 103, '2019-05-04 19:33:31', 1, 1, '2019-05-04 19:33:30', NULL);
INSERT INTO `praise` VALUES (49, 2, 104, '2019-05-04 19:33:38', 1, 1, '2019-05-04 19:33:37', NULL);
INSERT INTO `praise` VALUES (50, 2, 105, '2019-05-04 19:33:40', 1, 1, '2019-05-04 19:33:39', NULL);
INSERT INTO `praise` VALUES (51, 100, 101, '2019-05-08 22:14:52', 0, 1, NULL, NULL);
INSERT INTO `praise` VALUES (52, 100, 103, '2019-05-08 22:27:02', 0, 1, NULL, NULL);
INSERT INTO `praise` VALUES (53, 100, 104, '2019-05-08 22:27:04', 0, 1, NULL, NULL);
INSERT INTO `praise` VALUES (54, 100, 105, '2019-05-08 22:27:06', 0, 1, NULL, NULL);
INSERT INTO `praise` VALUES (55, 100, 106, '2019-05-08 22:27:08', 0, 1, NULL, NULL);
INSERT INTO `praise` VALUES (56, 100, 107, '2019-05-08 22:27:10', 0, 1, NULL, NULL);
INSERT INTO `praise` VALUES (57, 100, 108, '2019-05-08 22:27:13', 1, 1, NULL, NULL);
INSERT INTO `praise` VALUES (58, 100, 109, '2019-05-08 22:27:16', 1, 1, NULL, NULL);
INSERT INTO `praise` VALUES (59, 100, 102, '2019-05-08 22:27:23', 0, 1, NULL, NULL);
INSERT INTO `praise` VALUES (60, 100, 201, '2019-05-09 21:58:22', 1, 1, NULL, NULL);
INSERT INTO `praise` VALUES (61, 100, 202, '2019-05-09 21:58:25', 1, 1, NULL, NULL);
INSERT INTO `praise` VALUES (62, 100, 203, '2019-05-09 21:58:29', 1, 1, NULL, NULL);
INSERT INTO `praise` VALUES (63, 100, 204, '2019-05-09 21:58:35', 1, 1, NULL, NULL);

-- ----------------------------
-- Table structure for red_detail
-- ----------------------------
DROP TABLE IF EXISTS `red_detail`;
CREATE TABLE `red_detail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `record_id` int(11) NOT NULL COMMENT '红包记录id',
  `amount` decimal(8, 2) NULL DEFAULT NULL COMMENT '金额（单位为分）',
  `is_active` tinyint(4) NULL DEFAULT 1,
  `create_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 133 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '红包明细金额' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of red_detail
-- ----------------------------
INSERT INTO `red_detail` VALUES (93, 12, 34.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (94, 12, 61.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (95, 12, 106.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (96, 12, 28.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (97, 12, 15.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (98, 12, 214.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (99, 12, 34.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (100, 12, 237.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (101, 12, 91.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (102, 12, 180.00, 1, '2019-03-23 20:41:22');
INSERT INTO `red_detail` VALUES (103, 13, 95.00, 1, NULL);
INSERT INTO `red_detail` VALUES (104, 13, 37.00, 1, NULL);
INSERT INTO `red_detail` VALUES (105, 13, 25.00, 1, NULL);
INSERT INTO `red_detail` VALUES (106, 13, 10.00, 1, NULL);
INSERT INTO `red_detail` VALUES (107, 13, 43.00, 1, NULL);
INSERT INTO `red_detail` VALUES (108, 13, 22.00, 1, NULL);
INSERT INTO `red_detail` VALUES (109, 13, 12.00, 1, NULL);
INSERT INTO `red_detail` VALUES (110, 13, 150.00, 1, NULL);
INSERT INTO `red_detail` VALUES (111, 13, 38.00, 1, NULL);
INSERT INTO `red_detail` VALUES (112, 13, 68.00, 1, NULL);
INSERT INTO `red_detail` VALUES (113, 14, 161.00, 1, NULL);
INSERT INTO `red_detail` VALUES (114, 14, 65.00, 1, NULL);
INSERT INTO `red_detail` VALUES (115, 14, 54.00, 1, NULL);
INSERT INTO `red_detail` VALUES (116, 14, 130.00, 1, NULL);
INSERT INTO `red_detail` VALUES (117, 14, 16.00, 1, NULL);
INSERT INTO `red_detail` VALUES (118, 14, 44.00, 1, NULL);
INSERT INTO `red_detail` VALUES (119, 14, 16.00, 1, NULL);
INSERT INTO `red_detail` VALUES (120, 14, 220.00, 1, NULL);
INSERT INTO `red_detail` VALUES (121, 14, 48.00, 1, NULL);
INSERT INTO `red_detail` VALUES (122, 14, 246.00, 1, NULL);
INSERT INTO `red_detail` VALUES (123, 15, 14.00, 1, NULL);
INSERT INTO `red_detail` VALUES (124, 15, 149.00, 1, NULL);
INSERT INTO `red_detail` VALUES (125, 15, 204.00, 1, NULL);
INSERT INTO `red_detail` VALUES (126, 15, 139.00, 1, NULL);
INSERT INTO `red_detail` VALUES (127, 15, 79.00, 1, NULL);
INSERT INTO `red_detail` VALUES (128, 15, 38.00, 1, NULL);
INSERT INTO `red_detail` VALUES (129, 15, 133.00, 1, NULL);
INSERT INTO `red_detail` VALUES (130, 15, 85.00, 1, NULL);
INSERT INTO `red_detail` VALUES (131, 15, 53.00, 1, NULL);
INSERT INTO `red_detail` VALUES (132, 15, 106.00, 1, NULL);

-- ----------------------------
-- Table structure for red_record
-- ----------------------------
DROP TABLE IF EXISTS `red_record`;
CREATE TABLE `red_record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `red_packet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '红包全局唯一标识串',
  `total` int(11) NOT NULL COMMENT '人数',
  `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总金额（单位为分）',
  `is_active` tinyint(4) NULL DEFAULT 1,
  `create_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发红包记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of red_record
-- ----------------------------
INSERT INTO `red_record` VALUES (12, 10010, 'redis:red:packet:10010:177565921763957', 10, 1000.00, 1, '2019-03-23 20:41:16');
INSERT INTO `red_record` VALUES (13, 10030, 'redis:red:packet:10030:272246147091856', 10, 500.00, 1, NULL);
INSERT INTO `red_record` VALUES (14, 10050, 'redis:red:packet:10050:356031000034967', 10, 1000.00, 1, NULL);
INSERT INTO `red_record` VALUES (15, 10050, 'redis:red:packet:10050:356507939164216', 10, 1000.00, 1, NULL);

-- ----------------------------
-- Table structure for red_rob_record
-- ----------------------------
DROP TABLE IF EXISTS `red_rob_record`;
CREATE TABLE `red_rob_record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户账号',
  `red_packet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '红包标识串',
  `amount` decimal(8, 2) NULL DEFAULT NULL COMMENT '红包金额（单位为分）',
  `rob_time` datetime(0) NULL DEFAULT NULL COMMENT '时间',
  `is_active` tinyint(4) NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 118 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '抢红包记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of red_rob_record
-- ----------------------------
INSERT INTO `red_rob_record` VALUES (82, 10010, 'redis:red:packet:10010:177565921763957', 34.00, '2019-03-24 17:03:25', 1);
INSERT INTO `red_rob_record` VALUES (83, 10011, 'redis:red:packet:10010:177565921763957', 61.00, '2019-03-24 17:22:03', 1);
INSERT INTO `red_rob_record` VALUES (84, 10012, 'redis:red:packet:10010:177565921763957', 106.00, '2019-03-24 17:33:12', 1);
INSERT INTO `red_rob_record` VALUES (85, 10013, 'redis:red:packet:10010:177565921763957', 28.00, '2019-03-24 17:33:15', 1);
INSERT INTO `red_rob_record` VALUES (86, 10014, 'redis:red:packet:10010:177565921763957', 15.00, '2019-03-24 17:33:18', 1);
INSERT INTO `red_rob_record` VALUES (87, 10015, 'redis:red:packet:10010:177565921763957', 214.00, '2019-03-24 17:33:20', 1);
INSERT INTO `red_rob_record` VALUES (88, 10016, 'redis:red:packet:10010:177565921763957', 34.00, '2019-03-24 17:33:22', 1);
INSERT INTO `red_rob_record` VALUES (89, 10017, 'redis:red:packet:10010:177565921763957', 237.00, '2019-03-24 17:33:26', 1);
INSERT INTO `red_rob_record` VALUES (90, 10018, 'redis:red:packet:10010:177565921763957', 91.00, '2019-03-24 17:33:29', 1);
INSERT INTO `red_rob_record` VALUES (91, 10019, 'redis:red:packet:10010:177565921763957', 180.00, '2019-03-24 17:33:32', 1);
INSERT INTO `red_rob_record` VALUES (92, 10035, 'redis:red:packet:10030:272246147091856', 38.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (93, 10031, 'redis:red:packet:10030:272246147091856', 68.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (94, 10033, 'redis:red:packet:10030:272246147091856', 22.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (95, 10031, 'redis:red:packet:10030:272246147091856', 25.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (96, 10034, 'redis:red:packet:10030:272246147091856', 37.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (97, 10030, 'redis:red:packet:10030:272246147091856', 10.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (98, 10035, 'redis:red:packet:10030:272246147091856', 150.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (99, 10031, 'redis:red:packet:10030:272246147091856', 43.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (100, 10030, 'redis:red:packet:10030:272246147091856', 12.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (101, 10032, 'redis:red:packet:10030:272246147091856', 95.00, '2019-03-24 22:57:40', 1);
INSERT INTO `red_rob_record` VALUES (102, 10035, 'redis:red:packet:10050:356031000034967', 130.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (103, 10032, 'redis:red:packet:10050:356031000034967', 44.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (104, 10033, 'redis:red:packet:10050:356031000034967', 161.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (105, 10034, 'redis:red:packet:10050:356031000034967', 65.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (106, 10031, 'redis:red:packet:10050:356031000034967', 246.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (107, 10033, 'redis:red:packet:10050:356031000034967', 54.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (108, 10030, 'redis:red:packet:10050:356031000034967', 16.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (109, 10031, 'redis:red:packet:10050:356031000034967', 220.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (110, 10031, 'redis:red:packet:10050:356031000034967', 48.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (111, 10030, 'redis:red:packet:10050:356031000034967', 16.00, '2019-03-25 22:05:28', 1);
INSERT INTO `red_rob_record` VALUES (112, 10031, 'redis:red:packet:10050:356507939164216', 149.00, '2019-03-25 22:07:00', 1);
INSERT INTO `red_rob_record` VALUES (113, 10035, 'redis:red:packet:10050:356507939164216', 204.00, '2019-03-25 22:07:00', 1);
INSERT INTO `red_rob_record` VALUES (114, 10033, 'redis:red:packet:10050:356507939164216', 139.00, '2019-03-25 22:07:00', 1);
INSERT INTO `red_rob_record` VALUES (115, 10034, 'redis:red:packet:10050:356507939164216', 38.00, '2019-03-25 22:07:00', 1);
INSERT INTO `red_rob_record` VALUES (116, 10030, 'redis:red:packet:10050:356507939164216', 79.00, '2019-03-25 22:07:00', 1);
INSERT INTO `red_rob_record` VALUES (117, 10032, 'redis:red:packet:10050:356507939164216', 14.00, '2019-03-25 22:07:00', 1);

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT 0 COMMENT '用户id',
  `module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属操作模块',
  `data` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作数据',
  `memo` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '日志记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO `sys_log` VALUES (3, 2, '用户登录模块', '{\"userName\":\"jack\",\"password\":\"123456\",\"userId\":2}', '用户登录成功记录相关登录信息', '2019-04-07 22:59:20');
INSERT INTO `sys_log` VALUES (4, 80001, '用户登录模块', '{\"userName\":\"jack-debug\",\"password\":\"123456\",\"userId\":80001}', '用户登录成功记录相关登录信息', '2019-04-28 22:35:25');
INSERT INTO `sys_log` VALUES (5, 90001, '用户登录模块', '{\"userName\":\"a-xiu-luo\",\"password\":\"123456\",\"userId\":90001}', '用户登录成功记录相关登录信息', '2019-04-28 23:00:32');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_user_name`(`user_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'debug', '123456', '2019-04-07 19:03:41');
INSERT INTO `user` VALUES (2, 'jack', '123456', '2019-04-07 19:03:48');
INSERT INTO `user` VALUES (3, 'heart', '123456', '2019-04-07 19:03:56');

-- ----------------------------
-- Table structure for user_account
-- ----------------------------
DROP TABLE IF EXISTS `user_account`;
CREATE TABLE `user_account`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NOT NULL COMMENT '用户账户id',
  `amount` decimal(10, 4) NOT NULL COMMENT '账户余额',
  `version` int(11) NULL DEFAULT 1 COMMENT '版本号字段',
  `is_active` tinyint(11) NULL DEFAULT 1 COMMENT '是否有效(1=是;0=否)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户账户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_account
-- ----------------------------
INSERT INTO `user_account` VALUES (1, 10010, 20.0000, 1, 1);
INSERT INTO `user_account` VALUES (4, 10011, -1860.0000, 1, 1);
INSERT INTO `user_account` VALUES (5, 10012, 20.0000, 3, 1);
INSERT INTO `user_account` VALUES (6, 10013, 20.0000, 1, 1);

-- ----------------------------
-- Table structure for user_account_record
-- ----------------------------
DROP TABLE IF EXISTS `user_account_record`;
CREATE TABLE `user_account_record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `account_id` int(11) NOT NULL COMMENT '账户表主键id',
  `money` decimal(10, 4) NULL DEFAULT NULL COMMENT '提现成功时记录的金额',
  `create_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 422 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户每次提现时的金额记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_account_record
-- ----------------------------
INSERT INTO `user_account_record` VALUES (360, 1, 80.0000, '2019-04-17 23:30:06');
INSERT INTO `user_account_record` VALUES (361, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (362, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (363, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (364, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (365, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (366, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (367, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (368, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (369, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (370, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (371, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (372, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (373, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (374, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (375, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (376, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (377, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (378, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (379, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (380, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (381, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (382, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (383, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (384, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (385, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (386, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (387, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (388, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (389, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (390, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (391, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (392, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (393, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (394, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (395, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (396, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (397, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (398, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (399, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (400, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (401, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (402, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (403, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (404, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (405, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (406, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (407, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (408, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (409, 4, 40.0000, '2019-04-18 20:43:42');
INSERT INTO `user_account_record` VALUES (410, 5, 40.0000, '2019-04-18 21:13:00');
INSERT INTO `user_account_record` VALUES (411, 5, 40.0000, '2019-04-18 21:13:00');
INSERT INTO `user_account_record` VALUES (420, 6, 40.0000, '2019-04-19 21:55:56');
INSERT INTO `user_account_record` VALUES (421, 6, 40.0000, '2019-04-19 21:55:56');

-- ----------------------------
-- Table structure for user_order
-- ----------------------------
DROP TABLE IF EXISTS `user_order`;
CREATE TABLE `user_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单编号',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `status` int(11) NULL DEFAULT NULL COMMENT '支付状态(1=已保存；2=已付款；3=已取消)',
  `is_active` int(255) NULL DEFAULT 1 COMMENT '是否有效（1=有效；0=失效）',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '下单时间',
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户下单记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_order
-- ----------------------------
INSERT INTO `user_order` VALUES (5, '20190411001', 10010, 1, 1, '2019-04-12 22:48:43', NULL);
INSERT INTO `user_order` VALUES (6, '20190412001', 10011, 1, 0, '2019-04-12 23:47:54', '2019-04-12 23:48:04');
INSERT INTO `user_order` VALUES (7, '20190412002', 10012, 1, 0, '2019-04-13 10:28:33', '2019-04-13 10:28:43');

-- ----------------------------
-- Table structure for user_reg
-- ----------------------------
DROP TABLE IF EXISTS `user_reg`;
CREATE TABLE `user_reg`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户注册信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_reg
-- ----------------------------
INSERT INTO `user_reg` VALUES (53, 'linsen', '123456', '2019-04-20 23:01:08');
INSERT INTO `user_reg` VALUES (54, 'debug', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (55, 'debug', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (56, 'jack', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (57, 'sam', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (58, 'jack', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (59, 'jack', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (60, 'sam', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (61, 'sam', '123456', '2019-04-20 23:36:42');
INSERT INTO `user_reg` VALUES (62, 'database', '123456', '2019-04-20 23:59:41');
INSERT INTO `user_reg` VALUES (63, 'rabbitmq', '123456', '2019-04-20 23:59:41');
INSERT INTO `user_reg` VALUES (64, 'lock', '123456', '2019-04-20 23:59:41');
INSERT INTO `user_reg` VALUES (65, 'java', '123456', '2019-04-20 23:59:41');
INSERT INTO `user_reg` VALUES (66, 'redis', '123456', '2019-04-20 23:59:41');
INSERT INTO `user_reg` VALUES (71, 'luohou', '123456', '2019-04-21 21:51:05');
INSERT INTO `user_reg` VALUES (72, 'lixiaolong', '123456', '2019-04-21 21:51:05');
INSERT INTO `user_reg` VALUES (73, 'zhongwenjie', '123456', '2019-04-21 21:51:05');
INSERT INTO `user_reg` VALUES (74, 'userC', '123456', '2019-05-03 15:37:37');
INSERT INTO `user_reg` VALUES (75, 'userD', '123456', '2019-05-03 15:37:37');
INSERT INTO `user_reg` VALUES (76, 'userA', '123456', '2019-05-03 15:37:37');
INSERT INTO `user_reg` VALUES (77, 'userB', '123456', '2019-05-03 15:37:37');

SET FOREIGN_KEY_CHECKS = 1;