xq-pugs-travel
/
ksd-pug-travel.sql

/*
 Navicat MySQL Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : ksd-pug-travel

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

 Date: 20/03/2022 04:38:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ksd_state
-- ----------------------------
DROP TABLE IF EXISTS `ksd_state`;
CREATE TABLE `ksd_state`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主题标题',
  `description` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计描述',
  `personnum` int(11) NULL DEFAULT NULL COMMENT '参与人数',
  `endtime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计结束时间',
  `status` int(1) NULL DEFAULT NULL COMMENT '0未发布 1 发布',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT NULL,
  `userid` int(11) NULL DEFAULT NULL COMMENT '添加用户',
  `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '添加人的名称',
  `bgimg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ksd_state
-- ----------------------------
INSERT INTO `ksd_state` VALUES (1, '飞哥11111', '统计1', 10, '2021-07-30', 1, '2021-04-29 21:11:25', NULL, 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (2, '飞哥222222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (3, '飞哥222223', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (4, '飞哥222224', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (5, '飞哥222225', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (6, '飞哥222226', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (7, '飞哥222227', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (8, '飞哥222228', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (9, '飞哥222229', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (10, '飞哥222220', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (11, '飞哥2222211', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (12, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (13, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (14, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (15, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (16, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (17, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (18, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (19, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (20, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (21, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);
INSERT INTO `ksd_state` VALUES (22, '飞哥22222', '统计2', 20, '2021-07-30', 0, '2021-04-29 21:11:25', '2021-06-29 21:13:56', 1, 'yykk', 'a.jpg', NULL);

-- ----------------------------
-- Table structure for kss_admin_logs
-- ----------------------------
DROP TABLE IF EXISTS `kss_admin_logs`;
CREATE TABLE `kss_admin_logs`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `classname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类名',
  `classmethod` varchar(64) 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 '描述',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '执行用户',
  `username` varchar(128) 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 '更新时间',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  `status` int(1) NULL DEFAULT NULL COMMENT '发布状态 1 发布 0未发布',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台操作日志 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_admin_logs
-- ----------------------------

-- ----------------------------
-- 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_banner_category
-- ----------------------------
DROP TABLE IF EXISTS `kss_banner_category`;
CREATE TABLE `kss_banner_category`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类标题',
  `icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类图标',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '分类排序',
  `pid` bigint(20) NULL DEFAULT NULL COMMENT '分类父id',
  `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删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品分类 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_banner_category
-- ----------------------------
INSERT INTO `kss_banner_category` VALUES (1, '酒店', '1', 1, 0, 1, '2022-02-10 22:29:35', '2022-02-13 23:21:16', 0);
INSERT INTO `kss_banner_category` VALUES (2, '自由行', NULL, 2, 0, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);
INSERT INTO `kss_banner_category` VALUES (3, '门票', NULL, 3, 0, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);
INSERT INTO `kss_banner_category` VALUES (4, '景区', NULL, 1, 0, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);

-- ----------------------------
-- Table structure for kss_category
-- ----------------------------
DROP TABLE IF EXISTS `kss_category`;
CREATE TABLE `kss_category`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类标题',
  `icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类图标',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '分类排序',
  `pid` bigint(20) NULL DEFAULT NULL COMMENT '分类父id',
  `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删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品分类 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_category
-- ----------------------------
INSERT INTO `kss_category` VALUES (1, '酒店', '1', 1, 0, 1, '2022-02-10 22:29:35', '2022-02-13 23:21:16', 0);
INSERT INTO `kss_category` VALUES (2, '自由行', NULL, 2, 0, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);
INSERT INTO `kss_category` VALUES (3, '门票', NULL, 3, 0, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);
INSERT INTO `kss_category` VALUES (4, '上海酒店', NULL, 1, 1, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);
INSERT INTO `kss_category` VALUES (5, '北京酒店', NULL, 2, 1, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);
INSERT INTO `kss_category` VALUES (6, '景区', NULL, 1, 2, 1, '2022-02-10 22:29:35', '2022-02-10 22:29:35', NULL);
INSERT INTO `kss_category` VALUES (1492866131817934800, '1111', '222', 7, 0, 1, '2022-02-13 22:19:57', '2022-02-13 22:39:01', 0);
INSERT INTO `kss_category` VALUES (1492866131817934849, '111111111111', '222', 1111111, 0, 1, '2022-02-13 22:19:57', '2022-02-13 23:15:37', NULL);
INSERT INTO `kss_category` VALUES (1492867812626583553, '11', '11', 22, 0, 1, '2022-02-13 22:26:37', '2022-02-13 22:26:37', NULL);
INSERT INTO `kss_category` VALUES (1492867812626583600, '11', '11', 987, 0, 1, '2022-02-13 22:26:37', '2022-02-13 22:45:53', 0);
INSERT INTO `kss_category` VALUES (1492870002023911425, '1111', '111', 111, 0, 1, '2022-02-13 22:35:19', '2022-02-13 22:35:19', NULL);
INSERT INTO `kss_category` VALUES (1492876422731591682, '东京酒店11333333', '111', 3, 1, 0, '2022-02-13 23:00:50', '2022-02-13 23:20:45', NULL);
INSERT INTO `kss_category` VALUES (1492877373563531265, '1111', '222', 4, 1, 0, '2022-02-13 23:04:37', '2022-02-13 23:04:37', NULL);
INSERT INTO `kss_category` VALUES (1492877786178187266, '111', '111', 1, 3, 0, '2022-02-13 23:06:15', '2022-02-13 23:06:15', NULL);
INSERT INTO `kss_category` VALUES (1492877879228821505, '	 景区2', '322', 2, 2, 0, '2022-02-13 23:06:37', '2022-02-13 23:06:37', NULL);
INSERT INTO `kss_category` VALUES (1492877943250677761, '11111', '111', 3, 2, 0, '2022-02-13 23:06:53', '2022-02-13 23:06:53', NULL);
INSERT INTO `kss_category` VALUES (1492878169063616514, '111', '1111', 1, 1492870002023911425, 0, '2022-02-13 23:07:46', '2022-02-13 23:07:46', NULL);
INSERT INTO `kss_category` VALUES (1492878228303966209, '1111', '11111', 2, 1492870002023911425, 0, '2022-02-13 23:08:01', '2022-02-13 23:08:01', NULL);
INSERT INTO `kss_category` VALUES (1492878445640216578, '21222', '22222', 4, 2, 0, '2022-02-13 23:08:52', '2022-02-13 23:08:52', NULL);
INSERT INTO `kss_category` VALUES (1492878533754155010, '11111111111111111111', '111111', 5, 1, 0, '2022-02-13 23:09:13', '2022-02-13 23:09:13', NULL);
INSERT INTO `kss_category` VALUES (1492878595511087105, '222222222222222222222', '22222', 6, 1, 0, '2022-02-13 23:09:28', '2022-02-13 23:09:28', NULL);
INSERT INTO `kss_category` VALUES (1492879671719161857, '111', '111', 7, 1, 0, '2022-02-13 23:13:45', '2022-02-13 23:13:45', NULL);
INSERT INTO `kss_category` VALUES (1492879708306075649, '222222222222', '222', 5, 2, 0, '2022-02-13 23:13:53', '2022-02-13 23:13:53', NULL);
INSERT INTO `kss_category` VALUES (1492879765734486018, '5455555555555555', '555', 6, 2, 0, '2022-02-13 23:14:07', '2022-02-13 23:14:07', NULL);

-- ----------------------------
-- Table structure for kss_favorite
-- ----------------------------
DROP TABLE IF EXISTS `kss_favorite`;
CREATE TABLE `kss_favorite`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' 收藏夹的ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收藏夹的标题',
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT 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 '发布0未发布 1发布',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '添加用户',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_favorite
-- ----------------------------

-- ----------------------------
-- Table structure for kss_nav_menu
-- ----------------------------
DROP TABLE IF EXISTS `kss_nav_menu`;
CREATE TABLE `kss_nav_menu`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单名词',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '菜单排序',
  `path` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单链接',
  `icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `status` int(11) NULL DEFAULT NULL COMMENT '菜单发布',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NULL DEFAULT NULL COMMENT '菜单名称',
  `componentname` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件名称',
  `pathname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '路径名称',
  `layout` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父组件',
  `indexon` int(11) NULL DEFAULT NULL COMMENT '排序',
  `showflag` int(1) 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 COMMENT = '菜单管理 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_nav_menu
-- ----------------------------
INSERT INTO `kss_nav_menu` VALUES (7, '轮播图分类管理', 11, '/bannercategory', 'icon-dashboard', 1, '2022-02-20 20:17:40', '2022-02-20 20:17:40', 0, '@/views/admin/bannercategory/index.vue', 'bannercategory', 'layout', 10, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (8, '轮播图分类列表', 1, '/bannercategory/list', '', 1, '2022-02-20 20:17:40', '2022-02-20 20:17:40', 7, '@/views/admin/bannercategory/index.vue', 'bannercategorylist', 'layout', 10, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (9, '轮播图分类添加', 2, '/bannercategory/add', '', 1, '2022-02-20 20:17:40', '2022-02-20 20:17:40', 7, '@/views/admin/bannercategory/add.vue', 'bannercategoryadd', 'layout', 10, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (10, '轮播图分类编辑', 3, '/bannercategory/edit/:id', '', 1, '2022-02-20 20:17:40', '2022-02-20 20:17:40', 7, '@/views/admin/bannercategory/add.vue', 'bannercategoryedit', 'layout', 10, 0, 0);
INSERT INTO `kss_nav_menu` VALUES (11, '轮播图管理', 12, '/banner', 'icon-dashboard', 1, '2022-02-20 20:20:04', '2022-02-20 20:20:04', 0, '@/views/admin/banner/index.vue', 'banner', 'layout', 11, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (12, '轮播图列表', 1, '/banner/list', '', 1, '2022-02-20 20:20:04', '2022-02-20 20:20:04', 11, '@/views/admin/banner/index.vue', 'bannerlist', 'layout', 11, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (13, '轮播图添加', 2, '/banner/add', '', 1, '2022-02-20 20:20:04', '2022-02-20 20:20:04', 11, '@/views/admin/banner/add.vue', 'banneradd', 'layout', 11, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (14, '轮播图编辑', 3, '/banner/edit/:id', '', 1, '2022-02-20 20:20:04', '2022-02-20 20:20:04', 11, '@/views/admin/banner/add.vue', 'banneredit', 'layout', 11, 0, 0);
INSERT INTO `kss_nav_menu` VALUES (15, '角色管理管理', 13, '/role', 'icon-dashboard', 1, '2022-02-21 15:07:39', '2022-02-21 15:07:39', 0, '@/views/admin/role/index.vue', 'role', 'layout', 12, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (16, '角色管理列表', 1, '/role/list', '', 1, '2022-02-21 15:07:39', '2022-02-21 15:07:39', 15, '@/views/admin/role/index.vue', 'rolelist', 'layout', 12, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (17, '角色管理添加', 2, '/role/add', '', 1, '2022-02-21 15:07:39', '2022-02-21 15:07:39', 15, '@/views/admin/role/add.vue', 'roleadd', 'layout', 12, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (18, '角色管理编辑', 3, '/role/edit/:id', '', 1, '2022-02-21 15:07:39', '2022-02-21 15:07:39', 15, '@/views/admin/role/add.vue', 'roleedit', 'layout', 12, 0, 0);
INSERT INTO `kss_nav_menu` VALUES (19, '权限管理管理', 14, '/permission', 'icon-dashboard', 1, '2022-02-21 15:07:56', '2022-02-21 15:07:56', 0, '@/views/admin/permission/index.vue', 'permission', 'layout', 13, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (20, '权限管理列表', 1, '/permission/list', '', 1, '2022-02-21 15:07:56', '2022-02-21 15:07:56', 19, '@/views/admin/permission/index.vue', 'permissionlist', 'layout', 13, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (21, '权限管理添加', 2, '/permission/add', '', 1, '2022-02-21 15:07:56', '2022-02-21 15:07:56', 19, '@/views/admin/permission/add.vue', 'permissionadd', 'layout', 13, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (22, '权限管理编辑', 3, '/permission/edit/:id', '', 1, '2022-02-21 15:07:56', '2022-02-21 15:07:56', 19, '@/views/admin/permission/add.vue', 'permissionedit', 'layout', 13, 0, 0);
INSERT INTO `kss_nav_menu` VALUES (100, '产品管理', 9, '/product', 'icon-dashboard', 1, '2022-02-18 22:55:41', '2022-02-18 22:55:41', 0, '@/views/admin/product', 'product', 'layout', 8, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (101, '产品列表', 1, '/product/list', '', 1, '2022-02-18 22:55:41', '2022-02-18 22:55:41', 100, '@/views/admin/product/index', 'productlist', 'layout', 8, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (102, '添加产品', 2, '/product/add', '', 1, '2022-02-18 22:55:41', '2022-02-18 22:55:41', 100, '@/views/admin/product/add', 'productadd', 'layout', 8, 0, 0);
INSERT INTO `kss_nav_menu` VALUES (103, '编辑产品', 3, '/product/edit/:id', NULL, 1, '2022-02-18 22:55:41', '2022-02-18 22:55:41', 100, '@/views/admin/product/add', 'productedit', 'layout', 8, 0, 0);
INSERT INTO `kss_nav_menu` VALUES (104, '分类管理', 10, '/category', 'icon-dashboard', 1, '2022-02-18 22:55:41', '2022-02-18 22:55:41', 0, '@/views/admin/category', 'category', 'layout', 9, 1, 0);
INSERT INTO `kss_nav_menu` VALUES (105, '分类列表', 1, '/category/list', '', 1, '2022-02-18 22:55:41', '2022-02-18 22:55:41', 104, '@/views/admin/category/index', 'categorylist', 'layout', 9, 1, 0);

-- ----------------------------
-- Table structure for kss_order_detail
-- ----------------------------
DROP TABLE IF EXISTS `kss_order_detail`;
CREATE TABLE `kss_order_detail`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `order_id` bigint(20) NULL DEFAULT NULL COMMENT '订单ID',
  `product_id` bigint(20) NULL DEFAULT NULL COMMENT '产品ID',
  `product_price` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品价格',
  `product_desc` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品描述',
  `product_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品标题',
  `product_img` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品封面',
  `user_id` bigint(20) NULL DEFAULT 0 COMMENT '用户ID',
  `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名称',
  `useravatar` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
  `ordernumber` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单号',
  `tradeno` varchar(128) 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 '更新时间',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  `status` int(1) NULL DEFAULT NULL COMMENT '发布状态 1发布中 0未发布',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单明细 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_order_detail
-- ----------------------------

-- ----------------------------
-- Table structure for kss_orders
-- ----------------------------
DROP TABLE IF EXISTS `kss_orders`;
CREATE TABLE `kss_orders`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `ordernumber` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单号',
  `ip` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单交易的ip',
  `tradeno` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易号',
  `orderprice` varchar(32) 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 '更新时间',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '订单交易人',
  `paymethod` int(11) NULL DEFAULT NULL COMMENT '订单交易方式',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  `status` int(1) NULL DEFAULT NULL COMMENT '发布状态 1发布中 0未发布',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单表;' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_orders
-- ----------------------------

-- ----------------------------
-- Table structure for kss_permission
-- ----------------------------
DROP TABLE IF EXISTS `kss_permission`;
CREATE TABLE `kss_permission`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '权限名称',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限代号',
  `url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限URL',
  `sorted` int(11) NULL DEFAULT NULL COMMENT '权限排序',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  `status` int(1) NULL DEFAULT NULL COMMENT '发布状态 1发布中 0 未发布',
  `pid` bigint(20) NULL DEFAULT NULL COMMENT '父id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_permission
-- ----------------------------
INSERT INTO `kss_permission` VALUES (1, '轮播图管理', '2022-02-20 23:12:05', '2022-02-20 23:12:05', '1001', '/banner', 1, 0, 1, 0);
INSERT INTO `kss_permission` VALUES (2, '轮播图列表查询', '2022-02-20 23:12:05', '2022-02-20 23:12:05', '100101', '/banner/load', 1, 0, 1, 1);
INSERT INTO `kss_permission` VALUES (3, '轮播图查询分页', '2022-02-20 23:12:05', '2022-02-20 23:12:05', '100102', '/banner/saveupdate', 2, 0, 1, 1);
INSERT INTO `kss_permission` VALUES (4, '用户管理', '2022-02-20 23:12:05', '2022-02-20 23:12:05', '1001', '/user', 1, 0, 1, 0);
INSERT INTO `kss_permission` VALUES (5, '用户列表查询', '2022-02-20 23:12:05', '2022-02-20 23:12:05', '100101', '/user/load', 1, 0, 1, 4);
INSERT INTO `kss_permission` VALUES (6, '用户查询分页', '2022-02-20 23:12:05', '2022-02-20 23:12:05', '100102', '/user/saveupdate', 2, 0, 1, 4);

-- ----------------------------
-- Table structure for kss_product
-- ----------------------------
DROP TABLE IF EXISTS `kss_product`;
CREATE TABLE `kss_product`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) 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 '产品封面',
  `tags` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品标签',
  `price` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品价格',
  `realprice` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品交易价格',
  `description` varchar(3072) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品描述',
  `imgjson` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '产品组图',
  `views` int(11) NULL DEFAULT NULL COMMENT '产品浏览数',
  `collections` int(11) NULL DEFAULT NULL COMMENT '产品收藏数',
  `category_id` int(11) NULL DEFAULT NULL COMMENT '产品分类id',
  `category_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品分类标题',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '产品的商家',
  `isdelete` 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 '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_product
-- ----------------------------
INSERT INTO `kss_product` VALUES (1, '光明花博酒店', 'https://dimg11.c-ctrip.com/images/0205j120008p3cdhy8FF0_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 1, '2022-02-10 22:31:28', '2022-02-13 23:54:49');
INSERT INTO `kss_product` VALUES (14, '上海南郊宾馆', 'https://dimg11.c-ctrip.com/images/200315000000y1s5y4844_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 0, '2022-02-10 22:31:28', '2022-02-13 23:22:38');
INSERT INTO `kss_product` VALUES (15, '云和夜泊酒店', 'https://dimg11.c-ctrip.com/images/hotel/65000/64099/70c675a9a4ad4def85e129256a8bf7d0_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 0, '2022-02-10 22:31:28', '2022-02-13 23:22:39');

-- ----------------------------
-- Table structure for kss_product_copy1
-- ----------------------------
DROP TABLE IF EXISTS `kss_product_copy1`;
CREATE TABLE `kss_product_copy1`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) 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 '产品封面',
  `tags` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品标签',
  `price` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品价格',
  `realprice` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品交易价格',
  `description` varchar(3072) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品描述',
  `imgjson` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '产品组图',
  `views` int(11) NULL DEFAULT NULL COMMENT '产品浏览数',
  `collections` int(11) NULL DEFAULT NULL COMMENT '产品收藏数',
  `category_id` int(11) NULL DEFAULT NULL COMMENT '产品分类id',
  `category_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '产品分类标题',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '产品的商家',
  `isdelete` 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 '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '产品表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_product_copy1
-- ----------------------------
INSERT INTO `kss_product_copy1` VALUES (1, '北京贝尔特酒店\r\n北京贝尔特酒店', 'https://dimg11.c-ctrip.com/images/0205z120008dr4pxv9C7E_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (2, '北京石景山游乐园希尔顿欢朋酒店', 'https://dimg11.c-ctrip.com/images/0202b1200094qh2onA2BD_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (3, '王府井永光酒店', 'https://dimg11.c-ctrip.com/images/02015120008cje2aeEE11_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (4, '北京古北德邻水镇精品别墅', 'https://dimg11.c-ctrip.com/images/hotel/1000/10/d185c983e00945e1b9037ce5fa7528e3_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (5, '北京长富宫饭店', 'https://dimg11.c-ctrip.com/images/0206y120008n6wq2qDBFE_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (6, '镇美乐家别墅', 'https://dimg11.c-ctrip.com/images/02025120008lommuc023E_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 0, 0, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (7, '峪宿 Valley home·私汤小院', 'https://dimg11.c-ctrip.com/images/020691200082co240B8EA_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 0, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (8, '北京三元桥CitiGO欢阁酒店', 'https://dimg11.c-ctrip.com/images/0204q120004603gsuC04A_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 0, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (9, '上海浦东温德姆酒店\r\n上海浦东温德姆酒店', 'https://dimg11.c-ctrip.com/images/0205v120008yrfh2u2C74_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 0, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (10, '上海外滩璞硯酒店', 'https://dimg11.c-ctrip.com/images/200u0k000000c9j37749C_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (11, '上海万达瑞华酒店', 'https://dimg11.c-ctrip.com/images/0205m1200098auy178827_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (12, '上海五角场逸扉酒店', 'https://dimg11.c-ctrip.com/images/200m0d0000006u30z4A17_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (13, '光明花博酒店', 'https://dimg11.c-ctrip.com/images/0205j120008p3cdhy8FF0_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (14, '上海南郊宾馆', 'https://dimg11.c-ctrip.com/images/200315000000y1s5y4844_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');
INSERT INTO `kss_product_copy1` VALUES (15, '云和夜泊酒店', 'https://dimg11.c-ctrip.com/images/hotel/65000/64099/70c675a9a4ad4def85e129256a8bf7d0_R_300_120.jpg', NULL, '505', '356', '北京贝尔特酒店位于北京市中心商圈，距离地铁2号线和5号线“崇文门地铁站”约100米，距离同仁医院、北京医院约600米。酒店毗邻天安门广场、故宫、王府井、天坛公园、红桥珍珠市场等著名旅游景点，与新世界购物中心是一栋一体式建筑，可以通过酒店5层直达商场内部，酒店紧邻国瑞城、魔方购物中心，娱乐、餐饮、购物、商业配套一应俱全。', NULL, 0, 0, 1, '酒店', 1, 1, 1, '2022-02-10 22:31:28', '2022-02-10 22:31:28');

-- ----------------------------
-- Table structure for kss_product_user_collect
-- ----------------------------
DROP TABLE IF EXISTS `kss_product_user_collect`;
CREATE TABLE `kss_product_user_collect`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
  `product_id` bigint(20) NULL DEFAULT 0 COMMENT '产品ID',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) 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_product_user_collect
-- ----------------------------

-- ----------------------------
-- Table structure for kss_product_video
-- ----------------------------
DROP TABLE IF EXISTS `kss_product_video`;
CREATE TABLE `kss_product_video`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频名称',
  `img` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频VID',
  `videolink` varchar(400) 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 '视频介绍',
  `productids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '视频关联产品',
  `views` int(11) NULL DEFAULT NULL COMMENT '视频浏览数',
  `collections` int(11) NULL DEFAULT NULL COMMENT '视频收藏数',
  `category_id` bigint(20) NULL DEFAULT NULL COMMENT '视频分类id',
  `category_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频分类标题',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '视频的商家',
  `isdelete` 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 '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '旅拍表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_product_video
-- ----------------------------

-- ----------------------------
-- Table structure for kss_role
-- ----------------------------
DROP TABLE IF EXISTS `kss_role`;
CREATE TABLE `kss_role`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '角色名字',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色代号',
  `status` int(1) NULL DEFAULT NULL COMMENT '发布状态 1发布中 0未发布',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_role
-- ----------------------------
INSERT INTO `kss_role` VALUES (1, '超级管理员', '2022-02-20 23:11:13', '2022-02-20 23:11:13', '1001', 1, 0);
INSERT INTO `kss_role` VALUES (2, '管理员', '2022-02-20 23:11:13', '2022-02-20 23:11:13', '1002', 1, 0);
INSERT INTO `kss_role` VALUES (3, '财务', '2022-02-20 23:11:13', '2022-02-20 23:11:13', '1003', 1, 0);

-- ----------------------------
-- Table structure for kss_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `kss_role_permission`;
CREATE TABLE `kss_role_permission`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `permission_id` bigint(20) NULL DEFAULT NULL COMMENT '权限id',
  `role_id` bigint(20) NULL DEFAULT 0 COMMENT '角色id',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) 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_role_permission
-- ----------------------------
INSERT INTO `kss_role_permission` VALUES (1, 1, 1, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (2, 2, 1, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (3, 3, 1, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (4, 4, 1, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (5, 5, 1, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (6, 6, 1, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (7, 1, 2, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (8, 2, 2, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (9, 3, 2, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (10, 4, 3, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (11, 5, 3, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_permission` VALUES (12, 6, 3, '2022-02-20 23:11:13', '2022-02-20 23:11:13');

-- ----------------------------
-- Table structure for kss_role_user
-- ----------------------------
DROP TABLE IF EXISTS `kss_role_user`;
CREATE TABLE `kss_role_user`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `role_id` bigint(20) NULL DEFAULT 0 COMMENT '角色id',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) 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_role_user
-- ----------------------------
INSERT INTO `kss_role_user` VALUES (1, 1, 1, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_user` VALUES (2, 2, 2, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_user` VALUES (3, 2, 3, '2022-02-20 23:11:13', '2022-02-20 23:11:13');
INSERT INTO `kss_role_user` VALUES (4, 3, 3, '2022-02-20 23:11:13', '2022-02-20 23:11:13');

-- ----------------------------
-- Table structure for kss_sys_message
-- ----------------------------
DROP TABLE IF EXISTS `kss_sys_message`;
CREATE TABLE `kss_sys_message`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息内容',
  `type` int(11) 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未发布',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统消息 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_sys_message
-- ----------------------------

-- ----------------------------
-- Table structure for kss_user
-- ----------------------------
DROP TABLE IF EXISTS `kss_user`;
CREATE TABLE `kss_user`  (
  `id` bigint(20) NOT 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 '更新时间',
  `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `nickname` varchar(128) 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 '头像',
  `male` int(11) NULL DEFAULT NULL COMMENT '性别',
  `telephone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话',
  `idcard` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证',
  `openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_user
-- ----------------------------
INSERT INTO `kss_user` VALUES (1, 1, '2022-01-15 23:17:58', '2022-01-15 23:17:58', 'yykk', '6f69bc15a78e679021ceef633f5d5d55', '飞哥', 'https://gw.alipayobjects.com/zos/rmsportal/siCrBXXhmvTQGWPNLBow.png', 1, '15074816437', '2345414463453456456', '3543213513213', 0);
INSERT INTO `kss_user` VALUES (2, 1, '2022-02-20 21:58:13', '2022-02-20 21:58:13', 'xingchen', '6f69bc15a78e679021ceef633f5d5d55', '星辰', 'https://gw.alipayobjects.com/zos/rmsportal/siCrBXXhmvTQGWPNLBow.png', 1, '15074816438', '2345414463453456456', '111', 0);
INSERT INTO `kss_user` VALUES (3, 1, '2022-02-20 21:58:36', '2022-02-20 21:58:36', 'xiaolong', '6f69bc15a78e679021ceef633f5d5d55', '小龙', 'https://gw.alipayobjects.com/zos/rmsportal/siCrBXXhmvTQGWPNLBow.png', 1, '15074816438', '2345414463453456456', '2222', 0);
INSERT INTO `kss_user` VALUES (1498327289620238338, 0, '2022-03-01 00:00:38', '2022-03-01 00:00:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327331085127681, 0, '2022-03-01 00:00:48', '2022-03-01 00:00:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327331164819458, 0, '2022-03-01 00:00:48', '2022-03-01 00:00:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327331332591617, 0, '2022-03-01 00:00:48', '2022-03-01 00:00:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327331827519490, 0, '2022-03-01 00:00:48', '2022-03-01 00:00:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327336294453250, 0, '2022-03-01 00:00:49', '2022-03-01 00:00:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327343613513729, 0, '2022-03-01 00:00:51', '2022-03-01 00:00:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327344569815041, 0, '2022-03-01 00:00:51', '2022-03-01 00:00:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327344645312513, 0, '2022-03-01 00:00:51', '2022-03-01 00:00:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327472785494017, 0, '2022-03-01 00:01:22', '2022-03-01 00:01:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503567491073, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503567491074, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503567491075, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503567491076, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503567491077, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503571685378, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503571685379, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327503571685380, 0, '2022-03-01 00:01:29', '2022-03-01 00:01:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327935337586689, 0, '2022-03-01 00:03:12', '2022-03-01 00:03:12', 'yykk22222', '23436454564', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327935337586690, 0, '2022-03-01 00:03:12', '2022-03-01 00:03:12', 'yykk22222', '23436454564', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498327935337586691, 0, '2022-03-01 00:03:12', '2022-03-01 00:03:12', 'yykk22222', '23436454564', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328139767996418, 0, '2022-03-01 00:04:01', '2022-03-01 00:04:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328139767996419, 0, '2022-03-01 00:04:01', '2022-03-01 00:04:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328139767996420, 0, '2022-03-01 00:04:01', '2022-03-01 00:04:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328139767996421, 0, '2022-03-01 00:04:01', '2022-03-01 00:04:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328139767996422, 0, '2022-03-01 00:04:01', '2022-03-01 00:04:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328139767996423, 0, '2022-03-01 00:04:01', '2022-03-01 00:04:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328139767996424, 0, '2022-03-01 00:04:01', '2022-03-01 00:04:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328317887442946, 0, '2022-03-01 00:04:43', '2022-03-01 00:04:43', 'yykk22222', '23436454564', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `kss_user` VALUES (1498328317887442947, 0, '2022-03-01 00:04:43', '2022-03-01 00:04:43', 'yykk22222', '23436454564', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for kss_video_user_collect
-- ----------------------------
DROP TABLE IF EXISTS `kss_video_user_collect`;
CREATE TABLE `kss_video_user_collect`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
  `video_id` bigint(20) NULL DEFAULT 0 COMMENT '视频ID',
  `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未发布',
  `isdelete` int(1) NULL DEFAULT NULL COMMENT '删除状态 0未删除 1删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '旅拍用户收藏表 ' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of kss_video_user_collect
-- ----------------------------

-- ----------------------------
-- Table structure for pdman_db_version
-- ----------------------------
DROP TABLE IF EXISTS `pdman_db_version`;
CREATE TABLE `pdman_db_version`  (
  `DB_VERSION` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `VERSION_DESC` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CREATED_TIME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pdman_db_version
-- ----------------------------
INSERT INTO `pdman_db_version` VALUES ('v0.0.0', '默认版本，新增的版本不能低于此版本', '2022-01-15 22:26:25');
INSERT INTO `pdman_db_version` VALUES ('1.0', '初始化数据库', '2022-01-15 22:26:42');
INSERT INTO `pdman_db_version` VALUES ('1.1', '订单表增加了字段', '2022-01-15 22:35:24');
INSERT INTO `pdman_db_version` VALUES ('1.2', '订单表增加了交易地点字段', '2022-01-15 22:38:06');
INSERT INTO `pdman_db_version` VALUES ('1.3', '订单表增加了ip', '2022-01-15 22:45:11');
INSERT INTO `pdman_db_version` VALUES ('1.5', '同步数据库增加字段', '2022-01-15 23:58:18');
INSERT INTO `pdman_db_version` VALUES ('1.6', '修改用户字段', '2022-01-16 00:03:33');
INSERT INTO `pdman_db_version` VALUES ('1.8', '新增轮播图表', '2022-01-16 00:33:41');

SET FOREIGN_KEY_CHECKS = 1;