Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
文件
This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.
Clone or Download
kuangstudytourdb.sql 30.76 KB
Copy Edit Raw Blame History
飞哥 authored 2021-09-01 14:47 . 1:新增数据库脚本
/*
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');
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化