text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 127.0.0.1
   Source Server Type    : MySQL
   Source Server Version : 50722
   Source Host           : 127.0.0.1:3306
   Source Schema         : lamp_base_0000
  
   Target Server Type    : MySQL
   Target Server Version : 50722
   File Encoding         : 65001
  
   Date: 08/12/2020 11:08:48
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for c_application
  -- ----------------------------
  DROP TABLE IF EXISTS `c_application`;
  CREATE TABLE `c_application` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `client_id` varchar(24) DEFAULT '' COMMENT '客户端ID',
    `client_secret` varchar(32) DEFAULT '' COMMENT '客户端密码',
    `website` varchar(100) DEFAULT '' COMMENT '官网',
    `name` varchar(255) NOT NULL DEFAULT '' COMMENT '应用名称',
    `icon` varchar(255) DEFAULT '' COMMENT '应用图标',
    `app_type` varchar(10) DEFAULT '' COMMENT '类型 \n#{SERVER:服务应用;APP:手机应用;PC:PC网页应用;WAP:手机网页应用}',
    `describe_` varchar(200) DEFAULT '' COMMENT '备注',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人id',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_client_id` (`client_id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='应用';
  
  -- ----------------------------
  -- Records of c_application
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_application` VALUES (1, 'lamp_web', 'lamp_web_secret', 'http://tangyh.top:10000/zuihou-ui/', 'lamp快速开发平台', NULL, 'PC', '内置', b'1', 1, '2020-04-02 15:05:14', 1, '2020-04-02 15:05:17');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_area
  -- ----------------------------
  DROP TABLE IF EXISTS `c_area`;
  CREATE TABLE `c_area` (
    `id` bigint(20) NOT NULL COMMENT 'id',
    `code` varchar(64) NOT NULL COMMENT '编码',
    `label` varchar(255) NOT NULL COMMENT '名称',
    `full_name` varchar(255) DEFAULT '' COMMENT '全名',
    `sort_value` int(10) DEFAULT '1' COMMENT '排序',
    `longitude` varchar(255) DEFAULT '' COMMENT '经度',
    `latitude` varchar(255) DEFAULT '' COMMENT '维度',
    `level` varchar(10) DEFAULT '' COMMENT '行政区级 \n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.AREA_LEVEL) RemoteData<String, String>',
    `source_` varchar(255) DEFAULT '' COMMENT '数据来源',
    `state` bit(1) DEFAULT b'0' COMMENT '状态',
    `parent_id` bigint(20) DEFAULT '0' COMMENT '父ID',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_code` (`code`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='地区表';
  
  -- ----------------------------
  -- Table structure for c_attachment
  -- ----------------------------
  DROP TABLE IF EXISTS `c_attachment`;
  CREATE TABLE `c_attachment` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `biz_id` varchar(64) DEFAULT NULL COMMENT '业务ID',
    `biz_type` varchar(255) DEFAULT '' COMMENT '业务类型 \n#AttachmentType',
    `data_type` varchar(255) DEFAULT '' COMMENT '数据类型 \n#DataType{DIR:目录;IMAGE:图片;VIDEO:视频;AUDIO:音频;DOC:文档;OTHER:其他}',
    `submitted_file_name` varchar(255) DEFAULT '' COMMENT '原始文件名',
    `group_` varchar(255) DEFAULT '' COMMENT 'FastDFS返回的组\n用于FastDFS',
    `path` varchar(255) DEFAULT '' COMMENT 'FastDFS的远程文件名\n用于FastDFS',
    `relative_path` varchar(255) DEFAULT '' COMMENT '文件相对路径',
    `url` varchar(255) DEFAULT '' COMMENT '文件访问链接\n需要通过nginx配置路由，才能访问',
    `file_md5` varchar(255) DEFAULT '' COMMENT '文件md5值',
    `context_type` varchar(255) DEFAULT '' COMMENT '文件上传类型\n取上传文件的值',
    `filename` varchar(255) DEFAULT '' COMMENT '唯一文件名',
    `ext` varchar(64) DEFAULT '' COMMENT '后缀\n (没有.)',
    `size` bigint(20) DEFAULT '0' COMMENT '大小',
    `org_id` bigint(20) DEFAULT NULL COMMENT '组织ID \n#c_org',
    `icon` varchar(64) DEFAULT '' COMMENT '图标',
    `create_month` char(8) DEFAULT '' COMMENT '创建年月 \n格式：yyyy年MM周 用于统计',
    `create_week` char(8) DEFAULT '' COMMENT '创建时处于当年的第几周 \n格式：yyyy年ww周 用于统计',
    `create_day` char(11) DEFAULT '' COMMENT '创建年月日 \n格式： yyyy年MM月dd日',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '最后修改时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '最后修改人',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='附件';
  
  -- ----------------------------
  -- Table structure for c_dictionary
  -- ----------------------------
  DROP TABLE IF EXISTS `c_dictionary`;
  CREATE TABLE `c_dictionary` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `type` varchar(255) NOT NULL COMMENT '类型',
    `label` varchar(255) NOT NULL DEFAULT '' COMMENT '类型标签',
    `code` varchar(64) NOT NULL COMMENT '编码',
    `name` varchar(64) NOT NULL COMMENT '名称',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `describe_` varchar(255) DEFAULT '' COMMENT '描述',
    `sort_value` int(10) DEFAULT '1' COMMENT '排序',
    `icon` varchar(255) DEFAULT '' COMMENT '图标',
    `css_style` varchar(255) DEFAULT '' COMMENT 'css样式',
    `css_class` varchar(255) DEFAULT '' COMMENT 'css class',
    `readonly_` bit(1) DEFAULT b'0' COMMENT '内置',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人id',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_type_code` (`type`,`code`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典项';
  
  -- ----------------------------
  -- Records of c_dictionary
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_dictionary` VALUES (1, 'AREA_LEVEL', '行政区划', '01', '国家', b'1', '', 1, '', '', '', b'1', 3, '2020-01-20 15:12:57', 3, '2020-01-20 15:12:57');
  INSERT INTO `c_dictionary` VALUES (2, 'AREA_LEVEL', '行政区划', '02', '省份/直辖市', b'1', '', 2, '', '', '', b'1', 3, '2020-01-20 15:13:45', 3, '2020-01-20 15:13:45');
  INSERT INTO `c_dictionary` VALUES (3, 'AREA_LEVEL', '行政区划', '03', '地市', b'1', '', 3, '', '', '', b'1', 3, '2020-01-20 15:14:16', 3, '2020-01-20 15:14:16');
  INSERT INTO `c_dictionary` VALUES (4, 'AREA_LEVEL', '行政区划', '04', '区县', b'1', '', 4, '', '', '', b'1', 3, '2020-01-20 15:14:54', 3, '2020-01-20 15:14:54');
  INSERT INTO `c_dictionary` VALUES (5, 'AREA_LEVEL', '行政区划', '05', '乡镇', b'1', '', 5, '', '', '', b'1', 3, '2020-03-09 23:33:46', 3, '2020-03-09 23:33:46');
  INSERT INTO `c_dictionary` VALUES (10, 'EDUCATION', '学历', '01', '小学', b'1', '', 1, '', '', '', b'1', 3, '2020-03-09 23:34:13', 3, '2020-03-09 23:34:13');
  INSERT INTO `c_dictionary` VALUES (11, 'EDUCATION', '学历', '02', '中学', b'1', '', 2, '', '', '', b'1', 3, '2020-03-09 23:34:32', 3, '2020-03-09 23:34:32');
  INSERT INTO `c_dictionary` VALUES (12, 'EDUCATION', '学历', '03', '高中', b'1', '', 3, '', '', '', b'1', 3, '2020-03-09 23:34:40', 3, '2020-03-09 23:34:40');
  INSERT INTO `c_dictionary` VALUES (13, 'EDUCATION', '学历', '04', '专科', b'1', '', 4, '', '', '', b'1', 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
  INSERT INTO `c_dictionary` VALUES (14, 'EDUCATION', '学历', '05', '本科', b'1', '', 5, '', '', '', b'1', 1, '2019-06-04 11:36:19', 1, '2019-06-04 11:36:19');
  INSERT INTO `c_dictionary` VALUES (15, 'EDUCATION', '学历', '06', '硕士', b'1', '', 6, '', '', '', b'1', 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
  INSERT INTO `c_dictionary` VALUES (16, 'EDUCATION', '学历', '07', '博士', b'1', '', 7, '', '', '', b'1', 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
  INSERT INTO `c_dictionary` VALUES (17, 'EDUCATION', '学历', '08', '博士后', b'1', '', 8, '', '', '', b'1', 1, '2019-06-04 11:36:29', 1, '2019-06-04 11:36:29');
  INSERT INTO `c_dictionary` VALUES (29, 'EDUCATION', '学历', '20', '其他', b'1', '', 20, '', '', '', b'1', 3, '2020-03-09 23:34:54', 3, '2020-03-09 23:34:54');
  INSERT INTO `c_dictionary` VALUES (40, 'ORG_TYPE', '机构类型', '01', '单位', b'1', '', 1, '', '', '', b'1', 1, '2020-11-23 21:13:17', 1, '2020-11-23 21:13:17');
  INSERT INTO `c_dictionary` VALUES (41, 'ORG_TYPE', '机构类型', '02', '部门', b'1', '', 2, '', '', '', b'1', 1, '2020-11-23 21:13:17', 1, '2020-11-23 21:13:17');
  INSERT INTO `c_dictionary` VALUES (43, 'NATION', '民族', '01', '汉族', b'1', '', 0, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (44, 'NATION', '民族', '02', '壮族', b'1', '', 1, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (45, 'NATION', '民族', '03', '满族', b'1', '', 2, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (46, 'NATION', '民族', '04', '回族', b'1', '', 3, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (47, 'NATION', '民族', '05', '苗族', b'1', '', 4, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (48, 'NATION', '民族', '06', '维吾尔族', b'1', '', 5, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (49, 'NATION', '民族', '07', '土家族', b'1', '', 6, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (50, 'NATION', '民族', '08', '彝族', b'1', '', 7, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (51, 'NATION', '民族', '09', '蒙古族', b'1', '', 8, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (52, 'NATION', '民族', '10', '藏族', b'1', '', 9, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (53, 'NATION', '民族', '11', '布依族', b'1', '', 10, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (54, 'NATION', '民族', '12', '侗族', b'1', '', 11, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (55, 'NATION', '民族', '13', '瑶族', b'1', '', 12, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (56, 'NATION', '民族', '14', '朝鲜族', b'1', '', 13, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (57, 'NATION', '民族', '15', '白族', b'1', '', 14, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (58, 'NATION', '民族', '16', '哈尼族', b'1', '', 15, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (59, 'NATION', '民族', '17', '哈萨克族', b'1', '', 16, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (60, 'NATION', '民族', '18', '黎族', b'1', '', 17, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (61, 'NATION', '民族', '19', '傣族', b'1', '', 18, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (62, 'NATION', '民族', '20', '畲族', b'1', '', 19, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (63, 'NATION', '民族', '21', '傈僳族', b'1', '', 20, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (64, 'NATION', '民族', '22', '仡佬族', b'1', '', 21, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (65, 'NATION', '民族', '23', '东乡族', b'1', '', 22, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (66, 'NATION', '民族', '24', '高山族', b'1', '', 23, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (67, 'NATION', '民族', '25', '拉祜族', b'1', '', 24, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (68, 'NATION', '民族', '26', '水族', b'1', '', 25, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (69, 'NATION', '民族', '27', '佤族', b'1', '', 26, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (70, 'NATION', '民族', '28', '纳西族', b'1', '', 27, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (71, 'NATION', '民族', '29', '羌族', b'1', '', 28, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (72, 'NATION', '民族', '30', '土族', b'1', '', 29, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (73, 'NATION', '民族', '31', '仫佬族', b'1', '', 30, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (74, 'NATION', '民族', '32', '锡伯族', b'1', '', 31, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (75, 'NATION', '民族', '33', '柯尔克孜族', b'1', '', 32, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (76, 'NATION', '民族', '34', '达斡尔族', b'1', '', 33, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (77, 'NATION', '民族', '35', '景颇族', b'1', '', 34, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (78, 'NATION', '民族', '36', '毛南族', b'1', '', 35, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (79, 'NATION', '民族', '37', '撒拉族', b'1', '', 36, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (80, 'NATION', '民族', '38', '塔吉克族', b'1', '', 37, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (81, 'NATION', '民族', '39', '阿昌族', b'1', '', 38, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (82, 'NATION', '民族', '40', '普米族', b'1', '', 39, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (83, 'NATION', '民族', '41', '鄂温克族', b'1', '', 40, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (84, 'NATION', '民族', '42', '怒族', b'1', '', 41, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (85, 'NATION', '民族', '43', '京族', b'1', '', 42, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (86, 'NATION', '民族', '44', '基诺族', b'1', '', 43, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (87, 'NATION', '民族', '45', '德昂族', b'1', '', 44, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (88, 'NATION', '民族', '46', '保安族', b'1', '', 45, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (89, 'NATION', '民族', '47', '俄罗斯族', b'1', '', 46, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (90, 'NATION', '民族', '48', '裕固族', b'1', '', 47, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (91, 'NATION', '民族', '49', '乌兹别克族', b'1', '', 48, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (92, 'NATION', '民族', '50', '门巴族', b'1', '', 49, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (93, 'NATION', '民族', '51', '鄂伦春族', b'1', '', 50, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (94, 'NATION', '民族', '52', '独龙族', b'1', '', 51, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (95, 'NATION', '民族', '53', '塔塔尔族', b'1', '', 52, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (96, 'NATION', '民族', '54', '赫哲族', b'1', '', 53, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (97, 'NATION', '民族', '55', '珞巴族', b'1', '', 54, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (98, 'NATION', '民族', '56', '布朗族', b'1', '', 55, '', '', '', b'1', 1, '2018-03-15 20:11:01', 1, '2018-03-15 20:11:04');
  INSERT INTO `c_dictionary` VALUES (99, 'NATION', '民族', '57', '其他', b'1', '', 100, '', '', '', b'1', 3, '2020-03-09 23:38:29', 3, '2020-03-09 23:38:29');
  INSERT INTO `c_dictionary` VALUES (110, 'POSITION_STATUS', '职位状态', '01', '在职', b'1', '', 1, '', '', '', b'1', 1, '2019-06-04 11:38:16', 1, '2019-06-04 11:38:16');
  INSERT INTO `c_dictionary` VALUES (111, 'POSITION_STATUS', '职位状态', '02', '请假', b'1', '', 2, '', '', '', b'1', 3, '2020-03-09 23:39:30', 3, '2020-03-09 23:39:30');
  INSERT INTO `c_dictionary` VALUES (112, 'POSITION_STATUS', '职位状态', '03', '离职', b'1', '', 3, '', '', '', b'1', 1, '2019-06-04 11:38:50', 1, '2019-06-04 11:38:50');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_login_log
  -- ----------------------------
  DROP TABLE IF EXISTS `c_login_log`;
  CREATE TABLE `c_login_log` (
    `id` bigint(20) NOT NULL COMMENT '主键',
    `request_ip` varchar(50) DEFAULT '' COMMENT '登录IP',
    `user_id` bigint(20) DEFAULT NULL COMMENT '登录人ID',
    `user_name` varchar(50) DEFAULT '' COMMENT '登录人姓名',
    `account` varchar(30) DEFAULT '' COMMENT '登录人账号',
    `description` varchar(255) DEFAULT '' COMMENT '登录描述',
    `login_date` char(10) DEFAULT '' COMMENT '登录时间',
    `ua` varchar(500) DEFAULT '' COMMENT '浏览器请求头',
    `browser` varchar(255) DEFAULT '' COMMENT '浏览器名称',
    `browser_version` varchar(255) DEFAULT '' COMMENT '浏览器版本',
    `operating_system` varchar(255) DEFAULT '' COMMENT '操作系统',
    `location` varchar(50) DEFAULT '' COMMENT '登录地点',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='登录日志';
  
  -- ----------------------------
  -- Table structure for c_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `c_menu`;
  CREATE TABLE `c_menu` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `label` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
    `describe_` varchar(200) DEFAULT '' COMMENT '描述',
    `is_general` bit(1) DEFAULT b'0' COMMENT '通用菜单 \nTrue表示无需分配所有人就可以访问的',
    `path` varchar(255) DEFAULT '' COMMENT '路径',
    `component` varchar(255) DEFAULT '' COMMENT '组件',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `sort_value` int(10) DEFAULT '1' COMMENT '排序',
    `icon` varchar(255) DEFAULT '' COMMENT '菜单图标',
    `group_` varchar(20) DEFAULT '' COMMENT '分组',
    `parent_id` bigint(20) DEFAULT '0' COMMENT '父级菜单ID',
    `readonly_` bit(1) DEFAULT b'0' COMMENT '内置',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人id',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_path` (`path`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='菜单';
  
  -- ----------------------------
  -- Records of c_menu
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_menu` VALUES (10, '租户设置', '', b'0', '/tenant', 'Layout', b'1', 10, 'fa fa-object-group', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (20, '工作台', '', b'0', '/workbench', 'Layout', b'1', 20, 'fa fa-tachometer', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (30, '组织管理', '', b'0', '/org', 'Layout', b'1', 30, 'fa fa-users', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (40, '资源中心', '', b'0', '/resources', 'Layout', b'1', 40, 'fa fa-cloud', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (60, '系统设置', '', b'0', '/system', 'Layout', b'1', 60, 'fa fa-gears', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (80, '开发者管理', '', b'0', '/developer', 'Layout', b'1', 80, 'fa fa-bug', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (90, '了解lamp', '', b'1', '/community', 'Layout', b'1', 90, 'fa fa-github-square', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (100, '更多功能', '', b'1', '/more', 'Layout', b'1', 100, 'fa fa-th-large', '', 0, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (110, '租户管理', '', b'0', '/tenant/tenant', 'lamp/tenant/tenant/index', b'1', 20, '', '', 10, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-25 16:20:26');
  INSERT INTO `c_menu` VALUES (111, '超级用户', '', b'0', '/tenant/user', 'lamp/tenant/user/index', b'1', 30, '', '', 10, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-25 16:20:30');
  INSERT INTO `c_menu` VALUES (120, '通知公告', '', b'0', '/workbench/notice', 'lamp/workbench/notice/index', b'1', 10, '', '', 20, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (121, '待我审批', '', b'0', '/workbench/todo', 'lamp/workbench/todo/index', b'1', 20, '', '', 20, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (122, '我已审批', '', b'0', '/workbench/done', 'lamp/workbench/done/index', b'1', 30, '', '', 20, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (123, '我发起的', '', b'0', '/workbench/started', 'lamp/workbench/started/index', b'1', 40, '', '', 20, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (130, '机构管理', '', b'0', '/org/org', 'lamp/org/org/index', b'1', 10, '', '', 30, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (131, '岗位管理', '', b'0', '/org/station', 'lamp/org/station/index', b'1', 20, '', '', 30, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (132, '用户管理', '', b'0', '/org/user', 'lamp/org/user/index', b'1', 30, '', '', 30, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (140, '消息中心', '', b'0', '/resources/msg', 'lamp/resources/msg/index', b'1', 10, '', '', 40, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (141, '短信模版', '', b'0', '/resources/smsTemplate', 'lamp/resources/smsTemplate/index', b'1', 20, '', '', 40, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (142, '短信中心', '', b'0', '/resources/sms', 'lamp/resources/sms/index', b'1', 30, '', '', 40, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (143, '附件管理', '', b'0', '/resources/attachment', 'lamp/resources/attachment/index', b'1', 40, '', '', 40, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (160, '菜单管理', '', b'0', '/system/menu', 'lamp/system/menu/index', b'1', 10, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (161, '角色管理', '', b'0', '/system/role', 'lamp/system/role/index', b'1', 20, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (162, '字典管理', '', b'0', '/system/dictionary', 'lamp/system/dictionary/index', b'1', 30, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (163, '地区管理', '', b'0', '/system/area', 'lamp/system/area/index', b'1', 40, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (164, '参数管理', '', b'0', '/system/parameter', 'lamp/system/parameter/index', b'1', 50, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (165, '操作日志', '', b'0', '/system/optLog', 'lamp/system/optLog/index', b'1', 60, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (166, '登录日志', '', b'0', '/system/loginLog', 'lamp/system/loginLog/index', b'1', 70, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (167, '在线用户', '', b'0', '/system/online', 'lamp/system/online/index', b'1', 80, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (168, '应用管理', '', b'0', '/system/application', 'lamp/system/application/index', b'1', 90, '', '', 60, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (190, '定时任务', '', b'0', 'http://127.0.0.1:8767/zuihou-jobs-server', 'Layout', b'1', 10, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (191, '接口文档', '', b'0', 'http://127.0.0.1:8760/api/gate/doc.html', 'Layout', b'1', 20, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (192, 'nacos', '', b'0', 'http://127.0.0.1:8848/nacos', 'Layout', b'1', 30, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (193, '服务监控', '', b'0', 'http://127.0.0.1:8762/lamp-monitor', 'Layout', b'1', 40, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (194, '数据库监控', '', b'0', '/developer/db', 'lamp/developer/db/index', b'1', 50, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (195, '缓存监控', '', b'0', 'https://github.com/junegunn/redis-stat', 'Layout', b'1', 60, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (196, 'zipkin监控', '', b'0', 'http://127.0.0.1:8772/zipkin', 'Layout', b'1', 70, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (197, 'SkyWalking监控', '', b'0', 'http://127.0.0.1:12080', 'Layout', b'1', 80, '', '', 80, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (210, '在线文档', '', b'1', 'https://www.kancloud.cn/zuihou/zuihou-admin-cloud', 'Layout', b'1', 10, '', '', 90, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (211, '会员版', '', b'1', 'https://www.kancloud.cn/zuihou/zuihou-admin-cloud/2003629', 'Layout', b'1', 20, '', '', 90, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (212, '获取源码', '', b'1', 'https://github.com/zuihou', 'Layout', b'1', 30, '', '', 90, b'1', 1, '2020-11-23 11:47:31', 2, '2020-12-01 11:34:20');
  INSERT INTO `c_menu` VALUES (213, '问题反馈', '', b'1', 'https://github.com/zuihou/lamp-cloud/issues', 'Layout', b'1', 40, '', '', 90, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (214, '更新日志', '', b'1', 'https://www.kancloud.cn/zuihou/zuihou-admin-cloud/1465302', 'Layout', b'1', 50, '', '', 90, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (215, '蓝图', '', b'1', 'https://www.kancloud.cn/zuihou/zuihou-admin-cloud/2003640', 'Layout', b'1', 60, '', '', 90, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (220, '多级菜单', '', b'1', '/more/multiMenu', 'Layout', b'1', 1, '', '', 100, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (221, '菜单1-1', '', b'1', '/more/multiMenu/menu1-1', 'Layout', b'1', 1, '', '', 220, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (222, '菜单1-1-1', '', b'1', '/more/multiMenu/menu1-1/menu1-1-1', 'lamp/more/multiMenu/menu1-1/menu1-1-1/index', b'1', 1, '', '', 221, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (223, '菜单1-1-2', '', b'1', '/more/multiMenu/menu1-1/menu1-1-2', 'lamp/more/multiMenu/menu1-1/menu1-1-2/index', b'1', 2, '', '', 221, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  INSERT INTO `c_menu` VALUES (224, '菜单1-2', '', b'1', '/more/multiMenu/menu1-2', 'lamp/more/multiMenu/menu1-2/index', b'1', 2, '', '', 220, b'1', 1, '2020-11-23 11:47:31', 1, '2020-11-23 11:47:31');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_opt_log
  -- ----------------------------
  DROP TABLE IF EXISTS `c_opt_log`;
  CREATE TABLE `c_opt_log` (
    `id` bigint(20) NOT NULL COMMENT '主键',
    `request_ip` varchar(50) DEFAULT '' COMMENT '操作IP',
    `type` varchar(5) DEFAULT '' COMMENT '日志类型 \n#LogType{OPT:操作类型;EX:异常类型}',
    `user_name` varchar(50) DEFAULT '' COMMENT '操作人',
    `description` varchar(255) DEFAULT '' COMMENT '操作描述',
    `class_path` varchar(255) DEFAULT '' COMMENT '类路径',
    `action_method` varchar(50) DEFAULT '' COMMENT '请求方法',
    `request_uri` varchar(50) DEFAULT '' COMMENT '请求地址',
    `http_method` varchar(10) DEFAULT '' COMMENT '请求类型 \n#HttpMethod{GET:GET请求;POST:POST请求;PUT:PUT请求;DELETE:DELETE请求;PATCH:PATCH请求;TRACE:TRACE请求;HEAD:HEAD请求;OPTIONS:OPTIONS请求;}',
    `start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间',
    `finish_time` timestamp NULL DEFAULT NULL COMMENT '完成时间',
    `consuming_time` bigint(20) DEFAULT NULL COMMENT '消耗时间',
    `ua` varchar(500) DEFAULT '' COMMENT '浏览器',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统日志';
  
  -- ----------------------------
  -- Table structure for c_opt_log_ext
  -- ----------------------------
  DROP TABLE IF EXISTS `c_opt_log_ext`;
  CREATE TABLE `c_opt_log_ext` (
    `id` bigint(20) NOT NULL COMMENT '主键',
    `params` longtext COMMENT '请求参数',
    `result` longtext COMMENT '返回值',
    `ex_detail` longtext COMMENT '异常描述',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统日志扩展';
  
  -- ----------------------------
  -- Table structure for c_org
  -- ----------------------------
  DROP TABLE IF EXISTS `c_org`;
  CREATE TABLE `c_org` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `label` varchar(255) NOT NULL COMMENT '名称',
    `type_` char(2) DEFAULT '' COMMENT '类型 \n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.ORG_TYPE) RemoteData<String, String>',
    `abbreviation` varchar(255) DEFAULT '' COMMENT '简称',
    `parent_id` bigint(20) DEFAULT '0' COMMENT '父ID',
    `tree_path` varchar(255) DEFAULT '' COMMENT '树结构',
    `sort_value` int(10) DEFAULT '1' COMMENT '排序',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `describe_` varchar(255) DEFAULT '' COMMENT '描述',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '修改人',
    PRIMARY KEY (`id`) USING BTREE,
    FULLTEXT KEY `fu_path` (`tree_path`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='组织';
  
  -- ----------------------------
  -- Records of c_org
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_org` VALUES (1, '最后集团', '01', '', 0, ',', 1, b'1', '', '2020-11-23 00:05:55', 1, '2020-11-23 00:05:59', 1);
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_parameter
  -- ----------------------------
  DROP TABLE IF EXISTS `c_parameter`;
  CREATE TABLE `c_parameter` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `key_` varchar(255) NOT NULL COMMENT '参数键',
    `value` varchar(255) NOT NULL COMMENT '参数值',
    `name` varchar(255) NOT NULL COMMENT '参数名称',
    `describe_` varchar(255) DEFAULT '' COMMENT '描述',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `readonly_` bit(1) DEFAULT b'0' COMMENT '内置',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人id',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_key` (`key_`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='参数配置';
  
  -- ----------------------------
  -- Records of c_parameter
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_parameter` VALUES (1, 'LoginPolicy', 'MANY', '登录策略', 'ONLY_ONE:一个用户只能登录一次; MANY:用户可以任意登录; ONLY_ONE_CLIENT:一个用户在一个应用只能登录一次', b'1', b'1', 1, '2020-04-02 21:56:19', 2, '2020-11-30 09:14:44');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_resource
  -- ----------------------------
  DROP TABLE IF EXISTS `c_resource`;
  CREATE TABLE `c_resource` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `code` varchar(500) DEFAULT '' COMMENT '编码',
    `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
    `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID \n#c_menu',
    `describe_` varchar(255) DEFAULT '' COMMENT '描述',
    `readonly_` bit(1) DEFAULT b'1' COMMENT '内置',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人id',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_code` (`code`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资源';
  
  -- ----------------------------
  -- Records of c_resource
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_resource` VALUES (1, 'authority:menu:add', '新增', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (2, 'authority:menu:edit', '编辑', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (3, 'authority:menu:delete', '删除', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (4, 'authority:menu:view;authority:resource:view', '查看', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (5, 'authority:menu:import', '导入', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (6, 'authority:menu:export', '导出', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (7, 'authority:resource:add', '新增', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (8, 'authority:resource:edit', '编辑', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (9, 'authority:resource:delete', '删除', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (10, 'authority:resource:view', '查看', 160, '', b'1', 1, '2020-11-23 21:12:57', 1, '2020-11-23 21:12:57');
  INSERT INTO `c_resource` VALUES (25938183673872440, 'tenant:tenant:add', '新增', 110, '', b'1', 1, '2020-11-23 21:44:46', 1, '2020-11-23 21:44:46');
  INSERT INTO `c_resource` VALUES (25938183673872445, 'tenant:tenant:edit', '编辑', 110, '', b'1', 1, '2020-11-23 21:44:54', 1, '2020-11-23 21:44:54');
  INSERT INTO `c_resource` VALUES (25938183673872450, 'tenant:tenant:delete', '删除', 110, '', b'1', 1, '2020-11-23 21:45:02', 1, '2020-11-23 21:45:02');
  INSERT INTO `c_resource` VALUES (25938183673872455, 'tenant:tenant:view', '查看', 110, '', b'1', 1, '2020-11-23 21:45:10', 1, '2020-11-23 21:45:10');
  INSERT INTO `c_resource` VALUES (25938183673872460, 'tenant:tenant:initConnect;tenant:datasourceConfig:view', '初始化', 110, '', b'1', 1, '2020-11-23 22:01:23', 1, '2020-11-23 22:01:23');
  INSERT INTO `c_resource` VALUES (25938183673872467, 'tenant:user:add', '新增', 111, '', b'1', 1, '2020-11-23 22:01:46', 1, '2020-11-23 22:01:46');
  INSERT INTO `c_resource` VALUES (25938183673872472, 'tenant:user:edit', '编辑', 111, '', b'1', 1, '2020-11-23 22:01:58', 1, '2020-11-23 22:01:58');
  INSERT INTO `c_resource` VALUES (25938183673872477, 'tenant:user:delete', '删除', 111, '', b'1', 1, '2020-11-23 22:02:09', 1, '2020-11-23 22:02:09');
  INSERT INTO `c_resource` VALUES (25938183673872484, 'tenant:user:view;tenant:tenant:view', '查看', 111, '', b'1', 1, '2020-11-23 22:02:22', 1, '2020-11-23 22:02:22');
  INSERT INTO `c_resource` VALUES (25938183673872491, 'authority:org:add', '新增', 130, '', b'1', 1, '2020-11-23 22:02:52', 1, '2020-11-23 22:02:52');
  INSERT INTO `c_resource` VALUES (25938183673872496, 'authority:org:edit', '编辑', 130, '', b'1', 1, '2020-11-23 22:03:13', 1, '2020-11-23 22:03:13');
  INSERT INTO `c_resource` VALUES (25938183673872501, 'authority:org:delete', '删除', 130, '', b'1', 1, '2020-11-23 22:03:33', 1, '2020-11-23 22:03:33');
  INSERT INTO `c_resource` VALUES (25938183673872506, 'authority:org:view', '查看', 130, '', b'1', 1, '2020-11-23 22:03:47', 1, '2020-11-23 22:03:47');
  INSERT INTO `c_resource` VALUES (25938183673872513, 'authority:station:add', '新增', 131, '', b'1', 1, '2020-11-23 22:04:08', 1, '2020-11-23 22:04:08');
  INSERT INTO `c_resource` VALUES (25938183673872518, 'authority:station:edit', '编辑', 131, '', b'1', 1, '2020-11-23 22:04:17', 1, '2020-11-23 22:04:17');
  INSERT INTO `c_resource` VALUES (25938183673872523, 'authority:station:delete', '删除', 131, '', b'1', 1, '2020-11-23 22:04:28', 1, '2020-11-23 22:04:28');
  INSERT INTO `c_resource` VALUES (25938183673872528, 'authority:station:view;authority:org:view', '查看', 131, '', b'1', 1, '2020-11-23 22:04:41', 1, '2020-11-23 22:04:41');
  INSERT INTO `c_resource` VALUES (25938183673872537, 'authority:user:add', '新增', 132, '', b'1', 1, '2020-11-23 22:05:24', 1, '2020-11-23 22:05:24');
  INSERT INTO `c_resource` VALUES (25938183673872542, 'authority:user:edit', '编辑', 132, '', b'1', 1, '2020-11-23 22:05:33', 1, '2020-11-23 22:05:33');
  INSERT INTO `c_resource` VALUES (25938183673872547, 'authority:user:delete', '删除', 132, '', b'1', 1, '2020-11-23 22:05:41', 1, '2020-11-23 22:05:41');
  INSERT INTO `c_resource` VALUES (25938183673872552, 'authority:user:view;authority:station:view;authority:org:view', '查看', 132, '', b'1', 1, '2020-11-23 22:05:47', 1, '2020-11-23 22:05:47');
  INSERT INTO `c_resource` VALUES (25938183673872557, 'authority:user:resetPassword', '重置密码', 132, '', b'1', 1, '2020-11-23 22:06:09', 1, '2020-11-23 22:06:09');
  INSERT INTO `c_resource` VALUES (25938183673872562, 'authority:user:updateState', '修改状态', 132, '', b'1', 1, '2020-11-23 22:06:42', 1, '2020-11-23 22:06:42');
  INSERT INTO `c_resource` VALUES (25938183673872569, 'msg:msg:add;authority:user:view;authority:role:view', '新增', 140, '', b'1', 1, '2020-11-23 22:08:07', 1, '2020-11-23 22:08:07');
  INSERT INTO `c_resource` VALUES (25938183673872574, 'msg:msg:edit;authority:user:view;authority:role:view', '编辑', 140, '', b'1', 1, '2020-11-23 22:08:23', 1, '2020-11-23 22:08:23');
  INSERT INTO `c_resource` VALUES (25938183673872579, 'msg:msg:delete', '删除', 140, '', b'1', 1, '2020-11-23 22:08:32', 1, '2020-11-23 22:08:32');
  INSERT INTO `c_resource` VALUES (25938183673872584, 'msg:msg:view', '查看', 140, '', b'1', 1, '2020-11-23 22:08:38', 1, '2020-11-23 22:08:38');
  INSERT INTO `c_resource` VALUES (25938183673872589, 'msg:msg:mark', '标记已读', 140, '', b'1', 1, '2020-11-23 22:10:36', 1, '2020-11-23 22:10:36');
  INSERT INTO `c_resource` VALUES (25938183673872596, 'authority:org:import', '导入', 130, '', b'1', 1, '2020-11-23 22:11:11', 1, '2020-11-23 22:11:11');
  INSERT INTO `c_resource` VALUES (25938183673872601, 'authority:org:export', '导出', 130, '', b'1', 1, '2020-11-23 22:11:21', 1, '2020-11-23 22:11:21');
  INSERT INTO `c_resource` VALUES (25938183673872610, 'authority:station:import', '导入', 131, '', b'1', 1, '2020-11-23 22:11:41', 1, '2020-11-23 22:11:41');
  INSERT INTO `c_resource` VALUES (25938183673872615, 'authority:station:export', '导出', 131, '', b'1', 1, '2020-11-23 22:11:50', 1, '2020-11-23 22:11:50');
  INSERT INTO `c_resource` VALUES (25938183673872622, 'authority:user:import', '导入', 132, '', b'1', 1, '2020-11-23 22:12:16', 1, '2020-11-23 22:12:16');
  INSERT INTO `c_resource` VALUES (25938183673872627, 'authority:user:export', '导出', 132, '', b'1', 1, '2020-11-23 22:12:24', 1, '2020-11-23 22:12:24');
  INSERT INTO `c_resource` VALUES (25938183673872646, 'msg:msg:export', '导出', 140, '', b'1', 1, '2020-11-23 22:15:21', 1, '2020-11-23 22:15:21');
  INSERT INTO `c_resource` VALUES (25938183673872657, 'msg:sms:add', '新增', 142, '', b'1', 1, '2020-11-23 22:16:55', 1, '2020-11-23 22:16:55');
  INSERT INTO `c_resource` VALUES (25938183673872662, 'msg:sms:edit', '编辑', 142, '', b'1', 1, '2020-11-23 22:17:03', 1, '2020-11-23 22:17:03');
  INSERT INTO `c_resource` VALUES (25938183673872667, 'msg:sms:delete', '删除', 142, '', b'1', 1, '2020-11-23 22:17:15', 1, '2020-11-23 22:17:15');
  INSERT INTO `c_resource` VALUES (25938183673872672, 'msg:sms:view;msg:smsTemplate:view', '查看', 142, '', b'1', 1, '2020-11-23 22:17:24', 1, '2020-11-23 22:17:24');
  INSERT INTO `c_resource` VALUES (25938183673872679, 'msg:smsTemplate:add', '新增', 141, '', b'1', 1, '2020-11-23 22:18:00', 1, '2020-11-23 22:18:00');
  INSERT INTO `c_resource` VALUES (25938183673872684, 'msg:smsTemplate:edit', '编辑', 141, '', b'1', 1, '2020-11-23 22:18:07', 1, '2020-11-23 22:18:07');
  INSERT INTO `c_resource` VALUES (25938183673872689, 'msg:smsTemplate:delete', '删除', 141, '', b'1', 1, '2020-11-23 22:18:13', 1, '2020-11-23 22:18:13');
  INSERT INTO `c_resource` VALUES (25938183673872694, 'msg:smsTemplate:view', '查看', 141, '', b'1', 1, '2020-11-23 22:18:20', 1, '2020-11-23 22:18:20');
  INSERT INTO `c_resource` VALUES (25938183673872703, 'file:attachment:add', '新增', 143, '', b'1', 1, '2020-11-23 22:19:58', 1, '2020-11-23 22:19:58');
  INSERT INTO `c_resource` VALUES (25938183673872708, 'file:attachment:edit', '编辑', 143, '', b'1', 1, '2020-11-23 22:20:07', 1, '2020-11-23 22:20:07');
  INSERT INTO `c_resource` VALUES (25938183673872713, 'file:attachment:delete', '删除', 143, '', b'1', 1, '2020-11-23 22:20:13', 1, '2020-11-23 22:20:13');
  INSERT INTO `c_resource` VALUES (25938183673872718, 'file:attachment:view', '查看', 143, '', b'1', 1, '2020-11-23 22:20:19', 1, '2020-11-23 22:20:19');
  INSERT INTO `c_resource` VALUES (25938183673872723, 'file:attachment:download', '下载', 143, '', b'1', 1, '2020-11-23 22:20:30', 1, '2020-11-23 22:20:30');
  INSERT INTO `c_resource` VALUES (25938183673872736, 'authority:role:add;authority:org:view', '新增', 161, '', b'1', 1, '2020-11-23 22:23:25', 1, '2020-11-23 22:23:25');
  INSERT INTO `c_resource` VALUES (25938183673872741, 'authority:role:edit;authority:org:view', '编辑', 161, '', b'1', 1, '2020-11-23 22:23:33', 1, '2020-11-23 22:23:33');
  INSERT INTO `c_resource` VALUES (25938183673872746, 'authority:role:delete', '删除', 161, '', b'1', 1, '2020-11-23 22:23:41', 1, '2020-11-23 22:23:41');
  INSERT INTO `c_resource` VALUES (25938183673872751, 'authority:role:view', '查看', 161, '', b'1', 1, '2020-11-23 22:24:50', 1, '2020-11-23 22:24:50');
  INSERT INTO `c_resource` VALUES (25938183673872756, 'authority:role:config;authority:user:view', '配置权限', 161, '', b'1', 1, '2020-11-23 22:25:26', 1, '2020-11-23 22:25:26');
  INSERT INTO `c_resource` VALUES (25938183673872761, 'authority:role:auth;authority:menu:view;authority:resource:view', '授权', 161, '', b'1', 1, '2020-11-23 22:25:39', 1, '2020-11-23 22:25:39');
  INSERT INTO `c_resource` VALUES (25938183673872768, 'authority:dictionary:add', '新增', 162, '', b'1', 1, '2020-11-23 22:27:08', 1, '2020-11-23 22:27:08');
  INSERT INTO `c_resource` VALUES (25938183673872773, 'authority:dictionary:edit', '编辑', 162, '', b'1', 1, '2020-11-23 22:27:15', 1, '2020-11-23 22:27:15');
  INSERT INTO `c_resource` VALUES (25938183673872778, 'authority:dictionary:delete', '删除', 162, '', b'1', 1, '2020-11-23 22:27:22', 1, '2020-11-23 22:27:22');
  INSERT INTO `c_resource` VALUES (25938183673872783, 'authority:dictionary:view', '查看', 162, '', b'1', 1, '2020-11-23 22:27:28', 1, '2020-11-23 22:27:28');
  INSERT INTO `c_resource` VALUES (25938183673872790, 'authority:area:add', '新增', 163, '', b'1', 1, '2020-11-23 22:27:56', 1, '2020-11-23 22:27:56');
  INSERT INTO `c_resource` VALUES (25938183673872795, 'authority:area:edit', '编辑', 163, '', b'1', 1, '2020-11-23 22:28:04', 1, '2020-11-23 22:28:04');
  INSERT INTO `c_resource` VALUES (25938183673872800, 'authority:area:delete', '删除', 163, '', b'1', 1, '2020-11-23 22:28:11', 1, '2020-11-23 22:28:11');
  INSERT INTO `c_resource` VALUES (25938183673872805, 'authority:area:view', '查看', 163, '', b'1', 1, '2020-11-23 22:28:25', 1, '2020-11-23 22:28:25');
  INSERT INTO `c_resource` VALUES (25938183673872812, 'authority:parameter:add', '新增', 164, '', b'1', 1, '2020-11-23 22:29:01', 1, '2020-11-23 22:29:01');
  INSERT INTO `c_resource` VALUES (25938183673872817, 'authority:parameter:edit', '编辑', 164, '', b'1', 1, '2020-11-23 22:29:08', 1, '2020-11-23 22:29:08');
  INSERT INTO `c_resource` VALUES (25938183673872822, 'authority:parameter:delete', '删除', 164, '', b'1', 1, '2020-11-23 22:29:18', 1, '2020-11-23 22:29:18');
  INSERT INTO `c_resource` VALUES (25938183673872827, 'authority:parameter:view', '查看', 164, '', b'1', 1, '2020-11-23 22:29:26', 1, '2020-11-23 22:29:26');
  INSERT INTO `c_resource` VALUES (25938183673872838, 'authority:optLog:delete', '删除', 165, '', b'1', 1, '2020-11-23 22:30:00', 1, '2020-11-23 22:30:00');
  INSERT INTO `c_resource` VALUES (25938183673872843, 'authority:optLog:view', '查看', 165, '', b'1', 1, '2020-11-23 22:30:08', 1, '2020-11-23 22:30:08');
  INSERT INTO `c_resource` VALUES (25938183673872850, 'authority:loginLog:delete', '删除', 166, '', b'1', 1, '2020-11-23 22:30:27', 1, '2020-11-23 22:30:27');
  INSERT INTO `c_resource` VALUES (25938183673872857, 'authority:loginLog:view', '查看', 166, '', b'1', 1, '2020-11-23 22:30:43', 1, '2020-11-23 22:30:43');
  INSERT INTO `c_resource` VALUES (25938183673872864, 'authority:online:view', '查看', 167, '', b'1', 1, '2020-11-23 22:31:11', 1, '2020-11-23 22:31:11');
  INSERT INTO `c_resource` VALUES (25938183673872869, 'authority:online:delete', '删除', 167, '', b'1', 1, '2020-11-23 22:31:19', 1, '2020-11-23 22:31:19');
  INSERT INTO `c_resource` VALUES (25938183673872876, 'authority:application:add', '新增', 168, '', b'1', 1, '2020-11-23 22:31:37', 1, '2020-11-23 22:31:37');
  INSERT INTO `c_resource` VALUES (25938183673872881, 'authority:application:edit', '编辑', 168, '', b'1', 1, '2020-11-23 22:31:43', 1, '2020-11-23 22:31:43');
  INSERT INTO `c_resource` VALUES (25938183673872886, 'authority:application:delete', '删除', 168, '', b'1', 1, '2020-11-23 22:31:49', 1, '2020-11-23 22:31:49');
  INSERT INTO `c_resource` VALUES (25938183673872891, 'authority:application:view', '查看', 168, '', b'1', 1, '2020-11-23 22:31:55', 1, '2020-11-23 22:31:55');
  INSERT INTO `c_resource` VALUES (26578833880645891, 'tenant:datasourceConfig:add', '新增', 112, '', b'1', 2, '2020-11-25 17:05:43', 2, '2020-11-25 17:05:43');
  INSERT INTO `c_resource` VALUES (26578833880645896, 'tenant:datasourceConfig:edit', '编辑', 112, '', b'1', 2, '2020-11-25 17:06:41', 2, '2020-11-25 17:06:41');
  INSERT INTO `c_resource` VALUES (26578833880645901, 'tenant:datasourceConfig:delete', '删除', 112, '', b'1', 2, '2020-11-25 17:12:41', 2, '2020-11-25 17:12:41');
  INSERT INTO `c_resource` VALUES (26578833880645906, 'tenant:datasourceConfig:view', '查看', 112, '', b'1', 2, '2020-11-25 17:12:56', 2, '2020-11-25 17:12:56');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_role
  -- ----------------------------
  DROP TABLE IF EXISTS `c_role`;
  CREATE TABLE `c_role` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
    `code` varchar(20) DEFAULT '' COMMENT '编码',
    `describe_` varchar(100) DEFAULT '' COMMENT '描述',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `readonly_` bit(1) DEFAULT b'0' COMMENT '内置角色',
    `ds_type` varchar(20) NOT NULL DEFAULT '' COMMENT '数据权限 \n#DataScopeType{ALL:1,全部;THIS_LEVEL:2,本级;THIS_LEVEL_CHILDREN:3,本级以及子级;CUSTOMIZE:4,自定义;SELF:5,个人;}',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人id',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_code` (`code`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色';
  
  -- ----------------------------
  -- Records of c_role
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_role` VALUES (1, '超级管理员', 'SUPER_ADMIN', '内置管理员(二次开发必须保留)', b'1', b'1', 'ALL', 1, '2020-11-22 23:46:00', 1, '2020-11-22 23:46:00');
  INSERT INTO `c_role` VALUES (2, '平台管理员', 'PT_ADMIN', '内置运营专用平台管理员(二次开发必须保留)', b'1', b'1', 'ALL', 1, '2020-11-22 23:46:00', 1, '2020-11-22 23:46:00');
  INSERT INTO `c_role` VALUES (3, '普通管理员', 'GENERAL_ADMIN', '演示用的', b'1', b'1', 'THIS_LEVEL_CHILDREN', 1, '2020-11-22 23:46:00', 1, '2020-11-22 23:46:00');
  INSERT INTO `c_role` VALUES (4, '普通用户', 'NORMAL', '演示用的', b'1', b'1', 'SELF', 1, '2020-11-22 23:46:00', 1, '2020-11-22 23:46:00');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_role_authority
  -- ----------------------------
  DROP TABLE IF EXISTS `c_role_authority`;
  CREATE TABLE `c_role_authority` (
    `id` bigint(20) NOT NULL COMMENT '主键',
    `authority_id` bigint(20) NOT NULL COMMENT '资源id \n#c_resource #c_menu',
    `authority_type` varchar(10) NOT NULL COMMENT '权限类型 \n#AuthorizeType{MENU:菜单;RESOURCE:资源;}',
    `role_id` bigint(20) NOT NULL COMMENT '角色id \n#c_role',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_role_authority` (`authority_id`,`authority_type`,`role_id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色的资源';
  
  -- ----------------------------
  -- Records of c_role_authority
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_role_authority` VALUES (26578833880645921, 1, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645922, 25938183673872761, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645923, 25938183673872506, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645924, 2, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645925, 26578833880645906, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645926, 3, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645927, 25938183673872891, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645928, 4, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645929, 5, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645930, 6, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645931, 7, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645932, 25938183673872496, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645933, 8, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645934, 9, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645935, 25938183673872881, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645936, 10, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645937, 25938183673872627, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645938, 25938183673872756, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645939, 25938183673872501, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645940, 25938183673872886, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645941, 26578833880645891, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645942, 25938183673872746, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645943, 25938183673872491, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645944, 25938183673872876, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645945, 25938183673872622, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645946, 25938183673872751, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645947, 25938183673872736, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645948, 25938183673872864, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645949, 26578833880645896, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645950, 25938183673872610, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645951, 26578833880645901, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645952, 25938183673872484, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645953, 25938183673872741, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645954, 25938183673872869, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645955, 25938183673872615, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645956, 25938183673872472, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645957, 25938183673872601, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645958, 25938183673872857, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645959, 25938183673872477, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645960, 25938183673872850, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645961, 25938183673872467, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645962, 25938183673872723, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645963, 25938183673872596, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645964, 25938183673872584, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645965, 25938183673872713, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645966, 25938183673872843, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645967, 25938183673872460, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645968, 25938183673872589, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645969, 25938183673872718, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645970, 25938183673872450, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645971, 25938183673872579, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645972, 25938183673872708, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645973, 25938183673872838, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645974, 25938183673872455, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645975, 25938183673872440, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645976, 25938183673872569, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645977, 25938183673872827, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645978, 25938183673872445, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645979, 25938183673872574, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645980, 25938183673872703, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645981, 25938183673872689, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645982, 25938183673872817, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645983, 25938183673872562, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645984, 25938183673872694, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645985, 25938183673872822, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645986, 25938183673872552, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645987, 25938183673872684, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645988, 25938183673872812, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645989, 25938183673872557, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645990, 25938183673872672, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645991, 25938183673872800, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645992, 25938183673872547, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645993, 25938183673872805, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645994, 25938183673872679, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645995, 25938183673872537, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645996, 25938183673872667, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645997, 25938183673872795, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645998, 25938183673872542, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880645999, 25938183673872528, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646000, 25938183673872657, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646001, 25938183673872662, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646002, 25938183673872790, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646003, 25938183673872778, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646004, 25938183673872523, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646005, 25938183673872783, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646006, 25938183673872768, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646007, 25938183673872513, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646008, 25938183673872773, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646009, 25938183673872518, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646010, 25938183673872646, 'RESOURCE', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646011, 130, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646012, 131, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646013, 132, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646014, 10, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646015, 140, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646016, 141, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646017, 142, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646018, 143, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646019, 20, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646020, 150, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646021, 151, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646022, 152, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646023, 153, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646024, 154, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646025, 155, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646026, 156, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646027, 157, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646028, 30, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646029, 160, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646030, 161, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646031, 162, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646032, 163, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646033, 164, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646034, 165, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646035, 166, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646036, 167, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646037, 40, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646038, 168, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646039, 50, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646040, 180, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646041, 181, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646042, 60, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646043, 190, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646044, 191, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646045, 192, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646046, 193, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646047, 194, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646048, 195, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646049, 196, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646050, 197, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646051, 70, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646052, 80, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646053, 210, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646054, 211, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646055, 212, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646056, 213, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646057, 214, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646058, 215, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646059, 90, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646060, 220, 'MENU', 2, '2020-11-25 17:13:10', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646061, 221, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646062, 222, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646063, 223, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646064, 224, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646065, 100, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646066, 110, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646067, 111, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646068, 112, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646069, 120, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646070, 121, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646071, 122, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (26578833880646072, 123, 'MENU', 2, '2020-11-25 17:13:11', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633784, 25938183673872761, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633785, 1, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633786, 2, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633787, 25938183673872506, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633788, 25938183673872891, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633789, 3, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633790, 4, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633791, 5, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633792, 6, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633793, 7, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633794, 8, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633795, 25938183673872496, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633796, 25938183673872881, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633797, 9, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633798, 10, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633799, 25938183673872627, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633800, 25938183673872756, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633801, 25938183673872501, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633802, 25938183673872886, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633803, 25938183673872746, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633804, 25938183673872491, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633805, 25938183673872876, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633806, 25938183673872622, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633807, 25938183673872751, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633808, 25938183673872864, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633809, 25938183673872736, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633810, 25938183673872610, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633811, 25938183673872869, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633812, 25938183673872741, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633813, 25938183673872615, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633814, 25938183673872857, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633815, 25938183673872601, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633816, 25938183673872850, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633817, 25938183673872723, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633818, 25938183673872596, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633819, 25938183673872584, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633820, 25938183673872713, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633821, 25938183673872843, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633822, 25938183673872589, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633823, 25938183673872718, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633824, 25938183673872579, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633825, 25938183673872708, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633826, 25938183673872838, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633827, 25938183673872569, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633828, 25938183673872827, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633829, 25938183673872574, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633830, 25938183673872703, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633831, 25938183673872817, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633832, 25938183673872689, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633833, 25938183673872562, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633834, 25938183673872822, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633835, 25938183673872694, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633836, 25938183673872552, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633837, 25938183673872812, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633838, 25938183673872684, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633839, 25938183673872557, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633840, 25938183673872800, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633841, 25938183673872672, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633842, 25938183673872547, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633843, 25938183673872805, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633844, 25938183673872679, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633845, 25938183673872537, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633846, 25938183673872795, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633847, 25938183673872667, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633848, 25938183673872542, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633849, 25938183673872528, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633850, 25938183673872657, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633851, 25938183673872790, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633852, 25938183673872662, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633853, 25938183673872778, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633854, 25938183673872523, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633855, 25938183673872783, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633856, 25938183673872768, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633857, 25938183673872513, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633858, 25938183673872773, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633859, 25938183673872646, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633860, 25938183673872518, 'RESOURCE', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633861, 130, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633862, 131, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633863, 132, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633864, 140, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633865, 141, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633866, 142, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633867, 143, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633868, 20, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633869, 150, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633870, 151, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633871, 152, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633872, 153, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633873, 154, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633874, 155, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633875, 156, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633876, 157, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633877, 30, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633878, 160, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633879, 161, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633880, 162, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633881, 163, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633882, 164, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633883, 165, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633884, 166, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633885, 167, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633886, 40, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633887, 168, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633888, 50, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633889, 180, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633890, 181, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633891, 60, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633900, 70, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633902, 120, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633903, 121, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633904, 122, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633905, 123, 'MENU', 1, '2020-11-30 11:21:50', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633954, 25938183673872569, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633955, 25938183673872506, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633956, 25938183673872574, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633957, 25938183673872703, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633958, 25938183673872496, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633959, 25938183673872689, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633960, 25938183673872562, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633961, 25938183673872627, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633962, 25938183673872501, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633963, 25938183673872694, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633964, 25938183673872552, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633965, 25938183673872491, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633966, 25938183673872684, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633967, 25938183673872557, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633968, 25938183673872622, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633969, 25938183673872672, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633970, 25938183673872610, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633971, 25938183673872547, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633972, 25938183673872615, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633973, 25938183673872679, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633974, 25938183673872601, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633975, 25938183673872537, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633976, 25938183673872667, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633977, 25938183673872542, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633978, 25938183673872528, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633979, 25938183673872657, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633980, 25938183673872723, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633981, 25938183673872596, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633982, 25938183673872662, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633983, 25938183673872584, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633984, 25938183673872713, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633985, 25938183673872523, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633986, 25938183673872589, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633987, 25938183673872718, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633988, 25938183673872513, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633989, 25938183673872579, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633990, 25938183673872708, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633991, 25938183673872518, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633992, 25938183673872646, 'RESOURCE', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633993, 130, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633994, 131, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633995, 132, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633996, 140, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633997, 141, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633998, 142, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228633999, 143, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634000, 20, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634001, 150, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634002, 151, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634003, 152, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634004, 153, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634005, 154, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634006, 155, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634007, 156, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634008, 157, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634009, 30, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634010, 40, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634011, 50, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634012, 120, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634013, 121, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634014, 122, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634015, 123, 'MENU', 3, '2020-11-30 11:22:51', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634030, 25938183673872601, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634031, 25938183673872537, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634032, 25938183673872506, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634033, 25938183673872542, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634034, 25938183673872496, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634035, 25938183673872528, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634036, 25938183673872562, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634037, 25938183673872627, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634038, 25938183673872596, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634039, 25938183673872501, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634040, 25938183673872552, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634041, 25938183673872491, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634042, 25938183673872523, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634043, 25938183673872557, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634044, 25938183673872622, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634045, 25938183673872513, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634046, 25938183673872610, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634047, 25938183673872547, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634048, 25938183673872518, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634049, 25938183673872615, 'RESOURCE', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634050, 130, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634051, 131, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634052, 132, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634053, 50, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634054, 20, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634055, 120, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634056, 152, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634057, 121, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634058, 153, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634059, 122, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634060, 154, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634061, 123, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634062, 155, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634063, 156, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634064, 157, 'MENU', 4, '2020-11-30 11:23:19', 2);
  INSERT INTO `c_role_authority` VALUES (28369762228634065, 30, 'MENU', 4, '2020-11-30 11:23:19', 2);
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_role_org
  -- ----------------------------
  DROP TABLE IF EXISTS `c_role_org`;
  CREATE TABLE `c_role_org` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `role_id` bigint(20) NOT NULL COMMENT '角色ID \n#c_role',
    `org_id` bigint(20) NOT NULL COMMENT '部门ID \n#c_org',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_role_org` (`org_id`,`role_id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色组织关系';
  
  -- ----------------------------
  -- Table structure for c_station
  -- ----------------------------
  DROP TABLE IF EXISTS `c_station`;
  CREATE TABLE `c_station` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `name` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
    `org_id` bigint(20) DEFAULT NULL COMMENT '组织ID \n#c_org\n@InjectionField(api = ORG_ID_CLASS, method = ORG_ID_METHOD, beanClass = Org.class) RemoteData<Long, com.tangyh.lamp.authority.entity.core.Org>',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `describe_` varchar(255) DEFAULT '' COMMENT '描述',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '修改人',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='岗位';
  
  -- ----------------------------
  -- Records of c_station
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_station` VALUES (1, '总经理', 1, b'1', '', '2020-11-23 00:06:20', 1, '2020-11-23 00:06:25', 1);
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_user
  -- ----------------------------
  DROP TABLE IF EXISTS `c_user`;
  CREATE TABLE `c_user` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `account` varchar(30) NOT NULL DEFAULT '' COMMENT '账号',
    `name` varchar(50) NOT NULL DEFAULT '' COMMENT '姓名',
    `org_id` bigint(20) DEFAULT NULL COMMENT '组织ID \n#c_org\n@InjectionField(api = ORG_ID_CLASS, method = ORG_ID_METHOD, beanClass = Org.class) RemoteData<Long, com.tangyh.lamp.authority.entity.core.Org>',
    `station_id` bigint(20) DEFAULT NULL COMMENT '岗位ID \n#c_station\n@InjectionField(api = STATION_ID_CLASS, method = STATION_ID_NAME_METHOD) RemoteData<Long, String>',
    `readonly` bit(1) NOT NULL DEFAULT b'0' COMMENT '内置',
    `email` varchar(255) DEFAULT '' COMMENT '邮箱',
    `mobile` varchar(20) DEFAULT '' COMMENT '手机',
    `sex` varchar(1) DEFAULT '' COMMENT '性别 \n#Sex{W:女;M:男;N:未知}',
    `state` bit(1) DEFAULT b'1' COMMENT '状态',
    `avatar` varchar(255) DEFAULT '' COMMENT '头像',
    `nation` char(2) DEFAULT '' COMMENT '民族 \n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.NATION) RemoteData<String, String>',
    `education` char(2) DEFAULT '' COMMENT '学历 \n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.EDUCATION) RemoteData<String, String>',
    `position_status` char(2) DEFAULT '' COMMENT '职位状态 \n@InjectionField(api = DICTIONARY_ITEM_CLASS, method = DICTIONARY_ITEM_METHOD, dictType = DictionaryType.POSITION_STATUS) RemoteData<String, String>',
    `work_describe` varchar(255) DEFAULT '' COMMENT '工作描述',
    `password_error_last_time` datetime DEFAULT NULL COMMENT '最后一次输错密码时间',
    `password_error_num` int(10) DEFAULT '0' COMMENT '密码错误次数',
    `password_expire_time` datetime DEFAULT NULL COMMENT '密码过期时间',
    `password` varchar(64) NOT NULL DEFAULT '' COMMENT '密码',
    `salt` varchar(20) NOT NULL DEFAULT '' COMMENT '盐',
    `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人id',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `updated_by` bigint(20) DEFAULT NULL COMMENT '更新人id',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_account` (`account`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户';
  
  -- ----------------------------
  -- Records of c_user
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_user` VALUES (1, 'lampAdmin', '内置管理员', 1, 1, b'1', '', '', 'M', b'1', '', '', '', '', '不想上班!', '2020-11-24 19:08:45', 0, NULL, '0d70cc96860681487869a0304139d3410044298da40fe5b2d7acff76f83d79c8', 'ki5pj8dv44i14yu4nbhh', '2020-11-24 19:08:45', 1, '2020-11-22 23:03:15', 1, '2020-11-22 23:03:15');
  INSERT INTO `c_user` VALUES (2, 'lamp', '超级管理员', 1, 1, b'0', '', '', 'M', b'1', '', '', '', '', '不想上班!', '2020-12-07 23:50:06', 0, NULL, '0d70cc96860681487869a0304139d3410044298da40fe5b2d7acff76f83d79c8', 'ki5pj8dv44i14yu4nbhh', '2020-12-07 23:50:06', 1, '2020-11-22 23:03:15', 1, '2020-11-22 23:03:20');
  INSERT INTO `c_user` VALUES (3, 'lamp_pt', '平台管理员', 1, 1, b'0', '', '', 'M', b'1', '', '', '', '', '不想上班!', '2020-12-06 14:45:22', 0, NULL, '0d70cc96860681487869a0304139d3410044298da40fe5b2d7acff76f83d79c8', 'ki5pj8dv44i14yu4nbhh', '2020-12-06 14:45:22', 1, '2020-11-22 23:03:15', 1, '2020-11-22 23:03:15');
  INSERT INTO `c_user` VALUES (4, 'general', '普通管理员', 1, 1, b'0', '', '', 'M', b'1', '', '', '', '', '不想上班!', '2020-11-30 16:13:41', 0, NULL, '0d70cc96860681487869a0304139d3410044298da40fe5b2d7acff76f83d79c8', 'ki5pj8dv44i14yu4nbhh', '2020-11-30 16:13:41', 1, '2020-11-22 23:03:15', 1, '2020-11-22 23:03:15');
  INSERT INTO `c_user` VALUES (5, 'normal', '普通用户', 1, 1, b'0', '', '', 'M', b'1', '', '', '', '', '不想上班!', '2020-11-30 16:15:10', 0, NULL, '0d70cc96860681487869a0304139d3410044298da40fe5b2d7acff76f83d79c8', 'ki5pj8dv44i14yu4nbhh', '2020-11-30 16:15:10', 1, '2020-11-22 23:03:15', 1, '2020-11-22 23:03:15');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for c_user_role
  -- ----------------------------
  DROP TABLE IF EXISTS `c_user_role`;
  CREATE TABLE `c_user_role` (
    `id` bigint(20) NOT NULL COMMENT 'ID',
    `role_id` bigint(20) NOT NULL COMMENT '角色ID \n#c_role',
    `user_id` bigint(20) NOT NULL COMMENT '用户ID \n#c_user',
    `created_by` bigint(20) DEFAULT NULL COMMENT '创建人ID',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_user_role` (`role_id`,`user_id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色分配\n账号角色绑定';
  
  -- ----------------------------
  -- Records of c_user_role
  -- ----------------------------
  BEGIN;
  INSERT INTO `c_user_role` VALUES (1, 1, 1, 1, '2020-11-23 14:19:09');
  INSERT INTO `c_user_role` VALUES (2, 1, 2, 1, '2020-11-23 14:19:11');
  INSERT INTO `c_user_role` VALUES (3, 2, 3, 1, '2020-11-23 14:19:14');
  INSERT INTO `c_user_role` VALUES (4, 3, 4, 1, '2020-11-23 14:19:14');
  INSERT INTO `c_user_role` VALUES (5, 4, 5, 1, '2020-11-23 14:19:14');
  COMMIT;
  
  -- ----------------------------
  -- Table structure for undo_log
  -- ----------------------------
  DROP TABLE IF EXISTS `undo_log`;
  CREATE TABLE `undo_log` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'increment id',
    `branch_id` bigint(20) NOT NULL COMMENT 'branch transaction id',
    `xid` varchar(100) NOT NULL COMMENT 'global transaction id',
    `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
    `rollback_info` longblob NOT NULL COMMENT 'rollback info',
    `log_status` int(11) NOT NULL COMMENT '0:normal status,1:defense status',
    `log_created` datetime(6) NOT NULL COMMENT 'create datetime',
    `log_modified` datetime(6) NOT NULL COMMENT 'modify datetime',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AT transaction mode undo table';
  
  SET FOREIGN_KEY_CHECKS = 1;
  