text: /*
   Navicat Premium Data Transfer
  
   Source Server         : local
   Source Server Type    : MySQL
   Source Server Version : 50723
   Source Host           : localhost:3306
   Source Schema         : platform_cloud_base_v2
  
   Target Server Type    : MySQL
   Target Server Version : 50723
   File Encoding         : 65001
  
   Date: 13/05/2020 17:34:19
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for oauth_client_details
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_client_details`;
  CREATE TABLE `oauth_client_details`  (
    `client_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `resource_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `client_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `scope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `authorized_grant_types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `web_server_redirect_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `authorities` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `access_token_validity` int(11) NOT NULL,
    `refresh_token_validity` int(11) NULL DEFAULT NULL,
    `additional_information` varchar(4096) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `autoapprove` tinyint(4) NULL DEFAULT NULL,
    `origin_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    PRIMARY KEY (`client_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客户端配置表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of oauth_client_details
  -- ----------------------------
  INSERT INTO `oauth_client_details` VALUES ('app', '', '$2a$10$8Qk/efslEpO1Af1kyw/rp.DdJGsdnET8UCp1vGDzpQEa.1qBklvua', 'all', 'refresh_token,password', '', NULL, 86400, 864000, NULL, 0, '123456');
  INSERT INTO `oauth_client_details` VALUES ('code', '', '$2a$10$VJMqqnP14QbkO8IS/mNM6.JmeXQjeoCKsXKOpzePs51q3414forOa', 'all', 'refresh_token,authorization_code,client_credentials,password,implicit', 'http://www.baidu.com', NULL, 86400, 864000, NULL, 1, '123456');
  INSERT INTO `oauth_client_details` VALUES ('platform', '', '$2a$10$WqyC7Uiv5hSATt5F2VNTQuY4ITQs2BVmm4lfgIB2umypCZmUDt2Lu', 'all', 'refresh_token,password', '', NULL, 86400, 8640000, NULL, 0, '123456a_');
  
  -- ----------------------------
  -- Table structure for t_data_permission_test
  -- ----------------------------
  DROP TABLE IF EXISTS `t_data_permission_test`;
  CREATE TABLE `t_data_permission_test`  (
    `FIELD1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `FIELD2` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `FIELD3` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `FIELD4` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `DEPT_ID` int(11) NOT NULL,
    `CREATE_TIME` datetime(0) NOT NULL,
    `ID` int(11) NOT NULL,
    PRIMARY KEY (`ID`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户权限测试' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_data_permission_test
  -- ----------------------------
  INSERT INTO `t_data_permission_test` VALUES ('小米', '小米10Pro', '4999', '珍珠白', 1, '2020-04-14 15:00:38', 1);
  INSERT INTO `t_data_permission_test` VALUES ('腾讯', '黑鲨游戏手机3', '3799', '铠甲灰', 2, '2020-04-14 15:01:36', 2);
  INSERT INTO `t_data_permission_test` VALUES ('华为', '华为P30', '3299', '天空之境', 1, '2020-04-14 15:03:11', 3);
  INSERT INTO `t_data_permission_test` VALUES ('华为', '华为P40Pro', '6488', '亮黑色', 3, '2020-04-14 15:04:31', 4);
  INSERT INTO `t_data_permission_test` VALUES ('vivo', 'Vivo iQOO 3', '3998', '拉力橙', 4, '2020-04-14 15:05:55', 5);
  INSERT INTO `t_data_permission_test` VALUES ('一加', '一加7T', '3199', '冰际蓝', 5, '2020-04-14 15:06:53', 6);
  INSERT INTO `t_data_permission_test` VALUES ('三星', '三星Galaxy S10', '4098', '浩玉白', 6, '2020-04-14 15:08:25', 7);
  INSERT INTO `t_data_permission_test` VALUES ('苹果', 'iPhone 11 pro max', '9198', '暗夜绿', 4, '2020-04-14 15:09:20', 8);
  
  -- ----------------------------
  -- Table structure for t_dept
  -- ----------------------------
  DROP TABLE IF EXISTS `t_dept`;
  CREATE TABLE `t_dept`  (
    `DEPT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '部门ID',
    `PARENT_ID` bigint(20) NOT NULL COMMENT '上级部门ID',
    `DEPT_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称',
    `ORDER_NUM` double(20, 0) NULL DEFAULT NULL COMMENT '排序',
    `CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `MODIFY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY (`DEPT_ID`) USING BTREE,
    INDEX `t_dept_parent_id`(`PARENT_ID`) USING BTREE,
    INDEX `t_dept_dept_name`(`DEPT_NAME`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_dept
  -- ----------------------------
  INSERT INTO `t_dept` VALUES (1, 0, '开发部', 1, '2018-01-04 15:42:26', '2019-01-05 21:08:27');
  INSERT INTO `t_dept` VALUES (2, 1, '开发一部', 1, '2018-01-04 15:42:34', '2019-01-18 00:59:37');
  INSERT INTO `t_dept` VALUES (3, 1, '开发二部', 2, '2018-01-04 15:42:29', '2019-01-05 14:09:39');
  INSERT INTO `t_dept` VALUES (4, 0, '市场部', 2, '2018-01-04 15:42:36', '2019-01-23 06:27:56');
  INSERT INTO `t_dept` VALUES (5, 0, '人事部', 3, '2018-01-04 15:42:32', '2019-01-23 06:27:59');
  INSERT INTO `t_dept` VALUES (6, 0, '测试部', 4, '2018-01-04 15:42:38', '2019-01-17 08:15:47');
  
  -- ----------------------------
  -- Table structure for t_eximport
  -- ----------------------------
  DROP TABLE IF EXISTS `t_eximport`;
  CREATE TABLE `t_eximport`  (
    `FIELD1` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `FIELD2` int(11) NOT NULL,
    `FIELD3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `CREATE_TIME` datetime(0) NOT NULL
  ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Excel导入导出测试' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_eximport
  -- ----------------------------
  INSERT INTO `t_eximport` VALUES ('字段1', 1, '764471698@qq.com', '2019-07-25 19:08:01');
  INSERT INTO `t_eximport` VALUES ('字段1', 2, '764471698@qq.com', '2019-07-25 19:08:01');
  INSERT INTO `t_eximport` VALUES ('字段1', 3, '764471698@qq.com', '2019-07-25 19:08:01');
  INSERT INTO `t_eximport` VALUES ('字段1', 4, '764471698@qq.com', '2019-07-25 19:08:01');
  INSERT INTO `t_eximport` VALUES ('字段1', 5, '764471698@qq.com', '2019-07-25 19:08:01');
  INSERT INTO `t_eximport` VALUES ('字段1', 6, '764471698@qq.com', '2019-07-25 19:08:01');
  INSERT INTO `t_eximport` VALUES ('字段1', 7, '764471698@qq.com', '2019-07-25 19:08:01');
  INSERT INTO `t_eximport` VALUES ('字段1', 8, '764471698@qq.com', '2019-07-25 19:08:01');
  
  -- ----------------------------
  -- Table structure for t_generator_config
  -- ----------------------------
  DROP TABLE IF EXISTS `t_generator_config`;
  CREATE TABLE `t_generator_config`  (
    `id` int(11) NOT NULL COMMENT '主键',
    `author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '作者',
    `base_package` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '基础包名',
    `entity_package` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'entity文件存放路径',
    `mapper_package` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'mapper文件存放路径',
    `mapper_xml_package` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'mapper xml文件存放路径',
    `service_package` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'servcie文件存放路径',
    `service_impl_package` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'serviceImpl文件存放路径',
    `controller_package` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'controller文件存放路径',
    `is_trim` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '是否去除前缀 1是 0否',
    `trim_value` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前缀内容',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成配置表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_generator_config
  -- ----------------------------
  INSERT INTO `t_generator_config` VALUES (1, 'crystal', 'com.plm.platform.server.foundation', 'entity', 'mapper', 'mapper', 'service', 'service.impl', 'controller', '1', 't_');
  
  -- ----------------------------
  -- Table structure for t_job
  -- ----------------------------
  DROP TABLE IF EXISTS `t_job`;
  CREATE TABLE `t_job`  (
    `JOB_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
    `BEAN_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'spring bean名称',
    `METHOD_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '方法名',
    `PARAMS` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',
    `CRON_EXPRESSION` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'cron表达式',
    `STATUS` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务状态  0：正常  1：暂停',
    `REMARK` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    `CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`JOB_ID`) USING BTREE,
    INDEX `t_job_create_time`(`CREATE_TIME`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_job
  -- ----------------------------
  INSERT INTO `t_job` VALUES (1, 'taskList', 'test', 'hello', '0/1 * * * * ?', '1', '有参任务调度测试', '2018-02-24 16:26:14');
  INSERT INTO `t_job` VALUES (2, 'taskList', 'test1', NULL, '0/10 * * * * ?', '1', '无参任务调度测试', '2018-02-24 17:06:23');
  INSERT INTO `t_job` VALUES (3, 'taskList', 'test2', '{\"name\":\"star\",\"age\":18}', '0/1 * * * * ?', '1', 'JSON类型参数任务测试', '2018-02-26 09:28:26');
  INSERT INTO `t_job` VALUES (4, 'taskList', 'test3', '', '0/5 * * * * ?', '1', '测试异常，没有编写test3任务', '2018-02-26 11:15:30');
  
  -- ----------------------------
  -- Table structure for t_job_log
  -- ----------------------------
  DROP TABLE IF EXISTS `t_job_log`;
  CREATE TABLE `t_job_log`  (
    `LOG_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
    `JOB_ID` bigint(20) NOT NULL COMMENT '任务id',
    `BEAN_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'spring bean名称',
    `METHOD_NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '方法名',
    `PARAMS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',
    `STATUS` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务状态    0：成功    1：失败',
    `ERROR` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '失败信息',
    `TIMES` decimal(11, 0) NULL DEFAULT NULL COMMENT '耗时(单位：毫秒)',
    `CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`LOG_ID`) USING BTREE,
    INDEX `t_job_log_create_time`(`CREATE_TIME`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '调度日志表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_job_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_log
  -- ----------------------------
  DROP TABLE IF EXISTS `t_log`;
  CREATE TABLE `t_log`  (
    `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
    `USERNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户',
    `OPERATION` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '操作内容',
    `TIME` decimal(11, 0) NULL DEFAULT NULL COMMENT '耗时',
    `METHOD` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '操作方法',
    `PARAMS` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '方法参数',
    `IP` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作者IP',
    `CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `LOCATION` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作地点',
    PRIMARY KEY (`ID`) USING BTREE,
    INDEX `t_log_create_time`(`CREATE_TIME`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户操作日志表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_logger
  -- ----------------------------
  DROP TABLE IF EXISTS `t_logger`;
  CREATE TABLE `t_logger`  (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `group_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `unit_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `tag` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `create_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分布式事务日志' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_logger
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_login_log
  -- ----------------------------
  DROP TABLE IF EXISTS `t_login_log`;
  CREATE TABLE `t_login_log`  (
    `ID` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
    `USERNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
    `LOGIN_TIME` datetime(0) NOT NULL COMMENT '登录时间',
    `LOCATION` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录地点',
    `IP` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
    `SYSTEM` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作系统',
    `BROWSER` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览器',
    PRIMARY KEY (`ID`) USING BTREE,
    INDEX `t_login_log_login_time`(`LOGIN_TIME`) USING BTREE
  ) ENGINE = MyISAM AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录日志表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_login_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `t_menu`;
  CREATE TABLE `t_menu`  (
    `MENU_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单/按钮ID',
    `PARENT_ID` bigint(20) NOT NULL COMMENT '上级菜单ID',
    `MENU_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单/按钮名称',
    `PATH` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对应路由path',
    `COMPONENT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对应路由组件component',
    `PERMS` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识',
    `ICON` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',
    `TYPE` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型 0菜单 1按钮',
    `ORDER_NUM` double(20, 0) NULL DEFAULT NULL COMMENT '排序',
    `CREATE_TIME` datetime(0) NOT NULL COMMENT '创建时间',
    `MODIFY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY (`MENU_ID`) USING BTREE,
    INDEX `t_menu_parent_id`(`PARENT_ID`) USING BTREE,
    INDEX `t_menu_menu_id`(`MENU_ID`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 195 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_menu
  -- ----------------------------
  INSERT INTO `t_menu` VALUES (1, 0, '系统管理', '/system', 'Layout', NULL, 'el-icon-set-up', '0', 1, '2017-12-27 16:39:07', '2019-07-20 16:19:04');
  INSERT INTO `t_menu` VALUES (2, 0, '系统监控', '/monitor', 'Layout', NULL, 'el-icon-data-line', '0', 2, '2017-12-27 16:45:51', '2019-01-23 06:27:12');
  INSERT INTO `t_menu` VALUES (3, 1, '用户管理', '/system/user', 'platform/system/user/Index', 'user:view', '', '0', 1, '2017-12-27 16:47:13', '2019-01-22 06:45:55');
  INSERT INTO `t_menu` VALUES (4, 1, '角色管理', '/system/role', 'platform/system/role/Index', 'role:view', '', '0', 2, '2017-12-27 16:48:09', '2018-04-25 09:01:12');
  INSERT INTO `t_menu` VALUES (5, 1, '菜单管理', '/system/menu', 'platform/system/menu/Index', 'menu:view', '', '0', 3, '2017-12-27 16:48:57', '2018-04-25 09:01:30');
  INSERT INTO `t_menu` VALUES (6, 1, '部门管理', '/system/dept', 'platform/system/dept/Index', 'dept:view', '', '0', 4, '2017-12-27 16:57:33', '2018-04-25 09:01:40');
  INSERT INTO `t_menu` VALUES (10, 2, '系统日志', '/monitor/systemlog', 'platform/monitor/systemlog/Index', 'log:view', '', '0', 2, '2017-12-27 17:00:50', '2020-04-13 11:38:04');
  INSERT INTO `t_menu` VALUES (11, 3, '新增用户', '', '', 'user:add', NULL, '1', NULL, '2017-12-27 17:02:58', NULL);
  INSERT INTO `t_menu` VALUES (12, 3, '修改用户', '', '', 'user:update', NULL, '1', NULL, '2017-12-27 17:04:07', NULL);
  INSERT INTO `t_menu` VALUES (13, 3, '删除用户', '', '', 'user:delete', NULL, '1', NULL, '2017-12-27 17:04:58', NULL);
  INSERT INTO `t_menu` VALUES (14, 4, '新增角色', '', '', 'role:add', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
  INSERT INTO `t_menu` VALUES (15, 4, '修改角色', '', '', 'role:update', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
  INSERT INTO `t_menu` VALUES (16, 4, '删除角色', '', '', 'role:delete', NULL, '1', NULL, '2017-12-27 17:06:38', NULL);
  INSERT INTO `t_menu` VALUES (17, 5, '新增菜单', '', '', 'menu:add', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
  INSERT INTO `t_menu` VALUES (18, 5, '修改菜单', '', '', 'menu:update', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
  INSERT INTO `t_menu` VALUES (19, 5, '删除菜单', '', '', 'menu:delete', NULL, '1', NULL, '2017-12-27 17:08:02', NULL);
  INSERT INTO `t_menu` VALUES (20, 6, '新增部门', '', '', 'dept:add', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
  INSERT INTO `t_menu` VALUES (21, 6, '修改部门', '', '', 'dept:update', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
  INSERT INTO `t_menu` VALUES (22, 6, '删除部门', '', '', 'dept:delete', NULL, '1', NULL, '2017-12-27 17:09:24', NULL);
  INSERT INTO `t_menu` VALUES (24, 10, '删除日志', '', '', 'log:delete', NULL, '1', NULL, '2017-12-27 17:11:45', NULL);
  INSERT INTO `t_menu` VALUES (130, 3, '导出Excel', NULL, NULL, 'user:export', NULL, '1', NULL, '2019-01-23 06:35:16', NULL);
  INSERT INTO `t_menu` VALUES (131, 4, '导出Excel', NULL, NULL, 'role:export', NULL, '1', NULL, '2019-01-23 06:35:36', NULL);
  INSERT INTO `t_menu` VALUES (132, 5, '导出Excel', NULL, NULL, 'menu:export', NULL, '1', NULL, '2019-01-23 06:36:05', NULL);
  INSERT INTO `t_menu` VALUES (133, 6, '导出Excel', NULL, NULL, 'dept:export', NULL, '1', NULL, '2019-01-23 06:36:25', NULL);
  INSERT INTO `t_menu` VALUES (135, 3, '密码重置', NULL, NULL, 'user:reset', NULL, '1', NULL, '2019-01-23 06:37:00', NULL);
  INSERT INTO `t_menu` VALUES (136, 10, '导出Excel', NULL, NULL, 'log:export', NULL, '1', NULL, '2019-01-23 06:37:27', NULL);
  INSERT INTO `t_menu` VALUES (150, 2, '登录日志', '/monitor/loginlog', 'platform/monitor/loginlog/Index', 'monitor:loginlog', '', '0', 3, '2019-07-22 13:41:17', '2020-04-13 11:38:08');
  INSERT INTO `t_menu` VALUES (151, 150, '删除日志', NULL, NULL, 'loginlog:delete', NULL, '1', NULL, '2019-07-22 13:43:04', NULL);
  INSERT INTO `t_menu` VALUES (152, 150, '导出Excel', NULL, NULL, 'loginlog:export', NULL, '1', NULL, '2019-07-22 13:43:30', NULL);
  INSERT INTO `t_menu` VALUES (154, 0, '数据模块', '/others', 'Layout', '', 'el-icon-shopping-bag-1', '0', 6, '2019-07-25 10:16:16', '2020-06-18 16:43:03');
  INSERT INTO `t_menu` VALUES (156, 0, '代码生成', '/gen', 'Layout', '', 'el-icon-printer', '0', 4, '2019-07-25 10:24:03', '2020-01-16 13:59:49');
  INSERT INTO `t_menu` VALUES (157, 156, '基础配置', '/gen/config', 'platform/gen/config/Index', 'gen:config', '', '0', 1, '2019-07-25 10:24:55', '2020-04-09 14:21:54');
  INSERT INTO `t_menu` VALUES (158, 156, '生成代码', '/gen/generate', 'platform/gen/generate/Index', 'gen:generate', '', '0', 2, '2019-07-25 10:25:26', '2019-07-25 11:13:20');
  INSERT INTO `t_menu` VALUES (159, 157, '修改配置', NULL, NULL, 'gen:config:update', NULL, '1', NULL, '2019-07-26 16:22:56', NULL);
  INSERT INTO `t_menu` VALUES (160, 158, '打包生成', NULL, NULL, 'gen:generate:gen', NULL, '1', NULL, '2019-07-26 16:23:38', '2019-07-26 16:23:53');
  INSERT INTO `t_menu` VALUES (163, 1, '客户端管理', '/client', 'platform/system/client/Index', 'client:view', '', '0', 5, '2019-09-26 22:58:09', NULL);
  INSERT INTO `t_menu` VALUES (164, 163, '新增', NULL, NULL, 'client:add', NULL, '1', NULL, '2019-09-26 22:58:21', NULL);
  INSERT INTO `t_menu` VALUES (165, 163, '修改', NULL, NULL, 'client:update', NULL, '1', NULL, '2019-09-26 22:58:43', NULL);
  INSERT INTO `t_menu` VALUES (166, 163, '删除', NULL, NULL, 'client:delete', NULL, '1', NULL, '2019-09-26 22:58:55', NULL);
  INSERT INTO `t_menu` VALUES (167, 163, '解密', NULL, NULL, 'client:decrypt', NULL, '1', NULL, '2019-09-26 22:59:08', NULL);
  INSERT INTO `t_menu` VALUES (173, 0, '网关管理', '/route', 'Layout', '', 'el-icon-odometer', '0', 3, '2020-01-16 14:00:15', NULL);
  INSERT INTO `t_menu` VALUES (174, 173, '网关用户', '/route/user', 'platform/route/routeuser/Index', '', '', '0', 1, '2020-01-16 14:00:32', NULL);
  INSERT INTO `t_menu` VALUES (175, 173, '网关日志', '/route/log', 'platform/route/routelog/Index', '', '', '0', 2, '2020-01-16 14:00:47', NULL);
  INSERT INTO `t_menu` VALUES (176, 173, '限流规则', '/route/ratelimitrule', 'platform/route/ratelimitrule/Index', '', '', '0', 3, '2020-01-16 14:01:01', NULL);
  INSERT INTO `t_menu` VALUES (177, 173, '限流日志', '/route/ratelimitlog', 'platform/route/ratelimitlog/Index', '', '', '0', 4, '2020-01-16 14:01:17', NULL);
  INSERT INTO `t_menu` VALUES (178, 173, '黑名单管理', '/route/blacklist', 'platform/route/blacklist/Index', '', '', '0', 5, '2020-01-16 14:01:32', NULL);
  INSERT INTO `t_menu` VALUES (179, 173, '黑名单日志', '/route/blocklog', 'platform/route/blocklog/Index', '', '', '0', 6, '2020-01-16 14:01:49', NULL);
  INSERT INTO `t_menu` VALUES (180, 2, '监控面板', '/monitor/dashboard', 'platform/monitor/dashboard/Index', 'monitor:dashboard', '', '0', 1, '2020-04-13 09:44:09', '2020-04-13 11:38:00');
  INSERT INTO `t_menu` VALUES (182, 154, '数据权限', '/others/datapermission', 'platform/others/datapermission/Index', 'others:datapermission', '', '0', 3, '2020-04-14 14:51:35', '2020-04-14 15:37:19');
  INSERT INTO `t_menu` VALUES (183, 0, '任务调度', '/job', 'Layout', '', 'el-icon-alarm-clock', '0', 5, '2020-04-14 18:39:35', '2020-04-14 18:39:53');
  INSERT INTO `t_menu` VALUES (184, 183, '任务列表', '/job/list', 'platform/job/job/Index', 'job:view', '', '0', 1, '2020-04-14 18:40:37', '2020-04-14 18:41:36');
  INSERT INTO `t_menu` VALUES (185, 183, '调度日志', '/job/log', 'platform/job/log/Index', 'job:log:view', '', '0', 2, '2020-04-14 18:42:25', NULL);
  INSERT INTO `t_menu` VALUES (186, 184, '新增任务', NULL, NULL, 'job:add', NULL, '1', NULL, '2020-04-14 18:59:55', '2020-04-15 08:56:03');
  INSERT INTO `t_menu` VALUES (187, 184, '修改任务', NULL, NULL, 'job:update', NULL, '1', NULL, '2020-04-14 19:00:13', NULL);
  INSERT INTO `t_menu` VALUES (188, 184, '删除任务', NULL, NULL, 'job:delete', NULL, '1', NULL, '2020-04-14 19:00:26', NULL);
  INSERT INTO `t_menu` VALUES (189, 184, '暂停任务', NULL, NULL, 'job:pause', NULL, '1', NULL, '2020-04-14 19:00:42', NULL);
  INSERT INTO `t_menu` VALUES (190, 184, '恢复任务', NULL, NULL, 'job:resume', NULL, '1', NULL, '2020-04-14 19:00:56', NULL);
  INSERT INTO `t_menu` VALUES (191, 184, '立即执行一次', NULL, NULL, 'job:run', NULL, '1', NULL, '2020-04-14 19:01:42', NULL);
  INSERT INTO `t_menu` VALUES (192, 184, '导出Excel', NULL, NULL, 'job:export', NULL, '1', NULL, '2020-04-14 19:01:59', NULL);
  INSERT INTO `t_menu` VALUES (193, 185, '删除', NULL, NULL, 'job:log:delete', NULL, '1', NULL, '2020-04-15 14:01:33', NULL);
  INSERT INTO `t_menu` VALUES (194, 185, '导出', NULL, NULL, 'job:log:export', NULL, '1', NULL, '2020-04-15 14:01:45', NULL);
  INSERT INTO `t_menu` VALUES (195, 0, '统计服务', '/statistics', 'Layout', '', 'el-icon-data-analysis', '0', 7, '2020-06-18 16:48:10', NULL);
  INSERT INTO `t_menu` VALUES (196, 195, '邮件工具', '/statistics/mail', 'platform/statistics/mail/Index', 'mail:view', '', '0', 1, '2020-06-18 16:51:39', '2020-06-18 16:52:09');
  INSERT INTO `t_menu` VALUES (197, 196, '发送邮件', NULL, NULL, 'mail:send', NULL, '1', NULL, '2020-06-21 13:55:28', NULL);
  INSERT INTO `t_menu` VALUES (198, 195, 'SQL工具', 'statitics/sql', 'platform/statistics/sql/Index', 'sql:view', '', '0', 2, '2020-09-25 09:56:08', '2020-09-28 16:49:00');
  INSERT INTO `t_menu` VALUES (199, 198, '执行', NULL, NULL, 'sql:run', NULL, '1', NULL, '2020-09-25 09:58:53', NULL);
  
  -- ----------------------------
  -- Table structure for t_role
  -- ----------------------------
  DROP TABLE IF EXISTS `t_role`;
  CREATE TABLE `t_role`  (
    `ROLE_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    `ROLE_NAME` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
    `REMARK` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述',
    `CREATE_TIME` datetime(0) NOT NULL COMMENT '创建时间',
    `MODIFY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY (`ROLE_ID`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_role
  -- ----------------------------
  INSERT INTO `t_role` VALUES (1, '管理员', '管理员', '2017-12-27 16:23:11', '2020-04-15 14:02:27');
  INSERT INTO `t_role` VALUES (2, '注册用户', '可查看，新增，导出', '2019-01-04 14:11:28', '2020-05-06 14:10:45');
  INSERT INTO `t_role` VALUES (3, '系统监控员', '负责系统监控模块', '2019-09-01 10:30:25', '2020-05-06 14:10:13');
  
  -- ----------------------------
  -- Table structure for t_role_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `t_role_menu`;
  CREATE TABLE `t_role_menu`  (
    `ROLE_ID` bigint(20) NOT NULL,
    `MENU_ID` bigint(20) NOT NULL,
    PRIMARY KEY (`ROLE_ID`, `MENU_ID`) USING BTREE,
    INDEX `t_role_menu_menu_id`(`MENU_ID`) USING BTREE,
    INDEX `t_role_menu_role_id`(`ROLE_ID`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单关联表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_role_menu
  -- ----------------------------
  INSERT INTO `t_role_menu` VALUES (1, 1);
  INSERT INTO `t_role_menu` VALUES (2, 1);
  INSERT INTO `t_role_menu` VALUES (1, 2);
  INSERT INTO `t_role_menu` VALUES (2, 2);
  INSERT INTO `t_role_menu` VALUES (3, 2);
  INSERT INTO `t_role_menu` VALUES (1, 3);
  INSERT INTO `t_role_menu` VALUES (2, 3);
  INSERT INTO `t_role_menu` VALUES (1, 4);
  INSERT INTO `t_role_menu` VALUES (2, 4);
  INSERT INTO `t_role_menu` VALUES (1, 5);
  INSERT INTO `t_role_menu` VALUES (2, 5);
  INSERT INTO `t_role_menu` VALUES (1, 6);
  INSERT INTO `t_role_menu` VALUES (2, 6);
  INSERT INTO `t_role_menu` VALUES (1, 10);
  INSERT INTO `t_role_menu` VALUES (2, 10);
  INSERT INTO `t_role_menu` VALUES (3, 10);
  INSERT INTO `t_role_menu` VALUES (1, 11);
  INSERT INTO `t_role_menu` VALUES (1, 12);
  INSERT INTO `t_role_menu` VALUES (1, 13);
  INSERT INTO `t_role_menu` VALUES (1, 14);
  INSERT INTO `t_role_menu` VALUES (2, 14);
  INSERT INTO `t_role_menu` VALUES (1, 15);
  INSERT INTO `t_role_menu` VALUES (1, 16);
  INSERT INTO `t_role_menu` VALUES (1, 17);
  INSERT INTO `t_role_menu` VALUES (2, 17);
  INSERT INTO `t_role_menu` VALUES (1, 18);
  INSERT INTO `t_role_menu` VALUES (1, 19);
  INSERT INTO `t_role_menu` VALUES (1, 20);
  INSERT INTO `t_role_menu` VALUES (2, 20);
  INSERT INTO `t_role_menu` VALUES (1, 21);
  INSERT INTO `t_role_menu` VALUES (1, 22);
  INSERT INTO `t_role_menu` VALUES (1, 24);
  INSERT INTO `t_role_menu` VALUES (3, 24);
  INSERT INTO `t_role_menu` VALUES (1, 130);
  INSERT INTO `t_role_menu` VALUES (2, 130);
  INSERT INTO `t_role_menu` VALUES (1, 131);
  INSERT INTO `t_role_menu` VALUES (2, 131);
  INSERT INTO `t_role_menu` VALUES (1, 132);
  INSERT INTO `t_role_menu` VALUES (2, 132);
  INSERT INTO `t_role_menu` VALUES (1, 133);
  INSERT INTO `t_role_menu` VALUES (2, 133);
  INSERT INTO `t_role_menu` VALUES (1, 135);
  INSERT INTO `t_role_menu` VALUES (1, 136);
  INSERT INTO `t_role_menu` VALUES (2, 136);
  INSERT INTO `t_role_menu` VALUES (3, 136);
  INSERT INTO `t_role_menu` VALUES (1, 150);
  INSERT INTO `t_role_menu` VALUES (2, 150);
  INSERT INTO `t_role_menu` VALUES (3, 150);
  INSERT INTO `t_role_menu` VALUES (1, 151);
  INSERT INTO `t_role_menu` VALUES (3, 151);
  INSERT INTO `t_role_menu` VALUES (1, 152);
  INSERT INTO `t_role_menu` VALUES (2, 152);
  INSERT INTO `t_role_menu` VALUES (3, 152);
  INSERT INTO `t_role_menu` VALUES (1, 154);
  INSERT INTO `t_role_menu` VALUES (2, 154);
  INSERT INTO `t_role_menu` VALUES (2, 155);
  INSERT INTO `t_role_menu` VALUES (1, 156);
  INSERT INTO `t_role_menu` VALUES (2, 156);
  INSERT INTO `t_role_menu` VALUES (1, 157);
  INSERT INTO `t_role_menu` VALUES (2, 157);
  INSERT INTO `t_role_menu` VALUES (1, 158);
  INSERT INTO `t_role_menu` VALUES (2, 158);
  INSERT INTO `t_role_menu` VALUES (1, 159);
  INSERT INTO `t_role_menu` VALUES (1, 160);
  INSERT INTO `t_role_menu` VALUES (2, 160);
  INSERT INTO `t_role_menu` VALUES (1, 163);
  INSERT INTO `t_role_menu` VALUES (2, 163);
  INSERT INTO `t_role_menu` VALUES (1, 164);
  INSERT INTO `t_role_menu` VALUES (2, 164);
  INSERT INTO `t_role_menu` VALUES (1, 165);
  INSERT INTO `t_role_menu` VALUES (1, 166);
  INSERT INTO `t_role_menu` VALUES (1, 167);
  INSERT INTO `t_role_menu` VALUES (2, 167);
  INSERT INTO `t_role_menu` VALUES (2, 168);
  INSERT INTO `t_role_menu` VALUES (2, 169);
  INSERT INTO `t_role_menu` VALUES (2, 170);
  INSERT INTO `t_role_menu` VALUES (2, 171);
  INSERT INTO `t_role_menu` VALUES (2, 172);
  INSERT INTO `t_role_menu` VALUES (1, 173);
  INSERT INTO `t_role_menu` VALUES (2, 173);
  INSERT INTO `t_role_menu` VALUES (1, 174);
  INSERT INTO `t_role_menu` VALUES (2, 174);
  INSERT INTO `t_role_menu` VALUES (1, 175);
  INSERT INTO `t_role_menu` VALUES (2, 175);
  INSERT INTO `t_role_menu` VALUES (1, 176);
  INSERT INTO `t_role_menu` VALUES (2, 176);
  INSERT INTO `t_role_menu` VALUES (1, 177);
  INSERT INTO `t_role_menu` VALUES (2, 177);
  INSERT INTO `t_role_menu` VALUES (1, 178);
  INSERT INTO `t_role_menu` VALUES (2, 178);
  INSERT INTO `t_role_menu` VALUES (1, 179);
  INSERT INTO `t_role_menu` VALUES (2, 179);
  INSERT INTO `t_role_menu` VALUES (1, 180);
  INSERT INTO `t_role_menu` VALUES (2, 180);
  INSERT INTO `t_role_menu` VALUES (3, 180);
  INSERT INTO `t_role_menu` VALUES (2, 181);
  INSERT INTO `t_role_menu` VALUES (1, 182);
  INSERT INTO `t_role_menu` VALUES (2, 182);
  INSERT INTO `t_role_menu` VALUES (1, 183);
  INSERT INTO `t_role_menu` VALUES (2, 183);
  INSERT INTO `t_role_menu` VALUES (1, 184);
  INSERT INTO `t_role_menu` VALUES (2, 184);
  INSERT INTO `t_role_menu` VALUES (1, 185);
  INSERT INTO `t_role_menu` VALUES (2, 185);
  INSERT INTO `t_role_menu` VALUES (1, 186);
  INSERT INTO `t_role_menu` VALUES (1, 187);
  INSERT INTO `t_role_menu` VALUES (1, 188);
  INSERT INTO `t_role_menu` VALUES (1, 189);
  INSERT INTO `t_role_menu` VALUES (1, 190);
  INSERT INTO `t_role_menu` VALUES (1, 191);
  INSERT INTO `t_role_menu` VALUES (1, 192);
  INSERT INTO `t_role_menu` VALUES (2, 192);
  INSERT INTO `t_role_menu` VALUES (1, 193);
  INSERT INTO `t_role_menu` VALUES (1, 194);
  INSERT INTO `t_role_menu` VALUES (2, 194);
  INSERT INTO `t_role_menu` VALUES (1, 195);
  INSERT INTO `t_role_menu` VALUES (1, 196);
  INSERT INTO `t_role_menu` VALUES (1, 197);
  INSERT INTO `t_role_menu` VALUES (1, 198);
  INSERT INTO `t_role_menu` VALUES (1, 199);
  
  -- ----------------------------
  -- Table structure for t_trade_log
  -- ----------------------------
  DROP TABLE IF EXISTS `t_trade_log`;
  CREATE TABLE `t_trade_log`  (
    `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `GOODS_ID` int(11) NOT NULL COMMENT '商品ID',
    `GOODS_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称',
    `STATUS` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态',
    `CREATE_TIME` datetime(0) NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`ID`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '分布式事务测试' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_trade_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_tx_exception
  -- ----------------------------
  DROP TABLE IF EXISTS `t_tx_exception`;
  CREATE TABLE `t_tx_exception`  (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `group_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `unit_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `mod_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `transaction_state` tinyint(4) NULL DEFAULT NULL,
    `registrar` tinyint(4) NULL DEFAULT NULL,
    `ex_state` tinyint(4) NULL DEFAULT NULL COMMENT '0 待处理 1已处理',
    `remark` varchar(10240) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `create_time` datetime(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_tx_exception
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for t_user
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user`;
  CREATE TABLE `t_user`  (
    `USER_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `USERNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
    `PASSWORD` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
    `DEPT_ID` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
    `EMAIL` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    `MOBILE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
    `STATUS` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态 0锁定 1有效',
    `CREATE_TIME` datetime(0) NOT NULL COMMENT '创建时间',
    `MODIFY_TIME` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    `LAST_LOGIN_TIME` datetime(0) NULL DEFAULT NULL COMMENT '最近访问时间',
    `SSEX` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别 0男 1女 2保密',
    `IS_TAB` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否开启tab，0关闭 1开启',
    `THEME` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主题',
    `AVATAR` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
    `DESCRIPTION` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
    PRIMARY KEY (`USER_ID`) USING BTREE,
    INDEX `t_user_username`(`USERNAME`) USING BTREE,
    INDEX `t_user_mobile`(`MOBILE`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_user
  -- ----------------------------
  INSERT INTO `t_user` VALUES (1, 'admin', '$2a$10$YPRzfYQCvN/1OXw2.0HjKuI7elxPoHlZZ9nJCsPoruTzybyU9HhrW', 2, '764471698@qq.com', '18888888888', '1', '2019-06-14 20:39:22', '2020-04-15 16:00:32', '2020-05-13 17:16:02', '0', '1', 'white', 'default.jpg', '面对疾风吧');
  INSERT INTO `t_user` VALUES (15, 'scott', '$2a$10$MTrnLIomqmHn7208Fi4ZbeaUe3aOQ2ZoapIniqeInzA7/BEmSFFoe', 5, '764471698@qq.com', '18888888888', '1', '2019-07-20 19:00:32', '2020-05-06 14:07:57', '2020-05-12 15:24:09', '2', NULL, NULL, '20180414165815.jpg', NULL);
  INSERT INTO `t_user` VALUES (16, 'jack', '$2a$10$yU4BjESDm02Fk3Aq7OM3TurJz3Hxjr.pUSxayiVy/JQRkT4XCKNiS', 4, '764471698@qq.com', '18366666666', '1', '2019-09-01 10:31:21', '2020-05-06 14:08:22', '2020-05-06 14:48:01', '1', NULL, NULL, 'jZUIxmJycoymBprLOUbT.png', NULL);
  
  -- ----------------------------
  -- Table structure for t_user_connection
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user_connection`;
  CREATE TABLE `t_user_connection`  (
    `USER_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '系统用户名',
    `PROVIDER_NAME` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '第三方平台名称',
    `PROVIDER_USER_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '第三方平台账户ID',
    `PROVIDER_USER_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第三方平台用户名',
    `NICK_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第三方平台昵称',
    `IMAGE_URL` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第三方平台头像',
    `LOCATION` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
    `REMARK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`USER_NAME`, `PROVIDER_NAME`, `PROVIDER_USER_ID`) USING BTREE,
    UNIQUE INDEX `UserConnectionRank`(`USER_NAME`, `PROVIDER_NAME`, `PROVIDER_USER_ID`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户社交账户关联表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_user_connection
  -- ----------------------------
  INSERT INTO `t_user_connection` VALUES ('admin', 'GITEE', '5523383', 'chenwenhua666', 'chenwenhua666', 'https://portrait.gitee.com/uploads/avatars/user/1841/5523383_chenwenhua666_1588840866.png', NULL, NULL);
  INSERT INTO `t_user_connection` VALUES ('admin', 'GITHUB', '41222109', 'chenwenhua666', NULL, 'https://avatars0.githubusercontent.com/u/41222109?v=4', NULL, NULL);
  
  -- ----------------------------
  -- Table structure for t_user_data_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user_data_permission`;
  CREATE TABLE `t_user_data_permission`  (
    `USER_ID` bigint(20) NOT NULL,
    `DEPT_ID` bigint(20) NOT NULL,
    PRIMARY KEY (`USER_ID`, `DEPT_ID`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户数据权限关联表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_user_data_permission
  -- ----------------------------
  INSERT INTO `t_user_data_permission` VALUES (1, 1);
  INSERT INTO `t_user_data_permission` VALUES (1, 2);
  INSERT INTO `t_user_data_permission` VALUES (1, 3);
  INSERT INTO `t_user_data_permission` VALUES (1, 4);
  INSERT INTO `t_user_data_permission` VALUES (1, 5);
  INSERT INTO `t_user_data_permission` VALUES (1, 6);
  INSERT INTO `t_user_data_permission` VALUES (15, 1);
  INSERT INTO `t_user_data_permission` VALUES (15, 2);
  INSERT INTO `t_user_data_permission` VALUES (16, 4);
  INSERT INTO `t_user_data_permission` VALUES (16, 5);
  
  -- ----------------------------
  -- Table structure for t_user_role
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user_role`;
  CREATE TABLE `t_user_role`  (
    `USER_ID` bigint(20) NOT NULL COMMENT '用户ID',
    `ROLE_ID` bigint(20) NOT NULL COMMENT '角色ID',
    PRIMARY KEY (`USER_ID`, `ROLE_ID`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色关联表' ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of t_user_role
  -- ----------------------------
  INSERT INTO `t_user_role` VALUES (1, 1);
  INSERT INTO `t_user_role` VALUES (15, 2);
  INSERT INTO `t_user_role` VALUES (16, 3);
  
  SET FOREIGN_KEY_CHECKS = 1;
  