/*
 Navicat Premium Data Transfer

 Source Server         : 49.232.2.175
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : 49.232.2.175:3306
 Source Schema         : rms

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

 Date: 07/02/2023 23:00:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_comment
-- ----------------------------
DROP TABLE IF EXISTS `t_comment`;
CREATE TABLE `t_comment`  (
  `id` varbinary(16) NOT NULL COMMENT '备注ID',
  `interview_id` varbinary(16) NOT NULL COMMENT '面试表ID',
  `comment_type` int NOT NULL COMMENT '备注类型[0简历上传备注 1简历Review备注 2面试反馈备注]',
  `comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '备注内容',
  `creater` varbinary(16) NOT NULL COMMENT '创建人ID',
  `creat_date` datetime NOT NULL COMMENT '创建时间',
  `modifyer` varbinary(16) NULL DEFAULT NULL COMMENT '修改人ID',
  `modify_date` datetime NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_comment
-- ----------------------------
INSERT INTO `t_comment` VALUES (0x11ED7EBB93BD20878E560242AC110006, 0x11ED6A405035E3BBAF960242AC110002, 2, '这人有点蠢', 0x1DAAF2D067DC11EDAF960242AC110002, '2022-12-18 18:06:02', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED8EA477E830F685460242AC110003, 0x11ED6A41364FCD53AF960242AC110002, 2, '这人不太聪明', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 00:00:55', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED8F2A5522E7928C390242AC110003, 0x11ED8F2A551547E08C390242AC110003, 1, '测试备注内容', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 15:59:09', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED8F5E4137D74B8C390242AC110003, 0x05152E1311ED8DC7A9130242AC110003, 2, '此人怨念较深', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 22:10:50', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED8FCDC48E0B0E8C390242AC110003, 0x11ED6A3FEE72A57AAF960242AC110002, 2, '语言能力未达标', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-09 11:29:04', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED8FCDDECCA2E58C390242AC110003, 0x11ED6A3FEE72A57AAF960242AC110002, 2, '语言能力未达标', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-09 11:29:48', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED8FD51B7915218C390242AC110003, 0x11ED8FD51B779A2F8C390242AC110003, 1, '荣获多次奖学金', 0x11ED759BFC52D835AF960242AC110002, '2023-01-09 12:21:37', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED90D79D13B6F78C390242AC110003, 0x11ED90D79D131D7F8C390242AC110003, 1, '想法新颖', 0x11ED759BFC52D835AF960242AC110002, '2023-01-10 19:12:04', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED90E23C111DC08C390242AC110003, 0x11ED90E23C1083968C390242AC110003, 1, '优秀', 0x11ED759BFC52D835AF960242AC110002, '2023-01-10 20:28:06', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED9164202377AC8C390242AC110003, 0x11ED91642022FB0E8C390242AC110003, 1, '海归有经验', 0x11ED759BFC52D835AF960242AC110002, '2023-01-11 11:57:54', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED91666EE3B8698C390242AC110003, 0x11ED90D79D131D7F8C390242AC110003, 2, '重新投递', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11 12:14:25', NULL, NULL);
INSERT INTO `t_comment` VALUES (0x11ED917271A32FF98C390242AC110003, 0x11ED917271A2A4D68C390242AC110003, 1, '认真', 0x11ED759BFC52D835AF960242AC110002, '2023-01-11 13:40:23', NULL, NULL);

-- ----------------------------
-- Table structure for t_department
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department`  (
  `id` varbinary(16) NOT NULL COMMENT '部门ID',
  `company` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '部门名称',
  `comment` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_department
-- ----------------------------
INSERT INTO `t_department` VALUES (0x11ED6A36EDAD7C83AF960242AC110002, 'IBM / DaLian / China', '人事部', '统筹集团人力资源管理');
INSERT INTO `t_department` VALUES (0x11ED6A37565CB1A2AF960242AC110002, 'IBM / DaLian / China', '财务部', '执行国家的财务会计政策、税收政策和法规');
INSERT INTO `t_department` VALUES (0x11ED6A375668F368AF960242AC110002, 'IBM / DaLian / China', '研发部', '组织实施研发');
INSERT INTO `t_department` VALUES (0x11ED6A37567C1C77AF960242AC110002, 'IBM / DaLian / China', '销售部', '负责具体销售工作');

-- ----------------------------
-- Table structure for t_dictionary_type
-- ----------------------------
DROP TABLE IF EXISTS `t_dictionary_type`;
CREATE TABLE `t_dictionary_type`  (
  `id` varbinary(16) NOT NULL COMMENT '数据字典类型ID',
  `type_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '数据字典类型值',
  `comment` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据字典类型备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `type_code_unique`(`type_code` ASC) USING BTREE COMMENT 'type_code唯一索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_dictionary_type
-- ----------------------------
INSERT INTO `t_dictionary_type` VALUES (0x11ED7314BE99C60BAF960242AC110002, 'education', '学历, 如高中、专科、本科、硕士等');
INSERT INTO `t_dictionary_type` VALUES (0x11ED731C15C6BA86AF960242AC110002, 'sex', '性别');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732D7441072AAF960242AC110002, 'company', '所属公司');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732D7CEB2707AF960242AC110002, 'user_status', '用户状态');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732D8C760098AF960242AC110002, 'tech_ability', '技术能力');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732FA4D8DA01AF960242AC110002, 'lang_ability', '语言能力');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732FAD0E61D4AF960242AC110002, 'source', '简历来源');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732FB49D3B41AF960242AC110002, 'obey', '是否服从分配');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732FBDBAA6F8AF960242AC110002, 'interview_status', '面试状态可选项');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732FC5B8012FAF960242AC110002, 'result', '面试结果');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732FD4533E91AF960242AC110002, 'ability_item', '面试结果考察能力');
INSERT INTO `t_dictionary_type` VALUES (0x11ED732FE12D4A0DAF960242AC110002, 'comment_type', '备注类型');
INSERT INTO `t_dictionary_type` VALUES (0x11ED73E48BD5B190AF960242AC110002, 'confirm_item', '面试结果确认事项');
INSERT INTO `t_dictionary_type` VALUES (0x11ED78A8FE8BD85EA7840242AC110004, 'vague_search', '模糊搜索项, 面试一览画面模糊搜索项');
INSERT INTO `t_dictionary_type` VALUES (0x11ED78B86DDD913EA7840242AC110004, 'entry_time', '录入时间可选项');
INSERT INTO `t_dictionary_type` VALUES (0x11ED78B8CD99D614A7840242AC110004, 'grad_time', '毕业时间可选项');

-- ----------------------------
-- Table structure for t_dictionary_value
-- ----------------------------
DROP TABLE IF EXISTS `t_dictionary_value`;
CREATE TABLE `t_dictionary_value`  (
  `id` varbinary(16) NOT NULL COMMENT '数据字典值ID',
  `type_id` varbinary(16) NOT NULL COMMENT '数据字典类型ID',
  `value_key` int NOT NULL COMMENT '数据字典值代码',
  `value_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '数据字典值',
  `comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据字典值备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `type_code_value_key_unique`(`type_id` ASC, `value_key` ASC) USING BTREE COMMENT 'type_code和value_key不能同时重复'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_dictionary_value
-- ----------------------------
INSERT INTO `t_dictionary_value` VALUES (0x11ED7314C1255FD8AF960242AC110002, 0x11ED7314BE99C60BAF960242AC110002, 0, '无', '学历列表');
INSERT INTO `t_dictionary_value` VALUES (0x11ED7314C129A5F9AF960242AC110002, 0x11ED7314BE99C60BAF960242AC110002, 1, '专科', '学历列表');
INSERT INTO `t_dictionary_value` VALUES (0x11ED7314C12E092EAF960242AC110002, 0x11ED7314BE99C60BAF960242AC110002, 2, '本科', '学历列表');
INSERT INTO `t_dictionary_value` VALUES (0x11ED7314C1323237AF960242AC110002, 0x11ED7314BE99C60BAF960242AC110002, 3, '硕士', '学历列表');
INSERT INTO `t_dictionary_value` VALUES (0x11ED7314C13678FBAF960242AC110002, 0x11ED7314BE99C60BAF960242AC110002, 4, '海归', '学历列表');
INSERT INTO `t_dictionary_value` VALUES (0x11ED7314C13ABD64AF960242AC110002, 0x11ED7314BE99C60BAF960242AC110002, 5, '其它', '学历列表');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73BD15D192B9AF960242AC110002, 0x11ED731C15C6BA86AF960242AC110002, 0, '女', '性别女');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73BD1B983258AF960242AC110002, 0x11ED731C15C6BA86AF960242AC110002, 1, '男', '性别男');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E05588A2E0AF960242AC110002, 0x11ED732D7CEB2707AF960242AC110002, 0, '正常', '正常状态');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E0674503B5AF960242AC110002, 0x11ED732D7CEB2707AF960242AC110002, 1, '锁定', '锁定状态, 无法登录');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E09B89AB0EAF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 0, 'IBM / DaLian / China', 'IBM 大连 中国');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E11E94C896AF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 1, 'IBM / BeiJing / China', 'IBM 北京 中国');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E1314A3482AF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 2, 'IBM / ShenYang / China', 'IBM 沈阳 中国');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E13CF21558AF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 3, 'IBM / ShangHai / China', 'IBM 上海 中国');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E1518AA63BAF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 4, 'IBM / WuHan / China', 'IBM 武汉 中国');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E15D34FF65AF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 5, 'IBM / TianJin / China', 'IBM 天津 中国');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E1971DF1B4AF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 6, 'IBM / Chiba / Japan', 'IBM Chiba 日本');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E1CCB1A91BAF960242AC110002, 0x11ED732D7441072AAF960242AC110002, 7, 'IBM / Tokyo / Japan', 'IBM Tokyo 日本');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E2168DC3CEAF960242AC110002, 0x11ED732D8C760098AF960242AC110002, 0, '无', '无主要技术能力');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E230F3B9D8AF960242AC110002, 0x11ED732D8C760098AF960242AC110002, 1, 'Java', '主要技术能力 Java ');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E2429A201FAF960242AC110002, 0x11ED732D8C760098AF960242AC110002, 2, 'C / C++', '主要技术能力 C / C++');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E24E4E8950AF960242AC110002, 0x11ED732D8C760098AF960242AC110002, 3, 'Python', '主要技术能力 Python');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E256E01B72AF960242AC110002, 0x11ED732D8C760098AF960242AC110002, 4, 'Golang', '主要技术能力 Golang');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E25CDDF06DAF960242AC110002, 0x11ED732D8C760098AF960242AC110002, 5, 'PHP', '主要技术能力 PHP');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E263B124F1AF960242AC110002, 0x11ED732D8C760098AF960242AC110002, 6, 'Vue', '主要技术能力 Vue');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E289995805AF960242AC110002, 0x11ED732FA4D8DA01AF960242AC110002, 0, '无', '无主要语言能力');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E2BA338DA9AF960242AC110002, 0x11ED732FA4D8DA01AF960242AC110002, 1, '日语 N4', '主要语言能力 日语 N4');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E2C11D264AAF960242AC110002, 0x11ED732FA4D8DA01AF960242AC110002, 2, '日语 N3', '主要语言能力 日语 N3');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E2C56A8B49AF960242AC110002, 0x11ED732FA4D8DA01AF960242AC110002, 3, '日语 N2', '主要语言能力 日语 N2');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E2C9CEF522AF960242AC110002, 0x11ED732FA4D8DA01AF960242AC110002, 4, '日语 N1', '主要语言能力 日语 N1');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E2E4363590AF960242AC110002, 0x11ED732FA4D8DA01AF960242AC110002, 5, '英语 4 级', '主要语言能力 英语 4 级');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E303071191AF960242AC110002, 0x11ED732FA4D8DA01AF960242AC110002, 6, '英语 6 级', '主要语言能力 英语 6 级');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E321A08017AF960242AC110002, 0x11ED732FAD0E61D4AF960242AC110002, 0, '校招', '校园招聘会');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E360CEA1EEAF960242AC110002, 0x11ED732FAD0E61D4AF960242AC110002, 1, '官网', '官方网站');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E37815FD20AF960242AC110002, 0x11ED732FAD0E61D4AF960242AC110002, 2, '内推', '内部推荐');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E386B6DE42AF960242AC110002, 0x11ED732FAD0E61D4AF960242AC110002, 3, '宣讲会', '宣讲会');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E390257EB4AF960242AC110002, 0x11ED732FAD0E61D4AF960242AC110002, 4, '招聘软件', '招聘软件');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E39D2F1B08AF960242AC110002, 0x11ED732FAD0E61D4AF960242AC110002, 5, '其它', '其它来源');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E3AF5AE68AAF960242AC110002, 0x11ED732FB49D3B41AF960242AC110002, 0, '不服从', '不服从');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E3BA46D84FAF960242AC110002, 0x11ED732FB49D3B41AF960242AC110002, 1, '服从', '服从');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E3EDA29B5AAF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 2, '等待简历 Review', '等待简历 Review');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E3FD31DBB3AF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 3, '等待指定面试官', '等待指定面试官');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E405B3A454AF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 4, '等待确定面试时间', '等待确定面试时间');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E40DE83DF4AF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 5, '等待面试', '等待面试');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4134FCCA8AF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 6, '等待面试提交反馈', '等待面试提交反馈');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E418D31E6DAF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 7, '简历 Review NG', '简历ReviewNG');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E41F33318DAF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 8, '面试 OK', '面试 OK');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E424906497AF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 9, '面试 NG', '面试 NG');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E42DB6F87CAF960242AC110002, 0x11ED732FBDBAA6F8AF960242AC110002, 10, 'HOLD', 'HOLD');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E438039D1EAF960242AC110002, 0x11ED732FC5B8012FAF960242AC110002, 0, 'NG', 'NG');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E43C822CFFAF960242AC110002, 0x11ED732FC5B8012FAF960242AC110002, 1, 'OK', 'OK');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4ACBAA40BAF960242AC110002, 0x11ED732FD4533E91AF960242AC110002, 1, '技术水平和经验', '技术水平和经验');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4B7148669AF960242AC110002, 0x11ED732FD4533E91AF960242AC110002, 2, '语言水平', '语言水平');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4C112C1A4AF960242AC110002, 0x11ED732FD4533E91AF960242AC110002, 3, '管理经验', '管理经验');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4CD503B77AF960242AC110002, 0x11ED732FD4533E91AF960242AC110002, 4, '沟通能力', '沟通能力');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4E1B76D75AF960242AC110002, 0x11ED732FD4533E91AF960242AC110002, 5, '长期 AMS 作业适应能力', '长期 AMS 作业适应能力');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4EE333279AF960242AC110002, 0x11ED732FD4533E91AF960242AC110002, 6, '客户应对能力', '客户应对能力');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E4F99183C6AF960242AC110002, 0x11ED732FD4533E91AF960242AC110002, 7, '性格态度', '性格态度');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E5B1C92AA6AF960242AC110002, 0x11ED73E48BD5B190AF960242AC110002, 1, '即使当前 position 没有出差需求，未来如果需要出差，是否可以接受？可以接受为期多久的出差？', '即使当前 position 没有出差需求，未来如果需要出差，是否可以接受？可以接受为期多久的出差？');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E621417CDDAF960242AC110002, 0x11ED73E48BD5B190AF960242AC110002, 2, '是否接受日本工作时间 (早八晚五) 以及日本日历出勤？(中国法定假日，如双十一，春节期间等需正常上班) 个别开发项目有可能根据项目实际进行适当调整，是否接受？', '是否接受日本工作时间 (早八晚五) 以及日本日历出勤？(中国法定假日，如双十一，春节期间等需正常上班) 个别开发项目有可能根据项目实际进行适当调整，是否接受？');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E63BE151E2AF960242AC110002, 0x11ED73E48BD5B190AF960242AC110002, 3, '是否保证至少两年在本项目工作稳定？', '是否保证至少两年在本项目工作稳定？');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E65876D8D9AF960242AC110002, 0x11ED73E48BD5B190AF960242AC110002, 4, '如果有离开项目的计划，是否可以提前三个月同 leader 沟通？', '如果有离开项目的计划，是否可以提前三个月同 leader 沟通？');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E66E0DB5DCAF960242AC110002, 0x11ED732FE12D4A0DAF960242AC110002, 1, '简历上传备注', '');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E674CDF33EAF960242AC110002, 0x11ED732FE12D4A0DAF960242AC110002, 2, 'Review 备注', '');
INSERT INTO `t_dictionary_value` VALUES (0x11ED73E67B2BE9E7AF960242AC110002, 0x11ED732FE12D4A0DAF960242AC110002, 3, '面试反馈备注', '');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78A924489B58A7840242AC110004, 0x11ED78A8FE8BD85EA7840242AC110004, 2, '姓名', 'r.name');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78A940A20B78A7840242AC110004, 0x11ED78A8FE8BD85EA7840242AC110004, 3, '邮箱', 'r.email');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78A95B53F048A7840242AC110004, 0x11ED78A8FE8BD85EA7840242AC110004, 4, '毕业院校', 'r.grad_school');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78A967C5EE97A7840242AC110004, 0x11ED78A8FE8BD85EA7840242AC110004, 5, '专业', 'r.major');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8909C7776A7840242AC110004, 0x11ED78B86DDD913EA7840242AC110004, 1, '一周之内', '面试一览画面录入时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B89C36F8E2A7840242AC110004, 0x11ED78B86DDD913EA7840242AC110004, 2, '一个月之内', '面试一览画面录入时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8B288A27CA7840242AC110004, 0x11ED78B86DDD913EA7840242AC110004, 3, '三个月之内', '面试一览画面录入时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8B6DC7440A7840242AC110004, 0x11ED78B86DDD913EA7840242AC110004, 4, '半年之内', '面试一览画面录入时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8BB21BFFFA7840242AC110004, 0x11ED78B86DDD913EA7840242AC110004, 5, '一年之内', '面试一览画面录入时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8BF1F86B9A7840242AC110004, 0x11ED78B86DDD913EA7840242AC110004, 6, '一年以上', '面试一览画面录入时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8EF62698FA7840242AC110004, 0x11ED78B8CD99D614A7840242AC110004, 1, '2019', '面试一览画面毕业时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8F30E6A35A7840242AC110004, 0x11ED78B8CD99D614A7840242AC110004, 2, '2020', '面试一览画面毕业时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8F56B6602A7840242AC110004, 0x11ED78B8CD99D614A7840242AC110004, 3, '2021', '面试一览画面毕业时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED78B8F844581BA7840242AC110004, 0x11ED78B8CD99D614A7840242AC110004, 4, '2022', '面试一览画面毕业时间可选项');
INSERT INTO `t_dictionary_value` VALUES (0x11ED7D1E20804C759B940242AC110006, 0x11ED732FBDBAA6F8AF960242AC110002, 1, '等待分配 Reviewer', '等待分配 Reviewer');
INSERT INTO `t_dictionary_value` VALUES (0x11ED80EA3B85470CA9130242AC110003, 0x11ED78A8FE8BD85EA7840242AC110004, 1, '面试编号', 'BIN_TO_UUID(i.id)');
INSERT INTO `t_dictionary_value` VALUES (0x11ED9170FFF8455A8C390242AC110003, 0x11ED78B8CD99D614A7840242AC110004, 5, '2023', '');

-- ----------------------------
-- Table structure for t_interview
-- ----------------------------
DROP TABLE IF EXISTS `t_interview`;
CREATE TABLE `t_interview`  (
  `id` varbinary(16) NOT NULL COMMENT '面试ID',
  `resume_id` varbinary(16) NOT NULL COMMENT '对应简历表ID',
  `date` datetime NULL DEFAULT NULL COMMENT '面试时间',
  `interviewer_1` varbinary(16) NULL DEFAULT NULL COMMENT '面试官1,用户表ID',
  `interviewer_2` varbinary(16) NULL DEFAULT NULL COMMENT '面试官2,用户表ID',
  `interviewer_3` varbinary(16) NULL DEFAULT NULL COMMENT '面试官3,用户表ID',
  `interviewer_4` varbinary(16) NULL DEFAULT NULL COMMENT '面试官4,用户表ID',
  `status` int NOT NULL COMMENT '面试状态，对应数据字典值表',
  `creater` varbinary(16) NOT NULL COMMENT '创建人ID',
  `creat_date` datetime NOT NULL COMMENT '创建时间',
  `modifyer` varbinary(16) NULL DEFAULT NULL COMMENT '修改人ID',
  `modify_date` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `reviewer` varbinary(16) NULL DEFAULT NULL COMMENT 'Review人,用户表ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_reviewer`(`reviewer` ASC) USING BTREE COMMENT '审阅人索引，对应t_user表id',
  INDEX `idx_modity_date`(`modify_date` ASC) USING BTREE COMMENT '修改时间索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_interview
-- ----------------------------
INSERT INTO `t_interview` VALUES (0x05152E1311ED8DC7A9130242AC110003, 0x11ED8DC72E05BD9AA9130242AC110003, NULL, NULL, NULL, NULL, NULL, 10, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-06 21:36:52', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 22:10:50', 0x11ED6A2F3697BA95AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED6A3FEE72A57AAF960242AC110002, 0x11ED6A3A627C41E2AF960242AC110002, '2022-12-17 18:54:41', 0x11ED6A2EA820DAC7AF960242AC110002, 0x11ED7F59CF9E2D9E82E40242AC110006, NULL, NULL, 5, 0x1DAAF2D067DC11EDAF960242AC110002, '2022-11-22 00:00:00', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 01:19:11', 0x11ED7F59CF9E2D9E82E40242AC110006);
INSERT INTO `t_interview` VALUES (0x11ED6A40306EC36FAF960242AC110002, 0x11ED6A3B61CFF355AF960242AC110002, NULL, NULL, NULL, NULL, NULL, 2, 0x1DAAF2D067DC11EDAF960242AC110002, '2022-11-22 00:00:00', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-10 20:14:21', 0x11ED6A2EA820DAC7AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED6A404535F601AF960242AC110002, 0x11ED6A3A36F78919AF960242AC110002, NULL, NULL, NULL, NULL, NULL, 3, 0x1DAAF2D067DC11EDAF960242AC110002, '2022-11-22 00:00:00', 0x1DAAF2D067DC11EDAF960242AC110002, '2022-12-18 17:36:52', 0x11ED6A2F3697BA95AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED6A405035E3BBAF960242AC110002, 0x11ED6A3B80DCE972AF960242AC110002, NULL, NULL, NULL, NULL, NULL, 8, 0x1DAAF2D067DC11EDAF960242AC110002, '2022-11-22 00:00:00', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 00:06:08', 0x11ED6A2F3697BA95AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED6A40ED5C7813AF960242AC110002, 0x11ED6A3B849948A2AF960242AC110002, NULL, 0x11ED6A2EA820DAC7AF960242AC110002, NULL, NULL, NULL, 4, 0x1DAAF2D067DC11EDAF960242AC110002, '2020-10-01 00:00:00', 0x1DAAF2D067DC11EDAF960242AC110002, '2022-12-18 17:37:15', 0x11ED759BE4D61AEAAF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED6A41364FCD53AF960242AC110002, 0x11ED6A3BD909A622AF960242AC110002, NULL, NULL, NULL, NULL, NULL, 7, 0x1DAAF2D067DC11EDAF960242AC110002, '2022-11-22 00:00:00', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 00:00:55', 0x11ED6A2F3697BA95AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED8F2A551547E08C390242AC110003, 0x11ED8F2A550787888C390242AC110003, '2023-01-08 21:44:43', 0x11ED6A2EA820DAC7AF960242AC110002, NULL, NULL, NULL, 5, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 15:59:09', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-09 12:14:51', 0x11ED6A2EA820DAC7AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED8F4DE8E612FA8C390242AC110003, 0x11ED8F4DE8DBA65F8C390242AC110003, '2023-01-20 00:20:00', 0x11ED6A2EA820DAC7AF960242AC110002, NULL, NULL, NULL, 9, 0x11ED759BFC52D835AF960242AC110002, '2023-01-08 20:13:50', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 22:13:17', 0x11ED6A2F3697BA95AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED8F53758E89A18C390242AC110003, 0x11ED8F53758C32528C390242AC110003, NULL, NULL, NULL, NULL, NULL, 2, 0x11ED759BFC52D835AF960242AC110002, '2023-01-08 20:53:33', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11 13:32:15', 0x11ED7F59CF9E2D9E82E40242AC110006);
INSERT INTO `t_interview` VALUES (0x11ED8F5A0F42014B8C390242AC110003, 0x11ED8F5A0F1E27118C390242AC110003, NULL, NULL, NULL, NULL, NULL, 2, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 21:40:48', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 21:55:56', 0x11ED6A2EA820DAC7AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED8F5CD54348188C390242AC110003, 0x11ED8F5CD53D9B5A8C390242AC110003, NULL, 0x11ED6A2EA820DAC7AF960242AC110002, NULL, NULL, NULL, 4, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 22:00:39', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 22:11:22', 0x11ED6A2EA820DAC7AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED8FCF652A23E68C390242AC110003, 0x11ED8FCF65251B548C390242AC110003, NULL, NULL, NULL, NULL, NULL, 4, 0x11ED759BFC52D835AF960242AC110002, '2023-01-09 11:40:43', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11 12:12:58', 0x11ED6A2EA820DAC7AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED8FD51B779A2F8C390242AC110003, 0x11ED8FD51B735B718C390242AC110003, NULL, NULL, NULL, NULL, NULL, 2, 0x11ED759BFC52D835AF960242AC110002, '2023-01-09 12:21:37', NULL, NULL, 0x11ED759BE4D61AEAAF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED90D79D131D7F8C390242AC110003, 0x11ED90D79D0CF31A8C390242AC110003, NULL, NULL, NULL, NULL, NULL, 7, 0x11ED759BFC52D835AF960242AC110002, '2023-01-10 19:12:04', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11 12:14:25', 0x11ED7F59CF9E2D9E82E40242AC110006);
INSERT INTO `t_interview` VALUES (0x11ED90E23C1083968C390242AC110003, 0x11ED90E23C0E900F8C390242AC110003, NULL, NULL, NULL, NULL, NULL, 2, 0x11ED759BFC52D835AF960242AC110002, '2023-01-10 20:28:06', NULL, NULL, 0x11ED759BE4D61AEAAF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED91642022FB0E8C390242AC110003, 0x11ED9164201BBF828C390242AC110003, NULL, NULL, NULL, NULL, NULL, 2, 0x11ED759BFC52D835AF960242AC110002, '2023-01-11 11:57:54', NULL, NULL, 0x11ED759BE4D61AEAAF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED917271A2A4D68C390242AC110003, 0x11ED9172719BB2E08C390242AC110003, '2023-01-26 00:00:00', 0x11ED7F59CF9E2D9E82E40242AC110006, NULL, NULL, NULL, 5, 0x11ED759BFC52D835AF960242AC110002, '2023-01-11 13:40:23', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11 13:49:16', 0x11ED6A2EA820DAC7AF960242AC110002);
INSERT INTO `t_interview` VALUES (0x11ED91770057472B8C390242AC110003, 0x11ED8DC72E05BD9AA9130242AC110003, NULL, NULL, NULL, NULL, NULL, 1, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11 14:13:01', NULL, NULL, NULL);
INSERT INTO `t_interview` VALUES (0x1749183411ED8E9385460242AC110003, 0x11ED8E93182F9FE085460242AC110003, NULL, NULL, NULL, NULL, NULL, 2, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-07 21:56:33', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 01:28:52', 0x11ED759BE4D61AEAAF960242AC110002);
INSERT INTO `t_interview` VALUES (0x2998560211ED8EAB85460242AC110003, 0x11ED8EAB55F067B185460242AC110003, '2023-01-09 01:15:40', 0x11ED6A2F3697BA95AF960242AC110002, NULL, NULL, NULL, 5, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 00:50:05', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 01:15:42', 0x11ED7F59CF9E2D9E82E40242AC110006);
INSERT INTO `t_interview` VALUES (0x41A1F1CE11ED8E8A85460242AC110003, 0x11ED8E8AF1C432BC85460242AC110003, NULL, NULL, NULL, NULL, NULL, 4, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-07 20:58:13', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08 00:01:44', 0x11ED7F59CF9E2D9E82E40242AC110006);

-- ----------------------------
-- Table structure for t_interview_feedback
-- ----------------------------
DROP TABLE IF EXISTS `t_interview_feedback`;
CREATE TABLE `t_interview_feedback`  (
  `id` varbinary(16) NOT NULL COMMENT '面试反馈ID',
  `interview_id` varbinary(16) NOT NULL COMMENT '对应面试表ID',
  `interviewer` varbinary(16) NOT NULL COMMENT '评价人，对应用户表ID',
  `result` int NULL DEFAULT NULL COMMENT '面试结果:是否通过,数据字典值',
  `ref_dept_id` varbinary(16) NULL DEFAULT NULL COMMENT '参考部门ID',
  `ref_position` int NULL DEFAULT NULL COMMENT '推荐职位',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_interview_feedback
-- ----------------------------
INSERT INTO `t_interview_feedback` VALUES (0x11ED8FCC6B7D81998C390242AC110003, 0x11ED6A3FEE72A57AAF960242AC110002, 0x11ED7F59CF9E2D9E82E40242AC110006, 1, NULL, NULL);
INSERT INTO `t_interview_feedback` VALUES (0x11ED8FCDC4834E368C390242AC110003, 0x11ED6A3FEE72A57AAF960242AC110002, 0x11ED7F59CF9E2D9E82E40242AC110006, 0, NULL, NULL);
INSERT INTO `t_interview_feedback` VALUES (0x11ED8FCDDEC4D9918C390242AC110003, 0x11ED6A3FEE72A57AAF960242AC110002, 0x11ED7F59CF9E2D9E82E40242AC110006, 0, NULL, NULL);
INSERT INTO `t_interview_feedback` VALUES (0x11ED91742C203F888C390242AC110003, 0x11ED6A3FEE72A57AAF960242AC110002, 0x11ED7F59CF9E2D9E82E40242AC110006, 1, NULL, NULL);

-- ----------------------------
-- Table structure for t_interview_feedback_score
-- ----------------------------
DROP TABLE IF EXISTS `t_interview_feedback_score`;
CREATE TABLE `t_interview_feedback_score`  (
  `id` varbinary(16) NOT NULL COMMENT '面试反馈得分ID',
  `interview_feedback_id` varbinary(16) NOT NULL COMMENT '对应面试表反馈表ID',
  `item` int NOT NULL COMMENT '得分项，对应数据字典值表',
  `score` int NOT NULL COMMENT '分数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_interview_feedback_score
-- ----------------------------

-- ----------------------------
-- Table structure for t_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission`  (
  `id` varbinary(16) NOT NULL COMMENT '权限ID',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限名',
  `code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限代码',
  `path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '前端路径',
  `is_menu` int NOT NULL COMMENT '是否是前端路径',
  `order_by` int NOT NULL COMMENT '排序依据',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_order_by`(`order_by` ASC) USING BTREE COMMENT '排序索引',
  INDEX `idx_is_menu`(`is_menu` ASC) USING BTREE COMMENT '菜单索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_permission
-- ----------------------------
INSERT INTO `t_permission` VALUES (0x11ED67DC1D24125DAF960242AC110002, '简历上传', 'cvUpload:*:*', '/index/cvUpload', 1, 2);
INSERT INTO `t_permission` VALUES (0x11ED67DC1D282F92AF960242AC110002, '面试一览', 'interviewManage:*:*', '/index/interviewOverview', 1, 3);
INSERT INTO `t_permission` VALUES (0x11ED67DC1D2C4D03AF960242AC110002, '简历 Review', 'cvReview:*:*', '/index/cvReview', 1, 4);
INSERT INTO `t_permission` VALUES (0x11ED67DC1D35931FAF960242AC110002, '面试反馈', 'interviewFeedback:*:*', '/index/interviewFeedback', 1, 5);
INSERT INTO `t_permission` VALUES (0x11ED6A32D7383E36AF960242AC110002, '工作台', 'workbench:*:*', '/index/workbench', 1, 1);
INSERT INTO `t_permission` VALUES (0x11ED6A33008FC7F8AF960242AC110002, '部门管理', 'deptManage:*:*', '/index/deptManage', 1, 10);
INSERT INTO `t_permission` VALUES (0x11ED6A331D8045DEAF960242AC110002, '历史面试', 'historyInterview:*:*', '/index/historyInterview', 1, 6);
INSERT INTO `t_permission` VALUES (0x11ED6A333680A22BAF960242AC110002, '用户管理', 'userManage:*:*', '/index/userManage', 1, 9);
INSERT INTO `t_permission` VALUES (0x11ED6A337AF4A9C9AF960242AC110002, '数据字典类型管理', 'dictionaryTypeManage:*:*', '/index/dictionaryTypeManage', 1, 7);
INSERT INTO `t_permission` VALUES (0x11ED6A347AEB6A58AF960242AC110002, '数据字典值管理', 'dictionaryValueKeyManage:*:*', '/index/dictionaryValueManage', 1, 8);
INSERT INTO `t_permission` VALUES (0x11ED7E032BE0BF85AEBF0242AC110006, '历史面试', 'historyInterview:*:overPath', 'historyInterview', 2, 11);
INSERT INTO `t_permission` VALUES (0x11ED7E033E8F7D16AEBF0242AC110006, '简历 Review', 'CVReview:*:overPath', 'cvReview', 2, 12);
INSERT INTO `t_permission` VALUES (0x11ED7E0348054C25AEBF0242AC110006, '面试反馈', 'interviewFeedback:*:overPath', 'interviewFeedback', 2, 13);
INSERT INTO `t_permission` VALUES (0x11ED7E03565D67BAAEBF0242AC110006, '更新面试信息', 'updateInterviewInfo:*:overPath', '', 2, 14);
INSERT INTO `t_permission` VALUES (0x11ED7E036D63B774AEBF0242AC110006, '更新面试状态', 'editInterviewStatus:*:overPath', '', 2, 15);

-- ----------------------------
-- Table structure for t_resume
-- ----------------------------
DROP TABLE IF EXISTS `t_resume`;
CREATE TABLE `t_resume`  (
  `id` varbinary(16) NOT NULL COMMENT '简历ID',
  `file_path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件路径',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `sex` int NOT NULL COMMENT '性别,数据字典值表',
  `birthday` date NOT NULL COMMENT '生日',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '邮箱',
  `tel` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '电话',
  `education` int NOT NULL COMMENT '学历,数据字典值表',
  `grad_date` date NULL DEFAULT NULL COMMENT '毕业时间',
  `grad_school` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '毕业学校',
  `major` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '专业',
  `tech_ability` int NULL DEFAULT NULL COMMENT '技术能力,数据字典值表',
  `lang_ability` int NULL DEFAULT NULL COMMENT '语言能力,数据字典值表',
  `other_ability` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '其它能力',
  `work_experience` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '工作经验',
  `self_assessment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '自我评价',
  `source` int NULL DEFAULT NULL COMMENT '简历来源,数据字典值表',
  `internal_recommender` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '内推人名字',
  `intended_dept` varbinary(16) NULL DEFAULT NULL COMMENT '意向部门,部门表ID',
  `obey` int NULL DEFAULT NULL COMMENT '是否服从分配,数据字典值表',
  `creater` varbinary(16) NOT NULL COMMENT '创建人ID',
  `creat_date` date NOT NULL COMMENT '创建时间',
  `modifyer` varbinary(16) NULL DEFAULT NULL COMMENT '修改人ID',
  `modify_date` date NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_resume
-- ----------------------------
INSERT INTO `t_resume` VALUES (0x11ED6A3A36F78919AF960242AC110002, NULL, '张二三', 1, '1992-12-12', '333322@qq.com', '11122233344444', 2, '2008-03-22', '上海交通大学', '计算机科学技术', 3, 1, '具有演讲经验', NULL, '自我感觉良好', 1, NULL, 0x11ED6A375668F368AF960242AC110002, 1, 0x11ED6A2EA820DAC7AF960242AC110002, '2022-11-22', 0x1DAAF2D067DC11EDAF960242AC110002, '2022-12-18');
INSERT INTO `t_resume` VALUES (0x11ED6A3A627C41E2AF960242AC110002, '/rms/简历.pdf', '刘嘉宁', 1, '2022-07-01', 'liujianing@ibm.com', '12233334444', 2, '2022-07-01', '大连交通大学', '软件工程', 1, 1, '有对象', '无', '很帅', 0, NULL, 0x11ED6A375668F368AF960242AC110002, 0, 0x1DAAF2D067DC11EDAF960242AC110002, '2022-11-22', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED6A3B61CFF355AF960242AC110002, '/1921030124leijun.pdf', '雷军', 1, '1980-06-01', 'leijun@ibm.com', '12233334444', 4, '2001-07-01', '武汉大学', '计算机科学与技术', 2, 0, '领导力', 'CEO', 'Are You OK', 2, NULL, 0x11ED6A375668F368AF960242AC110002, 1, 0x1DAAF2D067DC11EDAF960242AC110002, '2022-11-22', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED6A3B80DCE972AF960242AC110002, NULL, '李六', 1, '1992-10-21', '31111322@qq.com', '11222233344444', 3, '2008-06-12', '上海复旦大学', '物联网管理控制', 3, 1, '具有演讲经验', NULL, '喜欢做xxx，不喜欢xxx，能满足公司要求', 1, NULL, 0x11ED6A375668F368AF960242AC110002, 1, 0x11ED6A2EA820DAC7AF960242AC110002, '2022-11-22', 0x1DAAF2D067DC11EDAF960242AC110002, '2022-12-18');
INSERT INTO `t_resume` VALUES (0x11ED6A3B849948A2AF960242AC110002, '/1921030130CYM.pdf', '陈亚明', 1, '1980-06-01', 'leijun@ibm.com', '12233334444', 4, '2022-07-01', '大连交通大学', '软件工程', 1, 1, '练习两年半', '唱跳rap', '鸡', 0, NULL, 0x11ED6A375668F368AF960242AC110002, 0, 0x11ED6A2F3697BA95AF960242AC110002, '2022-11-22', 0x1DAAF2D067DC11EDAF960242AC110002, '2022-12-18');
INSERT INTO `t_resume` VALUES (0x11ED6A3BD909A622AF960242AC110002, '/1921030130das.pdf', '王五', 1, '2002-02-11', 'wangwu@ibm.com', '18866669999', 4, '2022-07-01', '清华大学', '软件工程', 1, 1, '无', '无', '无', 0, NULL, 0x11ED6A36EDAD7C83AF960242AC110002, 0, 0x11ED6A2F3697BA95AF960242AC110002, '2022-11-22', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08');
INSERT INTO `t_resume` VALUES (0x11ED8DC72E05BD9AA9130242AC110003, '/rms/20230106213601-第一组.pptx', '傅组', 0, '2023-01-06', 'asdf@ljklha.com', '14422223333', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'CEO', NULL, NULL, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-06', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08');
INSERT INTO `t_resume` VALUES (0x11ED8E8AF1C432BC85460242AC110003, '/rms/20230107125808-车馨心简历.pdf', '李四', 1, '2023-01-13', '1151531237@qq.com', '18504167396', 2, '2023-01-30', '大连交通大学', '软件工程', 1, 3, '无', '无', '无', 1, NULL, 0x11ED6A37565CB1A2AF960242AC110002, 0, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-07', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08');
INSERT INTO `t_resume` VALUES (0x11ED8E93182F9FE085460242AC110003, '/rms/20230107134632-车馨心简历.pdf', '车馨心', 0, '2023-01-04', '1151531237@qq.com', '18504167396', 2, '2023-01-10', '大连交通大学', '软件工程', 1, 6, '无', NULL, NULL, 2, NULL, NULL, NULL, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-07', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED8EAB55F067B185460242AC110003, '/rms/20230107164501-张三简历.jpg', '王富贵', 1, '2000-07-04', 'wangfugui@fake.com', '15522223333', 5, '2023-07-01', '印尼开放大学', '母猪产后护理', 0, 0, '公猪也能护理', '在俺老家山西照顾过100余头母猪', '人猪合一', 4, NULL, 0x11ED6A36EDAD7C83AF960242AC110002, 0, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08');
INSERT INTO `t_resume` VALUES (0x11ED8F2A550787888C390242AC110003, '/rms/20230108075704-汇报todo.txt', '吴迪', 1, '2023-01-05', 'test@test.test', '14422223333', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED8F4DE8DBA65F8C390242AC110003, '/rms/20230108121346-车馨心简历.pdf', '赵武', 1, '2001-01-11', '1151531237@qq.com', '18504167396', 1, '2023-01-30', '辽东学院', '英语', 1, 5, NULL, NULL, NULL, 0, NULL, 0x11ED6A36EDAD7C83AF960242AC110002, 0, 0x11ED759BFC52D835AF960242AC110002, '2023-01-08', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED8F53758C32528C390242AC110003, '/rms/20230108124801-车馨心简历.pdf', '车馨心', 0, '2023-01-12', '1151531237@qq.com', '18504167396', 2, NULL, NULL, NULL, 1, 6, NULL, NULL, NULL, 2, NULL, 0x11ED6A37565CB1A2AF960242AC110002, 1, 0x11ED759BFC52D835AF960242AC110002, '2023-01-08', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED8F5A0F1E27118C390242AC110003, '/rms/20230108134042-王馨玉求职简历.pdf', '王馨玉', 0, '2001-12-16', 'wangxy@qq.com', '18566669999', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED8F5CD53D9B5A8C390242AC110003, '/rms/20230108140037-Shiro.jpg', 'mike', 0, '2023-01-08', 'qqq@qq.qq', '13322224444', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-08', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED8FCF65251B548C390242AC110003, '/rms/20230109034042-车馨心简历.pdf', '王玉', 0, '2023-01-04', '15464@qq.com', '18504198756', 1, NULL, NULL, NULL, 3, 0, NULL, NULL, NULL, 1, NULL, 0x11ED6A36EDAD7C83AF960242AC110002, 0, 0x11ED759BFC52D835AF960242AC110002, '2023-01-09', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11');
INSERT INTO `t_resume` VALUES (0x11ED8FD51B735B718C390242AC110003, '/rms/20230109042134-Lily简历.pdf', 'Lily', 0, '2023-01-02', '58647@qq.com', '18547963254', 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, '宋月', 0x11ED6A37565CB1A2AF960242AC110002, 0, 0x11ED759BFC52D835AF960242AC110002, '2023-01-09', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED90D79D0CF31A8C390242AC110003, '/rms/20230110110417-陈晓简历.pdf', '车馨心', 0, '2023-01-03', '15487@qq.com', '18504167986', 2, NULL, NULL, NULL, 1, 6, NULL, NULL, NULL, 1, NULL, 0x11ED6A37565CB1A2AF960242AC110002, 1, 0x11ED759BFC52D835AF960242AC110002, '2023-01-10', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11');
INSERT INTO `t_resume` VALUES (0x11ED90E23C0E900F8C390242AC110003, '/rms/20230110122441-陈晓简历.pdf', '陈晓', 1, '2023-01-02', '15487@qq.com', '18546975263', 1, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, 1, NULL, 0x11ED6A37565CB1A2AF960242AC110002, 1, 0x11ED759BFC52D835AF960242AC110002, '2023-01-10', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED9164201BBF828C390242AC110003, '/rms/20230111035308-李胜利简历.pdf', '李胜利', 1, '2023-01-01', '14895@qq.com', '14598759636', 4, NULL, NULL, NULL, 0, 4, NULL, NULL, NULL, 0, NULL, 0x11ED6A37565CB1A2AF960242AC110002, 1, 0x11ED759BFC52D835AF960242AC110002, '2023-01-11', NULL, NULL);
INSERT INTO `t_resume` VALUES (0x11ED9172719BB2E08C390242AC110003, '/rms/20230111053728-李胜利简历.pdf', '车馨心', 0, '2023-01-01', '14875@qq.com', '18504169874', 2, '2023-06-30', NULL, NULL, 1, 6, NULL, NULL, NULL, 0, NULL, 0x11ED6A37565CB1A2AF960242AC110002, 1, 0x11ED759BFC52D835AF960242AC110002, '2023-01-11', 0x11ED7F59CF9E2D9E82E40242AC110006, '2023-01-11');

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role`  (
  `id` varbinary(16) NOT NULL COMMENT '角色ID',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名',
  `comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色备注',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_name`(`name` ASC) USING BTREE COMMENT '角色名索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES (0x11ED67DC1D5115B2AF960242AC110002, 'ROLE_pmo', '项目管理人员, 有着人员管理的职务');
INSERT INTO `t_role` VALUES (0x11ED67DC1D553647AF960242AC110002, 'ROLE_reviewer', '简历审阅人, 有着一票  NG 的权利');
INSERT INTO `t_role` VALUES (0x11ED67DC1D59EC45AF960242AC110002, 'ROLE_gl', '技术面试官');
INSERT INTO `t_role` VALUES (0x11ED67DC1D62294CAF960242AC110002, 'ROLE_leader', '领导');
INSERT INTO `t_role` VALUES (0x11ED6A2DACC2E8A6AF960242AC110002, 'ROLE_admin', '系统管理员');

-- ----------------------------
-- Table structure for t_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission`  (
  `id` varbinary(16) NOT NULL COMMENT '主键ID',
  `role_id` varbinary(16) NOT NULL COMMENT '角色ID',
  `permission_id` varbinary(16) NOT NULL COMMENT '权限ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_id`(`role_id` ASC) USING BTREE COMMENT '角色id索引',
  INDEX `idx_permission_id`(`permission_id` ASC) USING BTREE COMMENT '权限id索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
INSERT INTO `t_role_permission` VALUES (0x11ED7E063EA5B447AEBF0242AC110006, 0x11ED67DC1D553647AF960242AC110002, 0x11ED6A32D7383E36AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E063EA5B935AEBF0242AC110006, 0x11ED67DC1D553647AF960242AC110002, 0x11ED67DC1D282F92AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E063EA5BAB1AEBF0242AC110006, 0x11ED67DC1D553647AF960242AC110002, 0x11ED67DC1D2C4D03AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E063EA5BB83AEBF0242AC110006, 0x11ED67DC1D553647AF960242AC110002, 0x11ED7E033E8F7D16AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED7E063EA5BC92AEBF0242AC110006, 0x11ED67DC1D553647AF960242AC110002, 0x11ED7E036D63B774AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED7E064982E8EBAEBF0242AC110006, 0x11ED67DC1D59EC45AF960242AC110002, 0x11ED6A32D7383E36AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E064982ED28AEBF0242AC110006, 0x11ED67DC1D59EC45AF960242AC110002, 0x11ED67DC1D282F92AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E064982EE0FAEBF0242AC110006, 0x11ED67DC1D59EC45AF960242AC110002, 0x11ED67DC1D35931FAF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E064982EECCAEBF0242AC110006, 0x11ED67DC1D59EC45AF960242AC110002, 0x11ED7E0348054C25AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED7E064982EF76AEBF0242AC110006, 0x11ED67DC1D59EC45AF960242AC110002, 0x11ED7E036D63B774AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED7E0655074C16AEBF0242AC110006, 0x11ED67DC1D62294CAF960242AC110002, 0x11ED6A32D7383E36AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E06550750B3AEBF0242AC110006, 0x11ED67DC1D62294CAF960242AC110002, 0x11ED67DC1D282F92AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E0655075227AEBF0242AC110006, 0x11ED67DC1D62294CAF960242AC110002, 0x11ED6A331D8045DEAF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E06550752F3AEBF0242AC110006, 0x11ED67DC1D62294CAF960242AC110002, 0x11ED7E032BE0BF85AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED7E066420D7CEAEBF0242AC110006, 0x11ED6A2DACC2E8A6AF960242AC110002, 0x11ED6A337AF4A9C9AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E066420DC17AEBF0242AC110006, 0x11ED6A2DACC2E8A6AF960242AC110002, 0x11ED6A347AEB6A58AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E066420DD06AEBF0242AC110006, 0x11ED6A2DACC2E8A6AF960242AC110002, 0x11ED6A333680A22BAF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED7E066420DDB1AEBF0242AC110006, 0x11ED6A2DACC2E8A6AF960242AC110002, 0x11ED6A33008FC7F8AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA47398C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED6A32D7383E36AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA4BFD8C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED67DC1D24125DAF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA4DB08C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED67DC1D282F92AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA4EC18C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED67DC1D2C4D03AF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA50AA8C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED67DC1D35931FAF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA51C88C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED6A331D8045DEAF960242AC110002);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA528D8C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED7E032BE0BF85AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA535F8C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED7E033E8F7D16AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA540E8C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED7E0348054C25AEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA54B18C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED7E03565D67BAAEBF0242AC110006);
INSERT INTO `t_role_permission` VALUES (0x11ED91707AEA55588C390242AC110003, 0x11ED67DC1D5115B2AF960242AC110002, 0x11ED7E036D63B774AEBF0242AC110006);

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` varbinary(16) NOT NULL COMMENT '用户ID',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
  `password` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
  `sign_in_date` date NOT NULL COMMENT '注册时间',
  `dept_id` varbinary(16) NULL DEFAULT NULL COMMENT '所属部门，部门表ID',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '邮箱',
  `status` int NOT NULL COMMENT '状态,数据字典值表ID',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username_unique`(`username` ASC) USING BTREE COMMENT '用户名唯一'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (0x11ED6A2EA820DAC7AF960242AC110002, 'gengchen', '$2a$10$EHn2XOp2hEgrrJYb5aKgFOiv3YuEVYh4kTzTZGYp3/fFuCksIDOpW', '耿晨', '2022-11-22', 0x11ED6A375668F368AF960242AC110002, 'gengchen@mail.rms.cool', 0);
INSERT INTO `t_user` VALUES (0x11ED6A2F3697BA95AF960242AC110002, 'chenyaming', '$2a$10$/7d4SzHFzMil6MM4o1Ltu.opus9v0lRFSiP1BE8ayPlePUoeF40ve', '陈亚明', '2022-11-20', 0x11ED6A375668F368AF960242AC110002, 'chenyaming@mail.rms.cool', 0);
INSERT INTO `t_user` VALUES (0x11ED759BE4D61AEAAF960242AC110002, 'songyue', '$2a$10$zolQ9rb2kPbrbpMSQ5G29uVkqZZDeATq6Duzfqgpivh2WVk6XOYia', '宋月', '2022-12-07', 0x11ED6A36EDAD7C83AF960242AC110002, 'songyue@mail.rms.cool', 0);
INSERT INTO `t_user` VALUES (0x11ED759BFC52D835AF960242AC110002, 'chexinxin', '$2a$10$6kECUWpF/lEj1fmRoYyYGeaB71LmWItnntLe9.PRX0ODJHr4rbilC', '车馨心', '2022-12-07', 0x11ED6A37565CB1A2AF960242AC110002, 'chexinxin@mail.rms.cool', 0);
INSERT INTO `t_user` VALUES (0x11ED759C953AEFF1AF960242AC110002, 'zhangyi', '$2a$10$ChfL88XXVSKZZ5u.oVtUP.1M8oYY0Jk1piJRPxeb5teqR59h/qzRK', '张毅', '2022-12-07', 0x11ED6A375668F368AF960242AC110002, 'zhangyi@mail.rms.cool', 0);
INSERT INTO `t_user` VALUES (0x11ED76145FFE6184AF960242AC110002, 'fengxingxin', '$2a$10$MmnKHZpAfAbmQ8rEaTmGBu62Dzmp.gE3ofHD1eeok99ceL5UbEGLO', '丰兴鑫', '2022-12-07', 0x11ED6A37567C1C77AF960242AC110002, 'fengxingxin@mail.rms.cool', 1);
INSERT INTO `t_user` VALUES (0x11ED7F59CF9E2D9E82E40242AC110006, 'liujianing', '$2a$10$JlWhjFM6ZCjOXF6gqCqxkOxWs/UNIN2dn6gv2eYnx4SI8ucOiauC2', '刘嘉宁', '2022-12-08', 0x11ED6A375668F368AF960242AC110002, 'liujianing@mail.rms.cool', 0);
INSERT INTO `t_user` VALUES (0x11ED7F5AD73CB6AC82E40242AC110006, '9vhQd4', '3fQ34S09gW4145sxD2XO7mKskx3a3Zc29t7xqSzL1KAdhlM37ex3pecBHkEv', '赵远航', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'ty.mills@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7444A0C82E40242AC110006, 'oeE5n7', 'Qri5PR1sP68564lFAW94pY8VWB40ZA3GdcWa3olz8j1eJKNIr743boLshX99', '龚绍齐', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'jeane.jerde@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD74AF32182E40242AC110006, 'B39NyeFZ', 'Q8b6OwoSY3X9m9xP7U0cGtnl85Nr3Fy9cLB74grUJ8st6oOFFIAWe67K5ARF', '史越彬', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'haley.schowalter@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD74F599B82E40242AC110006, '7QRz5q3RfMWzRQ', 'xi0rwFEr6Z2mEu9AkLIeAq565F45l7l78naHh5J1UK00eQ50U4PDH47QTTAZ', '陶天磊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'dalene.weimann@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD755727182E40242AC110006, 'k3Tkk5B3F3F1WtTrRhwE', 'Hn6A89qRkmKrtBQ02o7hPzhBwVg8Ab96z1d4K6b6c16l5B6650pc70v68d5I', '孔峻熙', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'fabian.bergstrom@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD759910482E40242AC110006, 'zGXHvBS4k2', 'GJfP4AH2HZ8W0nml65gIuu2V7D99CH866g17FDQDdxd32i89GvjPL7PrR78Z', '毛炎彬', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'darnell.nitzsche@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD75D8D9982E40242AC110006, 'hLrnQ1', 'yb6OC91pD2jC911Qs3fLZiJ1HswAFs6d960Qi4JM5UBB6I50P9k2NrBNPxE2', '曾浩宇', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'willard.stamm@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD761CFD782E40242AC110006, 'c8dK27', 'seCW6q4n3pc27OIz58DyxWWtZ112l3aCjaeE03Ld3HG2U0D53X65S1ISap36', '任子默', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'curt.pollich@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD765C88D82E40242AC110006, 'O0ehdo', '8Jh31Y4QrTWJoGrv1fVRM0m95zgIqj0cHaBEz2mb8tnK303T2EZol7N9PpZ0', '熊哲瀚', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'gino.crist@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD76A0C2082E40242AC110006, 'Oi4536MbP66', 'i857983i929X889Eh0wvEkwV7DNY60g193H5XoqGgm2RP72gi1AUyaxPsME7', '钟明辉', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'sylvester.herman@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD76EC5F382E40242AC110006, '1AT4482', '3mjg2uFlbB849A8XLD8thS2r62255i2Z1XR5l9bkYWv4p18z943136dmn7n6', '谢志泽', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'erasmo.boehm@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD772C5A682E40242AC110006, 'c7dOSUPrG', 'd4jaz5FbTI87nV0A8aqFXT375Z52m8Jk9XJ75l6lRB3fqj1tdz5sRLW45WTW', '卢建辉', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'edmond.goyette@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD776DDBB82E40242AC110006, 'XWCyZS6', 'Cf053i3BM751AOqs6BK5xZ8X2s8720KyOlkySA9s14y4JKe1EdavsD3PUvnd', '熊展鹏', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'margret.daniel@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD77C369782E40242AC110006, '6HV5HY8bY4mJNlF', '5Els0523tls3mYe3Szp1Pf8Wk0bffXC005T7Py9Glg7Hu2ITo9N7u37GfXt1', '陆伟宸', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'hyon.legros@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD780748682E40242AC110006, 'Ksb8zQ', 'BHf3a1YlSXp9TaQu0aE72fCvjkO6MQg64i1Ro3Do6K9Wlc2vDuZbC95w33Ax', '丁烨磊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'kiyoko.windler@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD784C4EA82E40242AC110006, 't1l5RnL', 'wsBPQ6r39i596CMKkM238WWCtNB7jUNqV64MmsXG4i6sQWPxNnZN78e54b34', '白语堂', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'cheryl.lakin@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD789060982E40242AC110006, 'DVv34oL', 'D4nq6egePNc01I317sg0mIFav0aGTraZGIW3EZ84zsLAXlf8IBW84pvEx3a2', '冯嘉懿', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'tessa.purdy@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD78D23B782E40242AC110006, 'uF47l8', '9wtm7TLQqYAx7ZylD7T5HOsRs4Cs2EVc8i8Hh16W6i3Gwzk95lb892wADTEh', '叶琪', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'dwain.hahn@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD791D73382E40242AC110006, 'n8VT4MO21', 'B9ATagNIfN03T3oT9XgJU56IryB08Q58W5BS915ITYK4AAe5gzVSZPXAT06x', '夏致远', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'randy.ernser@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD796270182E40242AC110006, 'r2G196UVn2', 'FRQu9pVvV3Onq7SeP4ote7WeDNdU4h0w5Hlp5EH38rz2Hc3fHQ07MbhMVR5V', '崔思', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'terrell.miller@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD79A470182E40242AC110006, '0jRt23', '08ME9oOMOSed38U0EeGQojxDZd3H5jX6TvYIhP8CS0eX1Knt00aTQ3I903t0', '史子涵', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'alonzo.powlowski@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD79EB46B82E40242AC110006, '65sGgAoQ', 'KAw655XpOtIR79MCw0DE22ecd7r1FSMAV1vqGxiZh6b4VIbp7ZJ29MGFX8n7', '罗烨磊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'alvera.upton@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7A2D0FB82E40242AC110006, '3u4lP6', 'L2Ff5Us8k0rbjhu2RAsbvwY3yuTSC0n4dQmeqcaw71fk9R753BmG949ct5ip', '史风华', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'libby.koss@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7A6EBC282E40242AC110006, 'z4P1GS', 'M240rvOKz0m6725Ix0h4yO71X3Y49497V1R3oN2o1L1nT22qWt5pb0m1U8yU', '谢智辉', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'shaunna.beer@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7AB094E82E40242AC110006, 'EMdHS2W', '39jFG48CZF4dW38FVI5LBDE8ETuDXQ493PDbr0Y9dY5vzlDzG0C2y7d1iQ3O', '王明', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'wonda.lesch@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7AF293F82E40242AC110006, 'qng844lZ', 'P1NFaNnYn726h2ugx4R23nEIQm2a0qk074X3vWq978Ef1IJJD3l4mI87w6s9', '赖苑博', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'tennie.wolf@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7B34A5982E40242AC110006, '68f4oM', 'k66sXm1yR06rruNSCB502D1u4Uv4fSs911e7GiC7vO7gCrYWj6Do72KNGk4s', '傅峻熙', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'chanel.tromp@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7B7DDB482E40242AC110006, 'nayi0CO', 'cpkrmX3xX5ISt779186lC22B6JxySkR83aBZ4H5FC7N0G8cNksS185fPlfbU', '武嘉懿', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'teresita.hyatt@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7BBF42D82E40242AC110006, '9Ot87ys', 'XLy6ZAc4suTcAjPe3h5XQsap2eW914jn340DH7X1g8UVkC4WELSiq1nNhiSS', '孟熠彤', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'meaghan.treutel@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7C01BD982E40242AC110006, 'TUK5ce', 'i75kWh9oVB31V40xiKMa2ZduNJqt7h8Z2vc6ABxLC5860hEGrUI2GrDoa78n', '贾炎彬', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'oscar.kuhn@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7C5998782E40242AC110006, 'G6fI6v3', '5Mxdb6flVD037TCl69t9H3aivd5fZMNRyyM45B4up085xzX5x925YU746xU3', '钱潇然', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'keshia.lehner@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7CA043082E40242AC110006, 'Gy6fZ9', '50U4uO5zXSUK9B0Q1yVZ0X8M4k6vdYn1hMY8RN7vZPuU0oq59FImAF3Lt351', '方浩轩', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'kevin.schaefer@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7CE22AA82E40242AC110006, 'zrV7wyc', 'bFyU4Hp3uZBRN0wT6y578Owo17S518F3J6Aq5CiKV79VMHfrGQ44fq919RKh', '梁凯瑞', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'faustino.carroll@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7D291C982E40242AC110006, 'IUw561', '9cXsvgEY0qMH8McIyOv31oBCe6e26W7UQhHKG47cZh6QAv3ndVcoy59I03H9', '武鹏', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'gayle.williamson@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7D7494282E40242AC110006, '76bZ48', 'AEm2Ouq8hh8WrK35Rtsqcc2o96BskjRVtxKs25Hfv5nic0D6XCMDwWfS7cfs', '苏弘文', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'loraine.quigley@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7DCF08D82E40242AC110006, 'p9X4uHqgthJF8', 'LFXuUWN7D03Hl3Ze891w80k4FXWZ3gokmMhEr8tNubdZNW3h6mOdMezUMYnR', '高绍齐', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'marcelene.bechtelar@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7E0E33F82E40242AC110006, 'LRyW8o6V', 'CEzi748U3I5xTLd2q37f1gao5sO2QoOzSdL7MUJL27DsdZyR7960lS1pgI1e', '毛烨磊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'randell.osinski@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7E4E27E82E40242AC110006, '7VY4x8O3', 'Ux6bi2phlW1U5vzt1a3t22p978NF2c1DUq937BDf9k42WnMrGBt84U79Mn8y', '郝博超', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'jerri.thompson@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7E8FEE482E40242AC110006, 'kkcH1N9e8', 'R0rs5IHD1pm6KC3J5cICfI016C5zPw22AfSCM20HgZf2tS7U2TXxIGf19096', '戴荣轩', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'charissa.kuphal@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7EE0A8982E40242AC110006, 'E8iavcJ2QI906', 'OJODe3Fr3HqEW8Eg4OEQo7D9MQxxWxzaisa0SL2ol1TCyf6TwcSSQ0O8YQ43', '汪鹤轩', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'alena.larkin@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7F2011482E40242AC110006, 'aG32GZ1x', 'H19o668o8GC87sEFZOcbz0IP7DdfK802NOqB73N23Ww5IJUgdWFHTlYPSRgP', '范越泽', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'bernie.lindgren@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7F6215182E40242AC110006, 'snCAsk7wn', '7s5zX9q8F9B16qY49sRh3S6W69U794BDy8REcfk8nLc9Mh5dEyyw6ibhCPFA', '廖伟宸', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'jon.hane@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7FA171D82E40242AC110006, '0Z50V3w', 'VtJ0bC238La7K5O9u36QQ1K77dvlyO8mN9y85VBS06LWs3biM9DV8Du8CS5W', '戴伟诚', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'jamal.kuhlman@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD7FE395682E40242AC110006, 'XIM3001z6', 'AYc2NxKeSx659KN4N94MVGDCE5j1Ewq7E4Whu2Z3kY6mvyWlxF9sWp5ZD2rv', '曹健柏', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'vada.conroy@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8024D0F82E40242AC110006, 'c51I6a', '040nxvS37gFL9P48Z1w00u6fDVSI8d6lZoMMBrl39cF5PS6j0Id80e02jAFz', '林哲瀚', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'margot.macgyver@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8064D6882E40242AC110006, 'XAHc0Kv', 'iru9671TIJQ4zHjW2bZK1e9O8R7cX12loqWoNePXE20L1Zrl1267njnK68l5', '崔靖琪', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'aiko.mcdermott@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD80A70D382E40242AC110006, 'WO0xj63M', 'IHsOgZ83ipSlJR834HwTT5xTK9w9N1F6Hw63pD5d0H4ayXkBVksyMB34BFs6', '丁乐驹', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'delmy.corwin@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD80E649D82E40242AC110006, 'Sobc0AT', 'oeEO0nHTutIkLj3of8BRv6nnnWzgv18F134fac004KD1c4j0sNux5Mdd3VQ3', '邹伟诚', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'neida.ward@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8125C8682E40242AC110006, 'N9fnV1MOW', 'Ii9YR48iqd79rcLXV3HjExrD54Y2hGjCf64C11tO0Oo7q4BRc8183jve54p7', '邓子骞', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'jordan.gottlieb@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD816523882E40242AC110006, 'SLIp6N2G', 't2IQDd7dP7o2184OaJoUyS7nVn5uS00fe86ABEdVUR19I855VRB02sIdo23w', '范弘文', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'pablo.kiehn@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD81A49D382E40242AC110006, 'mD7q8e', 'iCzn9r2h2mv3pVNRY3o2038sbsCvo3E99vjM9Y9L42aUDo37pkDRq8In0ZR5', '朱晟睿', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'laurence.gleichner@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD81EDD1182E40242AC110006, '1b4c3ud8Tgna', 'YcQ3c142XRmN2br37D7UAQ8wM3o17gu2WxNhGYyQjRP0Z7K5fHIGy324BeY3', '郭鸿涛', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'emmett.anderson@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD822D98A82E40242AC110006, 'ol9OB0', 'HQatuI54H311cfU63Fg54Vh65jGMs89g1A1vL8SIgb9TR4GgJ6ilz1PjD7Rd', '韦鹏煊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'lilli.sawayn@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD826F5D582E40242AC110006, '3W7od6qc', 'J00708SL0Ku2Y3fR0Angc90P72ZGT9O0Gu8V15i2O4MY6WL2mo7E1RD7bNBU', '陶耀杰', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'gretta.swaniawski@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD82B178482E40242AC110006, '4Gl55r', 'Z3tW8Au088ii613M4B97upPQz4qGpA0932X7RFARubONh6daj2gT0Z8VY0a2', '彭天翊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'wm.kunde@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD82F2FD982E40242AC110006, 'w89fF427', 'DMhU4xr63vz18sFYfyd8S1E8PlS6RijOW4i48W4a42oiS7ORxTA45gR5NAOm', '蔡志泽', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'thad.fritsch@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8343C8D82E40242AC110006, 'OmoQFw', '384bU5gx36PDulxt5y92685fD8Xp09Buk3ijy3qIvM0e4z3fStzleAu87Je2', '史越彬', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'ruth.hermiston@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8385AC082E40242AC110006, '3C9PNN', 'uXCjbvXLm398wzn005d1Vpzs6NY56s31ZQ117wRWAu0UUFNJmA223G8SjQ6P', '潘鸿煊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'fermin.feil@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD83D868F82E40242AC110006, 'iN4nmH9u0r', 'x6mdfbpqf55PB99L01yi1YNc1Chz21RtivRFV7vnw7L5Qj3flAVePy6P40Oi', '梁远航', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'blondell.macejkovic@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8417A5C82E40242AC110006, '4EoxOjx8U7h', 'sOg80070eGf85b7uq8jHneaU05L9j682fvn48kcKCnq4242J8bpClkZZp2iP', '魏笑愚', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'ivana.harvey@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD845A18082E40242AC110006, '2w2R4T', 'maYP8XWsry2OUpdB76d5S5e663b37uYbW01IeJG9fbXl1bx1ve76t0D4Z855', '韦文轩', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'noah.stroman@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD849BF6F82E40242AC110006, 'RYe5LI0', '4zToQW7k7gPc1vdZa0zFYD7BC55J8KK2F4425lhDYFe0aP1B3m9U0SeTW776', '段天翊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'maxwell.mcdermott@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD84E788182E40242AC110006, 'S4Y2T8rgai', '2pJBL61U0hEmm5TPuA9S3SCRN0y2Trnc4i237XlCVoAM8qa7Vg7z95hb5b8d', '邱思聪', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'angelique.luettgen@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD852BFEE82E40242AC110006, '472a0Q', '44G1bMuSFIImzp8cSLc9D2m6eVLm3Z58SgLaQ62g2qYWp0pN5Yk5KnwMTb97', '孟皓轩', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'renato.weissnat@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8572D3482E40242AC110006, 'd29nb1a3z', '9z9JLAC8LibI311yl9gjgGXmcIx84Il7J7JO3heL7Baq2Sl7w425Wp0AkLB1', '武明', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'roseline.hirthe@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD85CCFDA82E40242AC110006, '90jZ0f', 'ivLkm8C58P4oNsh70J9Nd1K2it1NatCI47296SDsJRl05LkJwkDGS9owy670', '黄文博', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'peter.torphy@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD861176982E40242AC110006, 'tN8N5X', 'H9Tl2Y6mzBm61WSk4j86vzl5eouaXJxmGLWpFPx7t840ov9P9353g2MnrMvd', '余笑愚', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'lavonne.hermiston@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD866E80A82E40242AC110006, '419j3k', 'ALO8d17nmHQ8e24MTNhV14m17JORvU30f9zPhKDdnnMw7MvN92L351991XR8', '王乐驹', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'rodger.ferry@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD86B2A9F82E40242AC110006, 'ub8aU8d', '68e2n2C9Z6eKhHD685O61FQ83BA0Fr9VU25xD8Y1tJSXwiIhp774RxYxQ26i', '沈修杰', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'pat.tillman@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD86F94F182E40242AC110006, 'QAA643', 'zRyGn47KES24kM9q2N2yJ9354sw81G8mk82Q54063lA59c1p3USIIG34PNz2', '曹思淼', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'bradford.bernier@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD874F00682E40242AC110006, '25sx304h', '88nNDXuMi7b6w65L56Dj38YV2Z3i011086Q6JxRk5ltoU72Y3V5A0wFH51GG', '谭思聪', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'georgianna.cartwright@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD879821682E40242AC110006, 'Na4G25HA0sg', 'q1j26I3mpC1344Dbm9djv6NEt10PpgvZtKMj07xr5HbYkn34ejdBmb447Sb9', '贺鹏', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'marivel.ruecker@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD87DA08682E40242AC110006, '6DCURzvV1', '3kqHHot07YX3QT04Q2U5RvQGX3EaU6D8Ng6hs8bUh9YdzvfhkPb78BqVIVti', '范鹏煊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'michal.schneider@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD881E7BE82E40242AC110006, 'rKyt3P7', 'xxI0Xi7e8rW009Q9BQJAp4WDqZ5xC1P4hR4XKL541xt821ep0c2uW1e487t8', '蒋烨霖', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'johnathan.gaylord@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD886365482E40242AC110006, 'm7f27O', '3KYOZx7ScB62HlDZL4Fyn480p3avQb4bRT39Zd6ul68DiyG4QkbVnDBL5YN1', '龙明哲', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'elwood.mayert@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD88A4B3682E40242AC110006, 'vcn4YskA', 'bIhguvAdit02pR8djHJF986uYzQ1c0ooKU3v9In25lAvu14t8Gf1i18yZln7', '梁健柏', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'jayna.reichert@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD88F807A82E40242AC110006, 'KA06UDr3o4O', 'qibgR6g0ZH9XRr71VPiva2rJ8T40RMHsR2tW3VXx7hcwBU87e659a4Y647Fh', '崔明哲', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'shantell.hessel@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD895766082E40242AC110006, '56GaZ9A', 'vaVghAH2V3FSoV6RZGx4DcE1ck1vp85D8mt8CMtq6X7Bd6NeOvuW544Jv82f', '陶瑞霖', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'yong.schuster@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD89A2A9D82E40242AC110006, 'nL7R0aj', '6H9R74q1Q46U74R0y8lrTMuEMdUsqlZ2438mgg5epHdSS6YK9e79W7D8iq2S', '覃乐驹', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'wes.hackett@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD89EBE3082E40242AC110006, '84m19R', 'l7l256NLJWz4Sp1Vc6hbpJTAC8E6XQ97ViI8w906p6lJ1A798j1sap7Y821w', '贺越彬', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'kris.schoen@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8A2E46182E40242AC110006, 'ftZ481p', 'HL8wt54QcbAGuorMFpvjMWbey38G24ub9dy6WQ961fG6u2Gk78cC5q1Z22s0', '黄乐驹', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'taren.rogahn@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8A94C6382E40242AC110006, 'zwa5F96515DgP', 'LkGWnDeiJXl66Jh6bkpPLZ3ukpVINLdc91eu1fK3461266xGp7oeu43mO0U0', '邹泽洋', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'truman.greenfelder@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8AD681782E40242AC110006, 'wk3PDW', '5QR0S01s4KRRepv92bV2H726xl3F80g2B4EKGyqdaY4p89lV80yezd20337f', '侯立辉', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'alda.blanda@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8B188F082E40242AC110006, 'vZgPbM', 'au8e8crPHVr1r1RmhYW0rHQ4g2pAg4tPvJKDBmw59G5CRY1j8885Y05900W3', '杜峻熙', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'rosalia.barton@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8B643B482E40242AC110006, 'BHZ1Ee', 'HGiu0108cw1A129T8w39pQx469x9ga127g47ZWX9u7P9A9NIj20YCE9HKCDp', '苏天磊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'teressa.moen@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8BA8A3982E40242AC110006, 'bEx4zQ', '0b5HY87p11Ss6T2eOK4xUXvhwq8oAk0AG4vEyClidaeJ080h4Qa5g1u3jwbn', '方烨磊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'sulema.goyette@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8BE80A582E40242AC110006, '93mJ7x', '51YI2ahs74gxSI4T55l674B7t78646gx85GO532z4KNx55spa6pFY9TP60Iz', '孔文昊', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'marlon.bartell@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8C2A00182E40242AC110006, '8awuyU8s', 'jcGm937r6VtLI9as85T3mbDhllm4e1wNQljeNDm9ITVR7JeTqvMc88L4Dfcr', '陈乐驹', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'charley.okon@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8C699B682E40242AC110006, '9rrolJ', '4XzlsUo8ze5bQZPheKIfoC0J07D2Vq1dL24h8dTI6izp0SZ7k56pwHApxAS8', '钱雨泽', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'numbers.walter@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8CAB6B382E40242AC110006, 'm7duCk0', 'QAFo79T89tW67rLf76plMEXIrbSuewl79SN95BPtEdlu04mR8LZL6pmOEIZv', '钱彬', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'odette.rohan@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8CED51682E40242AC110006, '6IVKLmCj36M', '4iH4gZF7Ykq8lCvE2M8z5i2npwZEg38X1ipkqY8mTnoPd99Bgs6J7M2qMPHh', '姚雨泽', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'soraya.witting@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8D2CC5F82E40242AC110006, 'QO25GX', 'B1DBc1meuU31MT1T72450tztrEc3Md76wR14406u83CB42z40wr1x1fLa3M0', '孟果', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'stephany.leannon@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8D6EBBC82E40242AC110006, 'sNNtTwQXV', 'oYedmRXkpwSBBG03098ssU8bKLY2bT7aKEB39elFHj368G4yEdnG808M5C2m', '汪思远', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'roberto.farrell@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8DB36F882E40242AC110006, 'Nmcp2i', 'wpHi4meTlhI8og9B7V0gh11fjLsXf0S00KQLhcG9vyMDecd3x2t22iWC9Y6D', '史君浩', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'darren.von@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8DFA17182E40242AC110006, 'MC56n5e', '4ob7IV2G10YsH77D504346EzIQP2229bg5RZ8Pt73uuJLwN4O7d4wg4g2SJS', '覃峻熙', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'samual.connelly@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8E3E24B82E40242AC110006, '28XQbn25', 'I9MRVUVBXW6y1oBz67661P9P1TOuS17U5M2azAeW4dfd5dgRuCmej9829PsR', '董凯瑞', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'steve.mueller@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8ED5B9282E40242AC110006, 'kg7XwNf04', 'dYDsDIif7L12Kh470tmI1i8nL2FEwLNda8E0RI41NyI6EY6IRWO21N72F4zq', '马天宇', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'lakita.champlin@hotmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8F1C7A982E40242AC110006, 'vr2M243', 'J2CRLj1vLfpKrgg3WTfJ7fqfMelM0O00VBkd90l1sn8DGq06NNjdZQxSNorh', '赵哲瀚', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'rosalva.bartoletti@gmail.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8F5E95082E40242AC110006, 'vWkH4u', '9ZltgA95jU3vhVN77cHSIZEuFV43OdeisQ1K7qAkihR2W0L0Pfzp8l618GiM', '蔡立辉', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'darryl.parisian@yahoo.com', 1);
INSERT INTO `t_user` VALUES (0x11ED7F5AD8FA2C6682E40242AC110006, 'mPi5XunAARC3h', '9mRqk85qPuGbXWw4eQD35S7OpUHf39Jfp4AgGfs05GH2Y2R42gKPAP0QGx4j', '许鹏飞', '2022-12-19', 0x11ED6A375668F368AF960242AC110002, 'rhiannon.jacobson@gmail.com', 1);

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role`  (
  `id` varbinary(16) NOT NULL COMMENT '用户角色ID',
  `user_id` varbinary(16) NOT NULL COMMENT '用户ID',
  `role_id` varbinary(16) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_id`(`role_id` ASC) USING BTREE COMMENT '角色id索引',
  INDEX `idx_user_id_role_id`(`user_id` ASC, `role_id` ASC) USING BTREE COMMENT '用户角色索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES (0x11ED9170461F970B8C390242AC110003, 0x11ED6A2EA820DAC7AF960242AC110002, 0x11ED67DC1D553647AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED9170461F9EDE8C390242AC110003, 0x11ED6A2EA820DAC7AF960242AC110002, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED9170461F9D2B8C390242AC110003, 0x11ED6A2EA820DAC7AF960242AC110002, 0x11ED67DC1D62294CAF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED8006F16B4EE8A9130242AC110003, 0x11ED6A2F3697BA95AF960242AC110002, 0x11ED67DC1D553647AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED8006F16B5354A9130242AC110003, 0x11ED6A2F3697BA95AF960242AC110002, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED8F59D71575CB8C390242AC110003, 0x11ED759BE4D61AEAAF960242AC110002, 0x11ED67DC1D553647AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED8F59D71572468C390242AC110003, 0x11ED759BE4D61AEAAF960242AC110002, 0x11ED6A2DACC2E8A6AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED8F58F312D4DD8C390242AC110003, 0x11ED759BFC52D835AF960242AC110002, 0x11ED67DC1D5115B2AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED8F58F312D7448C390242AC110003, 0x11ED759BFC52D835AF960242AC110002, 0x11ED6A2DACC2E8A6AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED838B5AFAE9BBA9130242AC110003, 0x11ED759C953AEFF1AF960242AC110002, 0x11ED6A2DACC2E8A6AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED800705D96433A9130242AC110003, 0x11ED76145FFE6184AF960242AC110002, 0x11ED67DC1D553647AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED800705D96935A9130242AC110003, 0x11ED76145FFE6184AF960242AC110002, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED80061AFA6673A9130242AC110003, 0x11ED7F59CF9E2D9E82E40242AC110006, 0x11ED67DC1D5115B2AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED80061AFA6260A9130242AC110003, 0x11ED7F59CF9E2D9E82E40242AC110006, 0x11ED67DC1D553647AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED80061AFA6895A9130242AC110003, 0x11ED7F59CF9E2D9E82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED80061AFA6768A9130242AC110003, 0x11ED7F59CF9E2D9E82E40242AC110006, 0x11ED67DC1D62294CAF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED80061AFA6963A9130242AC110003, 0x11ED7F59CF9E2D9E82E40242AC110006, 0x11ED6A2DACC2E8A6AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E499A0982E40242AC110006, 0x11ED7F5AD73CB6AC82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E53840382E40242AC110006, 0x11ED7F5AD7444A0C82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E57BA8082E40242AC110006, 0x11ED7F5AD74AF32182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E5CCB5082E40242AC110006, 0x11ED7F5AD74F599B82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E60C54282E40242AC110006, 0x11ED7F5AD755727182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E65A9F482E40242AC110006, 0x11ED7F5AD759910482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E69C94782E40242AC110006, 0x11ED7F5AD75D8D9982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E6DE60782E40242AC110006, 0x11ED7F5AD761CFD782E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E72040582E40242AC110006, 0x11ED7F5AD765C88D82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E76743882E40242AC110006, 0x11ED7F5AD76A0C2082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E7ABCFA82E40242AC110006, 0x11ED7F5AD76EC5F382E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E7EDFE182E40242AC110006, 0x11ED7F5AD772C5A682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E831E0582E40242AC110006, 0x11ED7F5AD776DDBB82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E87B3D382E40242AC110006, 0x11ED7F5AD77C369782E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E8BD29D82E40242AC110006, 0x11ED7F5AD780748682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E8FCCAE82E40242AC110006, 0x11ED7F5AD784C4EA82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E93E64082E40242AC110006, 0x11ED7F5AD789060982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E97DF7D82E40242AC110006, 0x11ED7F5AD78D23B782E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E9BD6FE82E40242AC110006, 0x11ED7F5AD791D73382E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7E9FD26F82E40242AC110006, 0x11ED7F5AD796270182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EA4445682E40242AC110006, 0x11ED7F5AD79A470182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EA85DEF82E40242AC110006, 0x11ED7F5AD79EB46B82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EAC76E982E40242AC110006, 0x11ED7F5AD7A2D0FB82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EB0963C82E40242AC110006, 0x11ED7F5AD7A6EBC282E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EB4B66D82E40242AC110006, 0x11ED7F5AD7AB094E82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EB8D54B82E40242AC110006, 0x11ED7F5AD7AF293F82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EBCF0AB82E40242AC110006, 0x11ED7F5AD7B34A5982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EC1148782E40242AC110006, 0x11ED7F5AD7B7DDB482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EC50A4582E40242AC110006, 0x11ED7F5AD7BBF42D82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EC94DAF82E40242AC110006, 0x11ED7F5AD7C01BD982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7ECD489982E40242AC110006, 0x11ED7F5AD7C5998782E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7ED169DC82E40242AC110006, 0x11ED7F5AD7CA043082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7ED5873E82E40242AC110006, 0x11ED7F5AD7CE22AA82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7ED9A56782E40242AC110006, 0x11ED7F5AD7D291C982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EDDC31A82E40242AC110006, 0x11ED7F5AD7D7494282E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EE1B82C82E40242AC110006, 0x11ED7F5AD7DCF08D82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EE5FE1282E40242AC110006, 0x11ED7F5AD7E0E33F82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EE9F6FA82E40242AC110006, 0x11ED7F5AD7E4E27E82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EEE195E82E40242AC110006, 0x11ED7F5AD7E8FEE482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EF2D21682E40242AC110006, 0x11ED7F5AD7EE0A8982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EF73E6982E40242AC110006, 0x11ED7F5AD7F2011482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EFB5FBC82E40242AC110006, 0x11ED7F5AD7F6215182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7EFFA24182E40242AC110006, 0x11ED7F5AD7FA171D82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F03E7E982E40242AC110006, 0x11ED7F5AD7FE395682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F082D1982E40242AC110006, 0x11ED7F5AD8024D0F82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F0C71CA82E40242AC110006, 0x11ED7F5AD8064D6882E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F11072282E40242AC110006, 0x11ED7F5AD80A70D382E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F154B3082E40242AC110006, 0x11ED7F5AD80E649D82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F19931982E40242AC110006, 0x11ED7F5AD8125C8682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F1D87EC82E40242AC110006, 0x11ED7F5AD816523882E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F21F71482E40242AC110006, 0x11ED7F5AD81A49D382E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F26624682E40242AC110006, 0x11ED7F5AD81EDD1182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F2A805E82E40242AC110006, 0x11ED7F5AD822D98A82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F2EA14282E40242AC110006, 0x11ED7F5AD826F5D582E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F32BC7D82E40242AC110006, 0x11ED7F5AD82B178482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F36B42C82E40242AC110006, 0x11ED7F5AD82F2FD982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F3AAC4A82E40242AC110006, 0x11ED7F5AD8343C8D82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F3F1ACB82E40242AC110006, 0x11ED7F5AD8385AC082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F433A1E82E40242AC110006, 0x11ED7F5AD83D868F82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F477FB382E40242AC110006, 0x11ED7F5AD8417A5C82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F4B9D1382E40242AC110006, 0x11ED7F5AD845A18082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F4FBB6182E40242AC110006, 0x11ED7F5AD849BF6F82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F5402FC82E40242AC110006, 0x11ED7F5AD84E788182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F5937F782E40242AC110006, 0x11ED7F5AD852BFEE82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F5D51DA82E40242AC110006, 0x11ED7F5AD8572D3482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F616BA982E40242AC110006, 0x11ED7F5AD85CCFDA82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F6604BF82E40242AC110006, 0x11ED7F5AD861176982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F6A239782E40242AC110006, 0x11ED7F5AD866E80A82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F6E432082E40242AC110006, 0x11ED7F5AD86B2A9F82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F7261D982E40242AC110006, 0x11ED7F5AD86F94F182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F76850982E40242AC110006, 0x11ED7F5AD874F00682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F7ACAE882E40242AC110006, 0x11ED7F5AD879821682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F7EE5B582E40242AC110006, 0x11ED7F5AD87DA08682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F83519C82E40242AC110006, 0x11ED7F5AD881E7BE82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F879B6E82E40242AC110006, 0x11ED7F5AD886365482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F8BB95682E40242AC110006, 0x11ED7F5AD88A4B3682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F904B5782E40242AC110006, 0x11ED7F5AD88F807A82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F94954182E40242AC110006, 0x11ED7F5AD895766082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F9970B882E40242AC110006, 0x11ED7F5AD89A2A9D82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7F9D90C882E40242AC110006, 0x11ED7F5AD89EBE3082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FA1B13282E40242AC110006, 0x11ED7F5AD8A2E46182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FA5CF0082E40242AC110006, 0x11ED7F5AD8A94C6382E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FAA14AB82E40242AC110006, 0x11ED7F5AD8AD681782E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FAE328C82E40242AC110006, 0x11ED7F5AD8B188F082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FB24DD682E40242AC110006, 0x11ED7F5AD8B643B482E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FB6446682E40242AC110006, 0x11ED7F5AD8BA8A3982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FBAB22F82E40242AC110006, 0x11ED7F5AD8BE80A582E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FBEACF582E40242AC110006, 0x11ED7F5AD8C2A00182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FC2A13782E40242AC110006, 0x11ED7F5AD8C699B682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FC6C18782E40242AC110006, 0x11ED7F5AD8CAB6B382E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FCADD9C82E40242AC110006, 0x11ED7F5AD8CED51682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FCED7C082E40242AC110006, 0x11ED7F5AD8D2CC5F82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FD2CEA382E40242AC110006, 0x11ED7F5AD8D6EBBC82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FD6C7B082E40242AC110006, 0x11ED7F5AD8DB36F882E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FDAE58982E40242AC110006, 0x11ED7F5AD8DFA17182E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FDF08F082E40242AC110006, 0x11ED7F5AD8E3E24B82E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FE2FF6982E40242AC110006, 0x11ED7F5AD8ED5B9282E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FE6F7EB82E40242AC110006, 0x11ED7F5AD8F1C7A982E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FEAEEC182E40242AC110006, 0x11ED7F5AD8F5E95082E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);
INSERT INTO `t_user_role` VALUES (0x11ED7F5C7FEF0C3682E40242AC110006, 0x11ED7F5AD8FA2C6682E40242AC110006, 0x11ED67DC1D59EC45AF960242AC110002);

SET FOREIGN_KEY_CHECKS = 1;