/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : xboot

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

 Date: 30/04/2020 21:53:59
*/

-- ----------------------------
-- Table structure for t_client
-- ----------------------------
DROP TABLE IF EXISTS `t_client`;
CREATE TABLE `t_client` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `client_secret` varchar(255) DEFAULT NULL,
  `home_uri` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `redirect_uri` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_department
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `parent_id` bigint(20) unsigned NOT NULL,
  `sort_order` decimal(10,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `is_parent` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_department
-- ----------------------------
BEGIN;
INSERT INTO `t_department` VALUES (40322777781112832, '', '2018-08-10 20:40:40', 0, '', '2018-08-11 00:03:06', 0, 1.00, 0, '总部', b'1');
INSERT INTO `t_department` VALUES (40322811096469504, '', '2018-08-10 20:40:48', 0, '', '2018-08-11 00:27:05', 40322777781112832, 1.00, 0, '技术部', b'1');
INSERT INTO `t_department` VALUES (40322852833988608, '', '2018-08-10 20:40:58', 0, '', '2018-08-11 01:29:42', 40322811096469504, 1.00, 0, '研发中心', NULL);
INSERT INTO `t_department` VALUES (40327204755738624, '', '2018-08-10 20:58:15', 0, '', '2018-08-10 22:02:15', 40322811096469504, 2.00, 0, '大数据', NULL);
INSERT INTO `t_department` VALUES (40327253309001728, '', '2018-08-10 20:58:27', 0, '', '2018-08-11 17:26:38', 40322811096469504, 3.00, -1, '人工智障', NULL);
INSERT INTO `t_department` VALUES (40343262766043136, '', '2018-08-10 22:02:04', 0, '', '2018-08-11 00:02:53', 0, 2.00, 0, '成都分部', b'1');
INSERT INTO `t_department` VALUES (40344005342400512, '', '2018-08-10 22:05:01', 0, '', '2018-08-11 17:48:44', 40343262766043136, 2.00, 0, 'Vue', NULL);
INSERT INTO `t_department` VALUES (40389030113710080, '', '2018-08-11 01:03:56', 0, '', '2018-08-11 17:50:04', 40343262766043136, 1.00, 0, 'JAVA', b'0');
INSERT INTO `t_department` VALUES (40652270295060480, '', '2018-08-11 18:29:57', 0, '', '2018-08-12 18:45:01', 0, 3.00, 0, '人事部', b'1');
INSERT INTO `t_department` VALUES (40652338142121984, NULL, '2018-08-11 18:30:13', 0, NULL, '2018-08-11 18:30:13', 40652270295060480, 1.00, 0, '游客', b'0');
INSERT INTO `t_department` VALUES (40681289119961088, '', '2018-08-11 20:25:16', 0, '', '2018-08-11 22:47:48', 40652270295060480, 2.00, 0, 'VIP', b'0');
COMMIT;

-- ----------------------------
-- Table structure for t_department_header
-- ----------------------------
DROP TABLE IF EXISTS `t_department_header`;
CREATE TABLE `t_department_header` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `department_id` bigint(20) unsigned DEFAULT NULL,
  `type` tinyint(1) DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_department_header
-- ----------------------------
BEGIN;
INSERT INTO `t_department_header` VALUES (1254427833757995008, 'admin', '2020-04-26 23:11:16', 0, 'admin', '2020-04-26 23:11:16', 40322777781112832, 0, 682265633886208);
INSERT INTO `t_department_header` VALUES (1254427833757995009, 'admin', '2020-04-26 23:11:16', 0, 'admin', '2020-04-26 23:11:16', 40322777781112832, 0, 16739222421508096);
INSERT INTO `t_department_header` VALUES (1254427833757995010, 'admin', '2020-04-26 23:11:16', 0, 'admin', '2020-04-26 23:11:16', 40322777781112832, 1, 16739222421508096);
COMMIT;

-- ----------------------------
-- Table structure for t_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_dict`;
CREATE TABLE `t_dict` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `sort_order` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_dict
-- ----------------------------
BEGIN;
INSERT INTO `t_dict` VALUES (75135930788220928, 'admin', '2018-11-14 22:15:43', 0, 'admin', '2018-11-27 01:39:06', '', '性别', 'sex', 0.00);
INSERT INTO `t_dict` VALUES (75383353938808832, 'admin', '2018-11-15 14:38:53', 0, 'admin', '2018-11-27 01:39:15', '', '消息类型', 'message_type', 1.00);
INSERT INTO `t_dict` VALUES (75388696739713024, 'admin', '2018-11-15 15:00:07', 0, 'admin', '2018-11-27 01:39:22', '', '按钮权限类型', 'permission_type', 2.00);
INSERT INTO `t_dict` VALUES (75392985935646720, 'admin', '2018-11-15 15:17:10', 0, 'admin', '2018-11-27 01:39:29', '', '腾讯云对象存储区域', 'tencent_bucket_region', 3.00);
INSERT INTO `t_dict` VALUES (79717732567748608, 'admin', '2018-11-27 13:42:10', 0, 'admin', '2018-11-27 13:42:10', '', '流程节点类型', 'process_node_type', 4.00);
INSERT INTO `t_dict` VALUES (81843858882695168, 'admin', '2018-12-03 10:30:38', 0, 'admin', '2018-12-03 10:30:49', '', '优先级', 'priority', 5.00);
INSERT INTO `t_dict` VALUES (82236987314016256, 'admin', '2018-12-04 12:32:47', 0, 'admin', '2018-12-04 12:32:47', '', '业务表', 'business_table', 6.00);
INSERT INTO `t_dict` VALUES (82236987314016257, 'admin', '2018-12-04 12:32:47', 0, 'admin', '2018-12-04 12:32:47', '', '业务表单路由', 'business_form', 7.00);
INSERT INTO `t_dict` VALUES (99020862912466944, 'admin', '2019-01-19 20:05:54', 0, 'admin', '2019-01-19 20:06:10', '', '请假类型', 'leave_type', 8.00);
COMMIT;

-- ----------------------------
-- Table structure for t_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `t_dict_data`;
CREATE TABLE `t_dict_data` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `dict_id` bigint(20) unsigned DEFAULT NULL,
  `sort_order` decimal(10,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sort_order` (`sort_order`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `t_dict_data` VALUES (75158227712479232, 'admin', '2018-11-14 23:44:19', 0, 'admin', '2019-04-01 23:53:13', '', 75135930788220928, 0.00, 0, '男', '男');
INSERT INTO `t_dict_data` VALUES (75159254272577536, 'admin', '2018-11-14 23:48:24', 0, 'admin', '2019-04-01 23:53:17', '', 75135930788220928, 1.00, 0, '女', '女');
INSERT INTO `t_dict_data` VALUES (75159898425397248, 'admin', '2018-11-14 23:50:57', 0, 'admin', '2019-04-01 23:53:22', '', 75135930788220928, 2.00, -1, '保密', '保密');
INSERT INTO `t_dict_data` VALUES (75385648017575936, 'admin', '2018-11-15 14:48:00', 0, 'admin', '2019-04-02 00:10:36', '', 75383353938808832, 0.00, 0, '系统公告', '系统公告');
INSERT INTO `t_dict_data` VALUES (75385706913992704, 'admin', '2018-11-15 14:48:14', 0, 'admin', '2019-04-02 00:10:32', '', 75383353938808832, 1.00, 0, '提醒', '提醒');
INSERT INTO `t_dict_data` VALUES (75385774274514944, 'admin', '2018-11-15 14:48:30', 0, 'admin', '2019-04-02 00:10:28', '', 75383353938808832, 2.00, 0, '私信', '私信');
INSERT INTO `t_dict_data` VALUES (75390787835138048, 'admin', '2018-11-15 15:08:26', 0, 'admin', '2018-11-15 15:08:26', '', 75388696739713024, 0.00, 0, '查看操作(view)', 'view');
INSERT INTO `t_dict_data` VALUES (75390886501945344, 'admin', '2018-11-15 15:08:49', 0, 'admin', '2018-11-15 15:08:57', '', 75388696739713024, 1.00, 0, '添加操作(add)', 'add');
INSERT INTO `t_dict_data` VALUES (75390993939042304, 'admin', '2018-11-15 15:09:15', 0, 'admin', '2018-11-15 15:09:15', '', 75388696739713024, 2.00, 0, '编辑操作(edit)', 'edit');
INSERT INTO `t_dict_data` VALUES (75391067532300288, 'admin', '2018-11-15 15:09:32', 0, 'admin', '2018-11-15 15:09:32', '', 75388696739713024, 3.00, 0, '删除操作(delete)', 'delete');
INSERT INTO `t_dict_data` VALUES (75391126902673408, 'admin', '2018-11-15 15:09:46', 0, 'admin', '2018-11-15 15:09:46', '', 75388696739713024, 4.00, 0, '清空操作(clear)', 'clear');
INSERT INTO `t_dict_data` VALUES (75391192883269632, 'admin', '2018-11-15 15:10:02', 0, 'admin', '2018-11-15 15:10:02', '', 75388696739713024, 5.00, 0, '启用操作(enable)', 'enable');
INSERT INTO `t_dict_data` VALUES (75391251024711680, 'admin', '2018-11-15 15:10:16', 0, 'admin', '2018-11-15 15:10:16', '', 75388696739713024, 6.00, 0, '禁用操作(disable)', 'disable');
INSERT INTO `t_dict_data` VALUES (75391297124306944, 'admin', '2018-11-15 15:10:27', 0, 'admin', '2018-11-15 15:10:27', '', 75388696739713024, 7.00, 0, '搜索操作(search)', 'search');
INSERT INTO `t_dict_data` VALUES (75391343379091456, 'admin', '2018-11-15 15:10:38', 0, 'admin', '2018-11-15 15:10:38', '', 75388696739713024, 8.00, 0, '上传文件(upload)', 'upload');
INSERT INTO `t_dict_data` VALUES (75391407526776832, 'admin', '2018-11-15 15:10:53', 0, 'admin', '2018-11-15 15:10:53', '', 75388696739713024, 9.00, 0, '导出操作(output)', 'output');
INSERT INTO `t_dict_data` VALUES (75391475042488320, 'admin', '2018-11-15 15:11:09', 0, 'admin', '2018-11-15 15:11:09', '', 75388696739713024, 10.00, 0, '导入操作(input)', 'input');
INSERT INTO `t_dict_data` VALUES (75391522182270976, 'admin', '2018-11-15 15:11:21', 0, 'admin', '2018-11-15 15:11:21', '', 75388696739713024, 11.00, 0, '分配权限(editPerm)', 'editPerm');
INSERT INTO `t_dict_data` VALUES (75391576364290048, 'admin', '2018-11-15 15:11:34', 0, 'admin', '2018-11-15 15:11:34', '', 75388696739713024, 12.00, 0, '设为默认(setDefault)', 'setDefault');
INSERT INTO `t_dict_data` VALUES (75391798033256448, 'admin', '2018-11-15 15:12:26', 0, 'admin', '2018-11-15 15:12:26', '', 75388696739713024, 13.00, 0, '其他操作(other)', 'other');
INSERT INTO `t_dict_data` VALUES (75393605291741184, 'admin', '2018-11-15 15:19:37', 0, 'admin', '2018-11-15 15:19:37', '', 75392985935646720, 0.00, 0, '北京一区（华北）', 'ap-beijing-1');
INSERT INTO `t_dict_data` VALUES (75393681254780928, 'admin', '2018-11-15 15:19:55', 0, 'admin', '2018-11-15 15:19:55', '', 75392985935646720, 1.00, 0, '北京', 'ap-beijing');
INSERT INTO `t_dict_data` VALUES (75393767619694592, 'admin', '2018-11-15 15:20:16', 0, 'admin', '2018-11-15 15:20:16', '', 75392985935646720, 2.00, 0, '上海（华东）', 'ap-shanghai');
INSERT INTO `t_dict_data` VALUES (75393851484803072, 'admin', '2018-11-15 15:20:36', 0, 'admin', '2018-11-15 15:20:36', '', 75392985935646720, 3.00, 0, '广州（华南）', 'ap-guangzhou');
INSERT INTO `t_dict_data` VALUES (75393961887272960, 'admin', '2018-11-15 15:21:02', 0, 'admin', '2018-11-15 15:21:02', '', 75392985935646720, 4.00, 0, '成都（西南）', 'ap-chengdu');
INSERT INTO `t_dict_data` VALUES (75394053969022976, 'admin', '2018-11-15 15:21:24', 0, 'admin', '2018-11-15 15:21:24', '', 75392985935646720, 5.00, 0, '重庆', 'ap-chongqing');
INSERT INTO `t_dict_data` VALUES (75394122474590208, 'admin', '2018-11-15 15:21:41', 0, 'admin', '2018-11-15 15:21:41', '', 75392985935646720, 6.00, 0, '新加坡', 'ap-singapore');
INSERT INTO `t_dict_data` VALUES (75394186202845184, 'admin', '2018-11-15 15:21:56', 0, 'admin', '2018-11-15 15:21:56', '', 75392985935646720, 7.00, 0, '香港', 'ap-hongkong');
INSERT INTO `t_dict_data` VALUES (75394254255427584, 'admin', '2018-11-15 15:22:12', 0, 'admin', '2018-11-15 15:22:12', '', 75392985935646720, 8.00, 0, '多伦多', 'na-toronto');
INSERT INTO `t_dict_data` VALUES (75394309125312512, 'admin', '2018-11-15 15:22:25', 0, 'admin', '2018-11-15 15:22:25', '', 75392985935646720, 9.00, 0, '法兰克福', 'eu-frankfurt');
INSERT INTO `t_dict_data` VALUES (75394367044456448, 'admin', '2018-11-15 15:22:39', 0, 'admin', '2018-11-15 15:22:39', '', 75392985935646720, 10.00, 0, '孟买', 'ap-mumbai');
INSERT INTO `t_dict_data` VALUES (75394448523005952, 'admin', '2018-11-15 15:22:58', 0, 'admin', '2018-11-15 15:22:58', '', 75392985935646720, 11.00, 0, '首尔', 'ap-seoul');
INSERT INTO `t_dict_data` VALUES (75394604765024256, 'admin', '2018-11-15 15:23:36', 0, 'admin', '2018-11-15 15:23:36', '', 75392985935646720, 12.00, 0, '硅谷', 'na-siliconvalley');
INSERT INTO `t_dict_data` VALUES (75394659299364864, 'admin', '2018-11-15 15:23:49', 0, 'admin', '2018-11-15 15:23:49', '', 75392985935646720, 13.00, 0, '弗吉尼亚', 'na-ashburn');
INSERT INTO `t_dict_data` VALUES (75394705700950016, 'admin', '2018-11-15 15:24:00', 0, 'admin', '2018-11-15 15:24:00', '', 75392985935646720, 14.00, 0, '曼谷', 'ap-bangkok');
INSERT INTO `t_dict_data` VALUES (75394759287377920, 'admin', '2018-11-15 15:24:12', 0, 'admin', '2018-11-15 15:24:12', '', 75392985935646720, 15.00, 0, '莫斯科', 'eu-moscow');
INSERT INTO `t_dict_data` VALUES (79717808262352896, 'admin', '2018-11-27 13:42:28', 0, 'admin', '2018-11-27 13:42:28', '', 79717732567748608, 0.00, 0, '开始节点', '0');
INSERT INTO `t_dict_data` VALUES (79717858308788224, 'admin', '2018-11-27 13:42:40', 0, 'admin', '2018-11-27 13:42:40', '', 79717732567748608, 1.00, 0, '审批节点', '1');
INSERT INTO `t_dict_data` VALUES (79717920061526016, 'admin', '2018-11-27 13:42:54', 0, 'admin', '2018-12-08 20:35:39', '', 79717732567748608, 2.00, 0, '结束节点', '2');
INSERT INTO `t_dict_data` VALUES (81843987719131136, 'admin', '2018-12-03 10:31:08', 0, 'admin', '2018-12-03 10:31:08', '', 81843858882695168, 0.00, 0, '普通', '0');
INSERT INTO `t_dict_data` VALUES (81844044015079424, 'admin', '2018-12-03 10:31:22', 0, 'admin', '2018-12-03 10:31:22', '', 81843858882695168, 1.00, 0, '重要', '1');
INSERT INTO `t_dict_data` VALUES (81844100705292288, 'admin', '2018-12-03 10:31:35', 0, 'admin', '2018-12-03 10:31:35', '', 81843858882695168, 2.00, 0, '紧急', '2');
INSERT INTO `t_dict_data` VALUES (82237106587439104, 'admin', '2018-12-04 12:33:15', 0, 'admin', '2018-12-04 12:33:15', '', 82236987314016256, 0.00, 0, '请假申请表', 't_leave');
INSERT INTO `t_dict_data` VALUES (82237106587439105, 'admin', '2018-12-04 12:33:15', 0, 'admin', '2018-12-04 12:33:15', '', 82236987314016257, 0.00, 0, '请假申请表', 'leave');
INSERT INTO `t_dict_data` VALUES (99020985985929216, 'admin', '2019-01-19 20:06:23', 0, 'admin', '2019-04-01 23:55:48', '', 99020862912466944, 0.00, 0, '年假', '年假');
INSERT INTO `t_dict_data` VALUES (99021020739932160, 'admin', '2019-01-19 20:06:32', 0, 'admin', '2019-04-01 23:55:52', '', 99020862912466944, 1.00, 0, '事假', '事假');
INSERT INTO `t_dict_data` VALUES (99021195566911488, 'admin', '2019-01-19 20:07:13', 0, 'admin', '2019-04-01 23:55:56', '', 99020862912466944, 2.00, 0, '病假', '病假');
INSERT INTO `t_dict_data` VALUES (99021242476007424, 'admin', '2019-01-19 20:07:24', 0, 'admin', '2019-04-01 23:56:01', '', 99020862912466944, 3.00, 0, '调休', '调休');
INSERT INTO `t_dict_data` VALUES (99021300730695680, 'admin', '2019-01-19 20:07:38', 0, 'admin', '2019-04-01 23:56:05', '', 99020862912466944, 4.00, 0, '产假', '产假');
INSERT INTO `t_dict_data` VALUES (99021341889400832, 'admin', '2019-01-19 20:07:48', 0, 'admin', '2019-04-01 23:56:10', '', 99020862912466944, 5.00, 0, '陪产假', '陪产假');
INSERT INTO `t_dict_data` VALUES (99021382393794560, 'admin', '2019-01-19 20:07:58', 0, 'admin', '2019-04-01 23:56:14', '', 99020862912466944, 6.00, 0, '婚假', '婚假');
INSERT INTO `t_dict_data` VALUES (99021437171404800, 'admin', '2019-01-19 20:08:11', 0, 'admin', '2019-04-01 23:56:18', '', 99020862912466944, 7.00, 0, '例假', '例假');
INSERT INTO `t_dict_data` VALUES (99021497724571648, 'admin', '2019-01-19 20:08:25', 0, 'admin', '2019-04-01 23:56:23', '', 99020862912466944, 8.00, 0, '丧假', '丧假');
INSERT INTO `t_dict_data` VALUES (99021556704874496, 'admin', '2019-01-19 20:08:39', 0, 'admin', '2019-04-01 23:56:27', '', 99020862912466944, 9.00, 0, '哺乳假', '哺乳假');
INSERT INTO `t_dict_data` VALUES (125170157323554816, 'admin', '2019-04-01 23:53:52', 0, 'admin', '2019-04-01 23:53:52', '', 75383353938808832, 3.00, 0, '工作流', '工作流');
COMMIT;

-- ----------------------------
-- Table structure for t_file
-- ----------------------------
DROP TABLE IF EXISTS `t_file`;
CREATE TABLE `t_file` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `size` bigint(20) unsigned DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `f_key` varchar(255) DEFAULT NULL,
  `location` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_log
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `cost_time` int(11) unsigned DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `ip_info` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `request_param` longtext,
  `request_type` varchar(255) DEFAULT NULL,
  `request_url` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `log_type` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `parent_id` bigint(20) unsigned NOT NULL,
  `type` tinyint(1) DEFAULT NULL,
  `sort_order` decimal(10,2) DEFAULT NULL,
  `component` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `level` int(11) unsigned DEFAULT NULL,
  `button_type` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `show_always` bit(1) DEFAULT NULL,
  `is_menu` bit(1) DEFAULT NULL,
  `is_parent` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_permission` VALUES (5129710648430592, '', '2018-06-04 19:02:29', 0, '', '2018-09-29 23:11:56', '', 'sys', 125909152017944576, 0, 1.00, 'Main', '/sys', '系统管理', 'ios-settings', 1, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (5129710648430593, '', '2018-06-04 19:02:32', 0, '', '2018-08-13 15:15:33', '', 'user-manage', 5129710648430592, 0, 1.10, 'sys/user-manage/userManage', 'user-manage', '用户管理', 'md-person', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (5129710648430594, '', '2018-06-04 19:02:35', 0, '', '2018-10-13 13:51:36', '', 'role-manage', 5129710648430592, 0, 1.60, 'sys/role-manage/roleManage', 'role-manage', '角色权限管理', 'md-contacts', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (5129710648430595, '', '2018-06-04 19:02:37', 0, '', '2018-09-23 23:32:02', '', 'menu-manage', 5129710648430592, 0, 1.70, 'sys/menu-manage/menuManage', 'menu-manage', '菜单权限管理', 'md-menu', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (15701400130424832, '', '2018-06-03 22:04:06', 0, '', '2018-09-19 22:16:44', '', '', 5129710648430593, 1, 1.11, '', '/xboot/user/admin/add*', '添加用户', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (15701915807518720, '', '2018-06-03 22:06:09', 0, '', '2018-06-06 14:46:51', '', '', 5129710648430593, 1, 1.13, '', '/xboot/user/admin/disable/**', '禁用用户', '', 3, 'disable', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (15708892205944832, '', '2018-06-03 22:33:52', 0, '', '2018-06-28 16:44:48', '', '', 5129710648430593, 1, 1.14, '', '/xboot/user/admin/enable/**', '启用用户', '', 3, 'enable', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16392452747300864, '', '2018-06-05 19:50:06', 0, 'admin', '2020-12-11 18:12:36', '', 'access', 125909152017944576, 0, 7.00, 'Main', '/access', '权限测试页', 'md-lock', 1, '', 0, '', b'0', NULL, b'1');
INSERT INTO `t_permission` VALUES (16392767785668608, '', '2018-06-05 19:51:21', 0, 'admin', '2018-10-23 12:34:38', '', 'access_index', 16392452747300864, 0, 5.10, 'access/access', 'index', '权限按钮测试页', 'md-lock', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (16438800255291392, '', '2018-06-05 22:54:18', 0, 'admin', '2018-10-23 12:34:51', '', '', 16392767785668608, 1, 5.11, '', 'test-add', '添加按钮测试', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16438962738434048, '', '2018-06-05 22:54:55', 0, 'admin', '2018-10-23 12:35:05', '', '', 16392767785668608, 1, 5.12, '', 'test-edit', '编辑按钮测试', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16439068543946752, '', '2018-06-05 22:55:20', 0, 'admin', '2018-10-23 12:34:54', '', '', 16392767785668608, 1, 5.13, '', 'test-delete', '删除按钮测试', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16678126574637056, '', '2018-06-06 14:45:16', 0, '', '2018-09-19 22:16:48', '', '', 5129710648430593, 1, 1.12, '', '/xboot/user/admin/edit*', '编辑用户', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16678447719911424, '', '2018-06-06 14:46:32', 0, '', '2018-08-10 21:41:16', '', '', 5129710648430593, 1, 1.15, '', '/xboot/user/delByIds/**', '删除用户', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16687383932047360, '', '2018-06-06 15:22:03', 0, '', '2018-09-19 22:07:34', '', '', 5129710648430594, 1, 1.21, '', '/xboot/role/save*', '添加角色', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16689632049631232, '', '2018-06-06 15:30:59', 0, '', '2018-09-19 22:07:37', '', '', 5129710648430594, 1, 1.22, '', '/xboot/role/edit*', '编辑角色', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16689745006432256, '', '2018-06-06 15:31:26', 0, '', '2018-08-10 21:41:23', '', '', 5129710648430594, 1, 1.23, '', '/xboot/role/delAllByIds/**', '删除角色', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16689883993083904, NULL, '2018-06-06 15:31:59', 0, NULL, '2018-06-06 15:31:59', NULL, NULL, 5129710648430594, 1, 1.24, NULL, '/xboot/role/editRolePerm**', '分配权限', NULL, 3, 'editPerm', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16690313745666048, '', '2018-06-06 15:33:41', 0, '', '2018-09-19 22:07:46', '', '', 5129710648430594, 1, 1.25, '', '/xboot/role/setDefault*', '设为默认角色', '', 3, 'setDefault', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16694861252005888, '', '2018-06-06 15:51:46', 0, '', '2018-09-19 22:07:52', '', '', 5129710648430595, 1, 1.31, '', '/xboot/permission/add*', '添加菜单', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16695107491205120, '', '2018-06-06 15:52:44', 0, '', '2018-09-19 22:07:57', '', '', 5129710648430595, 1, 1.32, '', '/xboot/permission/edit*', '编辑菜单', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (16695243126607872, '', '2018-06-06 15:53:17', 0, '', '2018-08-10 21:41:33', '', '', 5129710648430595, 1, 1.33, '', '/xboot/permission/delByIds/**', '删除菜单', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (25014528525733888, '', '2018-06-29 14:51:09', 0, '', '2018-10-08 11:13:27', '', '', 5129710648430593, 1, 1.16, '', '无', '上传图片', '', 3, 'upload', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (39915540965232640, NULL, '2018-08-09 17:42:28', 0, NULL, '2018-08-09 17:42:28', NULL, 'monitor', 125909152017944576, 0, 2.00, 'Main', '/monitor', '系统监控', 'ios-analytics', 1, NULL, 0, NULL, b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (39916171171991552, '', '2018-08-09 17:44:57', 0, 'admin', '2019-01-20 00:37:29', '', 'druid', 39915540965232640, 0, 2.40, 'sys/monitor/monitor', 'druid', 'SQL监控', 'md-analytics', 2, '', 0, 'http://127.0.0.1:8888/druid/login.html', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (39918482854252544, '', '2018-08-09 17:54:08', 0, 'admin', '2020-11-19 16:23:56', '', 'swagger', 39915540965232640, 0, 2.50, 'sys/monitor/monitor', 'swagger', '接口文档', 'md-document', 2, '', 0, 'http://127.0.0.1:8888/doc.html', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (40238597734928384, '', '2018-08-10 15:06:10', 0, 'admin', '2020-12-10 02:21:33', '', 'department-manage', 5129710648430592, 0, 1.20, 'sys/department-manage/departmentManage', 'department-manage', '部门管理', 'md-git-branch', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (41363147411427328, '', '2018-08-13 17:34:43', 0, 'admin', '2020-03-25 20:31:16', '', 'log-manage', 39915540965232640, 0, 2.20, 'sys/log-manage/logManage', 'log-manage', '日志管理', 'md-list-box', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (41363537456533504, '', '2018-08-13 17:36:16', 0, '', '2018-08-13 17:56:11', '', '', 41363147411427328, 1, 2.11, '', '/xboot/log/delByIds/**', '删除日志', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (41364927394353152, '', '2018-08-13 17:41:48', 0, 'admin', '2020-12-11 16:32:40', '', '', 41363147411427328, 1, 2.12, '', '/xboot/log/delAll*', '清空日志', '', 3, 'clear', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (41370251991977984, NULL, '2018-08-13 18:02:57', 0, NULL, '2018-08-13 18:02:57', NULL, 'quartz-job', 39915540965232640, 0, 2.10, 'sys/quartz-manage/quartzManage', 'quartz-job', '定时任务', 'md-time', 2, '', 0, NULL, b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (41371711400054784, '', '2018-08-13 18:08:45', 0, '', '2019-07-07 21:24:26', '', 'actuator', 39915540965232640, 0, 2.30, 'sys/actuator/actuator', 'actuator', 'Actuator监控', 'logo-angular', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (41373430515240960, '', '2018-08-13 18:15:35', 0, 'admin', '2019-11-22 11:47:07', '', 'vue-template', 125909152017944576, 0, 3.10, 'Main', '/vue-template', '后台Vue模版', 'ios-albums', 1, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (41375330996326400, '', '2018-08-13 18:23:08', 0, 'admin', '2020-03-21 20:41:28', '', 'simple-table', 41373430515240960, 0, 3.10, 'xboot-vue-template/simple-table/simpleTable', 'simple-table', '简单表格+动态列', 'ios-grid-outline', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (41376192166629376, '', '2018-08-13 18:26:33', 0, 'admin', '2018-10-20 22:47:26', '', 'search-table', 41373430515240960, 0, 3.40, 'xboot-vue-template/search-table/searchTable', 'search-table', '搜索表格[付费]', 'md-grid', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (41377034236071936, '', '2018-08-13 18:29:54', 0, 'admin', '2018-10-20 22:47:33', '', 'complex-table', 41373430515240960, 0, 3.50, 'xboot-vue-template/complex-table/complexTable', 'complex-table', '复杂表格[付费]', 'ios-grid', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (41378916912336896, '', '2018-08-13 18:37:23', 0, 'admin', '2019-04-12 15:38:08', '', 'tree', 41373430515240960, 0, 3.22, 'xboot-vue-template/tree/tree', 'tree', '树形结构', 'ios-git-network', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (41469219249852416, NULL, '2018-08-14 00:36:13', 0, NULL, '2018-08-14 00:36:13', NULL, '', 41371711400054784, 1, 2.31, '', '无', '查看数据', '', 3, 'view', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (42082442672082944, '', '2018-08-15 17:12:57', 0, 'admin', '2019-04-12 15:48:50', '', 'new-window', 41373430515240960, 0, 3.21, 'xboot-vue-template/new-window/newWindow', 'new-window', '新窗口操作', 'ios-browsers', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (43117268627886080, '', '2018-08-18 13:44:58', 0, '', '2018-08-18 20:55:04', '', 'message-manage', 5129710648430592, 0, 1.30, 'sys/message-manage/messageManage', 'message-manage', '消息管理[付费]', 'md-mail', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (44986029924421632, '', '2018-08-23 17:30:46', 0, '', '2018-09-23 23:26:53', '', 'social-manage', 5129710648430592, 0, 1.50, 'sys/social-manage/socialManage', 'social-manage', '社交账号绑定[付费]', 'md-share', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (45069342940860416, '', '2018-08-23 23:01:49', 0, '', '2018-08-24 10:01:09', '', '', 44986029924421632, 1, 1.42, '', '无', '查看社交账号数据', '', 3, 'view', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45235228800716800, '', '2018-08-24 10:01:00', 0, '', '2018-09-19 22:07:23', '', '', 44986029924421632, 1, 1.41, '', '/xboot/relate/delByIds*', '删除解绑', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45235621697949696, '', '2018-08-24 10:02:33', 0, '', '2018-09-19 22:06:57', '', '', 40238597734928384, 1, 1.21, '', '/xboot/department/add*', '添加部门', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45235787867885568, '', '2018-08-24 10:03:13', 0, '', '2018-09-19 22:07:02', '', '', 40238597734928384, 1, 1.22, '', '/xboot/department/edit*', '编辑部门', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45235939278065664, NULL, '2018-08-24 10:03:49', 0, NULL, '2018-08-24 10:03:49', NULL, '', 40238597734928384, 1, 1.23, '', '/xboot/department/delByIds/*', '删除部门', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45236734832676864, '', '2018-08-24 10:06:59', 0, '', '2018-09-19 22:07:07', '', '', 43117268627886080, 1, 1.31, '', '/xboot/message/add*', '添加消息', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45237010692050944, '', '2018-08-24 10:08:04', 0, '', '2018-09-19 22:07:12', '', '', 43117268627886080, 1, 1.32, '', '/xboot/message/edit*', '编辑消息', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45237170029465600, NULL, '2018-08-24 10:08:42', 0, NULL, '2018-08-24 10:08:42', NULL, '', 43117268627886080, 1, 1.33, '', '/xboot/message/delByIds/*', '删除消息', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45264987354042368, '', '2018-08-24 11:59:14', 0, '', '2018-09-19 22:08:11', '', '', 41370251991977984, 1, 2.11, '', '/xboot/quartzJob/add*', '添加定时任务', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45265487029866496, '', '2018-08-24 12:01:14', 0, '', '2018-09-19 22:08:17', '', '', 41370251991977984, 1, 2.12, '', '/xboot/quartzJob/edit*', '编辑定时任务', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45265762415284224, '', '2018-08-24 12:02:19', 0, '', '2018-09-19 22:08:24', '', '', 41370251991977984, 1, 2.13, '', '/xboot/quartzJob/pause*', '暂停定时任务', '', 3, 'disable', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45265886315024384, '', '2018-08-24 12:02:49', 0, '', '2018-09-19 22:09:13', '', '', 41370251991977984, 1, 2.14, '', '/xboot/quartzJob/resume*', '恢复定时任务', '', 3, 'enable', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (45266070000373760, NULL, '2018-08-24 12:03:33', 0, NULL, '2018-08-24 12:03:33', NULL, '', 41370251991977984, 1, 2.15, '', '/xboot/quartzJob/delByIds/*', '删除定时任务', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (56309618086776832, '', '2018-09-23 23:26:40', 0, 'admin', '2018-11-15 15:17:43', '', 'oss-manage', 5129710648430592, 0, 1.40, 'sys/oss-manage/ossManage', 'oss-manage', '文件对象存储[付费]', 'ios-folder', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (56898976661639168, '', '2018-09-25 14:28:34', 0, '', '2018-09-25 15:12:46', '', '', 5129710648430593, 1, 1.17, '', '/xboot/user/importData*', '导入用户', '', 3, 'input', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (56911328312299520, '', '2018-09-25 15:17:39', 0, 'admin', '2018-10-20 22:47:36', '', 'excel', 41373430515240960, 0, 3.60, 'xboot-vue-template/excel/excel', 'excel', 'Excel导入导出[付费]', 'md-exit', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (57009544286441472, NULL, '2018-09-25 21:47:55', 0, NULL, '2018-09-25 21:47:55', NULL, '', 43117268627886080, 1, 1.40, '', '/xboot/messageSend/save*', '添加已发送消息', '', 3, 'add', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (57009744761589760, NULL, '2018-09-25 21:48:43', 0, NULL, '2018-09-25 21:48:43', NULL, '', 43117268627886080, 1, 1.50, '', '/xboot/messageSend/update*', '编辑已发送消息', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (57009981228060672, NULL, '2018-09-25 21:49:39', 0, NULL, '2018-09-25 21:49:39', NULL, '', 43117268627886080, 1, 1.60, '', '/xboot/messageSend/delByIds/*', '删除已发送消息', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (57212882168844288, '', '2018-09-26 11:15:55', 0, '', '2018-10-08 11:10:05', '', '', 56309618086776832, 1, 1.41, '', '无', '上传文件', '', 3, 'upload', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (58480609315524608, '', '2018-09-29 23:13:24', 0, 'admin', '2018-11-14 13:24:26', '', 'setting', 5129710648430592, 0, 1.90, 'sys/setting-manage/settingManage', 'setting', '系统配置[付费]', 'ios-settings-outline', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (61394706252173312, NULL, '2018-10-08 00:12:59', 0, NULL, '2018-10-08 00:12:59', NULL, '', 58480609315524608, 1, 1.81, '', '/xboot/setting/seeSecret/**', '查看私密配置', '', 3, 'view', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (61417744146370560, '', '2018-10-08 01:44:32', 0, '', '2018-10-08 01:50:03', '', '', 58480609315524608, 1, 1.82, '', '/xboot/setting/*/set*', '编辑配置', '', 3, 'edit', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (61560041605435392, NULL, '2018-10-08 11:09:58', 0, NULL, '2018-10-08 11:09:58', NULL, '', 56309618086776832, 1, 1.42, '', '/xboot/file/rename*', '重命名文件', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (61560275261722624, NULL, '2018-10-08 11:10:54', 0, NULL, '2018-10-08 11:10:54', NULL, '', 56309618086776832, 1, 1.43, '', '/xboot/file/copy*', '复制文件', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (61560480518377472, NULL, '2018-10-08 11:11:43', 0, NULL, '2018-10-08 11:11:43', NULL, '', 56309618086776832, 1, 1.44, '', '/xboot/file/delete/*', '删除文件', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (63482475359244288, '', '2018-10-13 18:29:02', 0, 'admin', '2018-10-20 22:47:45', '', 'custom-tree', 41373430515240960, 0, 3.80, 'xboot-vue-template/custom-tree/customTree', 'custom-tree', '自定义树[付费]', 'md-git-network', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (63741744973352960, '', '2018-10-14 11:39:17', 0, 'admin', '2019-02-04 17:03:07', '', 'render', 41373430515240960, 0, 3.30, 'xboot-vue-template/render/render', 'render', 'Render函数示例[付费]', 'md-aperture', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (64290663792906240, '', '2018-10-16 00:00:29', 0, 'admin', '2018-10-20 22:47:49', '', 'tree&table', 41373430515240960, 0, 3.90, 'xboot-vue-template/tree&table/tree&table', 'tree&table', '树+表格[付费]', 'md-list', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (66790433014943744, 'admin', '2018-10-22 21:33:42', 0, 'admin', '2018-10-22 21:37:12', '', 'card-list', 41373430515240960, 0, 3.91, 'xboot-vue-template/card-list/cardList', 'card-list', '卡片列表[付费]', 'md-card', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (67027338952445952, 'admin', '2018-10-23 13:15:03', 0, 'admin', '2018-10-23 14:57:38', '', 'product-template', 125909152017944576, 0, 4.00, 'Main', '/product-template', '前台产品级组件', 'md-ribbon', 1, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (67027909637836800, 'admin', '2018-10-23 13:17:19', 0, 'admin', '2019-11-22 16:19:01', '', 'banner', 67027338952445952, 0, 4.10, 'xboot-product-template/banner/Banner', 'banner', '轮播组件[付费]', 'md-book', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (67042515441684480, 'admin', '2018-10-23 14:15:22', 0, 'admin', '2019-11-22 16:19:24', '', 'product', 67027338952445952, 0, 4.20, 'xboot-product-template/product/Product', 'product', '产品组件[付费]', 'md-pricetags', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (67082402312228864, 'admin', '2018-10-23 16:53:53', 0, 'admin', '2019-11-22 16:19:32', '', 'category', 67027338952445952, 0, 4.30, 'xboot-product-template/category/Category', 'category', '分类栏组件[付费]', 'md-apps', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (75002207560273920, 'admin', '2018-11-14 13:24:21', 0, 'admin', '2018-11-20 20:06:22', '', 'dict', 5129710648430592, 0, 1.80, 'sys/dict-manage/dictManage', 'dict', '数据字典管理', 'md-bookmarks', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (76215889006956544, 'admin', '2018-11-17 21:47:05', 0, 'admin', '2018-11-17 21:47:53', '', '', 75002207560273920, 1, 1.81, '', '/xboot/dict/add*', '添加字典', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (76216071333351424, 'admin', '2018-11-17 21:47:48', 0, 'admin', '2018-11-17 21:47:48', NULL, '', 75002207560273920, 1, 1.82, '', '/xboot/dict/edit*', '编辑字典', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (76216264070008832, 'admin', '2018-11-17 21:48:34', 0, 'admin', '2018-11-17 21:48:34', NULL, '', 75002207560273920, 1, 1.83, '', '/xboot/dict/delByIds/**', '删除字典', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (76216459709124608, 'admin', '2018-11-17 21:49:21', 0, 'admin', '2018-11-17 21:49:21', NULL, '', 75002207560273920, 1, 1.84, '', '/xboot/dictData/add*', '添加字典数据', '', 3, 'add', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (76216594207870976, 'admin', '2018-11-17 21:49:53', 0, 'admin', '2018-11-17 21:49:53', NULL, '', 75002207560273920, 1, 1.85, '', '/xboot/dictData/edit*', '编辑字典数据', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (76216702639017984, 'admin', '2018-11-17 21:50:18', 0, 'admin', '2018-11-17 21:50:18', NULL, '', 75002207560273920, 1, 1.86, '', '/xboot/dictData/delByIds/**', '删除字典数据', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (76606430504816640, 'admin', '2018-11-18 23:38:57', 0, 'admin', '2018-11-18 23:39:12', '', 'activiti', 125909152017944576, 0, 1.10, 'Main', '/activiti', '工作流程', 'md-git-compare', 1, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (76607201262702592, 'admin', '2018-11-18 23:42:01', 0, 'admin', '2018-11-20 19:41:58', '', 'model-manage', 76606430504816640, 0, 1.00, 'activiti/model-manage/modelManage', 'model-manage', '模型管理[付费]', 'md-cube', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (76914082455752704, 'admin', '2018-11-19 20:01:28', 0, 'admin', '2018-11-20 19:41:50', '', 'process-manage', 76606430504816640, 0, 0.90, 'activiti/process-manage/processManage', 'process-manage', '流程管理[付费]', 'md-calendar', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (80539147005071360, 'admin', '2018-11-29 20:06:10', 0, 'admin', '2018-12-04 14:14:41', '', 'category-manage', 76606430504816640, 0, 2.00, 'activiti/category-manage/categoryManage', 'category-manage', '流程分类管理[付费]', 'md-bookmark', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (81319435670917120, 'admin', '2018-12-01 23:46:45', 0, 'admin', '2018-12-02 15:37:03', '', 'process-ins-manage', 76606430504816640, 0, 0.70, 'activiti/process-ins-manage/processInsManage', 'process-ins-manage', '运行中的流程[付费]', 'md-fastforward', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (81558529864896512, 'admin', '2018-12-02 15:36:50', 0, 'admin', '2018-12-08 14:50:38', '', 'apply-manage', 76606430504816640, 0, 0.00, 'activiti/apply-manage/applyManage', 'apply-manage', '我的申请[付费]', 'md-clipboard', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (81716172680073216, 'admin', '2018-12-03 02:03:15', 0, 'admin', '2018-12-03 02:03:15', NULL, 'todo-manage', 76606430504816640, 0, 0.10, 'activiti/todo-manage/todoManage', 'todo-manage', '我的待办[付费]', 'ios-pricetag', 2, '', 0, NULL, b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (82269650301227008, 'admin', '2018-12-04 14:42:34', 0, 'admin', '2018-12-04 14:42:34', NULL, 'done-manage', 76606430504816640, 0, 0.20, 'activiti/done-manage/doneManage', 'done-manage', '我的已办[付费]', 'ios-pricetag-outline', 2, '', 0, NULL, b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (84082369492946944, 'admin', '2018-12-09 14:45:40', 0, 'admin', '2018-12-09 14:46:59', '', '', 81558529864896512, 1, 0.00, '', '/xboot/leave/add*', '添加请假申请', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84082920431554560, 'admin', '2018-12-09 14:47:51', 0, 'admin', '2020-12-11 01:18:01', '', '', 81558529864896512, 1, 4.00, '', '/xboot/actBusiness/delByIds/**', '删除草稿申请', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84083562503999488, 'admin', '2018-12-09 14:50:25', 0, 'admin', '2018-12-09 14:50:25', NULL, '', 81716172680073216, 1, 0.00, '', '/xboot/actTask/pass**', '审批通过', '', 3, 'enable', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84083641302388736, 'admin', '2018-12-09 14:50:43', 0, 'admin', '2018-12-09 14:50:43', NULL, '', 81716172680073216, 1, 1.00, '', '/xboot/actTask/back**', '审批驳回', '', 3, 'disable', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84084404707659776, 'admin', '2018-12-09 14:53:45', 0, 'admin', '2018-12-09 14:53:45', NULL, '', 81716172680073216, 1, 3.00, '', '/xboot/actTask/delegate**', '委托代办', '', 3, 'other', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84084724590448640, 'admin', '2018-12-09 14:55:02', 0, 'admin', '2018-12-09 14:55:02', NULL, '', 82269650301227008, 1, 0.00, '', '/xboot/actTask/deleteHistoric/**', '删除已办任务', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84084965817454592, 'admin', '2018-12-09 14:55:59', 0, 'admin', '2018-12-09 14:55:59', NULL, '', 81319435670917120, 1, 0.00, '', '/xboot/actProcess/delInsByIds/**', '删除运行流程', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84085542324539392, 'admin', '2018-12-09 14:58:17', 0, 'admin', '2018-12-09 14:58:17', NULL, '', 76914082455752704, 1, 0.00, '', '/xboot/actProcess/updateInfo/**', '编辑流程信息', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84085810797744128, 'admin', '2018-12-09 14:59:21', 0, 'admin', '2018-12-09 14:59:21', NULL, '', 76914082455752704, 1, 1.00, '', '/xboot/actProcess/editNodeUser**', '流程节点设置', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84085980943880192, 'admin', '2018-12-09 15:00:01', 0, 'admin', '2018-12-09 15:00:01', NULL, '', 76914082455752704, 1, 2.00, '', '/xboot/actProcess/convertToModel/**', '流程转模型', '', 3, 'other', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84086163001839616, 'admin', '2018-12-09 15:00:45', 0, 'admin', '2018-12-09 15:01:37', '', '', 76914082455752704, 1, 3.00, '', '/xboot/actProcess/delByIds/**', '删除流程定义', '', 3, 'delete', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84086362248056832, 'admin', '2018-12-09 15:01:32', 0, 'admin', '2018-12-09 15:01:32', NULL, '', 76914082455752704, 1, 4.00, '', '/xboot/actModel/deployByFile**', '文件部署流程', '', 3, 'other', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84086882907983872, 'admin', '2018-12-09 15:03:36', 0, 'admin', '2018-12-09 15:03:36', NULL, '', 76607201262702592, 1, 0.00, '', '/xboot/actModel/add**', '添加模型', '', 3, 'add', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84087009940869120, 'admin', '2018-12-09 15:04:06', 0, 'admin', '2018-12-09 15:04:06', NULL, '', 76607201262702592, 1, 1.00, '', '/xboot/actModel/delByIds/**', '删除模型', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84087154040377344, 'admin', '2018-12-09 15:04:41', 0, 'admin', '2018-12-09 15:04:41', NULL, '', 76607201262702592, 1, 2.00, '', '/xboot/actModel/deploy/**', '部署模型', '', 3, 'other', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84087344352727040, 'admin', '2018-12-09 15:05:26', 0, 'admin', '2018-12-09 15:05:33', '', '', 80539147005071360, 1, 0.00, '', '/xboot/actCategory/add**', '添加流程分类', '', 3, 'add', 0, '', b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84087480852156416, 'admin', '2018-12-09 15:05:59', 0, 'admin', '2018-12-09 15:05:59', NULL, '', 80539147005071360, 1, 1.00, '', '/xboot/actCategory/edit**', '编辑流程分类', '', 3, 'edit', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (84087593041399808, 'admin', '2018-12-09 15:06:25', 0, 'admin', '2018-12-09 15:06:25', NULL, '', 80539147005071360, 1, 2.00, '', '/xboot/actCategory/delByIds/**', '删除流程分类', '', 3, 'delete', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (102235632889237504, 'admin', '2019-01-28 17:00:15', 0, 'admin', '2019-11-22 11:47:14', '', 'vue-generator', 125909152017944576, 0, 3.00, 'Main', '/vue-generator', 'Vue代码生成', 'md-send', 1, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (102237605176807424, 'admin', '2019-01-28 17:08:06', 0, 'admin', '2019-02-01 20:41:31', '', 'table-generator', 102235632889237504, 0, 0.00, 'xboot-vue-generator/tableGenerator', 'table', '增删改表格生成[付费]', 'md-grid', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (102240052523831296, 'admin', '2019-01-28 17:17:49', 0, 'admin', '2019-02-01 20:41:38', '', 'tree-generator', 102235632889237504, 0, 1.00, 'xboot-vue-generator/treeGenerator', 'tree', '树形结构生成[付费]', 'md-git-branch', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (103658022701633536, 'admin', '2019-02-01 15:12:20', 0, 'admin', '2019-02-01 18:38:29', '', 'test', 102235632889237504, 0, 3.00, 'xboot-vue-generator/test', 'test', '代码生成测试页', 'ios-bug', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (113601631450304512, 'admin', '2019-03-01 01:44:41', 0, 'admin', '2019-03-01 01:44:41', NULL, '', 81716172680073216, 1, 2.00, '', '/xboot/actTask/backAll/**', '审批驳回至发起人', '', 3, 'disable', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (113602149589454848, 'admin', '2019-03-01 01:46:44', 0, 'admin', '2019-06-26 20:38:55', '', 'components', 125909152017944576, 0, 5.00, 'Main', '/components', 'XBoot业务组件', 'md-cube', 1, '', 0, '', b'0', NULL, b'1');
INSERT INTO `t_permission` VALUES (113602342657462272, 'admin', '2019-03-01 01:47:30', 0, 'admin', '2019-03-01 02:03:26', '', 'components', 113602149589454848, 0, 0.00, 'xboot-components/xboot-components', 'components', 'XBoot业务组件', 'md-cube', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (113603512293658624, 'admin', '2019-03-01 01:52:09', 0, 'admin', '2019-06-26 20:38:47', '', 'library', 125909152017944576, 0, 6.00, 'Main', '/library', '第三方依赖工具/组件', 'ios-link', 1, '', 0, '', b'0', NULL, b'1');
INSERT INTO `t_permission` VALUES (113603617897844736, 'admin', '2019-03-01 01:52:34', 0, 'admin', '2019-03-01 02:03:15', '', 'library', 113603512293658624, 0, 0.00, 'xboot-library/xboot-library', 'library', '第三方依赖工具/组件', 'ios-link', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (117806106536841216, 'admin', '2019-03-12 16:11:46', 0, 'admin', '2019-03-12 16:11:46', NULL, 'process-finish-manage', 76606430504816640, 0, 0.80, 'activiti/process-finish-manage/processFinishManage', 'process-finish-manage', '结束的流程[付费]', 'md-power', 2, '', 0, NULL, b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (121426317022334976, 'admin', '2019-03-22 15:57:11', 0, 'admin', '2019-03-22 15:57:11', NULL, 'redis', 39915540965232640, 0, 2.21, 'sys/redis/redis', 'redis', 'Redis缓存管理', 'md-barcode', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (125909152017944576, 'admin', '2019-04-04 00:50:22', 0, 'admin', '2020-12-10 02:18:38', 'undefined', 'xboot', 0, -1, 0.00, 'false', '', 'XBoot管理系统', 'md-home', 0, '', 0, '', b'1', b'1', b'1');
INSERT INTO `t_permission` VALUES (127995258721013760, 'admin', '2019-04-09 18:59:49', 0, 'admin', '2020-05-24 20:05:41', 'window', 'doc', 0, -1, 2.00, '', '', 'XBoot开发文档', 'md-document', 0, '', 0, 'https://www.kancloud.cn/exrick/xboot/content', b'1', b'0', NULL);
INSERT INTO `t_permission` VALUES (127996320085446656, 'admin', '2019-04-09 19:04:02', 0, 'admin', '2020-12-10 02:19:01', '', 'app', 0, -1, 1.00, '', '', 'APP与小程序管理', 'md-phone-portrait', 0, '', 0, '', b'1', b'1', b'1');
INSERT INTO `t_permission` VALUES (127996726786134016, 'admin', '2019-04-09 19:05:39', 0, 'admin', '2020-05-24 20:08:26', 'window', 'xpay', 0, -1, 3.00, '', '', 'XPay支付系统', 'md-cash', 0, '', 0, 'http://xpay.exrick.cn', b'1', b'0', NULL);
INSERT INTO `t_permission` VALUES (127997001756315648, 'admin', '2019-04-09 19:06:44', 0, 'admin', '2020-05-24 20:08:39', 'window', 'xmall', 0, -1, 4.00, '', '', 'XMall商城', 'md-cart', 0, '', 0, 'http://xmall.exrick.cn', b'1', b'0', NULL);
INSERT INTO `t_permission` VALUES (128364633437245440, 'admin', '2019-04-10 19:27:35', 0, 'admin', '2020-05-24 20:08:10', 'window', 'xboot-show', 0, -1, 2.10, '', '', 'XBoot宣传官网', 'md-paper-plane', 0, '', 0, 'http://xb.exrick.cn', b'1', b'0', NULL);
INSERT INTO `t_permission` VALUES (128366789653434368, 'admin', '2019-04-10 19:36:09', 0, 'admin', '2020-04-27 11:11:22', '', 'app', 127996320085446656, 0, 1.00, 'Main', '/app', 'XBoot Uniapp App', 'md-phone-portrait', 1, '', 0, '', b'0', NULL, b'1');
INSERT INTO `t_permission` VALUES (128368112335589376, 'admin', '2019-04-10 19:41:24', 0, 'admin', '2020-04-27 11:11:28', '', 'uniapp', 128366789653434368, 0, 0.00, 'uniapp/uniapp', 'uniapp', 'XBoot Uniapp App', 'md-phone-portrait', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (129033675403694080, 'admin', '2019-04-12 15:46:07', 0, 'admin', '2019-11-25 17:33:43', '', 'single-window', 41373430515240960, 0, 1.00, 'xboot-vue-template/single-window/singleWindow', 'single-window', '动态组件单页操作', 'md-easel', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (149452775095275520, 'admin', '2019-06-08 00:04:19', 0, 'admin', '2019-06-08 00:04:19', NULL, 'admin', 39915540965232640, 0, 2.29, 'sys/monitor/monitor', '/admin', 'Admin监控', 'md-speedometer', 2, '', 0, 'http://127.0.0.1:8888/xboot/admin/wallboard', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (156365156580855808, 'admin', '2019-06-27 01:51:39', 0, 'admin', '2019-06-27 01:51:39', NULL, '', 5129710648430593, 1, 1.18, '', '/xboot/user/resetPass', '重置密码', '', 3, 'other', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (160509731956330496, 'admin', '2019-07-08 12:20:43', 0, 'admin', '2019-07-08 12:22:13', '', 'weapp', 127996320085446656, 0, 0.00, 'Main', '/weapp', '微信小程序', 'ios-appstore', 1, '', 0, '', b'0', NULL, b'1');
INSERT INTO `t_permission` VALUES (160509918166650881, 'admin', '2019-07-08 12:21:28', 0, 'admin', '2020-04-27 11:10:54', '', 'weapp', 160509731956330496, 0, 0.00, 'weapp/weapp', 'weapp', '微信小程序', 'md-phone-portrait', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (175808753877127169, 'admin', '2019-08-19 17:33:34', 0, 'admin', '2020-08-14 14:34:16', '', 'sso', 125909152017944576, 0, 8.00, 'Main', '/sso', '单点登录测试站', 'md-log-in', 1, '', 0, '', b'0', NULL, b'1');
INSERT INTO `t_permission` VALUES (175808922710446081, 'admin', '2019-08-19 17:34:15', 0, 'admin', '2019-08-19 17:34:15', NULL, 'sso', 175808753877127169, 0, 0.00, 'sso/sso', 'sso', '单点登录测试站', 'md-log-in', 2, '', 0, NULL, b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (210154306362413056, 'admin', '2019-11-22 12:10:32', 0, 'admin', '2019-11-22 12:10:32', NULL, 'charts', 125909152017944576, 0, 3.10, 'Main', '/charts', '图表数据展示', 'md-analytics', 1, '', 0, NULL, b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (210155258859491329, 'admin', '2019-11-22 12:14:19', 0, 'admin', '2019-11-22 12:20:50', '', 'dashboard1', 210154306362413056, 0, 0.00, 'xboot-charts/dashboard1/dashboard1', 'dashboard1', 'Dashboard1[付费]', 'md-speedometer', 2, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (210156371755143168, 'admin', '2019-11-22 12:18:45', 0, 'admin', '2019-11-22 12:18:45', NULL, 'dashboard2', 210154306362413056, 0, 1.00, 'xboot-charts/dashboard2/dashboard2', 'dashboard2', 'Dashboard2[付费]', 'ios-speedometer', 2, '', 0, NULL, b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (211251162815401984, 'admin', '2019-11-25 12:49:03', 0, 'admin', '2019-11-25 12:49:12', '', 'open', 125909152017944576, 0, 1.20, 'Main', '/open', '开放平台', 'ios-apps', 1, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (211251678651879424, 'admin', '2019-11-25 12:51:06', 0, 'admin', '2020-12-10 12:16:22', '', 'client', 211251162815401984, 0, 0.00, 'open/client/client', 'client', '接入网站管理', 'md-browsers', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (211652331387752448, 'admin', '2019-11-26 15:23:09', 0, 'admin', '2020-12-10 12:16:35', '', 'doc', 211251162815401984, 0, 1.00, 'sys/monitor/monitor', 'doc', '开放平台文档', 'md-document', 2, '', 0, 'https://www.kancloud.cn/exrick/xboot/1399478', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (1251152298521006080, 'admin', '2020-04-17 22:15:28', 0, 'admin', '2020-04-27 18:30:59', '', 'member', 127996320085446656, 0, 2.00, 'Main', '/member', '会员管理', 'md-contact', 1, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (1251153074307862528, 'admin', '2020-04-17 22:18:33', 0, 'admin', '2020-04-27 18:31:17', '', 'member', 1251152298521006080, 0, 0.00, 'app/member/member', 'member', '注册会员管理[付费]', 'md-contacts', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (1251760630449442816, 'admin', '2020-04-19 14:32:46', 0, 'admin', '2020-04-27 18:31:03', '', 'member-log', 127996320085446656, 0, 3.00, 'Main', '/member-log', '日志记录', 'md-list-box', 1, '', 0, '', b'1', NULL, b'0');
INSERT INTO `t_permission` VALUES (1251761480286736384, 'admin', '2020-04-19 14:36:08', 0, 'admin', '2020-04-27 18:31:22', '', 'member-log', 1251760630449442816, 0, 0.00, 'sys/log-manage/logManage', 'member-log', '日志记录[付费]', 'md-list-box', 2, '', 0, '', b'1', NULL, b'1');
INSERT INTO `t_permission` VALUES (1254739560500432897, 'admin', '2020-04-27 19:49:58', 0, 'admin', '2020-04-27 19:49:58', NULL, '', 81716172680073216, 1, 0.00, '', '/xboot/actTask/passAll/**', '批量通过', '', 3, 'other', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (1254739666461134848, 'admin', '2020-04-27 19:50:23', 0, 'admin', '2020-04-27 19:50:23', NULL, '', 81716172680073216, 1, 0.00, '', '/xboot/actTask/back**', '批量驳回', '', 3, 'disable', 0, NULL, b'1', NULL, NULL);
INSERT INTO `t_permission` VALUES (1337084109473845248, 'admin', '2020-12-11 01:17:48', 0, 'admin', '2020-12-11 01:17:48', NULL, '', 81558529864896512, 1, 3.00, '', '/xboot/actBusiness/apply*', '提交申请', '', 3, 'enable', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337084263631294465, 'admin', '2020-12-11 01:18:25', 0, 'admin', '2020-12-11 01:18:32', '', '', 81558529864896512, 1, 3.00, '', '/xboot/actBusiness/cancel*', '撤回申请', '', 3, 'disable', 0, '', b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337084380564295681, 'admin', '2020-12-11 01:18:53', 0, 'admin', '2020-12-11 01:18:53', NULL, '', 117806106536841216, 1, 1.00, '', '/xboot/actProcess/delHistoricInsByIds**', '删除结束流程', '', 3, 'delete', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337087041741131777, 'admin', '2020-12-11 01:29:27', 0, 'admin', '2020-12-11 01:29:27', NULL, '', 76914082455752704, 1, 0.00, '', '/xboot/actProcess/editStartUser**', '编辑流程发起人', '', 3, 'edit', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337087257902977024, 'admin', '2020-12-11 01:30:19', 0, 'admin', '2020-12-11 01:30:19', NULL, '', 211251678651879424, 1, 1.00, '', '/xboot/client/save**', '添加网站', '', 3, 'add', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337087364513796097, 'admin', '2020-12-11 01:30:44', 0, 'admin', '2020-12-11 01:31:28', '', '', 211251678651879424, 1, 3.00, '', '/xboot/client/delByIds**', '删除网站', '', 3, 'delete', 0, '', b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337087482155634689, 'admin', '2020-12-11 01:31:12', 0, 'admin', '2020-12-11 01:31:32', '', '', 211251678651879424, 1, 2.00, '', '/xboot/client/update**', '编辑网站', '', 3, 'edit', 0, '', b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337087799127576577, 'admin', '2020-12-11 01:32:28', 0, 'admin', '2020-12-11 01:32:28', NULL, '', 121426317022334976, 1, 1.00, '', '/xboot/redis/getAllByPage**', '获取Redis', '', 3, 'view', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337087867276627969, 'admin', '2020-12-11 01:32:44', 0, 'admin', '2020-12-11 01:32:44', NULL, '', 121426317022334976, 1, 2.00, '', '/xboot/redis/save', '添加Redis', '', 3, 'add', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337087940756639745, 'admin', '2020-12-11 01:33:02', 0, 'admin', '2020-12-11 01:33:02', NULL, '', 121426317022334976, 1, 2.00, '', '/xboot/redis/delByKeys**', '删除Redis', '', 3, 'delete', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337088037640867841, 'admin', '2020-12-11 01:33:25', 0, 'admin', '2020-12-11 01:33:25', NULL, '', 121426317022334976, 1, 2.00, '', '/xboot/redis/delAll', '清空Redis', '', 3, 'clear', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337088390826430465, 'admin', '2020-12-11 01:34:49', 0, 'admin', '2020-12-11 01:34:49', NULL, '', 1251153074307862528, 1, 1.00, '', '/xboot/app/member/admin/add**', '添加会员', '', 3, 'add', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337088472535666689, 'admin', '2020-12-11 01:35:08', 0, 'admin', '2020-12-11 01:35:08', NULL, '', 1251153074307862528, 1, 2.00, '', '/xboot/app/member/admin/edit**', '编辑会员', '', 3, 'edit', 0, NULL, b'1', b'1', b'0');
INSERT INTO `t_permission` VALUES (1337088563610783745, 'admin', '2020-12-11 01:35:30', 0, 'admin', '2020-12-11 01:35:30', NULL, '', 1251153074307862528, 1, 3.00, '', '/xboot/app/member/delByIds**', '删除会员', '', 3, 'delete', 0, NULL, b'1', b'1', b'0');
COMMIT;

-- ----------------------------
-- Table structure for t_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `permission_id` bigint(20) unsigned DEFAULT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `t_role_permission` VALUES (175877432572645376, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 125909152017944576, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432576839680, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 5129710648430592, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432581033985, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 5129710648430593, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432585228289, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 40238597734928384, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432589422593, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 57009744761589760, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432593616897, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 16392452747300864, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432602005504, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 16392767785668608, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432606199808, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 16439068543946752, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432610394113, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 175808753877127169, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (175877432614588417, NULL, '2019-08-19 22:06:29', 0, NULL, '2019-08-19 22:06:29', 175808922710446081, 16457350655250432);
INSERT INTO `t_role_permission` VALUES (1254788552848445440, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 125909152017944576, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445441, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 5129710648430592, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445442, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 5129710648430593, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445443, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 40238597734928384, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445444, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 43117268627886080, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445445, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 57009744761589760, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445446, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 56309618086776832, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445447, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 44986029924421632, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445448, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 5129710648430594, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445449, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 5129710648430595, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445450, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 75002207560273920, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445451, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 58480609315524608, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445452, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 76606430504816640, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445453, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 81558529864896512, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445454, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 81716172680073216, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445455, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 84083562503999488, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445456, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 82269650301227008, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445457, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 81319435670917120, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445458, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 117806106536841216, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445459, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 76914082455752704, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445460, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 76607201262702592, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445461, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 80539147005071360, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445462, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 211251162815401984, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445463, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 211251678651879424, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445464, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 211652331387752448, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445465, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 39915540965232640, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445466, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41370251991977984, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445467, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41363147411427328, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445468, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 121426317022334976, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445469, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 149452775095275520, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445470, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41371711400054784, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445471, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 39916171171991552, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445472, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 39918482854252544, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445473, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 102235632889237504, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445474, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 102237605176807424, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445475, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 102240052523831296, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445476, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 103658022701633536, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445477, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41373430515240960, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445478, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 129033675403694080, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445479, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41375330996326400, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445480, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 42082442672082944, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445481, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41378916912336896, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445482, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 63741744973352960, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445483, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41376192166629376, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445484, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 41377034236071936, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445485, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 56911328312299520, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445486, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 63482475359244288, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445487, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 64290663792906240, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445488, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 66790433014943744, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445489, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 210154306362413056, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445490, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 210155258859491329, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445491, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 210156371755143168, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445492, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 67027338952445952, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445493, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 67027909637836800, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445494, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 67042515441684480, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445495, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 67082402312228864, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445496, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 113602149589454848, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445497, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 113602342657462272, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445498, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 113603512293658624, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445499, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 113603617897844736, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445500, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 16392452747300864, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445501, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 16392767785668608, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445502, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 16438800255291392, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445503, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 16438962738434048, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445504, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 16439068543946752, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445505, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 175808753877127169, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445506, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 175808922710446081, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445507, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 127996320085446656, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445508, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 160509731956330496, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445509, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 160509918166650881, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445510, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 128366789653434368, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445511, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 128368112335589376, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445512, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 1251152298521006080, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445513, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 1251153074307862528, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445514, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 1251760630449442816, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445515, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 1251761480286736384, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445516, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 127995258721013760, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445517, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 128364633437245440, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445518, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 127996726786134016, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1254788552848445519, 'admin', '2020-04-27 23:04:39', 0, 'admin', '2020-04-27 23:04:39', 127997001756315648, 496138616573953);
INSERT INTO `t_role_permission` VALUES (1337316841210646528, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 125909152017944576, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646529, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 5129710648430592, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646530, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 5129710648430593, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646531, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 15701400130424832, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646532, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16678126574637056, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646533, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 15701915807518720, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646534, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 15708892205944832, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646535, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16678447719911424, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646536, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 25014528525733888, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646537, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 56898976661639168, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646538, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 156365156580855808, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646539, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 40238597734928384, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646540, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45235621697949696, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646541, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45235787867885568, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646542, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45235939278065664, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646543, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 43117268627886080, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646544, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45236734832676864, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646545, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45237010692050944, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646546, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45237170029465600, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646547, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 57009544286441472, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646548, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 57009744761589760, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646549, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 57009981228060672, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646550, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 56309618086776832, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646551, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 57212882168844288, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646552, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 61560041605435392, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646553, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 61560275261722624, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646554, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 61560480518377472, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646555, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 44986029924421632, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646556, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45235228800716800, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646557, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45069342940860416, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646558, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 5129710648430594, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646559, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16687383932047360, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646560, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16689632049631232, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646561, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16689745006432256, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646562, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16689883993083904, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646563, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16690313745666048, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646564, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 5129710648430595, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646565, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16694861252005888, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646566, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16695107491205120, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646567, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16695243126607872, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646568, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 75002207560273920, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646569, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76215889006956544, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646570, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76216071333351424, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646571, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76216264070008832, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646572, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76216459709124608, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646573, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76216594207870976, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646574, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76216702639017984, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646575, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 58480609315524608, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646576, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 61394706252173312, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646577, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 61417744146370560, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646578, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76606430504816640, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646579, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 81558529864896512, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646580, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84082369492946944, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646581, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337084109473845248, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646582, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337084263631294465, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646583, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84082920431554560, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646584, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 81716172680073216, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646585, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84083562503999488, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646586, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1254739560500432897, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646587, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1254739666461134848, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646588, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84083641302388736, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646589, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 113601631450304512, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646590, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84084404707659776, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646591, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 82269650301227008, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646592, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84084724590448640, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646593, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 81319435670917120, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646594, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84084965817454592, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646595, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 117806106536841216, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646596, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337084380564295681, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646597, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76914082455752704, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646598, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84085542324539392, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646599, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337087041741131777, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646600, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84085810797744128, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646601, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84085980943880192, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646602, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84086163001839616, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646603, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84086362248056832, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646604, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 76607201262702592, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646605, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84086882907983872, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646606, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84087009940869120, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646607, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84087154040377344, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646608, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 80539147005071360, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646609, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84087344352727040, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646610, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84087480852156416, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646611, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 84087593041399808, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646612, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 211251162815401984, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646613, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 211251678651879424, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646614, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337087257902977024, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646615, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337087482155634689, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646616, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337087364513796097, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646617, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 211652331387752448, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646618, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 39915540965232640, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646619, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41370251991977984, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646620, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45264987354042368, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646621, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45265487029866496, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646622, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45265762415284224, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646623, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45265886315024384, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646624, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 45266070000373760, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646625, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41363147411427328, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646626, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41363537456533504, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646627, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41364927394353152, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646628, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 121426317022334976, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646629, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337087799127576577, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646630, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337087867276627969, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646631, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337087940756639745, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646632, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337088037640867841, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646633, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 149452775095275520, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646634, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41371711400054784, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646635, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41469219249852416, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646636, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 39916171171991552, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646637, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 39918482854252544, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646638, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 102235632889237504, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646639, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 102237605176807424, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646640, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 102240052523831296, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646641, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 103658022701633536, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646642, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41373430515240960, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646643, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 129033675403694080, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646644, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41375330996326400, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646645, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 42082442672082944, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646646, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41378916912336896, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646647, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 63741744973352960, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646648, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41376192166629376, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646649, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 41377034236071936, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646650, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 56911328312299520, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646651, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 63482475359244288, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646652, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 64290663792906240, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646653, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 66790433014943744, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646654, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 210154306362413056, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646655, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 210155258859491329, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646656, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 210156371755143168, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646657, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 67027338952445952, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646658, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 67027909637836800, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646659, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 67042515441684480, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646660, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 67082402312228864, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646661, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 113602149589454848, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646662, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 113602342657462272, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646663, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 113603512293658624, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646664, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 113603617897844736, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646665, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16392452747300864, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646666, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16392767785668608, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646667, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16438800255291392, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646668, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16438962738434048, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646669, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 16439068543946752, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646670, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 175808753877127169, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646671, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 175808922710446081, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646672, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 127996320085446656, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646673, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 160509731956330496, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646674, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 160509918166650881, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646675, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 128366789653434368, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646676, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 128368112335589376, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646677, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1251152298521006080, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646678, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1251153074307862528, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646679, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337088390826430465, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646680, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337088472535666689, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646681, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1337088563610783745, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646682, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1251760630449442816, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646683, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 1251761480286736384, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646684, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 127995258721013760, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646685, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 128364633437245440, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646686, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 127996726786134016, 496138616573952);
INSERT INTO `t_role_permission` VALUES (1337316841210646687, 'admin', '2020-12-11 16:42:36', 0, 'admin', '2020-12-11 16:42:36', 127997001756315648, 496138616573952);
COMMIT;

-- ----------------------------
-- Table structure for t_quartz_job
-- ----------------------------
DROP TABLE IF EXISTS `t_quartz_job`;
CREATE TABLE `t_quartz_job` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `cron_expression` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `job_class_name` varchar(255) DEFAULT NULL,
  `parameter` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `default_role` bit(1) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `data_type` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES (496138616573952, '', '2018-04-22 23:03:49', 'admin', '2018-11-15 23:02:59', 'ROLE_ADMIN', 0, NULL, '超级管理员 拥有所有权限', 0);
INSERT INTO `t_role` VALUES (496138616573953, '', '2018-05-02 21:40:03', 'admin', '2018-11-01 22:59:48', 'ROLE_USER', 0, b'1', '普通注册用户 路过看看', 0);
INSERT INTO `t_role` VALUES (16457350655250432, '', '2018-06-06 00:08:00', 'admin', '2018-11-02 20:42:24', 'ROLE_TEST', 0, NULL, '测试权限按钮显示', 1);
COMMIT;

-- ----------------------------
-- Table structure for t_role_department
-- ----------------------------
DROP TABLE IF EXISTS `t_role_department`;
CREATE TABLE `t_role_department` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `department_id` bigint(20) unsigned DEFAULT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role_department
-- ----------------------------
BEGIN;
INSERT INTO `t_role_department` VALUES (70763874256687105, 'admin', '2018-11-02 20:42:43', 0, 'admin', '2018-11-02 20:42:43', 40322777781112832, 16457350655250432);
INSERT INTO `t_role_department` VALUES (70763874265075712, 'admin', '2018-11-02 20:42:43', 0, 'admin', '2018-11-02 20:42:43', 40322811096469504, 16457350655250432);
INSERT INTO `t_role_department` VALUES (70763874277658624, 'admin', '2018-11-02 20:42:43', 0, 'admin', '2018-11-02 20:42:43', 40322852833988608, 16457350655250432);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `department_id` bigint(20) unsigned DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `pass_strength` varchar(2) DEFAULT NULL,
  `department_title` varchar(255) DEFAULT NULL,
  `birth` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `email` (`email`) USING BTREE,
  UNIQUE KEY `mobile` (`mobile`) USING BTREE,
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (682265633886208, '', '2018-05-01 03:13:51', 'admin', '2020-04-30 04:56:32', '北京市,市辖区,东城区', 'https://ooo.0o0.ooo/2019/04/28/5cc5a71a6e3b6.png', '我是大帅逼', 'admin@exrick.cn', '18782059031', '管理员', '$2a$10$PS04ecXfknNd3V8d.ymLTObQciapMU4xU8.GADBZZsuTZr7ymnagy', '男', 0, 1, 'admin', 0, 40322777781112832, '天府1街', '弱', '总部', '2020-04-15 11:00:00.000000');
INSERT INTO `t_user` VALUES (682265633886209, '', '2018-04-30 23:28:42', 'admin', '2020-04-12 13:57:08', '北京市,市辖区,东城区', 'https://ooo.0o0.ooo/2019/04/28/5cc5a71a6e3b6.png', '', 'Exrick@exrick.cn', '18782059032', 'exrick', '$2a$10$PS04ecXfknNd3V8d.ymLTObQciapMU4xU8.GADBZZsuTZr7ymnagy', '女', -1, 0, 'Exrick', 0, 40343262766043136, '', '弱', '成都分部', '2020-04-13 00:00:00.000000');
INSERT INTO `t_user` VALUES (4363087427670016, '', '2018-05-03 15:09:42', 'admin', '2020-04-18 22:24:08', '北京市,市辖区,东城区', 'https://ooo.0o0.ooo/2019/04/28/5cc5a71a6e3b6.png', '', 'test@exrick.cn', '18782059033', '游客1', '$2a$10$PS04ecXfknNd3V8d.ymLTObQciapMU4xU8.GADBZZsuTZr7ymnagy', '男', 0, 0, 'test', 0, 40343262766043136, '', '弱', '成都分部', '2020-04-28 00:00:00.000000');
INSERT INTO `t_user` VALUES (16739222421508096, '', '2018-06-06 18:48:02', 'admin', '2020-04-30 03:13:37', '北京市,市辖区,东城区', 'https://ooo.0o0.ooo/2019/04/28/5cc5a71a6e3b6.png', '', 'test2@exrick.cn', '18782059034', '游客2', '$2a$10$PS04ecXfknNd3V8d.ymLTObQciapMU4xU8.GADBZZsuTZr7ymnagy', '男', 0, 0, 'test2', 0, 40322777781112832, '', '弱', '总部', '2020-04-22 11:00:00.000000');
COMMIT;

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` bigint(20) unsigned NOT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` tinyint(1) DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_user_role` VALUES (1251516834239352832, 'admin', '2020-04-18 22:24:00', 0, 'admin', '2020-04-18 22:24:00', 496138616573952, 682265633886209);
INSERT INTO `t_user_role` VALUES (1251516834239352833, 'admin', '2020-04-18 22:24:00', 0, 'admin', '2020-04-18 22:24:00', 496138616573953, 682265633886209);
INSERT INTO `t_user_role` VALUES (1251516869526032384, 'admin', '2020-04-18 22:24:08', 0, 'admin', '2020-04-18 22:24:08', 496138616573953, 4363087427670016);
INSERT INTO `t_user_role` VALUES (1254427593457930240, 'admin', '2020-04-26 23:10:19', 0, 'admin', '2020-04-26 23:10:19', 496138616573952, 682265633886208);
INSERT INTO `t_user_role` VALUES (1255772277023313920, 'admin', '2020-04-30 03:13:37', 0, 'admin', '2020-04-30 03:13:37', 16457350655250432, 16739222421508096);
COMMIT;

DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
DROP TABLE IF EXISTS QRTZ_LOCKS;
DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
DROP TABLE IF EXISTS QRTZ_CALENDARS;


CREATE TABLE QRTZ_JOB_DETAILS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    JOB_NAME  VARCHAR(200) NOT NULL,
    JOB_GROUP VARCHAR(200) NOT NULL,
    DESCRIPTION VARCHAR(250) NULL,
    JOB_CLASS_NAME   VARCHAR(250) NOT NULL,
    IS_DURABLE VARCHAR(1) NOT NULL,
    IS_NONCONCURRENT VARCHAR(1) NOT NULL,
    IS_UPDATE_DATA VARCHAR(1) NOT NULL,
    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    JOB_NAME  VARCHAR(200) NOT NULL,
    JOB_GROUP VARCHAR(200) NOT NULL,
    DESCRIPTION VARCHAR(250) NULL,
    NEXT_FIRE_TIME BIGINT(13) NULL,
    PREV_FIRE_TIME BIGINT(13) NULL,
    PRIORITY INTEGER NULL,
    TRIGGER_STATE VARCHAR(16) NOT NULL,
    TRIGGER_TYPE VARCHAR(8) NOT NULL,
    START_TIME BIGINT(13) NOT NULL,
    END_TIME BIGINT(13) NULL,
    CALENDAR_NAME VARCHAR(200) NULL,
    MISFIRE_INSTR SMALLINT(2) NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
        REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_SIMPLE_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) 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),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_CRON_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    CRON_EXPRESSION VARCHAR(200) NOT NULL,
    TIME_ZONE_ID VARCHAR(80),
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_SIMPROP_TRIGGERS
  (          
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    STR_PROP_1 VARCHAR(512) NULL,
    STR_PROP_2 VARCHAR(512) NULL,
    STR_PROP_3 VARCHAR(512) NULL,
    INT_PROP_1 INT NULL,
    INT_PROP_2 INT NULL,
    LONG_PROP_1 BIGINT NULL,
    LONG_PROP_2 BIGINT NULL,
    DEC_PROP_1 NUMERIC(13,4) NULL,
    DEC_PROP_2 NUMERIC(13,4) NULL,
    BOOL_PROP_1 VARCHAR(1) NULL,
    BOOL_PROP_2 VARCHAR(1) NULL,
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) 
    REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_BLOB_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    BLOB_DATA BLOB NULL,
    PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_CALENDARS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    CALENDAR_NAME  VARCHAR(200) NOT NULL,
    CALENDAR BLOB NOT NULL,
    PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_GROUP  VARCHAR(200) NOT NULL, 
    PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_FIRED_TRIGGERS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    ENTRY_ID VARCHAR(95) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    INSTANCE_NAME VARCHAR(200) NOT NULL,
    FIRED_TIME BIGINT(13) NOT NULL,
    SCHED_TIME BIGINT(13) NOT NULL,
    PRIORITY INTEGER NOT NULL,
    STATE VARCHAR(16) NOT NULL,
    JOB_NAME VARCHAR(200) NULL,
    JOB_GROUP VARCHAR(200) NULL,
    IS_NONCONCURRENT VARCHAR(1) NULL,
    REQUESTS_RECOVERY VARCHAR(1) NULL,
    PRIMARY KEY (SCHED_NAME,ENTRY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_SCHEDULER_STATE
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    INSTANCE_NAME VARCHAR(200) NOT NULL,
    LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
    CHECKIN_INTERVAL BIGINT(13) NOT NULL,
    PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_LOCKS
  (
    SCHED_NAME VARCHAR(120) NOT NULL,
    LOCK_NAME  VARCHAR(40) NOT NULL, 
    PRIMARY KEY (SCHED_NAME,LOCK_NAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;