/*
Navicat MySQL Data Transfer

Source Server         : 我的数据库
Source Server Version : 50735
Source Host           : 139.224.164.101:3306
Source Database       : kuangstudytourdb

Target Server Type    : MYSQL
Target Server Version : 50735
File Encoding         : 65001

Date: 2021-09-01 14:46:08
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for kss_banner
-- ----------------------------
DROP TABLE IF EXISTS `kss_banner`;
CREATE TABLE `kss_banner` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `appimg` varchar(400) DEFAULT NULL COMMENT '小程序的封面的地址',
  `appopen` varchar(20) DEFAULT NULL COMMENT '打开方式 redirect,switchtab',
  `applink` varchar(200) DEFAULT NULL COMMENT 'app连接打开的地址',
  `appsort` int(11) DEFAULT NULL COMMENT '轮播图的排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `status` int(1) DEFAULT NULL COMMENT '0未发布 1发布',
  `user_id` bigint(20) DEFAULT NULL COMMENT '添加人',
  `nickname` varchar(100) DEFAULT NULL COMMENT '添加人姓名',
  `avatar` varchar(400) DEFAULT NULL COMMENT '添加人的头像',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_banner
-- ----------------------------
INSERT INTO `kss_banner` VALUES ('1', '测试标题', '测试标题1', 'https://graceui.oss-cn-beijing.aliyuncs.com/swiperimgs/1.png', 'switchTab', 'pages/about/about', '0', '2021-08-10 23:18:42', '2021-08-10 23:18:42', '1', '1', 'yykk', null);
INSERT INTO `kss_banner` VALUES ('2', '测试标题', '测试标题2', 'https://graceui.oss-cn-beijing.aliyuncs.com/swiperimgs/2.png', 'switchTab', 'pages/about/about', '2', '2021-08-10 23:18:42', '2021-08-10 23:18:42', '1', '1', 'yykk', null);
INSERT INTO `kss_banner` VALUES ('3', '测试标题', '测试标题3', 'https://graceui.oss-cn-beijing.aliyuncs.com/swiperimgs/3.png', 'switchTab', 'pages/about/about', '3', '2021-08-10 23:18:42', '2021-08-10 23:18:42', '1', '1', 'yykk', null);
INSERT INTO `kss_banner` VALUES ('4', '测试标题', '测试标题4', 'https://graceui.oss-cn-beijing.aliyuncs.com/swiperimgs/4.png', 'switchTab', 'pages/about/about', '1', '2021-08-10 23:18:42', '2021-08-10 23:18:42', '1', '1', 'yykk', null);
INSERT INTO `kss_banner` VALUES ('5', '测试标题', '测试标题5', 'https://graceui.oss-cn-beijing.aliyuncs.com/swiperimgs/5.png', 'switchTab', 'pages/about/about', '4', '2021-08-10 23:18:42', '2021-08-10 23:18:42', '1', '1', 'yykk', null);
INSERT INTO `kss_banner` VALUES ('6', '测试标题', '测试标题6', 'https://graceui.oss-cn-beijing.aliyuncs.com/swiperimgs/5.png', 'switchTab', 'pages/about/about', '6', '2021-08-10 23:18:42', '2021-08-10 23:18:42', '1', '1', 'yykk', null);

-- ----------------------------
-- Table structure for kss_category
-- ----------------------------
DROP TABLE IF EXISTS `kss_category`;
CREATE TABLE `kss_category` (
  `subject_id` bigint(32) NOT NULL COMMENT '分类id',
  `subject_pid` bigint(32) NOT NULL COMMENT '分类父id',
  `subject_title` varchar(50) NOT NULL COMMENT '分类名称',
  `subject_sort` int(3) DEFAULT NULL COMMENT '排序',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `status` int(1) DEFAULT NULL,
  `subject_stitle` varchar(50) DEFAULT NULL,
  `subject_msg` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_category
-- ----------------------------
INSERT INTO `kss_category` VALUES ('1', '0', '景点', '2', '2020-09-10 22:12:58', '2021-03-26 17:14:02', '1', '景点', '');
INSERT INTO `kss_category` VALUES ('2', '0', '自由行', '3', '2021-01-23 21:06:27', '2021-06-23 16:47:40', '1', '自由行', '');
INSERT INTO `kss_category` VALUES ('3', '0', '线路攻略', '4', '2021-03-21 23:04:47', '2021-08-05 15:31:30', '1', '线路攻略', '');
INSERT INTO `kss_category` VALUES ('4', '0', '门票', '5', '2021-02-20 14:21:10', '2021-06-23 16:48:00', '1', '门票', '');
INSERT INTO `kss_category` VALUES ('5', '0', '酒店', '1', '2021-02-20 14:23:14', '2021-03-26 17:14:07', '1', '酒店', '');
INSERT INTO `kss_category` VALUES ('11', '1', '自然风光', '1', '2020-09-10 22:13:20', '2020-09-10 22:13:23', '1', '自然风光', '');
INSERT INTO `kss_category` VALUES ('12', '1', '名胜古迹', '2', '2020-09-10 22:13:37', '2020-09-10 22:13:38', '1', '名胜古迹', '');
INSERT INTO `kss_category` VALUES ('13', '1', '公园游乐场', '3', '2020-09-10 22:13:54', '2020-09-10 22:13:55', '1', '公园游乐场', '');
INSERT INTO `kss_category` VALUES ('14', '2', '海南行', '4', '2020-09-10 22:14:36', '2020-09-10 22:14:38', '1', '海南行', '');
INSERT INTO `kss_category` VALUES ('15', '2', '云南丽江', '5', '2020-09-10 22:15:06', '2020-09-10 22:15:08', '1', '云南丽江', '');
INSERT INTO `kss_category` VALUES ('16', '2', '大西北', '6', '2020-09-10 22:15:27', '2020-09-10 22:15:29', '1', '大西北', '');
INSERT INTO `kss_category` VALUES ('17', '2', '广西广东', '7', '2020-09-10 22:15:46', '2020-09-10 22:15:49', '1', '广西广东', '');
INSERT INTO `kss_category` VALUES ('18', '2', '两湖北京', '8', '2020-09-10 22:16:26', '2020-09-10 22:16:28', '1', '两湖北京', '');
INSERT INTO `kss_category` VALUES ('19', '2', '川贵', '9', '2020-10-16 14:42:52', '2020-10-16 14:42:55', '1', '川贵', '');
INSERT INTO `kss_category` VALUES ('20', '3', '港澳台旅游攻略', '10', '2020-10-16 14:43:34', '2020-10-16 14:43:36', '1', '港澳台旅游攻略', '');
INSERT INTO `kss_category` VALUES ('21', '3', '东南亚攻略', '11', '2020-10-16 14:44:16', '2020-10-16 14:44:18', '1', '东南亚攻略', '');
INSERT INTO `kss_category` VALUES ('22', '3', '新马泰攻略', '12', '2020-10-16 14:59:15', '2020-10-16 14:59:18', '1', '新马泰攻略', '');
INSERT INTO `kss_category` VALUES ('23', '3', '澳洲攻略', '1', '2021-03-26 16:31:00', '2021-06-18 18:00:37', '1', '澳洲攻略', '');
INSERT INTO `kss_category` VALUES ('24', '3', '国内攻略', '2', '2021-03-26 16:32:03', '2021-06-18 18:00:42', '1', '国内攻略', '');
INSERT INTO `kss_category` VALUES ('25', '4', '上海迪士尼', '1', '2021-03-26 16:39:49', '2021-03-30 18:13:47', '1', '上海迪士尼', '');
INSERT INTO `kss_category` VALUES ('26', '4', '东风明珠', '2', '2021-03-26 16:40:11', '2021-03-30 18:13:49', '1', '东风明珠', '');
INSERT INTO `kss_category` VALUES ('27', '4', '十六码头', '3', '2021-03-26 16:40:34', '2021-03-30 18:13:53', '1', '十六码头', '');
INSERT INTO `kss_category` VALUES ('28', '4', '上海海昌公园', '4', '2021-03-26 16:41:03', '2021-03-30 18:13:55', '1', '上海海昌公园', '');
INSERT INTO `kss_category` VALUES ('29', '4', '乌镇', '5', '2021-03-26 16:41:27', '2021-03-30 18:13:57', '1', '乌镇', '');
INSERT INTO `kss_category` VALUES ('30', '4', '长沙橘子洲头', '6', '2021-03-26 16:41:49', '2021-03-30 18:13:59', '1', '长沙橘子洲头', '');
INSERT INTO `kss_category` VALUES ('31', '4', '岳麓山书院', '7', '2021-03-26 16:42:07', '2021-03-30 18:14:00', '1', '岳麓山书院', '');
INSERT INTO `kss_category` VALUES ('32', '5', '三星', '8', '2021-03-26 16:42:25', '2021-03-30 18:14:02', '1', '三星', '');
INSERT INTO `kss_category` VALUES ('33', '5', '四星', '9', '2021-03-26 16:42:50', '2021-03-30 18:14:04', '1', '四星', '');
INSERT INTO `kss_category` VALUES ('34', '5', '五星', '6', '2021-03-26 16:43:54', '2021-03-26 17:14:41', '1', '五星', '');
INSERT INTO `kss_category` VALUES ('35', '5', '海景房', '1', '2021-03-26 16:44:32', '2021-03-26 16:46:47', '1', '海景房', '');
INSERT INTO `kss_category` VALUES ('36', '5', '民宿', '2', '2021-03-26 16:44:47', '2021-03-26 16:46:45', '1', '民宿', '');
INSERT INTO `kss_category` VALUES ('37', '5', '公寓', '3', '2021-03-26 16:44:59', '2021-03-26 16:46:43', '1', '公寓', '');

-- ----------------------------
-- Table structure for kss_order
-- ----------------------------
DROP TABLE IF EXISTS `kss_order`;
CREATE TABLE `kss_order` (
  `id` bigint(20) NOT NULL,
  `order_number` bigint(20) DEFAULT NULL,
  `bit_number` bigint(20) DEFAULT NULL,
  `product_title` varchar(200) DEFAULT NULL,
  `product_img` varchar(200) DEFAULT NULL,
  `product_price` decimal(10,2) DEFAULT NULL,
  `product_desc` varchar(400) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `avatar` varchar(200) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `paymethod` int(1) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `ipaddr` varchar(100) DEFAULT NULL,
  `platform` int(1) DEFAULT NULL,
  `tradeno` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_order
-- ----------------------------

-- ----------------------------
-- Table structure for kss_product
-- ----------------------------
DROP TABLE IF EXISTS `kss_product`;
CREATE TABLE `kss_product` (
  `product_id` bigint(20) NOT NULL COMMENT '产品id',
  `product_title` varchar(200) DEFAULT NULL COMMENT '产品标题',
  `product_desc` varchar(400) DEFAULT NULL COMMENT '产品描述',
  `product_price` decimal(10,2) DEFAULT NULL COMMENT '产品价格',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `product_img` varchar(400) DEFAULT NULL COMMENT '产品封面',
  `status` int(1) DEFAULT NULL COMMENT '产品的状态 0 未发布 1发布',
  `product_info` longtext COMMENT '产品详细描述',
  `tags` varchar(100) DEFAULT NULL COMMENT '标签',
  `thumnimgs` text COMMENT '图集',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `address` varchar(200) DEFAULT NULL COMMENT '景区地址',
  `latitude` varchar(20) DEFAULT NULL COMMENT '纬度',
  `longitude` varchar(20) DEFAULT NULL COMMENT '经度',
  `user_id` bigint(20) DEFAULT NULL COMMENT '添加用户',
  `username` varchar(255) DEFAULT NULL COMMENT '添加用户名称',
  `avatar` varchar(400) DEFAULT NULL COMMENT '添加用户的头像',
  `price` varchar(10) DEFAULT NULL COMMENT '展示价格',
  `viewcount` int(11) DEFAULT NULL COMMENT '产品的浏览数',
  `favcount` int(11) DEFAULT NULL COMMENT '产品的收藏数',
  `category_cid` bigint(20) DEFAULT NULL COMMENT '产品的二级分类',
  `category_pid` bigint(20) DEFAULT NULL COMMENT '产品的一级分类',
  `category_ptitle` varchar(100) DEFAULT NULL COMMENT '产品一级分类的名称',
  `category_ctitle` varchar(100) DEFAULT NULL COMMENT '产品二级分类的名称',
  PRIMARY KEY (`product_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_product
-- ----------------------------
INSERT INTO `kss_product` VALUES ('1', '小米12', '1游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tps/i4/TB1q42TjMTqK1RjSZPhSutfOFXa.jpg', '1', null, null, null, '2021-08-30 23:09:51', null, null, null, null, null, null, null, null, null, '2', '1', null, null);
INSERT INTO `kss_product` VALUES ('2', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖2』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/bao/uploaded/i1/2787417447/O1CN0124sly8iXb80L4OS_!!0-item_pic.jpg', '1', null, null, null, '2021-08-30 23:10:37', null, null, null, null, null, null, null, null, null, '3', '1', null, null);
INSERT INTO `kss_product` VALUES ('3', '小米12', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖3』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB13FixCeuSBuNjy1XcXXcYjFXa-468-1236.jpg', '1', null, null, null, '2021-08-30 23:10:37', null, null, null, null, null, null, null, null, null, '3', '1', null, null);
INSERT INTO `kss_product` VALUES ('4', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖4』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB1Q2Org4rI8KJjy0FpXXb5hVXa-468-1236.jpg', '1', null, null, null, '2021-08-30 23:10:37', null, null, null, null, null, null, null, null, null, '3', '1', null, null);
INSERT INTO `kss_product` VALUES ('5', '小米12', '1游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tps/i4/TB1q42TjMTqK1RjSZPhSutfOFXa.jpg', '1', '', '', '', '2021-08-30 23:09:51', '', '', '', null, '', '', '', null, null, '2', '1', '', '');
INSERT INTO `kss_product` VALUES ('6', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖2』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/bao/uploaded/i1/2787417447/O1CN0124sly8iXb80L4OS_!!0-item_pic.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('7', '小米12', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖3』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB13FixCeuSBuNjy1XcXXcYjFXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('8', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖4』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB1Q2Org4rI8KJjy0FpXXb5hVXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('9', '小米12', '1游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tps/i4/TB1q42TjMTqK1RjSZPhSutfOFXa.jpg', '1', '', '', '', '2021-08-30 23:09:51', '', '', '', null, '', '', '', null, null, '2', '1', '', '');
INSERT INTO `kss_product` VALUES ('10', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖2』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/bao/uploaded/i1/2787417447/O1CN0124sly8iXb80L4OS_!!0-item_pic.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('11', '小米12', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖3』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB13FixCeuSBuNjy1XcXXcYjFXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('12', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖4』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB1Q2Org4rI8KJjy0FpXXb5hVXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('111', '小米12', '1游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tps/i4/TB1q42TjMTqK1RjSZPhSutfOFXa.jpg', '1', '', '', '', '2021-08-30 23:09:51', '', '', '', null, '', '', '', null, null, '2', '1', '', '');
INSERT INTO `kss_product` VALUES ('222', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖2』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/bao/uploaded/i1/2787417447/O1CN0124sly8iXb80L4OS_!!0-item_pic.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('333', '小米12', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖3』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB13FixCeuSBuNjy1XcXXcYjFXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('444', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖4』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB1Q2Org4rI8KJjy0FpXXb5hVXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('555', '小米12', '1游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tps/i4/TB1q42TjMTqK1RjSZPhSutfOFXa.jpg', '1', '', '', '', '2021-08-30 23:09:51', '', '', '', null, '', '', '', null, null, '2', '1', '', '');
INSERT INTO `kss_product` VALUES ('666', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖2』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/bao/uploaded/i1/2787417447/O1CN0124sly8iXb80L4OS_!!0-item_pic.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('777', '小米12', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖3』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB13FixCeuSBuNjy1XcXXcYjFXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('888', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖4』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB1Q2Org4rI8KJjy0FpXXb5hVXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('999', '小米12', '1游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tps/i4/TB1q42TjMTqK1RjSZPhSutfOFXa.jpg', '1', '', '', '', '2021-08-30 23:09:51', '', '', '', null, '', '', '', null, null, '2', '1', '', '');
INSERT INTO `kss_product` VALUES ('1111', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖2』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/bao/uploaded/i1/2787417447/O1CN0124sly8iXb80L4OS_!!0-item_pic.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('2222', '小米12', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖3』', '2999.58', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB13FixCeuSBuNjy1XcXXcYjFXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');
INSERT INTO `kss_product` VALUES ('3333', '品牌T恤', '游玩安排：广州长隆3日自由行(4钻)·『人气热卖』广州长隆3日自由行(4钻)·『人气热卖4』', '1999.00', '2021-08-01 21:52:16', 'https://img.alicdn.com/tfs/TB1Q2Org4rI8KJjy0FpXXb5hVXa-468-1236.jpg', '1', '', '', '', '2021-08-30 23:10:37', '', '', '', null, '', '', '', null, null, '3', '1', '', '');

-- ----------------------------
-- Table structure for kss_ticket
-- ----------------------------
DROP TABLE IF EXISTS `kss_ticket`;
CREATE TABLE `kss_ticket` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `price` varchar(10) DEFAULT NULL COMMENT '展示价格',
  `realprice` decimal(10,2) DEFAULT NULL COMMENT '真实价格',
  `salecount` int(11) DEFAULT NULL COMMENT '已购数量',
  `tags1` varchar(50) DEFAULT NULL COMMENT '标签1',
  `tags2` varchar(50) DEFAULT NULL COMMENT '标签1',
  `tags3` varchar(50) DEFAULT NULL COMMENT '标签1',
  `tags4` varchar(50) DEFAULT NULL COMMENT '标签1',
  `tags5` varchar(50) DEFAULT NULL COMMENT '标签1',
  `tags6` varchar(50) DEFAULT NULL COMMENT '标签1',
  `tags7` varchar(50) DEFAULT NULL COMMENT '标签1',
  `tags8` varchar(50) DEFAULT NULL COMMENT '标签1',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `status` int(1) DEFAULT NULL COMMENT '发布字段 0 未发布 1 发布',
  `product_id` bigint(20) DEFAULT NULL COMMENT '所属产品',
  `user_id` bigint(20) DEFAULT NULL COMMENT '添加用户',
  `username` varchar(255) DEFAULT NULL COMMENT '添加用户名称',
  `avatar` varchar(400) DEFAULT NULL COMMENT '添加用户的头像',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_ticket
-- ----------------------------

-- ----------------------------
-- Table structure for kss_user
-- ----------------------------
DROP TABLE IF EXISTS `kss_user`;
CREATE TABLE `kss_user` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `username` varchar(100) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `openid` varchar(80) DEFAULT NULL COMMENT '微信小程序openid',
  `avatar_url` varchar(200) DEFAULT NULL COMMENT '微信用户的头像',
  `city` varchar(50) DEFAULT NULL COMMENT '微信用户的城市',
  `country` varchar(50) DEFAULT NULL COMMENT '微信用户的国家',
  `gender` int(1) DEFAULT NULL COMMENT '微信用户的性别1男 0女',
  `nick_name` varchar(200) DEFAULT NULL COMMENT '微信用户的昵称',
  `province` varchar(50) DEFAULT NULL COMMENT '微信用户的省份',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `active` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_user
-- ----------------------------
INSERT INTO `kss_user` VALUES ('1432344068020514817', 'yykk', '', 'ofMLq0GZZZzUd5aZ2JgnlhGAekTc', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKJWV6WFibOryicMNTdPvmUlSdfhr5NOibvHCBK16eFj4ng9uiaPajNc4D2S6tVc4EbOT6eTTtXeqVCtg/132', 'Meizhou', 'China', '1', 'yykk', 'Guangdong', '2021-08-30 22:06:52', '2021-08-30 22:06:52', '1');

-- ----------------------------
-- Table structure for kss_user_202108
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_202108`;
CREATE TABLE `kss_user_202108` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `username` varchar(100) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `openid` varchar(80) DEFAULT NULL COMMENT '微信小程序openid',
  `avatar_url` varchar(200) DEFAULT NULL COMMENT '微信用户的头像',
  `city` varchar(50) DEFAULT NULL COMMENT '微信用户的城市',
  `country` varchar(50) DEFAULT NULL COMMENT '微信用户的国家',
  `gender` int(1) DEFAULT NULL COMMENT '微信用户的性别1男 0女',
  `nick_name` varchar(200) DEFAULT NULL COMMENT '微信用户的昵称',
  `province` varchar(50) DEFAULT NULL COMMENT '微信用户的省份',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `active` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_user_202108
-- ----------------------------
INSERT INTO `kss_user_202108` VALUES ('1426206712481832962', 'yykk', '', 'ofMLq0GZZZzUd5aZ2JgnlhGAekTc', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKJWV6WFibOryicMNTdPvmUlSdfhr5NOibvHCBK16eFj4ng9uiaPajNc4D2S6tVc4EbOT6eTTtXeqVCtg/132', 'Meizhou', 'China', '1', 'yykk', 'Guangdong', null, null, '1');

-- ----------------------------
-- Table structure for kss_user_202109
-- ----------------------------
DROP TABLE IF EXISTS `kss_user_202109`;
CREATE TABLE `kss_user_202109` (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `username` varchar(100) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `openid` varchar(80) DEFAULT NULL COMMENT '微信小程序openid',
  `avatar_url` varchar(200) DEFAULT NULL COMMENT '微信用户的头像',
  `city` varchar(50) DEFAULT NULL COMMENT '微信用户的城市',
  `country` varchar(50) DEFAULT NULL COMMENT '微信用户的国家',
  `gender` int(1) DEFAULT NULL COMMENT '微信用户的性别1男 0女',
  `nick_name` varchar(200) DEFAULT NULL COMMENT '微信用户的昵称',
  `province` varchar(50) DEFAULT NULL COMMENT '微信用户的省份',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `active` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of kss_user_202109
-- ----------------------------
INSERT INTO `kss_user_202109` VALUES ('1426206712481832962', 'yykk', '', 'ofMLq0GZZZzUd5aZ2JgnlhGAekTc', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKJWV6WFibOryicMNTdPvmUlSdfhr5NOibvHCBK16eFj4ng9uiaPajNc4D2S6tVc4EbOT6eTTtXeqVCtg/132', 'Meizhou', 'China', '1', 'yykk', 'Guangdong', null, null, '1');

-- ----------------------------
-- Table structure for tiny_id_info
-- ----------------------------
DROP TABLE IF EXISTS `tiny_id_info`;
CREATE TABLE `tiny_id_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `biz_type` varchar(63) NOT NULL DEFAULT '' COMMENT '业务类型，唯一',
  `begin_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '开始id，仅记录初始值，无其他含义。初始化时begin_id和max_id应相同',
  `max_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '当前最大id',
  `step` int(11) DEFAULT '0' COMMENT '步长',
  `delta` int(11) NOT NULL DEFAULT '1' COMMENT '每次id增量',
  `remainder` int(11) NOT NULL DEFAULT '0' COMMENT '余数',
  `create_time` timestamp NOT NULL DEFAULT '2010-01-01 00:00:00' COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT '2010-01-01 00:00:00' COMMENT '更新时间',
  `version` bigint(20) NOT NULL DEFAULT '0' COMMENT '版本号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq_biz_type` (`biz_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='id信息表';

-- ----------------------------
-- Records of tiny_id_info
-- ----------------------------
INSERT INTO `tiny_id_info` VALUES ('1', 'order', '1', '2210', '100', '1', '0', '2018-07-21 23:52:58', '2021-08-18 22:51:10', '63');
INSERT INTO `tiny_id_info` VALUES ('2', 'product', '1', '710', '100', '10', '1', '2018-07-21 23:52:58', '2021-08-18 23:24:09', '20');

-- ----------------------------
-- Table structure for tiny_id_token
-- ----------------------------
DROP TABLE IF EXISTS `tiny_id_token`;
CREATE TABLE `tiny_id_token` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `token` varchar(255) NOT NULL DEFAULT '' COMMENT 'token',
  `biz_type` varchar(63) NOT NULL DEFAULT '' COMMENT '此token可访问的业务类型标识',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT '2010-01-01 00:00:00' COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT '2010-01-01 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token信息表';

-- ----------------------------
-- Records of tiny_id_token
-- ----------------------------
INSERT INTO `tiny_id_token` VALUES ('1', '0f673adf80504e2eaa552f5d791b644c', 'order', '1', '2017-12-14 16:36:46', '2017-12-14 16:36:48');
INSERT INTO `tiny_id_token` VALUES ('2', '0f673adf80504e2eaa552f5d791b644c', 'product', '1', '2017-12-14 16:36:46', '2017-12-14 16:36:48');

-- ----------------------------
-- Table structure for worker_node
-- ----------------------------
DROP TABLE IF EXISTS `worker_node`;
CREATE TABLE `worker_node` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'auto increment id',
  `HOST_NAME` varchar(64) NOT NULL COMMENT 'host name',
  `PORT` varchar(64) NOT NULL COMMENT 'port',
  `TYPE` int(11) NOT NULL COMMENT 'node type: ACTUAL or CONTAINER',
  `LAUNCH_DATE` date NOT NULL COMMENT 'launch date',
  `MODIFIED` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'modified time',
  `CREATED` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='DB WorkerID Assigner for UID Generator';

-- ----------------------------
-- Records of worker_node
-- ----------------------------
INSERT INTO `worker_node` VALUES ('1', '192.168.0.10', '1629167405022-61277', '2', '2021-08-17', '2021-08-17 10:30:05', '2021-08-17 10:30:05');
INSERT INTO `worker_node` VALUES ('2', '192.168.0.10', '1629168974457-184', '2', '2021-08-17', '2021-08-17 10:56:14', '2021-08-17 10:56:14');
INSERT INTO `worker_node` VALUES ('3', '192.168.0.10', '1629169614412-13094', '2', '2021-08-17', '2021-08-17 11:06:54', '2021-08-17 11:06:54');
INSERT INTO `worker_node` VALUES ('4', '192.168.0.10', '1629183429021-29141', '2', '2021-08-17', '2021-08-17 14:57:09', '2021-08-17 14:57:09');
INSERT INTO `worker_node` VALUES ('5', '192.168.0.10', '1629183588660-59721', '2', '2021-08-17', '2021-08-17 14:59:48', '2021-08-17 14:59:48');
INSERT INTO `worker_node` VALUES ('6', '192.168.0.10', '1629183662777-57636', '2', '2021-08-17', '2021-08-17 15:01:02', '2021-08-17 15:01:02');
INSERT INTO `worker_node` VALUES ('7', '192.168.0.10', '1629185001795-50748', '2', '2021-08-17', '2021-08-17 15:23:21', '2021-08-17 15:23:21');
INSERT INTO `worker_node` VALUES ('8', '192.168.0.10', '1629185046579-90906', '2', '2021-08-17', '2021-08-17 15:24:06', '2021-08-17 15:24:06');
INSERT INTO `worker_node` VALUES ('9', '192.168.1.9', '1629203815473-86855', '2', '2021-08-17', '2021-08-17 20:36:55', '2021-08-17 20:36:55');
INSERT INTO `worker_node` VALUES ('10', '192.168.1.9', '1629285476358-76765', '2', '2021-08-18', '2021-08-18 19:17:56', '2021-08-18 19:17:56');
INSERT INTO `worker_node` VALUES ('11', '192.168.1.9', '1629286242641-29190', '2', '2021-08-18', '2021-08-18 19:30:42', '2021-08-18 19:30:42');
INSERT INTO `worker_node` VALUES ('12', '192.168.1.9', '1629286521540-98939', '2', '2021-08-18', '2021-08-18 19:35:21', '2021-08-18 19:35:21');