/*
 Navicat MySQL Data Transfer

 Source Server         : 阿里云
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : 47.105.122.186:3306
 Source Schema         : cms_v2_site_1

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

 Date: 05/08/2021 23:42:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `BLOB_DATA` blob NULL,
  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CRON_EXPRESSION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_DATA` blob NULL,
  PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `STR_PROP_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `INT_PROP_1` int(11) NULL DEFAULT NULL,
  `INT_PROP_2` int(11) NULL DEFAULT NULL,
  `LONG_PROP_1` bigint(20) NULL DEFAULT NULL,
  `LONG_PROP_2` bigint(20) NULL DEFAULT NULL,
  `DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL,
  `DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers`  (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) NULL DEFAULT NULL,
  `PRIORITY` int(11) NULL DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) NULL DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) NULL DEFAULT NULL,
  `JOB_DATA` blob NULL,
  PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
  INDEX `SCHED_NAME`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for sys_api_source
-- ----------------------------
DROP TABLE IF EXISTS `sys_api_source`;
CREATE TABLE `sys_api_source`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parent_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `api_type` int(11) NULL DEFAULT 0 COMMENT '0:服务 1：接口',
  `api_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口名称',
  `api_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口地址',
  `api_perm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口标识',
  `api_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口描述',
  `api_module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口所属服务模块标识',
  `api_order_num` int(11) NULL DEFAULT 0 COMMENT '排序',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` timestamp(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 sys_api_source
-- ----------------------------
INSERT INTO `sys_api_source` VALUES ('441972374280077312', '0', 0, '管理端服务', NULL, NULL, '颠三倒四', 'thinkit-cms', 1, '1', '1', '2020-05-04 14:40:25', '2021-07-17 18:35:56');

-- ----------------------------
-- Table structure for sys_api_source_client
-- ----------------------------
DROP TABLE IF EXISTS `sys_api_source_client`;
CREATE TABLE `sys_api_source_client`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `api_source_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口资源ID',
  `client_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `service_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微服务实例id',
  `half_checked` int(2) NULL DEFAULT 0 COMMENT '0：半选中 1：全选中',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人Id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 sys_api_source_client
-- ----------------------------
INSERT INTO `sys_api_source_client` VALUES ('445226399440044032', '441973796379820032', 'app_tgy', NULL, 1, '1', NULL, '2020-05-13 14:10:46', NULL);
INSERT INTO `sys_api_source_client` VALUES ('445226399440044033', '442453014058369024', 'app_tgy', NULL, 1, '1', NULL, '2020-05-13 14:10:46', NULL);
INSERT INTO `sys_api_source_client` VALUES ('445226399440044034', '441974253068222464', 'app_tgy', NULL, 1, '1', NULL, '2020-05-13 14:10:46', NULL);
INSERT INTO `sys_api_source_client` VALUES ('445226399440044035', '441974347662360576', 'app_tgy', NULL, 1, '1', NULL, '2020-05-13 14:10:46', NULL);
INSERT INTO `sys_api_source_client` VALUES ('445226399440044036', '441972374280077312', 'app_tgy', NULL, 0, '1', '1', '2020-05-13 14:10:46', '2020-11-21 18:46:45');
INSERT INTO `sys_api_source_client` VALUES ('451070471023099904', '441974347662360576', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099905', '441972374280077312', 'app_sy', NULL, 0, '1', '1', '2020-05-29 17:13:01', '2020-11-21 18:46:45');
INSERT INTO `sys_api_source_client` VALUES ('451070471023099906', '441974253068222464', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099907', '447794498928377856', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099908', '447798661405999104', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099909', '447798520993284096', 'app_sy', NULL, 0, '1', '1', '2020-05-29 17:13:01', '2020-11-21 18:32:14');
INSERT INTO `sys_api_source_client` VALUES ('451070471023099910', '448060921177178112', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099911', '449629836923633664', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099912', '450646575459336192', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099913', '450647035004059648', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099914', '451070413804404736', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('451070471023099915', '447794227493994496', 'app_sy', NULL, 1, '1', NULL, '2020-05-29 17:13:01', NULL);
INSERT INTO `sys_api_source_client` VALUES ('514911699338264576', '441972374280077312', 'mem_user', NULL, 0, '1', NULL, '2020-11-21 21:15:16', NULL);
INSERT INTO `sys_api_source_client` VALUES ('514911699338264577', '441974253068222464', 'mem_user', NULL, 1, '1', NULL, '2020-11-21 21:15:16', NULL);
INSERT INTO `sys_api_source_client` VALUES ('514911699338264578', '441974347662360576', 'mem_user', NULL, 1, '1', NULL, '2020-11-21 21:15:16', NULL);
INSERT INTO `sys_api_source_client` VALUES ('514911699338264579', '441973796379820032', 'mem_user', NULL, 1, '1', NULL, '2020-11-21 21:15:16', NULL);
INSERT INTO `sys_api_source_client` VALUES ('514911699338264580', '442453014058369024', 'mem_user', NULL, 1, '1', NULL, '2020-11-21 21:15:16', NULL);

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '标签名',
  `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '数据值',
  `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '类型',
  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '描述',
  `num` int(10) NULL DEFAULT NULL COMMENT '排序（升序）',
  `parent_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '0' COMMENT '父级主键',
  `remarks` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '备注信息',
  `del_flag` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `status` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '0' COMMENT '删除标记 0:正常 1：删除',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sys_dict_value`(`value`) USING BTREE,
  INDEX `sys_dict_label`(`name`) USING BTREE,
  INDEX `sys_dict_del_flag`(`status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '字典表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES ('381387466474520577', '任务执行时间', 'JOB_TIME_CRON', 'JOB_TIME_CRON', '任务执行时间表达式', 1, '0', NULL, NULL, '0', '1', NULL, '2019-11-19 10:17:38', '2019-11-19 10:17:38');
INSERT INTO `sys_dict` VALUES ('381387899242807297', '1分钟', '0 0/1 * * * ?', 'JOB_TIME_CRON', '3分钟执行一次', 4, '381387466474520577', NULL, NULL, '0', '1', '1', '2019-11-19 10:19:21', '2019-12-24 15:02:28');
INSERT INTO `sys_dict` VALUES ('381387985976819713', '3分钟', '0 0/3 * * * ?', 'JOB_TIME_CRON', '0 0/3 * * * ?', 6, '381387466474520577', NULL, NULL, '0', '1', '1', '2019-11-19 10:19:42', '2019-12-24 15:02:48');
INSERT INTO `sys_dict` VALUES ('381388286448369665', '2分钟', '0 0/2 * * * ?', 'JOB_TIME_CRON', '2分钟执行一次', 5, '381387466474520577', '2分钟执行一次', NULL, '0', '1', '1', '2019-11-19 10:20:53', '2019-12-24 15:02:38');
INSERT INTO `sys_dict` VALUES ('381389072393830401', '任务执行器', 'JOB_CLASS', 'JOB_CLASS', '用于任务执行时调用类', 1, '0', NULL, NULL, '0', '1', '1', '2019-11-19 10:24:01', '2020-02-22 00:19:59');
INSERT INTO `sys_dict` VALUES ('381389263385657345', '生成首页文件', 'com.thinkcms.freemark.jobs.HomePageGenJob', 'JOB_CLASS', NULL, 11, '381389072393830401', NULL, NULL, '0', '1', '1', '2019-11-19 10:24:46', '2020-02-22 00:18:30');
INSERT INTO `sys_dict` VALUES ('381389470974345217', '生成栏目列表页', 'com.thinkcms.freemark.jobs.CategoryListGenJob', 'JOB_CLASS', NULL, 9, '381389072393830401', 'eeeeeee', NULL, '0', '1', '1', '2019-11-19 10:25:36', '2020-11-16 22:21:08');
INSERT INTO `sys_dict` VALUES ('381497258744479745', '10秒', '1/10 * * * * ? ', 'JOB_TIME_CRON', '10秒执行一次', 2, '381387466474520577', NULL, NULL, '0', '1', '1', '2019-11-19 17:33:54', '2019-12-24 15:00:00');
INSERT INTO `sys_dict` VALUES ('381499363274260481', '3秒钟', '0/3 * * * * ? ', 'JOB_TIME_CRON', NULL, 1, '381387466474520577', NULL, NULL, '0', '1', NULL, '2019-11-19 17:42:16', '2019-11-19 17:42:16');
INSERT INTO `sys_dict` VALUES ('394421373386096641', '凌晨1点', '0 0 1 * * ?', 'JOB_TIME_CRON', '每天凌晨1点执行', 7, '381387466474520577', '每天凌晨1点执行', NULL, '0', '1', '1', '2019-12-25 09:29:43', '2019-12-25 09:30:03');
INSERT INTO `sys_dict` VALUES ('408265033609379841', 'LOG日志删除', 'com.thinkcms.freemark.jobs.ClearLogJob', 'JOB_CLASS', '日志删除', 1, '381389072393830401', '日志定时删除', NULL, '0', '1', '1', '2020-02-01 14:19:29', '2020-02-22 00:18:06');
INSERT INTO `sys_dict` VALUES ('408265222889930753', '月末23点', '0 00 23 L * ?', 'JOB_TIME_CRON', '每月最后一天的23点执行', 55, '381387466474520577', '每月最后一天的23点执行', NULL, '0', '1', '1', '2020-02-01 14:20:14', '2020-02-01 14:20:42');
INSERT INTO `sys_dict` VALUES ('513117091247685632', 'ggggg', 'gggg', 'ddddddfdfd', 'ggg', 1, '513117054492999680', 'gggg', NULL, '0', '1', NULL, '2020-11-16 22:24:08', '2020-11-16 22:24:08');
INSERT INTO `sys_dict` VALUES ('513122265185910784', '服务名称', 'servers', 'server_name', '服务名称', 1, '0', '服务名称', NULL, '0', '1', NULL, '2020-11-16 22:44:41', '2020-11-16 22:44:41');
INSERT INTO `sys_dict` VALUES ('513122549333229568', '管理端服务', 'thinkit-admin', 'server_name', '管理端服务', 1, '513122265185910784', NULL, NULL, '0', '1', NULL, '2020-11-16 22:45:49', '2020-11-16 22:45:49');
INSERT INTO `sys_dict` VALUES ('513122671605579776', 'CMS 服务', 'thinkit-cms', 'server_name', 'CMS 服务', 1, '513122265185910784', 'CMS 服务', NULL, '0', '1', NULL, '2020-11-16 22:46:18', '2020-11-16 22:46:18');
INSERT INTO `sys_dict` VALUES ('513122840845746176', '授权服务', 'thinkit-auth', 'server_name', '授权服务', 1, '513122265185910784', 'thinkit-auth', NULL, '0', '1', NULL, '2020-11-16 22:46:59', '2020-11-16 22:46:59');
INSERT INTO `sys_dict` VALUES ('513122974803427328', '网关服务', 'thinkit-gateway', 'server_name', '网关服务', 1, '513122265185910784', NULL, NULL, '0', '1', NULL, '2020-11-16 22:47:31', '2020-11-16 22:47:31');

-- ----------------------------
-- Table structure for sys_file_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_group`;
CREATE TABLE `sys_file_group`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分组名称',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分组编码',
  `is_sys_group` tinyint(4) NULL DEFAULT 0 COMMENT '是否是系统分组，系统分组禁止删除',
  `sort` int(11) NULL DEFAULT 0 COMMENT '排序',
  `site_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_file_group
-- ----------------------------
INSERT INTO `sys_file_group` VALUES ('596153554255740928', '32而且我无群二位', NULL, 0, 1, '592501202101469184', '1', '1', '2021-07-04 01:41:23', '2021-07-04 01:41:38');
INSERT INTO `sys_file_group` VALUES ('596153642428399616', '颠三倒四', NULL, 0, 1, '592501202101469184', '1', NULL, '2021-07-04 01:41:44', '2021-07-04 01:41:44');
INSERT INTO `sys_file_group` VALUES ('596153740461867008', '额问问', NULL, 0, 1, '592501202101469184', '1', NULL, '2021-07-04 01:42:08', '2021-07-04 01:42:08');
INSERT INTO `sys_file_group` VALUES ('596261889420296192', '文档专栏', NULL, 0, 0, '403877614789328897', '1', '1', '2021-07-04 08:51:52', '2021-07-24 17:32:08');
INSERT INTO `sys_file_group` VALUES ('598904510609358848', '视频专栏', NULL, 0, 0, '403877614789328897', '1', '1', '2021-07-11 15:52:42', '2021-07-24 17:32:01');
INSERT INTO `sys_file_group` VALUES ('601026887958921216', '共享文件夹', NULL, 0, 0, '403877614789328897', '1', '1', '2021-07-17 12:26:17', '2021-07-18 17:10:47');
INSERT INTO `sys_file_group` VALUES ('603640625069293568', '图片素材', NULL, 0, 0, '403877614789328897', '1', NULL, '2021-07-24 17:32:20', '2021-07-24 17:32:20');

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组',
  `cron_expression` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务表达式',
  `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务描述',
  `job_status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '-1：为启动 0：已启动 1：已暂停' COMMENT '任务状态',
  `job_class` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'job class',
  `job_param` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '执行参数',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_job
-- ----------------------------
INSERT INTO `sys_job` VALUES ('415664168100691969', '首页生成', 'group3', '0 0 1 * * ?', NULL, '-1：为启动 0：已启动 1：已暂停', 'com.thinkcms.freemark.jobs.HomePageGenJob', NULL, '1', NULL, '2020-02-22 00:21:00', '2020-02-22 00:21:00');
INSERT INTO `sys_job` VALUES ('415664375731322881', '日志清理', 'group3', '0 00 23 L * ?', NULL, '-1：为启动 0：已启动 1：已暂停', 'com.thinkcms.freemark.jobs.ClearLogJob', '5', '1', NULL, '2020-02-22 00:21:50', '2020-02-22 00:21:50');
INSERT INTO `sys_job` VALUES ('415664629897756673', '同步点击次数', 'group3', '0 0 1 * * ?', NULL, '0', 'com.thinkcms.freemark.jobs.ContentClickAndGiveLikeJob', NULL, '1', '1', '2020-02-22 00:22:50', '2020-04-12 16:03:46');

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `type` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块类型',
  `module` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `user_id` bigint(30) NULL DEFAULT NULL COMMENT '用户id',
  `user_account` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `operation` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '用户操作',
  `time` int(11) NULL DEFAULT NULL COMMENT '响应时间',
  `method` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求方法',
  `params` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数',
  `ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `system_type` int(11) NULL DEFAULT 0 COMMENT '系统类型0：后台操作日志 1：前台操作日志 2：安卓或者其他操作日志 等',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO `sys_log` VALUES ('608081072126689280', 'USER', '用户管理模块', 1, 'admin', NULL, '进入/刷新首页', 16, 'com.thinkit.cms.controller.admin.UserController.info()', NULL, '127.0.0.1', '2021-08-05 23:37:05', 0, '1', NULL, '2021-08-05 23:37:05');
INSERT INTO `sys_log` VALUES ('608081072533536768', 'MENU', '菜单管理模块', 1, 'admin', NULL, '加载用户菜单', 1, 'com.thinkit.cms.controller.admin.MenuController.loadMenu()', NULL, '127.0.0.1', '2021-08-05 23:37:05', 0, '1', NULL, '2021-08-05 23:37:05');
INSERT INTO `sys_log` VALUES ('608081784193679360', 'USER', '用户管理模块', 1, 'admin', NULL, '进入/刷新首页', 15, 'com.thinkit.cms.controller.admin.UserController.info()', NULL, '127.0.0.1', '2021-08-05 23:39:55', 0, '1', NULL, '2021-08-05 23:39:55');
INSERT INTO `sys_log` VALUES ('608081784579555328', 'MENU', '菜单管理模块', 1, 'admin', NULL, '加载用户菜单', 2, 'com.thinkit.cms.controller.admin.MenuController.loadMenu()', NULL, '127.0.0.1', '2021-08-05 23:39:55', 0, '1', NULL, '2021-08-05 23:39:55');
INSERT INTO `sys_log` VALUES ('608081814757572608', 'CONTENT', '内容管理模块', 1, 'admin', NULL, '统计文章月份发布量', 142, 'com.thinkit.cms.controller.content.ContentController.analysisMonthTop()', '{\"siteId\":\"403877614789328897\",\"status\":1}', '127.0.0.1', '2021-08-05 23:40:02', 0, '1', NULL, '2021-08-05 23:40:02');
INSERT INTO `sys_log` VALUES ('608081853299032064', 'USER', '用户管理模块', 1, 'admin', NULL, '查询用户列表', 69, 'com.thinkit.cms.controller.admin.UserController.page()', '{\"pageCount\":0,\"pageSize\":10,\"hasNext\":true,\"total\":0,\"pageNo\":1,\"dto\":{\"roleSigns\":[],\"perms\":[]}}', '127.0.0.1', '2021-08-05 23:40:11', 0, '1', NULL, '2021-08-05 23:40:11');
INSERT INTO `sys_log` VALUES ('608081874736119808', 'MODEL', '模型管理模块', 1, 'admin', NULL, '查看模型列表', 18, 'com.thinkit.cms.controller.model.ModelController.listPage()', '{\"pageCount\":0,\"pageSize\":10,\"hasNext\":true,\"total\":0,\"pageNo\":1,\"dto\":{\"siteId\":\"403877614789328897\"}}', '127.0.0.1', '2021-08-05 23:40:17', 0, '1', NULL, '2021-08-05 23:40:17');
INSERT INTO `sys_log` VALUES ('608082000670097408', 'USER', '用户管理模块', 1, 'admin', NULL, '进入/刷新首页', 18, 'com.thinkit.cms.controller.admin.UserController.info()', NULL, '127.0.0.1', '2021-08-05 23:40:47', 0, '1', NULL, '2021-08-05 23:40:47');
INSERT INTO `sys_log` VALUES ('608082001001447424', 'MENU', '菜单管理模块', 1, 'admin', NULL, '加载用户菜单', 2, 'com.thinkit.cms.controller.admin.MenuController.loadMenu()', NULL, '127.0.0.1', '2021-08-05 23:40:47', 0, '1', NULL, '2021-08-05 23:40:47');
INSERT INTO `sys_log` VALUES ('608082147835641856', 'USER', '用户管理模块', 1, 'admin', NULL, '进入/刷新首页', 31, 'com.thinkit.cms.controller.admin.UserController.info()', NULL, '127.0.0.1', '2021-08-05 23:41:22', 0, '1', NULL, '2021-08-05 23:41:22');
INSERT INTO `sys_log` VALUES ('608082148703862784', 'MENU', '菜单管理模块', 1, 'admin', NULL, '加载用户菜单', 1, 'com.thinkit.cms.controller.admin.MenuController.loadMenu()', NULL, '127.0.0.1', '2021-08-05 23:41:22', 0, '1', NULL, '2021-08-05 23:41:22');
INSERT INTO `sys_log` VALUES ('608082379965202432', 'USER', '用户管理模块', 1, 'admin', NULL, '进入/刷新首页', 52, 'com.thinkit.cms.controller.admin.UserController.info()', NULL, '127.0.0.1', '2021-08-05 23:42:17', 0, '1', NULL, '2021-08-05 23:42:17');
INSERT INTO `sys_log` VALUES ('608082380506267648', 'MENU', '菜单管理模块', 1, 'admin', NULL, '加载用户菜单', 41, 'com.thinkit.cms.controller.admin.MenuController.loadMenu()', NULL, '127.0.0.1', '2021-08-05 23:42:17', 0, '1', NULL, '2021-08-05 23:42:17');
INSERT INTO `sys_log` VALUES ('608082467265445888', 'USER', '用户管理模块', 1, 'admin', NULL, '进入/刷新首页', 43, 'com.thinkit.cms.controller.admin.UserController.info()', NULL, '127.0.0.1', '2021-08-05 23:42:38', 0, '1', NULL, '2021-08-05 23:42:38');
INSERT INTO `sys_log` VALUES ('608082467592601600', 'MENU', '菜单管理模块', 1, 'admin', NULL, '加载用户菜单', 1, 'com.thinkit.cms.controller.admin.MenuController.loadMenu()', NULL, '127.0.0.1', '2021-08-05 23:42:38', 0, '1', NULL, '2021-08-05 23:42:38');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `application` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '服务名称',
  `parent_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单URL对应接口地址',
  `perms` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(5) NULL DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `hidden` tinyint(4) NULL DEFAULT 0 COMMENT '0:不隐藏 1：隐藏',
  `keep_alive` tinyint(4) NULL DEFAULT NULL COMMENT '0:不缓存 1：缓存',
  `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入口组件',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由地址',
  `redirect` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '重定向（只有目录有）',
  `order_num` int(11) NULL DEFAULT 1 COMMENT '排序',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('130', NULL, '0', '系统管理', '', 'system:system', 0, 0, NULL, 'setting', 'RouteView', 'system', 'system/user', 1, '2018-03-22 16:31:10', '2020-11-24 22:17:52', '', '1');
INSERT INTO `sys_menu` VALUES ('131', 'thinkit-admin', '130', '用户管理', '/user/page', 'user:page', 1, 0, 1, 'user', 'SystemUser', 'user', NULL, 2, '2018-03-22 16:32:01', '2020-11-24 22:17:30', '', '1');
INSERT INTO `sys_menu` VALUES ('132', 'thinkit-admin', '130', '角色管理', '/role/page', 'role:page', 1, 0, 0, 'usergroup-add', 'SystemRole', 'role', NULL, 3, '2018-03-22 16:32:33', '2020-11-24 22:18:48', '', '1');
INSERT INTO `sys_menu` VALUES ('133', 'thinkit-admin', '130', '菜单管理', '/menu/selectTreeList', 'menu:page', 1, 0, 1, 'unordered-list', 'SystemMenu', 'menu', NULL, 4, '2019-11-06 18:38:05', '2020-11-24 22:19:43', '', '1');
INSERT INTO `sys_menu` VALUES ('134', 'thinkit-admin', '130', '组织管理', '/org/selectTreeList', 'org:org', 1, 0, 1, 'cluster', 'SystemOrg', 'org', NULL, 5, '2019-11-06 18:38:05', '2020-11-24 22:23:58', '', '1');
INSERT INTO `sys_menu` VALUES ('135', 'thinkit-admin', '130', '基础数据', '/dict/page', 'base:base', 1, 0, 1, 'database', 'Dict', 'dict', NULL, 6, '2018-03-22 16:31:10', '2020-11-24 22:24:24', '', '1');
INSERT INTO `sys_menu` VALUES ('417082887330856961', 'thinkit-cms', '130', '授权证书', '/license/page', 'license:license', 1, 0, 1, 'border-outer', 'License', 'license', NULL, 7, '2020-02-25 22:18:29', '2020-11-24 22:52:24', '1', '1');
INSERT INTO `sys_menu` VALUES ('417083403792285697', 'thinkit-admin', '130', '系统日志', '/log/page', 'log:log', 1, 0, 1, 'snippets', 'SysLog', 'log', NULL, 4, '2020-02-25 22:20:32', '2020-11-24 22:19:22', '1', '1');
INSERT INTO `sys_menu` VALUES ('417083840905871361', 'thinkit-admin', '130', 'SQL监控', '/sqlmonitor/sqlmonitor', 'sql:monitor', 1, 0, 1, 'line-chart', 'SqlMonitor', 'sql', NULL, 9, '2020-02-25 22:22:17', '2020-11-24 22:26:29', '1', '1');
INSERT INTO `sys_menu` VALUES ('470175840504643584', 'thinkit-admin', '131', '添加用户', '/user/save', 'user:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:30:56', '2020-07-21 10:30:56', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470176020423507968', 'thinkit-admin', '131', '编辑用户', '/user/update', 'user:update', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:31:39', '2020-07-21 10:31:39', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470176237189332992', 'thinkit-admin', '131', '删除用户', '/user/delete', 'user:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:32:30', '2020-07-21 10:32:30', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470176446581571584', 'thinkit-admin', '131', '密码重置', '/user/resetPass', 'user:reset:pass', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:33:20', '2020-07-21 10:33:20', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470176806989725696', 'thinkit-admin', '131', '批量删除', '/user/batch', 'user:batch:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:34:46', '2020-07-21 10:34:46', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470177016176443392', 'thinkit-admin', '131', '批量锁定/解锁', '/user/batch', 'user:batch:lock', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:35:36', '2020-07-21 10:35:36', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470178055101349888', 'thinkit-admin', '132', '新建角色', '/role/save', 'role:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:39:44', '2020-07-21 10:39:44', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470178149917786112', 'thinkit-admin', '132', '编辑角色', '/role/update', 'role:update', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:40:06', '2020-07-21 10:40:06', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470178266997587968', 'thinkit-admin', '132', '删除角色', '/role/delete', 'role:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:40:34', '2020-07-21 10:40:34', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470178473751609344', 'thinkit-admin', '132', '分配菜单', '/role/roleMenu/assignMenu', 'role:assign:menu', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:41:24', '2020-07-21 10:41:24', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470178850257502208', 'thinkit-admin', '133', '新增菜单', '/menu/save', 'menu:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:42:53', '2020-07-21 10:42:53', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470178940586033152', 'thinkit-admin', '133', '编辑按钮', '/menu/update', 'menu:update', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:43:15', '2020-07-21 10:43:15', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470179053974847488', 'thinkit-admin', '133', '删除菜单', '/menu/delete', 'menu:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:43:42', '2020-07-21 10:43:42', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470179289577291776', 'thinkit-admin', '133', '隐藏/显示菜单', '/menu/hideIt', 'menu:hide', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 10:44:38', '2020-07-21 10:44:38', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470270429810917376', 'thinkit-admin', '134', '新增组织', '/org/save', 'org:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 16:46:48', '2020-07-21 16:46:48', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470270538674077696', 'thinkit-admin', '134', '编辑组织', '/org/update', 'org:update', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 16:47:14', '2020-07-21 16:47:14', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470270678113714176', 'thinkit-admin', '134', '删除组织', '/org/delete', 'org:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-07-21 16:47:47', '2020-07-21 16:47:47', '1', NULL);
INSERT INTO `sys_menu` VALUES ('470616522981638144', 'thinkit-admin', '130', '代码生成', '/online/page', 'online:page', 1, 0, 1, 'dashboard', 'SysOnline', 'online', NULL, 1, '2020-07-22 15:42:03', '2020-07-22 15:50:05', '1', '1');
INSERT INTO `sys_menu` VALUES ('470640201337667584', NULL, '0', '站点管理', NULL, 'site:site', 0, 0, NULL, 'windows', 'RouteView', 'site/site', 'site', 2, '2020-07-22 17:16:08', '2020-11-21 18:56:37', '1', '1');
INSERT INTO `sys_menu` VALUES ('470640419034628096', 'thinkit-cms', '470640201337667584', '站点管理', '/site/page', 'site:page', 1, 0, 0, 'windows', 'SysSite', 'site', NULL, 1, '2020-07-22 17:17:00', '2020-07-23 15:21:15', '1', '1');
INSERT INTO `sys_menu` VALUES ('470978914013937664', NULL, '0', '模板管理', NULL, 'template:template', 0, 0, NULL, 'container', 'RouteView', 'template', 'template/index', 3, '2020-07-23 15:42:03', '2020-11-24 22:29:07', '1', '1');
INSERT INTO `sys_menu` VALUES ('470979156960608256', 'thinkit-cms', '470978914013937664', '模板管理', '/template/page', 'template:page', 1, 0, 1, 'container', 'SysTemplate', 'index', NULL, 1, '2020-07-23 15:43:01', '2020-11-24 22:29:16', '1', '1');
INSERT INTO `sys_menu` VALUES ('472774427130462208', 'thinkit-cms', '470978914013937664', '模板类型', '/templateType/selectTreeList', 'templateType:page', 1, 0, 1, 'tags', 'TemplateType', 'templateType', NULL, 1, '2020-07-28 14:36:47', '2020-11-24 22:30:01', '1', '1');
INSERT INTO `sys_menu` VALUES ('473513756475785216', 'thinkit-cms', '470640201337667584', '模型管理', '/model/page', 'model:page', 1, 0, 1, 'form', 'SiteModel', '/model', NULL, 1, '2020-07-30 15:34:37', '2020-11-24 22:28:21', '1', '1');
INSERT INTO `sys_menu` VALUES ('476518100485799936', NULL, '0', '栏目管理', NULL, 'category:category', 0, 0, NULL, 'bars', 'RouteView', 'category', 'category', 4, '2020-08-07 22:32:48', '2020-11-24 22:30:20', '1', '1');
INSERT INTO `sys_menu` VALUES ('476518545061052416', 'thinkit-cms', '476518100485799936', '栏目管理', '/category/page', 'category:page', 1, 0, 1, 'bars', 'Category', 'category', NULL, 1, '2020-08-07 22:34:34', '2020-11-24 22:30:34', '1', '1');
INSERT INTO `sys_menu` VALUES ('476888860551282688', 'thinkit-cms', '476518100485799936', '栏目模型', '/categoryModel/page', 'category:model', 1, 0, 0, 'border', 'CategoryModel', 'model', NULL, 1, '2020-08-08 23:06:05', '2020-11-24 22:30:47', '1', '1');
INSERT INTO `sys_menu` VALUES ('479332101695471616', NULL, '0', '内容管理', NULL, 'content:content', 0, 0, NULL, 'profile', 'RouteView', '/content/manager', '/content/index', 5, '2020-08-15 16:54:39', '2020-11-24 22:31:14', '1', '1');
INSERT INTO `sys_menu` VALUES ('479332936366161920', 'thinkit-cms', '479332101695471616', '内容管理', '/content/page', 'content:page', 1, 0, 1, 'profile', 'SysContent', 'content', NULL, 1, '2020-08-15 16:57:58', '2020-11-24 22:31:27', '1', '1');
INSERT INTO `sys_menu` VALUES ('491994857498214400', NULL, '0', '资源管理', NULL, 'resource:resource', 0, 0, NULL, 'cloud-upload', 'RouteView', '/resource', 'siteResource', 7, '2020-09-19 15:31:55', '2020-11-24 22:35:05', '1', '1');
INSERT INTO `sys_menu` VALUES ('491995254396813312', 'thinkit-cms', '491994857498214400', '站点文件', '/resource/site/page', 'resource:site', 1, 0, 1, 'folder-add', 'SysResource', 'siteResource', NULL, 1, '2020-09-19 15:33:29', '2020-11-24 22:35:47', '1', '1');
INSERT INTO `sys_menu` VALUES ('491995763174277120', 'thinkit-cms', '491994857498214400', '上传资源', '/resource/upfile', 'resource:upload', 1, 0, 1, 'cloud-upload', 'UploadResource', 'uploadResource', NULL, 1, '2020-09-19 15:35:31', '2020-11-24 22:35:16', '1', '1');
INSERT INTO `sys_menu` VALUES ('498896187085029376', 'thinkit-cms', '479332101695471616', '回收站', '/content/recycler', 'recycler:recycler', 1, 0, 1, 'rest', 'Recycler', 'recycler', NULL, 1, '2020-10-08 16:35:20', '2020-11-24 22:32:03', '492434381399392256', '1');
INSERT INTO `sys_menu` VALUES ('499349406085021696', NULL, '0', '账号管理', NULL, 'setting', 0, 0, NULL, 'safety-certificate', 'RouteView', '/account/settings', 'base', 6, '2020-10-09 22:36:16', '2020-11-24 22:34:04', '492434381399392256', '1');
INSERT INTO `sys_menu` VALUES ('499349821891543040', 'thinkit-admin', '499349406085021696', '密码设置', '/category/page', 'setting:base', 1, 0, 0, 'security-scan', 'SysBaseInfo', 'base', NULL, 1, '2020-10-09 22:37:55', '2020-11-24 22:33:21', '492434381399392256', '1');
INSERT INTO `sys_menu` VALUES ('499357341532028928', 'thinkit-admin', '499349406085021696', '个人设置', '/category/page', 'user:user', 1, 0, 1, 'tool', 'BaseSettings', 'BaseSetting', NULL, 1, '2020-10-09 23:07:48', '2020-11-24 22:34:47', '492434381399392256', '1');
INSERT INTO `sys_menu` VALUES ('507504151639359488', NULL, '0', '流量统计', NULL, 'analysis', 0, 0, NULL, 'fund', 'RouteView', 'analysis', '', 8, '2020-11-01 10:40:19', '2020-11-25 21:19:57', '1', '1');
INSERT INTO `sys_menu` VALUES ('507504327745601536', 'thinkit-admin', '507504151639359488', '流量管理', '/analysis/page', 'analysis:index', 1, 0, 1, 'fund', 'Analysis', 'analysis/index', NULL, 1, '2020-11-01 10:41:01', '2020-11-25 22:07:30', '1', '1');
INSERT INTO `sys_menu` VALUES ('508415214991966208', 'thinkit-admin', '130', '终端管理', '/clients/page', 'clients:clients', 1, 0, 1, 'android', 'SysClient', 'clients', NULL, 1, '2020-11-03 23:00:33', '2020-11-24 22:22:33', '1', '1');
INSERT INTO `sys_menu` VALUES ('512764555508580352', 'thinkit-admin', '130', '接口管理', '/apiSource/selectTreeList', 'api:api', 1, 0, 1, 'api', 'ApiManager', 'api', NULL, 1, '2020-11-15 23:03:17', '2020-11-24 22:23:12', '1', '1');
INSERT INTO `sys_menu` VALUES ('514891279771893760', 'thinkit-cms', '473513756475785216', '创建模型', '/model/save', 'model:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 19:54:07', '2020-11-21 19:54:07', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514891453323804672', 'thinkit-cms', '473513756475785216', '编辑模型', '/model/update', 'model:edit', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 19:54:49', '2020-11-21 20:11:28', '1', '1');
INSERT INTO `sys_menu` VALUES ('514891597070991360', 'thinkit-cms', '473513756475785216', '删除模型', '/model/delete', 'model:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 19:55:23', '2020-11-21 20:11:04', '1', '1');
INSERT INTO `sys_menu` VALUES ('514899284722712576', 'thinkit-cms', '470640419034628096', '创建站点', '/site/save', 'site:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:25:56', '2020-11-21 20:25:56', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514899447637868544', 'thinkit-cms', '470640419034628096', '编辑站点', '/site/update', 'site:edit', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:26:35', '2020-11-21 20:26:35', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514899715070885888', 'thinkit-cms', '470640419034628096', '删除站点', '/site/deleteByPk', 'site:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:27:38', '2020-11-21 20:27:38', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514899985943232512', 'thinkit-cms', '470640419034628096', '选择模板', '/templateType/getTempByPidTypes', 'site:chose:temp', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:28:43', '2020-11-21 20:28:43', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514901057562738688', 'thinkit-cms', '472774427130462208', '创建类型', '/templateType/save', 'temp:typesave', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:32:59', '2020-11-21 20:33:55', '1', '1');
INSERT INTO `sys_menu` VALUES ('514901261141671936', 'thinkit-cms', '472774427130462208', '编辑类型', '/templateType/update', 'temp:typeedit', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:33:47', '2020-11-21 20:33:47', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514901476972167168', 'thinkit-cms', '472774427130462208', '删除类型', '/templateType/deleteByPk', 'temp:typedel', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:34:39', '2020-11-21 20:34:39', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514902432564641792', 'thinkit-cms', '470979156960608256', '新建模板', '/template/save', 'temp:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:38:26', '2020-11-21 20:38:26', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514902580950728704', 'thinkit-cms', '470979156960608256', '编辑模板', '/template/update', 'temp:edit', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:39:02', '2020-11-21 20:39:02', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514902991015247872', 'thinkit-cms', '470979156960608256', '删除模板', '/template/deleteByPk', 'temp:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:40:39', '2020-11-21 20:40:39', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514903254853746688', 'thinkit-cms', '470979156960608256', '设计模板', '/template/loadTemplateTree', 'temp:design', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:41:42', '2020-11-21 20:41:42', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514903466913562624', 'thinkit-cms', '470979156960608256', '导入模板', '/template/uploadFile', 'temp:import', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:42:33', '2020-11-21 20:42:33', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514904846386593792', 'thinkit-cms', '476888860551282688', '创建栏目模型', '/categoryModel/save', 'category:savemodel', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:48:02', '2020-11-21 20:48:02', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514905080441339904', 'thinkit-cms', '476888860551282688', '删除栏目模型', '/categoryModel/deleteByPk', 'category:delmodel', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:48:58', '2020-11-21 20:48:58', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514905296015982592', 'thinkit-cms', '476888860551282688', '编辑栏目模型', '/categoryModel/update', 'category:editmodel', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:49:49', '2020-11-21 20:49:49', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514907816855601152', 'thinkit-cms', '476518545061052416', '创建栏目', '/category/save', 'category:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 20:59:50', '2020-11-21 20:59:50', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514907938779824128', 'thinkit-cms', '476518545061052416', '编辑栏目', '/category/update', 'category:edit', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 21:00:19', '2020-11-21 21:00:19', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514908228165828608', 'thinkit-cms', '476518545061052416', '删除栏目', '/category/deleteByPk', 'category:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 21:01:28', '2020-11-21 21:01:28', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514908346327760896', 'thinkit-cms', '476518545061052416', '静态化', '/category/genCategory', 'category:static', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 21:01:56', '2020-11-21 21:01:56', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514910546961629184', 'thinkit-admin', '135', '创建按钮', '/dict/save', 'dict:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 21:10:41', '2020-11-21 21:10:41', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514910700544458752', 'thinkit-admin', '135', '编辑按钮', '/dict/update', 'dict:edit', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 21:11:18', '2020-11-21 21:11:18', '1', NULL);
INSERT INTO `sys_menu` VALUES ('514910965356036096', 'thinkit-admin', '135', '删除按钮', '/dict/delByPk', 'dict:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-21 21:12:21', '2020-11-21 21:13:29', '1', '1');
INSERT INTO `sys_menu` VALUES ('515095651067887616', 'thinkit-cms', '479332936366161920', '创建内容', '/content/save', 'content:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:26:13', '2020-11-22 09:26:13', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515095821952221184', 'thinkit-cms', '479332936366161920', '编辑内容', '/content/update', 'content:edit', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:26:54', '2020-11-22 09:26:54', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515096300694274048', 'thinkit-cms', '479332936366161920', '删除内容', '/content/deleteByPk', 'content:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:28:48', '2020-11-22 09:28:48', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515096456751742976', 'thinkit-cms', '479332936366161920', '批量删除', '/content/deleteByIds', 'content:dels', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:29:25', '2020-11-22 09:29:25', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515096685945290752', 'thinkit-cms', '479332936366161920', '置顶按钮', '/content/top', 'content:top', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:30:20', '2020-11-22 09:30:20', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515096933916737536', 'thinkit-cms', '479332936366161920', '相关推荐', '/contentRelated/saveRelatedBath', 'content:related', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:31:19', '2020-11-22 09:31:19', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515097177077317632', 'thinkit-cms', '479332936366161920', '删除推荐', '/contentRelated/deleteRelated', 'content:relateddel', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:32:17', '2020-11-22 09:32:17', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515097653927739392', 'thinkit-cms', '479332936366161920', '预览按钮', '/content/viewContent', 'content:view', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:34:11', '2020-11-22 09:39:33', '1', '1');
INSERT INTO `sys_menu` VALUES ('515097974859104256', 'thinkit-cms', '479332936366161920', '批量发布/撤销', '/content/publish', 'content:publish', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 09:35:27', '2020-11-22 09:35:27', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515104688035594240', 'thinkit-cms', '479332936366161920', '批量移动', '/content/move', 'content:move', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:02:08', '2020-11-22 10:02:08', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515104861327458304', 'thinkit-cms', '479332936366161920', '批量生成', '/content/reStaticBatchGenCid', 'content:batchgen', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:02:49', '2020-11-22 10:02:49', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515105177024331776', 'thinkit-cms', '479332936366161920', '定时发布', '/job/jobPublish', 'content:jobpub', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:04:04', '2020-11-22 10:04:04', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515105564808708096', 'thinkit-cms', '498896187085029376', '彻底删除', '/content/delRealByPks', 'content:realdel', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:05:37', '2020-11-22 10:05:37', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515106332345368576', 'thinkit-cms', '498896187085029376', '还原内容', '/content/recyclerByPks', 'content:backdel', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:08:40', '2020-11-22 10:08:40', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515115687727857664', 'thinkit-cms', '491995763174277120', '删除资源', '/upload/deleteFile', 'resource:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:45:50', '2020-11-22 10:46:24', '1', '1');
INSERT INTO `sys_menu` VALUES ('515116630905192448', 'thinkit-cms', '491995254396813312', '创建目录', '/webstatic/mkdirFolder', 'mkdir:folder', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:49:35', '2020-11-22 10:49:35', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515116984979947520', 'thinkit-cms', '491995254396813312', '删除目录/文件', '/webstatic/deleteFile', 'folder:delete', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:51:00', '2020-11-22 10:51:00', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515117206418227200', 'thinkit-cms', '491995254396813312', '压缩下载', '/webstatic/downZip', 'folder:down', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:51:52', '2020-11-22 10:51:52', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515117385317875712', 'thinkit-cms', '491995254396813312', '文件上传', '/webstatic/uploadFile', 'folder:upload', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 10:52:35', '2020-11-22 10:52:35', '1', NULL);
INSERT INTO `sys_menu` VALUES ('515183680654671872', 'thinkit-cms', '470979156960608256', '导出模板', '/template/exportit', 'temp:export', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-22 15:16:01', '2020-11-22 15:16:01', '469290977866022912', NULL);
INSERT INTO `sys_menu` VALUES ('516374689296154624', 'thinkit-admin', '507504151639359488', '流量查看', '/analysis/view', 'analysis:view', 1, 1, 0, 'apple', 'AnalysisView', 'view', NULL, 1, '2020-11-25 22:08:40', '2020-11-25 22:16:30', '1', '1');
INSERT INTO `sys_menu` VALUES ('516378995583877120', 'thinkit-admin', '507504327745601536', '新增流量平台', '/analysis/save', 'analysis:save', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-25 22:25:46', '2020-11-25 22:25:46', '1', NULL);
INSERT INTO `sys_menu` VALUES ('516379113766780928', 'thinkit-admin', '507504327745601536', '编辑流量平台', '/analysis/update', 'analysis:update', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-25 22:26:15', '2020-11-25 22:26:15', '1', NULL);
INSERT INTO `sys_menu` VALUES ('516379302523043840', 'thinkit-admin', '507504327745601536', '删除流量平台', '/analysis/deleteByPk', 'analysis:del', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-25 22:27:00', '2020-11-25 22:27:00', '1', NULL);
INSERT INTO `sys_menu` VALUES ('516379496731901952', 'thinkit-admin', '507504327745601536', '分析统计', '/analysis/view', 'analysis:view:page', 2, 0, NULL, NULL, NULL, NULL, NULL, 1, '2020-11-25 22:27:46', '2021-07-11 23:30:42', '1', '1');
INSERT INTO `sys_menu` VALUES ('585961646871019520', NULL, '130', '控制管台', '/analysis/view', 'dashboard:analysis', 1, 0, 1, 'android', 'DashAnalysis', '/dashboard', NULL, 1, '2021-06-05 22:42:23', '2021-06-06 21:39:55', '1', '1');
INSERT INTO `sys_menu` VALUES ('596152750870364160', NULL, '491994857498214400', '素材中心', '/resource/listGroupPage', 'uploadMedia:uploadMedia', 1, 0, 1, 'cloud-upload', 'UploadMedia', 'uploadMedia', NULL, 1, '2021-07-04 01:38:12', '2021-07-04 01:38:21', '1', '1');

-- ----------------------------
-- Table structure for sys_oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `sys_oauth_client_details`;
CREATE TABLE `sys_oauth_client_details`  (
  `client_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `resource_ids` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `client_secret` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `scope` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `authorized_grant_types` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `web_server_redirect_uri` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `authorities` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `access_token_validity` int(11) NULL DEFAULT NULL,
  `refresh_token_validity` int(11) NULL DEFAULT NULL,
  `additional_information` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `autoapprove` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`client_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '终端信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_oauth_client_details
-- ----------------------------
INSERT INTO `sys_oauth_client_details` VALUES ('mem_user', NULL, '$2a$10$S820Y0XH1xAa38Te2BN9g.MQNXL1UIo.34mWqqVto4pa3DLDjdHDe', 'server', 'password,refresh_token', NULL, NULL, -1, NULL, NULL, 'true');
INSERT INTO `sys_oauth_client_details` VALUES ('plat_user', NULL, '$2a$10$gxZwnxkkPvdoG.DF2kw3YOEG0zkoaJs0eiMZM/IcXoVQTf1o60DJq', 'server', 'password,refresh_token', NULL, NULL, 864000, NULL, NULL, 'true');

-- ----------------------------
-- Table structure for sys_online
-- ----------------------------
DROP TABLE IF EXISTS `sys_online`;
CREATE TABLE `sys_online`  (
  `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `base_pack` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'com.thinkit' COMMENT '基础 package',
  `controller_pack` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'controller' COMMENT 'controller',
  `service_pack` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'service' COMMENT 'service',
  `service_impl_pack` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'service.impl' COMMENT 'service.impl',
  `mapper_pack` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'mapper',
  `entity_pack` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'entity',
  `table_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `table_note` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `engine` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `model_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `prefix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否去除前缀',
  `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者名称',
  `file_override` int(11) NULL DEFAULT 0 COMMENT '是否覆盖现有文件：0/不覆盖 1：覆盖',
  `open` int(11) NULL DEFAULT 0 COMMENT '是否打开输出目录0：打开 1：不打开',
  `resultmap` int(11) NULL DEFAULT 0 COMMENT '是否开启 BaseResultMap 0：是 1：否',
  `column_list` int(11) NULL DEFAULT 0 COMMENT '0:开启 1：不开启',
  `enable_cache` int(11) NULL DEFAULT 0 COMMENT '是否开启二级缓存 0:是 1：否',
  `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'D' COMMENT '生成的代码位置：默认d盘',
  `create_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `super_controller_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'com.thinkit.core.base.BaseController' COMMENT '实体集成类',
  `super_service_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'com.thinkit.core.base.BaseService' COMMENT '实体集成类',
  `super_service_impl_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'com.thinkit.core.base.BaseServiceImpl' COMMENT '实体集成类',
  `super_entity_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'com.thinkit.utils.model.BaseModel' COMMENT '实体集成类',
  `super_mapper_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'com.baomidou.mybatisplus.core.mapper.BaseMapper' COMMENT 'com.baomidou.mybatisplus.core.mapper.BaseMapper',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_online
-- ----------------------------
INSERT INTO `sys_online` VALUES ('472768814174437376', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_template_type', '模板分类', 'InnoDB', 'templateType', NULL, 'lg', 0, 0, 0, 0, 0, 'E:AutoCodeLg', '1', '1', '2020-07-28 14:14:29', '2020-07-28 14:16:00', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('473481493574844416', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_model_category', '模型-分类', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', '1', NULL, '2020-07-30 13:26:25', '2020-07-30 13:26:25', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('474506706940854272', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_fragment_model', '页面片段文件模型', 'InnoDB', 'fragmentModel', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-08-02 09:20:15', '2020-08-02 09:22:10', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('474946020657070080', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_member_attr', '', 'InnoDB', 'fragmentAttr', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-08-03 14:25:55', '2020-08-03 14:27:00', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('474946293337161728', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_fragment_attr', '页面片段数据表', 'InnoDB', 'fragmentAttr', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-08-03 14:27:00', '2020-08-03 14:28:51', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('476886263148838912', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_category_model', '分类扩展模型', 'InnoDB', 'categoryModel', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-08-08 22:55:45', '2020-08-08 22:56:17', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('477515606812262400', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_category_model_relation', '分类选择模型时关系表 该模型值 tk_model 表 不是 分类模型表', 'InnoDB', 'categoryModelRelation', NULL, 'LG', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-08-10 16:36:32', '2020-08-10 17:00:39', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('479319829149384704', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_content_attr', '内容扩展', 'InnoDB', 'contentAttr', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-08-15 16:05:53', '2020-08-15 16:19:59', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('480851908995579904', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_content_attach', '内容附件', 'InnoDB', 'contentAttach', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-08-19 21:33:49', '2020-08-19 21:34:19', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('492261951766790144', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_user_site_setting', '用户站点设置表', 'InnoDB', 'userSiteSetting', NULL, 'LG', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-09-20 09:13:15', '2020-09-20 09:14:58', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('507487950393573376', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_content2', '内容', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'D', '1', NULL, '2020-11-01 09:35:56', '2020-11-01 09:35:56', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('510162497878097920', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_api_source', '接口资源', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'D', '1', NULL, '2020-11-08 18:43:38', '2020-11-08 18:43:38', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('510162497936818176', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_api_source_client', '接口资源分配表', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'D', '1', NULL, '2020-11-08 18:43:38', '2020-11-08 18:43:38', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('516359047163674624', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_analysis', '流量统计配置', 'InnoDB', 'analysis', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', '1', '1', '2020-11-25 21:06:30', '2020-11-25 21:07:08', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('585972143305523200', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_strategy', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'D', '1', NULL, '2021-06-05 23:24:06', '2021-06-05 23:24:06', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('597909200806346752', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_file_group', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'D', '1', NULL, '2021-07-08 21:57:42', '2021-07-08 21:57:42', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fb9542cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_blob_triggers', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fba922cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_calendars', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbaac4cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_cron_triggers', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbab8ecbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_fired_triggers', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbac58cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_job_details', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbacfacbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_locks', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbad98cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_paused_trigger_grps', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbae2ccbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_scheduler_state', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbaed6cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_simple_triggers', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbaf5ccbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_simprop_triggers', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbafe3cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'qrtz_triggers', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:06', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb06acbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_dict', '字典表', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:56', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb0f4cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_job', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:56', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb194cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_log', '系统日志', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-21 13:56:19', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb229cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_menu', '菜单管理', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-15 16:05:53', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb2a8cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_oauth_client_details', '终端信息表', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:57', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb332cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_org', '组织架构表', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:57', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb3c8cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_resource', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:57', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb458cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_role', '角色', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:57', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb4d7cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_role_menu', '角色与菜单对应关系', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:57', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb560cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_user', '用户表', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-10 17:05:08', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb5f2cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'sys_user_role', '用户与角色对应关系', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-06-23 16:41:57', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb674cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_category', '分类', 'InnoDB', 'category', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', NULL, '1', '2020-07-09 14:29:53', '2020-08-07 22:21:28', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb6f1cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_category_attr', '分类扩展', 'InnoDB', 'categoryAttr', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', NULL, '1', '2020-06-30 11:21:12', '2020-08-10 16:37:03', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb76fcbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_category_extensible', '分类扩展', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:28:21', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb7f2cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_category_template', '分类-模板配置表', 'InnoDB', 'categoryTemplate', NULL, 'LG', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', NULL, '1', '2020-07-06 16:07:50', '2020-08-12 16:10:37', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbb877cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_content', '内容', 'InnoDB', 'content', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', NULL, '1', '2020-07-09 14:24:25', '2020-08-15 16:06:16', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbaa8cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_content_attribute', '内容扩展', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 15:01:20', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbb82cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_content_file', '内容附件', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:44:58', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbc0bcbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_content_related', '内容推荐', 'InnoDB', 'contentRelated', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', NULL, '492434381399392256', '2020-07-09 14:34:10', '2020-09-30 22:54:17', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbc8dcbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_fragment', '页面片段数据表', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:53:23', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbd1dcbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_fragment_attribute', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:49:44', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbda1cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_fragment_file_model', '页面片段文件模型', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:49:44', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbe27cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_member', '', 'InnoDB', 'member', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', NULL, '1', '2020-07-08 10:47:58', '2020-11-03 21:29:21', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbeb2cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_model', '', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:12:19', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbbf3ecbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_model_template', '模型模板针对不同的站点不同的模型下有不同的 模板页面', 'InnoDB', 'modelTemplate', NULL, 'lg', 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, '1', '2020-07-09 14:09:15', '2020-08-01 15:43:37', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbc341cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_org_site_category', '部门-站点-分类 用于数据权限控制', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:40:36', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbc42fcbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_share_model', '模型分享库', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:10:55', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbc4b9cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_site', '站点管理表', 'InnoDB', 'site', NULL, 'LG', 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, '1', '2020-06-30 09:52:32', '2020-07-22 16:59:52', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbc540cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_site_template', '站点模型表', 'InnoDB', 'siteTemplate', NULL, 'lg', 1, 1, 0, 0, 0, 'E:AutoCodeLg', NULL, '1', '2020-06-28 11:21:04', '2020-08-01 09:34:35', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbc5c0cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_tag', '标签', 'InnoDB', 'tag', NULL, 'lg', 0, 0, 0, 0, 0, 'E:\\AutoCodeLg', NULL, '1', '2020-07-09 14:46:55', '2020-08-20 13:56:30', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbc642cbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_tag_type', '标签类型', 'InnoDB', NULL, NULL, NULL, 0, 0, 0, 0, 0, 'E:AutoCodeLg', NULL, NULL, '2020-07-09 14:46:55', NULL, 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');
INSERT INTO `sys_online` VALUES ('61fbc6cecbf211eab8e280fa5b22a4ff', 'com.thinkit', 'controller', 'service', 'service.impl', 'mapper', 'entity', 'tk_template', '模板表', 'InnoDB', 'template', NULL, 'lg', 0, 1, 0, 0, 0, 'E:AutoCodeLg', NULL, '1', '2020-06-29 15:28:26', '2020-07-23 15:28:06', 'com.thinkit.core.base.BaseController', 'com.thinkit.core.base.BaseService', 'com.thinkit.core.base.BaseServiceImpl', 'com.thinkit.utils.model.BaseModel', 'com.baomidou.mybatisplus.core.mapper.BaseMapper');

-- ----------------------------
-- Table structure for sys_org
-- ----------------------------
DROP TABLE IF EXISTS `sys_org`;
CREATE TABLE `sys_org`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门ID',
  `org_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `org_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门编码',
  `parent_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父级部门ID',
  `parent_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父级部门编码',
  `comment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '0:集团 1：公司 2：部门',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `Index_1`(`org_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组织架构表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_org
-- ----------------------------
INSERT INTO `sys_org` VALUES ('334719919587328000', 'ThinkItCMS', 'MANAGER', '0', 'QO', NULL, '1', '', '1', '2019-11-07 17:05:51', '2021-07-14 21:28:17');
INSERT INTO `sys_org` VALUES ('334720090958200832', '管理部', 'MANAGER1', '334719919587328000', 'GB', '', '1', '', '1', '2019-11-07 09:04:51', '2020-07-18 23:51:17');
INSERT INTO `sys_org` VALUES ('334720172759711744', '超级管理部', 'SUPER_ADMIN', '334719919587328000', 'GB', '', '2', '', '1', '2019-11-07 09:04:53', '2020-02-09 13:55:32');

-- ----------------------------
-- Table structure for sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE `sys_resource`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `file_uid` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件唯一标识',
  `file_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `file_md5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `file_size` bigint(20) NULL DEFAULT NULL COMMENT '文件大小kb',
  `file_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件类型',
  `file_path` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '相对地址',
  `file_full_path` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全地址',
  `site_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `file_group_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `group_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组',
  `create_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人Id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_resource
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `role_sign` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色标识',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1', '超级用户角色', 'administrator', '拥有最高权限11', '', '1', '2018-03-21 10:30:58', '2020-07-21 15:16:04');
INSERT INTO `sys_role` VALUES ('420227014310494209', '演示角色', 'demo_sign', '演示角色.11我抢抢', '1', '1', '2020-03-05 14:32:08', '2020-07-21 16:45:18');
INSERT INTO `sys_role` VALUES ('90', '系统管理员', 'manager', '管理系统所有的功能', '1', '1', '2018-08-02 16:41:08', '2021-06-06 21:38:51');

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色ID',
  `menu_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单ID',
  `half_checked` int(2) NULL DEFAULT 0 COMMENT '0：半选中 1：全选中',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人Id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与菜单对应关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('515108343392501760', '420227014310494209', '479332936366161920', 0, '1', NULL, '2020-11-22 10:16:39', NULL);
INSERT INTO `sys_role_menu` VALUES ('515108343392501761', '420227014310494209', '479332101695471616', 0, '1', NULL, '2020-11-22 10:16:39', NULL);
INSERT INTO `sys_role_menu` VALUES ('515108343392501762', '420227014310494209', '515096933916737536', 1, '1', NULL, '2020-11-22 10:16:39', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686528', '90', '133', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686529', '90', '470178850257502208', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686530', '90', '470178940586033152', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686531', '90', '470179053974847488', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686532', '90', '470179289577291776', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686533', '90', '130', 0, '1', '1', '2020-11-25 22:31:30', '2021-06-05 22:42:23');
INSERT INTO `sys_role_menu` VALUES ('516380435601686534', '90', '131', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686535', '90', '470175840504643584', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686536', '90', '470176020423507968', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686537', '90', '470176237189332992', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686538', '90', '470176446581571584', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686539', '90', '470176806989725696', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686540', '90', '470177016176443392', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686541', '90', '132', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686542', '90', '470178055101349888', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686543', '90', '470178149917786112', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686544', '90', '470178266997587968', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686545', '90', '470178473751609344', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686546', '90', '134', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686547', '90', '470270429810917376', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686548', '90', '470270538674077696', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686549', '90', '470270678113714176', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686550', '90', '135', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686551', '90', '514910546961629184', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686552', '90', '514910700544458752', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686553', '90', '514910965356036096', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686554', '90', '417082887330856961', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686555', '90', '417083403792285697', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686556', '90', '417083840905871361', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686557', '90', '470616522981638144', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686558', '90', '508415214991966208', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686559', '90', '512764555508580352', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686560', '90', '491995763174277120', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686561', '90', '515115687727857664', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686562', '90', '491994857498214400', 0, '1', '1', '2020-11-25 22:31:30', '2021-07-04 01:38:12');
INSERT INTO `sys_role_menu` VALUES ('516380435601686563', '90', '491995254396813312', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686564', '90', '515116630905192448', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686565', '90', '515116984979947520', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686566', '90', '515117206418227200', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686567', '90', '515117385317875712', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686568', '90', '499349406085021696', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686569', '90', '499349821891543040', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686570', '90', '499357341532028928', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686571', '90', '514891453323804672', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686572', '90', '473513756475785216', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686573', '90', '470640201337667584', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686574', '90', '514891279771893760', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686575', '90', '514891597070991360', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686576', '90', '470640419034628096', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686577', '90', '514899284722712576', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686578', '90', '514899447637868544', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686579', '90', '514899715070885888', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686580', '90', '514899985943232512', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686581', '90', '472774427130462208', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686582', '90', '514901057562738688', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686583', '90', '514901261141671936', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686584', '90', '514901476972167168', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686585', '90', '470978914013937664', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686586', '90', '514902432564641792', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686587', '90', '470979156960608256', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686588', '90', '514902580950728704', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686589', '90', '514902991015247872', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686590', '90', '514903254853746688', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686591', '90', '514903466913562624', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686592', '90', '514904846386593792', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435601686593', '90', '476888860551282688', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880832', '90', '476518100485799936', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880833', '90', '514905080441339904', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880834', '90', '514905296015982592', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880835', '90', '476518545061052416', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880836', '90', '514907816855601152', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880837', '90', '514907938779824128', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880838', '90', '514908228165828608', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880839', '90', '514908346327760896', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880840', '90', '515095651067887616', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880841', '90', '479332936366161920', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880842', '90', '479332101695471616', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880843', '90', '515095821952221184', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880844', '90', '515096300694274048', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880845', '90', '515096456751742976', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880846', '90', '515096685945290752', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880847', '90', '515096933916737536', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880848', '90', '515097177077317632', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880849', '90', '515097653927739392', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880850', '90', '515097974859104256', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880851', '90', '515104688035594240', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880852', '90', '515104861327458304', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880853', '90', '515105177024331776', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880854', '90', '498896187085029376', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880855', '90', '515105564808708096', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880856', '90', '515106332345368576', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880857', '90', '515183680654671872', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880858', '90', '507504151639359488', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880859', '90', '507504327745601536', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880860', '90', '516378995583877120', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880861', '90', '516379113766780928', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880862', '90', '516379302523043840', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880863', '90', '516379496731901952', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('516380435605880864', '90', '516374689296154624', 1, '1', NULL, '2020-11-25 22:31:30', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233088', '1', '131', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233089', '1', '470175840504643584', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233090', '1', '470176020423507968', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233091', '1', '470176237189332992', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233092', '1', '470176446581571584', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233093', '1', '470176806989725696', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233094', '1', '470177016176443392', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233095', '1', '130', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233096', '1', '132', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233097', '1', '470178055101349888', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233098', '1', '470178149917786112', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233099', '1', '470178266997587968', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233100', '1', '470178473751609344', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233101', '1', '133', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233102', '1', '470178850257502208', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233103', '1', '470178940586033152', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233104', '1', '470179053974847488', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233105', '1', '470179289577291776', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233106', '1', '134', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233107', '1', '470270429810917376', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233108', '1', '470270538674077696', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233109', '1', '470270678113714176', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233110', '1', '135', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233111', '1', '514910546961629184', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233112', '1', '514910700544458752', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233113', '1', '514910965356036096', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233114', '1', '417082887330856961', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233115', '1', '417083403792285697', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233116', '1', '417083840905871361', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233117', '1', '470616522981638144', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233118', '1', '508415214991966208', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233119', '1', '512764555508580352', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233120', '1', '585961646871019520', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233121', '1', '491995763174277120', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233122', '1', '515115687727857664', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233123', '1', '491994857498214400', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233124', '1', '491995254396813312', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233125', '1', '515116630905192448', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233126', '1', '515116984979947520', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233127', '1', '515117206418227200', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233128', '1', '515117385317875712', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233129', '1', '596152750870364160', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233130', '1', '499349406085021696', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233131', '1', '499349821891543040', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233132', '1', '499357341532028928', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233133', '1', '470640201337667584', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233134', '1', '470640419034628096', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233135', '1', '514899284722712576', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233136', '1', '514899447637868544', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233137', '1', '514899715070885888', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233138', '1', '514899985943232512', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233139', '1', '473513756475785216', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233140', '1', '514891279771893760', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233141', '1', '514891453323804672', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233142', '1', '514891597070991360', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233143', '1', '514902432564641792', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233144', '1', '470979156960608256', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233145', '1', '470978914013937664', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233146', '1', '514902580950728704', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233147', '1', '514902991015247872', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233148', '1', '514903254853746688', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233149', '1', '514903466913562624', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233150', '1', '515183680654671872', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233151', '1', '472774427130462208', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233152', '1', '514901057562738688', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233153', '1', '514901261141671936', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233154', '1', '514901476972167168', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233155', '1', '476518100485799936', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233156', '1', '476518545061052416', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233157', '1', '514907816855601152', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233158', '1', '514907938779824128', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233159', '1', '514908228165828608', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233160', '1', '514908346327760896', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233161', '1', '476888860551282688', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233162', '1', '514904846386593792', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233163', '1', '514905080441339904', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233164', '1', '514905296015982592', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233165', '1', '479332101695471616', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233166', '1', '479332936366161920', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233167', '1', '515095651067887616', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233168', '1', '515095821952221184', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233169', '1', '515096300694274048', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233170', '1', '515096456751742976', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233171', '1', '515096685945290752', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233172', '1', '515096933916737536', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233173', '1', '515097177077317632', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233174', '1', '515097653927739392', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233175', '1', '515097974859104256', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233176', '1', '515104688035594240', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233177', '1', '515104861327458304', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233178', '1', '515105177024331776', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233179', '1', '498896187085029376', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233180', '1', '515105564808708096', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233181', '1', '515106332345368576', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233182', '1', '516379113766780928', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233183', '1', '516379302523043840', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233184', '1', '516374689296154624', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233185', '1', '516379496731901952', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233186', '1', '516378995583877120', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233187', '1', '507504327745601536', 1, '1', NULL, '2021-07-11 23:31:22', NULL);
INSERT INTO `sys_role_menu` VALUES ('599019936534233188', '1', '507504151639359488', 1, '1', NULL, '2021-07-11 23:31:22', NULL);

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `user_account` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账户名',
  `org_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '组织id',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态 0:正常，1:禁用',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  `sex` tinyint(1) NULL DEFAULT 0 COMMENT '0:男 1：女',
  `out_date` bigint(20) NULL DEFAULT NULL COMMENT '有效时间',
  `secret_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密令',
  `org_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '组织代码',
  `org_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '组织名',
  `psd_init_date` date NULL DEFAULT NULL COMMENT '密码初始时间(用于设置90天密码修改提醒)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'admin', '334720172759711744', '超级管理员', '$2a$10$vKd21d99JcVNy.KLu90tQOHIN8anE3IVjxvSgkAL.Pi9reTviZwr6', '783728@qq.com', '13005154154', '0', '1', '1', '2020-07-17 15:34:27', '2021-07-14 20:58:04', 2, NULL, NULL, 'SUPER_ADMIN', '超级管理部', NULL);
INSERT INTO `sys_user` VALUES ('469290977866022912', 'manager', '334720090958200832', '管理员', '$2a$10$vKd21d99JcVNy.KLu90tQOHIN8anE3IVjxvSgkAL.Pi9reTviZwr6', '826319429@qq.com', '15665297396', '0', '1', '1', '2020-07-18 23:54:48', '2021-08-01 17:55:21', 1, NULL, NULL, 'MANAGER1', '管理部', NULL);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户ID',
  `role_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色ID',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与角色对应关系' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('113', '131', '48', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('120', '134', '1', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('121', '134', '48', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('123', '130', '1', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('125', '132', '52', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('126', '132', '49', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('468802672292528128', '468802671592079360', '1', '1', NULL, '2020-07-17 15:34:27', NULL);
INSERT INTO `sys_user_role` VALUES ('470023166836604928', '1', '1', '1', NULL, '2020-07-21 00:24:16', NULL);
INSERT INTO `sys_user_role` VALUES ('606545520285974528', '469290977866022912', '1', '1', NULL, '2021-08-01 17:55:21', NULL);
INSERT INTO `sys_user_role` VALUES ('75', '30', '50', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('76', '31', '48', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('77', '31', '49', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('78', '31', '52', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('79', '32', '48', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('80', '32', '49', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('81', '32', '50', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('82', '32', '51', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('83', '32', '52', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('84', '33', '38', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('85', '33', '49', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('86', '33', '52', '', NULL, '2019-12-19 16:32:56', NULL);
INSERT INTO `sys_user_role` VALUES ('97', '36', '48', '', NULL, '2019-12-19 16:32:56', NULL);

-- ----------------------------
-- Table structure for tk_analysis
-- ----------------------------
DROP TABLE IF EXISTS `tk_analysis`;
CREATE TABLE `tk_analysis`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `analysis_plat` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '统计平台',
  `pc_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'pc端地址',
  `mobile_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机端地址',
  `is_default` tinyint(4) NULL DEFAULT 0 COMMENT '0:非默认 1：默认',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_analysis
-- ----------------------------
INSERT INTO `tk_analysis` VALUES ('516364965272092672', '百度统计', 'https://tongji.baidu.com/web/demo/overview/index?siteId=16847648', 'https://tongji.baidu.com/web/demo/overview/index?siteId=16847648', 0, '1', '1', '2021-07-27 02:16:20', '2021-07-27 10:16:21');
INSERT INTO `tk_analysis` VALUES ('516378771117309952', '友盟统计', 'https://uweb.umeng.com/v1/login.php?siteid=1279992241', 'https://www.umeng.com/', 0, '469290977866022912', '1', '2021-07-13 15:31:19', '2021-07-13 23:34:57');

-- ----------------------------
-- Table structure for tk_category
-- ----------------------------
DROP TABLE IF EXISTS `tk_category`;
CREATE TABLE `tk_category`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `parent_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父分类ID',
  `site_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点ID',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码',
  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类图片',
  `path_rule` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成路径规则',
  `path` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类首页路径',
  `only_url` tinyint(1) NULL DEFAULT 0 COMMENT '是否只外链 只是外链栏目直接访问',
  `remote_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '外链跳转地址',
  `page_size` int(11) NULL DEFAULT NULL COMMENT '每页数据条数',
  `allow_contribute` tinyint(1) NOT NULL COMMENT '允许投稿',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '顺序',
  `hidden` tinyint(1) NOT NULL COMMENT '是否在首页隐藏',
  `category_model_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '扩展模型ID',
  `single_page` tinyint(4) NULL DEFAULT 0 COMMENT '是否是单页',
  `top_pages` int(5) NULL DEFAULT 20 COMMENT '指定生成前多少页',
  `contain_child` tinyint(1) NULL DEFAULT 0 COMMENT '是否包含字内容',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `code`(`code`) USING BTREE,
  INDEX `sort`(`sort`) USING BTREE,
  INDEX `type_id`(`allow_contribute`) USING BTREE,
  INDEX `site_id`(`parent_id`, `hidden`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_category
-- ----------------------------

-- ----------------------------
-- Table structure for tk_category_attr
-- ----------------------------
DROP TABLE IF EXISTS `tk_category_attr`;
CREATE TABLE `tk_category_attr`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `category_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类ID',
  `title` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题(分类标题用于 SEO 关键字优化)',
  `keywords` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关键词用于 SEO 关键字优化',
  `description` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述用于 SEO 关键字优化',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数据JSON',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`, `category_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分类扩展' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_category_attr
-- ----------------------------

-- ----------------------------
-- Table structure for tk_category_model
-- ----------------------------
DROP TABLE IF EXISTS `tk_category_model`;
CREATE TABLE `tk_category_model`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `category_model_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类模型扩展名称',
  `extend_field_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '扩展字段(json 保存)',
  `sort` int(11) NULL DEFAULT 0 COMMENT '排序',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_category_model
-- ----------------------------

-- ----------------------------
-- Table structure for tk_category_model_relation
-- ----------------------------
DROP TABLE IF EXISTS `tk_category_model_relation`;
CREATE TABLE `tk_category_model_relation`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `model_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `category_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板ID',
  `template_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分类选择模型时关系表 该模型值 tk_model 表 不是 分类模型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_category_model_relation
-- ----------------------------

-- ----------------------------
-- Table structure for tk_category_template
-- ----------------------------
DROP TABLE IF EXISTS `tk_category_template`;
CREATE TABLE `tk_category_template`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `category_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类ID',
  `site_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点ID',
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板ID',
  `template_path` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板列表页路径',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_category_template
-- ----------------------------

-- ----------------------------
-- Table structure for tk_content
-- ----------------------------
DROP TABLE IF EXISTS `tk_content`;
CREATE TABLE `tk_content`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点ID',
  `title` varchar(350) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `sub_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '副标题',
  `approve_user_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核用户',
  `approve_user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `category_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类',
  `p_category_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父分类ID',
  `model_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模型表ID',
  `copied` tinyint(1) NULL DEFAULT NULL COMMENT '是否转载',
  `author` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者',
  `editor` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编辑',
  `istop` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否置顶',
  `isrecomd` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推荐',
  `isheadline` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否头条',
  `only_url` tinyint(1) NULL DEFAULT NULL COMMENT '外链',
  `has_files` tinyint(1) NOT NULL COMMENT '拥有附件列表',
  `has_related` tinyint(4) NULL DEFAULT 0 COMMENT '是否有推荐内容',
  `has_tags` tinyint(2) NULL DEFAULT 0 COMMENT '是否包含附件',
  `url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '简介',
  `tag_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '标签',
  `top_tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '置顶标签',
  `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面',
  `comments` int(11) NULL DEFAULT NULL COMMENT '评论数',
  `clicks` int(11) NULL DEFAULT NULL COMMENT '点击数',
  `path_rule` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日期生成规则',
  `give_likes` int(11) NULL DEFAULT 0 COMMENT '点赞数',
  `publish_date` timestamp(0) NULL DEFAULT NULL COMMENT '发布日期',
  `publish_user_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发表用户ID',
  `job_date` timestamp(0) NULL DEFAULT NULL COMMENT '定时发布日期',
  `approve_date` timestamp(0) NULL DEFAULT NULL COMMENT '审核日期(c)',
  `sort` int(11) NULL DEFAULT 0 COMMENT '顺序',
  `status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '状态：0、草稿 1、已发布 2、删除',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  `create_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
  `modified_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人名称',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `check_date`(`approve_date`) USING BTREE,
  INDEX `scores`(`comments`, `clicks`) USING BTREE,
  INDEX `only_url`(`only_url`, `has_files`, `publish_user_id`) USING BTREE,
  INDEX `status`(`status`, `category_id`, `model_id`, `sort`, `publish_date`) USING BTREE,
  INDEX `site_id`(`site_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '内容' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_content
-- ----------------------------

-- ----------------------------
-- Table structure for tk_content_attach
-- ----------------------------
DROP TABLE IF EXISTS `tk_content_attach`;
CREATE TABLE `tk_content_attach`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `content_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
  `file_uid` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联资源表',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `downs` int(11) NULL DEFAULT NULL COMMENT '下载数',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `data` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'json 字段',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `content_id`(`content_id`) USING BTREE,
  INDEX `sort`(`sort`) USING BTREE,
  INDEX `clicks`(`downs`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '内容附件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_content_attach
-- ----------------------------

-- ----------------------------
-- Table structure for tk_content_attr
-- ----------------------------
DROP TABLE IF EXISTS `tk_content_attr`;
CREATE TABLE `tk_content_attr`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `content_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `origin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容来源',
  `origin_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '来源地址',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数据JSON',
  `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
  `total_word_count` int(11) NULL DEFAULT NULL COMMENT '字数',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`content_id`, `id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '内容扩展' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_content_attr
-- ----------------------------

-- ----------------------------
-- Table structure for tk_content_related
-- ----------------------------
DROP TABLE IF EXISTS `tk_content_related`;
CREATE TABLE `tk_content_related`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '当前文章内容id',
  `content_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前内容id',
  `related_cid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '推荐的内容ID',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`id`, `content_id`, `sort`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '内容推荐' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_content_related
-- ----------------------------

-- ----------------------------
-- Table structure for tk_fragment_attr
-- ----------------------------
DROP TABLE IF EXISTS `tk_fragment_attr`;
CREATE TABLE `tk_fragment_attr`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图',
  `path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '片段路径',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '超链接',
  `sort` int(11) NULL DEFAULT 0 COMMENT '排序',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '扩展数据data',
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板id',
  `fragment_model_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `activate` tinyint(4) NULL DEFAULT 1 COMMENT '0:未激活 1：已激活',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_fragment_attr
-- ----------------------------

-- ----------------------------
-- Table structure for tk_fragment_model
-- ----------------------------
DROP TABLE IF EXISTS `tk_fragment_model`;
CREATE TABLE `tk_fragment_model`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `alias` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '别名',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '片段编码',
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板id',
  `size` int(100) NULL DEFAULT 1 COMMENT '展示条数',
  `file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `default_field_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认自带',
  `extend_field_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '扩展字段',
  `all_field_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '所有选择字段（包含选择默认+扩展）',
  `required_field_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '必填字段',
  `field_text_map` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '字段对应中文名称',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_fragment_model
-- ----------------------------

-- ----------------------------
-- Table structure for tk_jobs
-- ----------------------------
DROP TABLE IF EXISTS `tk_jobs`;
CREATE TABLE `tk_jobs`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sex` int(2) NOT NULL,
  `job_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应聘职位 code',
  `job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '应聘职位 ',
  `contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '自我简介',
  `resume_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简历地址',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_jobs
-- ----------------------------
INSERT INTO `tk_jobs` VALUES ('596041009251483648', '牛德华', 1, '职位', '', '18229911633', '自我介绍自我介绍', 'http://127.0.0.1:8115/thinkitcmsresource/document/20210703/596041006550351872.doc', '', NULL, '2021-07-03 18:14:11', '2021-07-03 18:14:11');
INSERT INTO `tk_jobs` VALUES ('596101691250573312', '牛德华', 1, '职位', '', '18229911633', '自我介绍自我介绍', 'http://127.0.0.1:8115/thinkitcmsresource/document/20210703/596101690634010624.doc', '', NULL, '2021-07-03 22:15:18', '2021-07-03 22:15:18');
INSERT INTO `tk_jobs` VALUES ('596107735150362624', '牛德花', 1, '职位', '', '18229911633', '自我介绍', 'http://127.0.0.1:8115/thinkitcmsresource/document/20210703/596107734743515136.doc', '', NULL, '2021-07-03 22:39:19', '2021-07-03 22:39:19');
INSERT INTO `tk_jobs` VALUES ('596112885910863872', '蒋某', 1, '应聘职位', '', '18229911632', '111', 'http://127.0.0.1:8115/thinkitcmsresource/document/20210703/596112885504016384.doc', '', NULL, '2021-07-03 22:59:47', '2021-07-03 22:59:47');
INSERT INTO `tk_jobs` VALUES ('596114883745939456', '111', 2, '应聘职位', '', '111', '111', 'http://127.0.0.1:8115/thinkitcmsresource/document/20210703/596114883318120448.doc', '', NULL, '2021-07-03 23:07:44', '2021-07-03 23:07:44');
INSERT INTO `tk_jobs` VALUES ('596117015245094912', '潘长江', 1, '茶艺师', '', '18229911634', '本人专业', 'http://127.0.0.1:8115/thinkitcmsresource/document/20210703/596117014825664512.doc', '', NULL, '2021-07-03 23:16:12', '2021-07-03 23:16:12');
INSERT INTO `tk_jobs` VALUES ('596497459333562368', '蒋某', 1, '总经理高级助理', '', '18229911634', '找工作', 'http://127.0.0.1:8115/thinkitcmsresource/file/20210705/596497456603070464.docx', '', NULL, '2021-07-05 00:27:57', '2021-07-05 00:27:57');
INSERT INTO `tk_jobs` VALUES ('596503648800866304', '蒋某', 1, '新媒体运营', '', '18229911634', '我来找工作', 'http://127.0.0.1:8115/thinkitcmsresource/file/20210705/596503648255606784.docx', '', NULL, '2021-07-05 00:52:32', '2021-07-05 00:52:32');
INSERT INTO `tk_jobs` VALUES ('596847624317829120', '蒋先生', 1, '总经理高级助理', '', '18229911634', '找工作', 'http://47.113.204.40:8118/thinkitcmsresource/file/20210705/596847624246525952.docx', '', NULL, '2021-07-05 23:39:23', '2021-07-05 23:39:23');

-- ----------------------------
-- Table structure for tk_member
-- ----------------------------
DROP TABLE IF EXISTS `tk_member`;
CREATE TABLE `tk_member`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `real_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
  `head_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  `account` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `tel` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `sex` int(1) NULL DEFAULT NULL COMMENT '性别',
  `register_date` timestamp(0) NULL DEFAULT NULL COMMENT '注册时间',
  `is_lock` tinyint(4) NULL DEFAULT 0 COMMENT '是否锁定 0：未锁定 1：已锁定',
  `is_del` tinyint(4) NULL DEFAULT 0 COMMENT '0:未删除 1：已删除',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_member
-- ----------------------------

-- ----------------------------
-- Table structure for tk_model
-- ----------------------------
DROP TABLE IF EXISTS `tk_model`;
CREATE TABLE `tk_model`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `site_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点模型',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模型名称',
  `has_images` tinyint(4) NULL DEFAULT NULL COMMENT '是否有用图片',
  `has_files` tinyint(4) NULL DEFAULT NULL COMMENT '是否拥有文件',
  `is_url` tinyint(4) NULL DEFAULT NULL COMMENT '是否网址',
  `default_field_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认自带',
  `extend_field_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '扩展字段',
  `all_field_list` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '所有选择字段（包含选择默认+扩展）',
  `required_field_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '必填字段',
  `field_text_map` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '字段对应中文名称',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
  `gmt_create` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  `support_wehcat` tinyint(4) NULL DEFAULT NULL COMMENT '是否支持公众号模型',
  `support_tops` tinyint(4) NULL DEFAULT NULL COMMENT '是否支持头条模型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_model
-- ----------------------------

-- ----------------------------
-- Table structure for tk_model_category
-- ----------------------------
DROP TABLE IF EXISTS `tk_model_category`;
CREATE TABLE `tk_model_category`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模型-分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_model_category
-- ----------------------------

-- ----------------------------
-- Table structure for tk_model_template
-- ----------------------------
DROP TABLE IF EXISTS `tk_model_template`;
CREATE TABLE `tk_model_template`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模型ID',
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点ID',
  `template_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板ID',
  `template_path` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容静态化模板地址',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_model_template
-- ----------------------------

-- ----------------------------
-- Table structure for tk_org_site_category
-- ----------------------------
DROP TABLE IF EXISTS `tk_org_site_category`;
CREATE TABLE `tk_org_site_category`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `org_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门ID',
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `category_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类ID',
  `half_checked` int(2) NULL DEFAULT 0 COMMENT '0：半选中 1：全选中',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`org_id`, `category_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门-站点-分类 用于数据权限控制' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_org_site_category
-- ----------------------------

-- ----------------------------
-- Table structure for tk_share_model
-- ----------------------------
DROP TABLE IF EXISTS `tk_share_model`;
CREATE TABLE `tk_share_model`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `model_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模型ID',
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模型共享站点（-1：全部共享）',
  `start_using` tinyint(4) NULL DEFAULT 0 COMMENT '是否启用'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '模型分享库' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_share_model
-- ----------------------------

-- ----------------------------
-- Table structure for tk_site
-- ----------------------------
DROP TABLE IF EXISTS `tk_site`;
CREATE TABLE `tk_site`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_default` tinyint(4) NULL DEFAULT 0 COMMENT '0:非默认 1：默认',
  `is_share_org` tinyint(4) NULL DEFAULT 1 COMMENT '是的组织内共享 0：否 1：是',
  `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点名称',
  `site_subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点副标题',
  `site_key_words` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关键字',
  `site_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点描述',
  `site_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点logo',
  `org_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '组织ID',
  `domain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '域名',
  `siteicp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '站点备案信息',
  `copyright` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点版权',
  `comment_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '第三方评论代码',
  `share_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '第三方分享代码',
  `statistical_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '第三方统计代码',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_site
-- ----------------------------

-- ----------------------------
-- Table structure for tk_site_template
-- ----------------------------
DROP TABLE IF EXISTS `tk_site_template`;
CREATE TABLE `tk_site_template`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `site_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '站点id',
  `template_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模型id',
  `template_folder_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板路径',
  `start_using` tinyint(4) NULL DEFAULT 0 COMMENT '0:未启用 1：已启用',
  `create_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_site_template
-- ----------------------------

-- ----------------------------
-- Table structure for tk_strategy
-- ----------------------------
DROP TABLE IF EXISTS `tk_strategy`;
CREATE TABLE `tk_strategy`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `action_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '动作编码',
  `action_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '动作名称',
  `actuator_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器编码',
  `actuator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器名称',
  `category_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目ID',
  `trigger_time` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行时间',
  `order_num` int(5) NULL DEFAULT NULL COMMENT '顺序',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
  `is_start` tinyint(1) NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tk_strategy
-- ----------------------------

-- ----------------------------
-- Table structure for tk_tag
-- ----------------------------
DROP TABLE IF EXISTS `tk_tag`;
CREATE TABLE `tk_tag`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `sort` int(50) NULL DEFAULT NULL COMMENT '分类ID',
  `clicks` bigint(255) NULL DEFAULT NULL,
  `site_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_tag
-- ----------------------------

-- ----------------------------
-- Table structure for tk_tag_type
-- ----------------------------
DROP TABLE IF EXISTS `tk_tag_type`;
CREATE TABLE `tk_tag_type`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `count` int(11) NULL DEFAULT 0 COMMENT '标签数',
  `create_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_tag_type
-- ----------------------------

-- ----------------------------
-- Table structure for tk_template
-- ----------------------------
DROP TABLE IF EXISTS `tk_template`;
CREATE TABLE `tk_template`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属分类',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板名称',
  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'https://gw.alipayobjects.com/zos/rmsportal/uMfMFlvUuceEyPpotzlq.png' COMMENT '封面',
  `price` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '售价',
  `is_share` tinyint(2) NULL DEFAULT 0 COMMENT '是否共享',
  `template_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板 code ',
  `template_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板描述',
  `template_zip_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模板压缩路径',
  `template_folder_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件夹路径',
  `file_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件大小',
  `source_folder` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'static' COMMENT '资源目录根目录名称',
  `developer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '开发者名称',
  `developer_contact` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开发者 联系方式',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_template
-- ----------------------------

-- ----------------------------
-- Table structure for tk_template_type
-- ----------------------------
DROP TABLE IF EXISTS `tk_template_type`;
CREATE TABLE `tk_template_type`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类编码',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `parent_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` int(11) NULL DEFAULT 0 COMMENT '分类状态 0：显示 1：隐藏',
  `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_template_type
-- ----------------------------

-- ----------------------------
-- Table structure for tk_user_site_setting
-- ----------------------------
DROP TABLE IF EXISTS `tk_user_site_setting`;
CREATE TABLE `tk_user_site_setting`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `site_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `org_id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_default` tinyint(4) NULL DEFAULT 0,
  `create_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户id',
  `modified_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `gmt_create` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `gmt_modified` timestamp(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 tk_user_site_setting
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;