/* Navicat Premium Data Transfer Source Server : localhost_mysql_5.7 Source Server Type : MySQL Source Server Version : 50726 Source Host : localhost:3306 Source Schema : febs_base Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001 Date: 04/12/2019 16:48:56 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- 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` bigint(20) 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, KEY `t_dept_parent_id` (`PARENT_ID`), KEY `t_dept_dept_name` (`DEPT_NAME`) ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_dept -- ---------------------------- INSERT INTO `t_dept` VALUES (1, 0, '开发部', 1, '2019-06-14 20:56:41', NULL); INSERT INTO `t_dept` VALUES (2, 1, '开发一部', 1, '2019-06-14 20:58:46', NULL); INSERT INTO `t_dept` VALUES (3, 1, '开发二部', 2, '2019-06-14 20:58:56', NULL); INSERT INTO `t_dept` VALUES (4, 0, '采购部', 2, '2019-06-14 20:59:56', NULL); INSERT INTO `t_dept` VALUES (5, 0, '财务部', 3, '2019-06-14 21:00:08', NULL); INSERT INTO `t_dept` VALUES (6, 0, '销售部', 4, '2019-06-14 21:00:15', NULL); INSERT INTO `t_dept` VALUES (7, 0, '工程部', 5, '2019-06-14 21:00:42', NULL); INSERT INTO `t_dept` VALUES (8, 0, '行政部', 6, '2019-06-14 21:00:49', NULL); INSERT INTO `t_dept` VALUES (9, 0, '人力资源部', 8, '2019-06-14 21:01:14', '2019-06-14 21:01:34'); INSERT INTO `t_dept` VALUES (10, 0, '系统部', 7, '2019-06-14 21:01:31', NULL); -- ---------------------------- -- 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 COMMENT '字段1', `FIELD2` int(11) NOT NULL COMMENT '字段2', `FIELD3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段3', `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, 'mrbird0@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 2, 'mrbird1@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 3, 'mrbird2@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 4, 'mrbird3@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 5, 'mrbird4@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 6, 'mrbird5@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 7, 'mrbird6@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 8, 'mrbird7@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 9, 'mrbird8@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 10, 'mrbird9@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 11, 'mrbird10@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 12, 'mrbird11@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 13, 'mrbird12@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 14, 'mrbird13@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 15, 'mrbird14@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 16, 'mrbird15@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 17, 'mrbird16@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 18, 'mrbird17@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 19, 'mrbird18@gmail.com', '2019-06-13 03:14:06'); INSERT INTO `t_eximport` VALUES ('字段1', 20, 'mrbird19@gmail.com', '2019-06-13 03:14:06'); -- ---------------------------- -- 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, 'MrBird', 'cc.mrbird.febs.gen', '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, KEY `t_job_create_time` (`CREATE_TIME`) ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_job -- ---------------------------- INSERT INTO `t_job` VALUES (1, 'testTask', 'test', 'mrbird', '0/1 * * * * ?', '1', '有参任务调度测试~~', '2018-02-24 16:26:14'); INSERT INTO `t_job` VALUES (2, 'testTask', 'test1', NULL, '0/10 * * * * ?', '1', '无参任务调度测试', '2018-02-24 17:06:23'); INSERT INTO `t_job` VALUES (3, 'testTask', 'test', 'hello world', '0/1 * * * * ?', '1', '有参任务调度测试,每隔一秒触发', '2018-02-26 09:28:26'); INSERT INTO `t_job` VALUES (11, 'testTask', 'test2', NULL, '0/5 * * * * ?', '1', '测试异常', '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, KEY `t_job_log_create_time` (`CREATE_TIME`) ) ENGINE = MyISAM AUTO_INCREMENT = 2562 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '调度日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- 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, KEY `t_log_create_time` (`CREATE_TIME`) ) ENGINE = MyISAM AUTO_INCREMENT = 1011 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- 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, KEY `t_login_log_login_time` (`LOGIN_TIME`) ) ENGINE = MyISAM AUTO_INCREMENT = 70 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) NOT NULL COMMENT '菜单/按钮名称', `URL` varchar(50) DEFAULT NULL COMMENT '菜单URL', `PERMS` text COMMENT '权限标识', `ICON` varchar(50) DEFAULT NULL COMMENT '图标', `TYPE` char(2) NOT NULL COMMENT '类型 0菜单 1按钮', `ORDER_NUM` bigint(20) DEFAULT NULL COMMENT '排序', `CREATE_TIME` datetime NOT NULL COMMENT '创建时间', `MODIFY_TIME` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`MENU_ID`) USING BTREE, KEY `t_menu_parent_id` (`PARENT_ID`), KEY `t_menu_menu_id` (`MENU_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单表'; -- ---------------------------- -- Records of t_menu -- ---------------------------- BEGIN; INSERT INTO `t_menu` VALUES (1, 0, '系统管理', NULL, NULL, 'layui-icon-setting', '0', 1, '2017-12-27 16:39:07', NULL); INSERT INTO `t_menu` VALUES (2, 0, '系统监控', '', '', 'layui-icon-alert', '0', 2, '2017-12-27 16:45:51', '2019-06-13 11:20:40'); INSERT INTO `t_menu` VALUES (3, 1, '用户管理', '/system/user', 'user:view', '', '0', 1, '2017-12-27 16:47:13', '2019-12-04 16:46:50'); INSERT INTO `t_menu` VALUES (4, 1, '角色管理', '/system/role', 'role:view', '', '0', 2, '2017-12-27 16:48:09', '2019-06-13 08:57:19'); INSERT INTO `t_menu` VALUES (5, 1, '菜单管理', '/system/menu', 'menu:view', '', '0', 3, '2017-12-27 16:48:57', '2019-06-13 08:57:34'); INSERT INTO `t_menu` VALUES (6, 1, '部门管理', '/system/dept', 'dept:view', '', '0', 4, '2017-12-27 16:57:33', '2019-06-14 19:56:00'); INSERT INTO `t_menu` VALUES (8, 2, '在线用户', '/monitor/online', 'online:view', '', '0', 1, '2017-12-27 16:59:33', '2019-06-13 14:30:31'); INSERT INTO `t_menu` VALUES (10, 2, '系统日志', '/monitor/log', 'log:view', '', '0', 2, '2017-12-27 17:00:50', '2019-06-13 14:30:37'); INSERT INTO `t_menu` VALUES (11, 3, '新增用户', NULL, 'user:add', NULL, '1', NULL, '2017-12-27 17:02:58', NULL); INSERT INTO `t_menu` VALUES (12, 3, '修改用户', NULL, 'user:update', NULL, '1', NULL, '2017-12-27 17:04:07', NULL); INSERT INTO `t_menu` VALUES (13, 3, '删除用户', NULL, 'user:delete', NULL, '1', NULL, '2017-12-27 17:04:58', NULL); INSERT INTO `t_menu` VALUES (14, 4, '新增角色', NULL, 'role:add', NULL, '1', NULL, '2017-12-27 17:06:38', NULL); INSERT INTO `t_menu` VALUES (15, 4, '修改角色', NULL, 'role:update', NULL, '1', NULL, '2017-12-27 17:06:38', NULL); INSERT INTO `t_menu` VALUES (16, 4, '删除角色', NULL, 'role:delete', NULL, '1', NULL, '2017-12-27 17:06:38', NULL); INSERT INTO `t_menu` VALUES (17, 5, '新增菜单', NULL, 'menu:add', NULL, '1', NULL, '2017-12-27 17:08:02', NULL); INSERT INTO `t_menu` VALUES (18, 5, '修改菜单', NULL, 'menu:update', NULL, '1', NULL, '2017-12-27 17:08:02', NULL); INSERT INTO `t_menu` VALUES (19, 5, '删除菜单', NULL, 'menu:delete', NULL, '1', NULL, '2017-12-27 17:08:02', NULL); INSERT INTO `t_menu` VALUES (20, 6, '新增部门', NULL, 'dept:add', NULL, '1', NULL, '2017-12-27 17:09:24', NULL); INSERT INTO `t_menu` VALUES (21, 6, '修改部门', NULL, 'dept:update', NULL, '1', NULL, '2017-12-27 17:09:24', NULL); INSERT INTO `t_menu` VALUES (22, 6, '删除部门', NULL, 'dept:delete', NULL, '1', NULL, '2017-12-27 17:09:24', NULL); INSERT INTO `t_menu` VALUES (23, 8, '踢出用户', NULL, 'user:kickout', NULL, '1', NULL, '2017-12-27 17:11:13', NULL); INSERT INTO `t_menu` VALUES (24, 10, '删除日志', NULL, 'log:delete', NULL, '1', NULL, '2017-12-27 17:11:45', '2019-06-06 05:56:40'); INSERT INTO `t_menu` VALUES (101, 0, '任务调度', NULL, NULL, 'layui-icon-time-circle', '0', 3, '2018-02-24 15:52:57', NULL); INSERT INTO `t_menu` VALUES (102, 101, '定时任务', '/job/job', 'job:view', '', '0', 1, '2018-02-24 15:53:53', '2018-04-25 09:05:12'); INSERT INTO `t_menu` VALUES (103, 102, '新增任务', NULL, 'job:add', NULL, '1', NULL, '2018-02-24 15:55:10', NULL); INSERT INTO `t_menu` VALUES (104, 102, '修改任务', NULL, 'job:update', NULL, '1', NULL, '2018-02-24 15:55:53', NULL); INSERT INTO `t_menu` VALUES (105, 102, '删除任务', NULL, 'job:delete', NULL, '1', NULL, '2018-02-24 15:56:18', NULL); INSERT INTO `t_menu` VALUES (106, 102, '暂停任务', NULL, 'job:pause', NULL, '1', NULL, '2018-02-24 15:57:08', NULL); INSERT INTO `t_menu` VALUES (107, 102, '恢复任务', NULL, 'job:resume', NULL, '1', NULL, '2018-02-24 15:58:21', NULL); INSERT INTO `t_menu` VALUES (108, 102, '立即执行任务', NULL, 'job:run', NULL, '1', NULL, '2018-02-24 15:59:45', NULL); INSERT INTO `t_menu` VALUES (109, 101, '调度日志', '/job/log', 'job:log:view', '', '0', 2, '2018-02-24 16:00:45', '2019-06-09 02:48:19'); INSERT INTO `t_menu` VALUES (110, 109, '删除日志', NULL, 'job:log:delete', NULL, '1', NULL, '2018-02-24 16:01:21', NULL); INSERT INTO `t_menu` VALUES (115, 0, '其他模块', NULL, NULL, 'layui-icon-gift', '0', 5, '2019-05-27 10:18:07', NULL); INSERT INTO `t_menu` VALUES (116, 115, 'Apex图表', '', '', NULL, '0', 2, '2019-05-27 10:21:35', NULL); INSERT INTO `t_menu` VALUES (117, 116, '线性图表', '/others/apex/line', 'apex:line:view', NULL, '0', 1, '2019-05-27 10:24:49', NULL); INSERT INTO `t_menu` VALUES (118, 115, '高德地图', '/others/map', 'map:view', '', '0', 3, '2019-05-27 17:13:12', '2019-06-12 15:33:00'); INSERT INTO `t_menu` VALUES (119, 116, '面积图表', '/others/apex/area', 'apex:area:view', NULL, '0', 2, '2019-05-27 18:49:22', NULL); INSERT INTO `t_menu` VALUES (120, 116, '柱形图表', '/others/apex/column', 'apex:column:view', NULL, '0', 3, '2019-05-27 18:51:33', NULL); INSERT INTO `t_menu` VALUES (121, 116, '雷达图表', '/others/apex/radar', 'apex:radar:view', NULL, '0', 4, '2019-05-27 18:56:05', NULL); INSERT INTO `t_menu` VALUES (122, 116, '条形图表', '/others/apex/bar', 'apex:bar:view', NULL, '0', 5, '2019-05-27 18:57:02', NULL); INSERT INTO `t_menu` VALUES (123, 116, '混合图表', '/others/apex/mix', 'apex:mix:view', '', '0', 6, '2019-05-27 18:58:04', '2019-06-06 02:55:23'); INSERT INTO `t_menu` VALUES (125, 115, '导入导出', '/others/eximport', 'others:eximport:view', '', '0', 4, '2019-05-27 19:01:57', '2019-06-13 01:20:14'); INSERT INTO `t_menu` VALUES (126, 132, '系统图标', '/others/febs/icon', 'febs:icons:view', '', '0', 4, '2019-05-27 19:03:18', '2019-06-06 03:05:26'); INSERT INTO `t_menu` VALUES (127, 2, '请求追踪', '/monitor/httptrace', 'httptrace:view', '', '0', 6, '2019-05-27 19:06:38', '2019-06-13 14:36:43'); INSERT INTO `t_menu` VALUES (128, 2, '系统信息', NULL, NULL, NULL, '0', 7, '2019-05-27 19:08:23', NULL); INSERT INTO `t_menu` VALUES (129, 128, 'JVM信息', '/monitor/jvm', 'jvm:view', '', '0', 1, '2019-05-27 19:08:50', '2019-06-13 14:36:51'); INSERT INTO `t_menu` VALUES (131, 128, '服务器信息', '/monitor/server', 'server:view', '', '0', 3, '2019-05-27 19:10:07', '2019-06-13 14:37:04'); INSERT INTO `t_menu` VALUES (132, 115, 'FEBS组件', '', '', NULL, '0', 1, '2019-05-27 19:13:54', NULL); INSERT INTO `t_menu` VALUES (133, 132, '表单组件', '/others/febs/form', 'febs:form:view', NULL, '0', 1, '2019-05-27 19:14:45', NULL); INSERT INTO `t_menu` VALUES (134, 132, 'FEBS工具', '/others/febs/tools', 'febs:tools:view', '', '0', 3, '2019-05-29 10:11:22', '2019-06-12 13:21:27'); INSERT INTO `t_menu` VALUES (135, 132, '表单组合', '/others/febs/form/group', 'febs:formgroup:view', NULL, '0', 2, '2019-05-29 10:16:19', NULL); INSERT INTO `t_menu` VALUES (136, 2, '登录日志', '/monitor/loginlog', 'loginlog:view', '', '0', 3, '2019-05-29 15:56:15', '2019-06-13 14:35:56'); INSERT INTO `t_menu` VALUES (137, 0, '代码生成', '', NULL, 'layui-icon-verticalright', '0', 4, '2019-06-03 15:35:58', NULL); INSERT INTO `t_menu` VALUES (138, 137, '生成配置', '/generator/configure', 'generator:configure:view', NULL, '0', 1, '2019-06-03 15:38:36', NULL); INSERT INTO `t_menu` VALUES (139, 137, '代码生成', '/generator/generator', 'generator:view', '', '0', 2, '2019-06-03 15:39:15', '2019-06-13 14:31:38'); INSERT INTO `t_menu` VALUES (159, 132, '其他组件', '/others/febs/others', 'others:febs:others', '', '0', 5, '2019-06-12 07:51:08', '2019-06-12 07:51:40'); INSERT INTO `t_menu` VALUES (160, 3, '密码重置', NULL, 'user:password:reset', NULL, '1', NULL, '2019-06-13 08:40:13', NULL); INSERT INTO `t_menu` VALUES (161, 3, '导出Excel', NULL, 'user:export', NULL, '1', NULL, '2019-06-13 08:40:34', NULL); INSERT INTO `t_menu` VALUES (162, 4, '导出Excel', NULL, 'role:export', NULL, '1', NULL, '2019-06-13 14:29:00', '2019-06-13 14:29:11'); INSERT INTO `t_menu` VALUES (163, 5, '导出Excel', NULL, 'menu:export', NULL, '1', NULL, '2019-06-13 14:29:32', NULL); INSERT INTO `t_menu` VALUES (164, 6, '导出Excel', NULL, 'dept:export', NULL, '1', NULL, '2019-06-13 14:29:59', NULL); INSERT INTO `t_menu` VALUES (165, 138, '修改配置', NULL, 'generator:configure:update', NULL, '1', NULL, '2019-06-13 14:32:09', '2019-06-13 14:32:20'); INSERT INTO `t_menu` VALUES (166, 139, '生成代码', NULL, 'generator:generate', NULL, '1', NULL, '2019-06-13 14:32:51', NULL); INSERT INTO `t_menu` VALUES (167, 125, '模板下载', NULL, 'eximport:template', NULL, '1', NULL, '2019-06-13 14:33:37', NULL); INSERT INTO `t_menu` VALUES (168, 125, '导出Excel', NULL, 'eximport:export', NULL, '1', NULL, '2019-06-13 14:33:57', NULL); INSERT INTO `t_menu` VALUES (169, 125, '导入Excel', NULL, 'eximport:import', NULL, '1', NULL, '2019-06-13 14:34:19', NULL); INSERT INTO `t_menu` VALUES (170, 10, '导出Excel', NULL, 'log:export', NULL, '1', NULL, '2019-06-13 14:34:55', NULL); INSERT INTO `t_menu` VALUES (171, 136, '删除日志', NULL, 'loginlog:delete', NULL, '1', NULL, '2019-06-13 14:35:27', '2019-06-13 14:36:08'); INSERT INTO `t_menu` VALUES (172, 136, '导出Excel', NULL, 'loginlog:export', NULL, '1', NULL, '2019-06-13 14:36:26', NULL); INSERT INTO `t_menu` VALUES (173, 102, '导出Excel', NULL, 'job:export', NULL, '1', NULL, '2019-06-13 14:37:25', NULL); INSERT INTO `t_menu` VALUES (174, 109, '导出Excel', NULL, 'job:log:export', NULL, '1', NULL, '2019-06-13 14:37:46', '2019-06-13 14:38:02'); INSERT INTO `t_menu` VALUES (175, 2, 'Swagger文档', '/monitor/swagger', 'swagger:view', '', '0', 8, '2019-08-18 17:25:36', '2019-08-18 17:25:59'); INSERT INTO `t_menu` VALUES (178, 115, '数据权限', '/others/datapermission', 'others:datapermission', '', '0', 5, '2020-04-29 09:34:25', NULL); COMMIT; -- ---------------------------- -- 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(100) 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 = 81 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_role -- ---------------------------- INSERT INTO `t_role` VALUES (1, '系统管理员', '系统管理员,拥有所有操作权限 ^_^', '2019-06-14 16:23:11', '2019-08-18 17:26:19'); INSERT INTO `t_role` VALUES (2, '注册账户', '注册账户,拥有查看,新增权限(新增用户除外)和导出Excel权限', '2019-06-14 16:00:15', '2019-08-18 17:36:02'); INSERT INTO `t_role` VALUES (77, 'Redis监控员', '负责Redis模块', '2019-06-14 20:49:22', NULL); INSERT INTO `t_role` VALUES (78, '系统监控员', '负责整个系统监控模块', '2019-06-14 20:50:07', NULL); INSERT INTO `t_role` VALUES (79, '跑批人员', '负责任务调度跑批模块', '2019-06-14 20:51:02', NULL); INSERT INTO `t_role` VALUES (80, '开发人员', '拥有代码生成模块的权限', '2019-06-14 20:51:26', NULL); -- ---------------------------- -- Table structure for t_role_menu -- ---------------------------- DROP TABLE IF EXISTS `t_role_menu`; CREATE TABLE `t_role_menu` ( `ROLE_ID` bigint(20) NOT NULL COMMENT '角色ID', `MENU_ID` bigint(20) NOT NULL COMMENT '菜单/按钮ID', KEY `t_role_menu_menu_id` (`MENU_ID`), KEY `t_role_menu_role_id` (`ROLE_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色菜单关联表'; -- ---------------------------- -- Records of t_role_menu -- ---------------------------- BEGIN; INSERT INTO `t_role_menu` VALUES (77, 2); INSERT INTO `t_role_menu` VALUES (78, 2); INSERT INTO `t_role_menu` VALUES (78, 8); INSERT INTO `t_role_menu` VALUES (78, 23); INSERT INTO `t_role_menu` VALUES (78, 10); INSERT INTO `t_role_menu` VALUES (78, 24); INSERT INTO `t_role_menu` VALUES (78, 170); INSERT INTO `t_role_menu` VALUES (78, 136); INSERT INTO `t_role_menu` VALUES (78, 171); INSERT INTO `t_role_menu` VALUES (78, 172); INSERT INTO `t_role_menu` VALUES (78, 127); INSERT INTO `t_role_menu` VALUES (78, 128); INSERT INTO `t_role_menu` VALUES (78, 129); INSERT INTO `t_role_menu` VALUES (78, 131); INSERT INTO `t_role_menu` VALUES (79, 101); INSERT INTO `t_role_menu` VALUES (79, 102); INSERT INTO `t_role_menu` VALUES (79, 103); INSERT INTO `t_role_menu` VALUES (79, 104); INSERT INTO `t_role_menu` VALUES (79, 105); INSERT INTO `t_role_menu` VALUES (79, 106); INSERT INTO `t_role_menu` VALUES (79, 107); INSERT INTO `t_role_menu` VALUES (79, 108); INSERT INTO `t_role_menu` VALUES (79, 173); INSERT INTO `t_role_menu` VALUES (79, 109); INSERT INTO `t_role_menu` VALUES (79, 110); INSERT INTO `t_role_menu` VALUES (79, 174); INSERT INTO `t_role_menu` VALUES (80, 137); INSERT INTO `t_role_menu` VALUES (80, 138); INSERT INTO `t_role_menu` VALUES (80, 165); INSERT INTO `t_role_menu` VALUES (80, 139); INSERT INTO `t_role_menu` VALUES (80, 166); INSERT INTO `t_role_menu` VALUES (1, 1); INSERT INTO `t_role_menu` VALUES (1, 3); 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, 160); INSERT INTO `t_role_menu` VALUES (1, 161); INSERT INTO `t_role_menu` VALUES (1, 4); INSERT INTO `t_role_menu` VALUES (1, 14); INSERT INTO `t_role_menu` VALUES (1, 15); INSERT INTO `t_role_menu` VALUES (1, 16); INSERT INTO `t_role_menu` VALUES (1, 162); INSERT INTO `t_role_menu` VALUES (1, 5); INSERT INTO `t_role_menu` VALUES (1, 17); INSERT INTO `t_role_menu` VALUES (1, 18); INSERT INTO `t_role_menu` VALUES (1, 19); INSERT INTO `t_role_menu` VALUES (1, 163); INSERT INTO `t_role_menu` VALUES (1, 6); INSERT INTO `t_role_menu` VALUES (1, 20); INSERT INTO `t_role_menu` VALUES (1, 21); INSERT INTO `t_role_menu` VALUES (1, 22); INSERT INTO `t_role_menu` VALUES (1, 164); INSERT INTO `t_role_menu` VALUES (1, 2); INSERT INTO `t_role_menu` VALUES (1, 8); INSERT INTO `t_role_menu` VALUES (1, 23); INSERT INTO `t_role_menu` VALUES (1, 10); INSERT INTO `t_role_menu` VALUES (1, 24); INSERT INTO `t_role_menu` VALUES (1, 170); INSERT INTO `t_role_menu` VALUES (1, 136); INSERT INTO `t_role_menu` VALUES (1, 171); INSERT INTO `t_role_menu` VALUES (1, 172); INSERT INTO `t_role_menu` VALUES (1, 127); INSERT INTO `t_role_menu` VALUES (1, 128); INSERT INTO `t_role_menu` VALUES (1, 129); INSERT INTO `t_role_menu` VALUES (1, 131); INSERT INTO `t_role_menu` VALUES (1, 175); INSERT INTO `t_role_menu` VALUES (1, 101); INSERT INTO `t_role_menu` VALUES (1, 102); INSERT INTO `t_role_menu` VALUES (1, 103); INSERT INTO `t_role_menu` VALUES (1, 104); INSERT INTO `t_role_menu` VALUES (1, 105); INSERT INTO `t_role_menu` VALUES (1, 106); INSERT INTO `t_role_menu` VALUES (1, 107); INSERT INTO `t_role_menu` VALUES (1, 108); INSERT INTO `t_role_menu` VALUES (1, 173); INSERT INTO `t_role_menu` VALUES (1, 109); INSERT INTO `t_role_menu` VALUES (1, 110); INSERT INTO `t_role_menu` VALUES (1, 174); INSERT INTO `t_role_menu` VALUES (1, 137); INSERT INTO `t_role_menu` VALUES (1, 138); INSERT INTO `t_role_menu` VALUES (1, 165); INSERT INTO `t_role_menu` VALUES (1, 139); INSERT INTO `t_role_menu` VALUES (1, 166); INSERT INTO `t_role_menu` VALUES (1, 115); INSERT INTO `t_role_menu` VALUES (1, 132); INSERT INTO `t_role_menu` VALUES (1, 133); INSERT INTO `t_role_menu` VALUES (1, 135); INSERT INTO `t_role_menu` VALUES (1, 134); INSERT INTO `t_role_menu` VALUES (1, 126); INSERT INTO `t_role_menu` VALUES (1, 159); INSERT INTO `t_role_menu` VALUES (1, 116); INSERT INTO `t_role_menu` VALUES (1, 117); INSERT INTO `t_role_menu` VALUES (1, 119); INSERT INTO `t_role_menu` VALUES (1, 120); INSERT INTO `t_role_menu` VALUES (1, 121); INSERT INTO `t_role_menu` VALUES (1, 122); INSERT INTO `t_role_menu` VALUES (1, 123); INSERT INTO `t_role_menu` VALUES (1, 118); INSERT INTO `t_role_menu` VALUES (1, 125); INSERT INTO `t_role_menu` VALUES (1, 167); INSERT INTO `t_role_menu` VALUES (1, 168); INSERT INTO `t_role_menu` VALUES (1, 169); INSERT INTO `t_role_menu` VALUES (1, 178); INSERT INTO `t_role_menu` VALUES (2, 1); INSERT INTO `t_role_menu` VALUES (2, 3); INSERT INTO `t_role_menu` VALUES (2, 161); INSERT INTO `t_role_menu` VALUES (2, 4); INSERT INTO `t_role_menu` VALUES (2, 14); INSERT INTO `t_role_menu` VALUES (2, 162); INSERT INTO `t_role_menu` VALUES (2, 5); INSERT INTO `t_role_menu` VALUES (2, 17); INSERT INTO `t_role_menu` VALUES (2, 163); INSERT INTO `t_role_menu` VALUES (2, 6); INSERT INTO `t_role_menu` VALUES (2, 20); INSERT INTO `t_role_menu` VALUES (2, 164); INSERT INTO `t_role_menu` VALUES (2, 2); INSERT INTO `t_role_menu` VALUES (2, 8); INSERT INTO `t_role_menu` VALUES (2, 10); INSERT INTO `t_role_menu` VALUES (2, 170); INSERT INTO `t_role_menu` VALUES (2, 136); INSERT INTO `t_role_menu` VALUES (2, 172); INSERT INTO `t_role_menu` VALUES (2, 127); INSERT INTO `t_role_menu` VALUES (2, 128); INSERT INTO `t_role_menu` VALUES (2, 129); INSERT INTO `t_role_menu` VALUES (2, 131); INSERT INTO `t_role_menu` VALUES (2, 175); INSERT INTO `t_role_menu` VALUES (2, 101); INSERT INTO `t_role_menu` VALUES (2, 102); INSERT INTO `t_role_menu` VALUES (2, 173); INSERT INTO `t_role_menu` VALUES (2, 109); INSERT INTO `t_role_menu` VALUES (2, 174); INSERT INTO `t_role_menu` VALUES (2, 137); INSERT INTO `t_role_menu` VALUES (2, 138); INSERT INTO `t_role_menu` VALUES (2, 139); INSERT INTO `t_role_menu` VALUES (2, 115); INSERT INTO `t_role_menu` VALUES (2, 132); INSERT INTO `t_role_menu` VALUES (2, 133); INSERT INTO `t_role_menu` VALUES (2, 135); INSERT INTO `t_role_menu` VALUES (2, 134); INSERT INTO `t_role_menu` VALUES (2, 126); INSERT INTO `t_role_menu` VALUES (2, 159); INSERT INTO `t_role_menu` VALUES (2, 116); INSERT INTO `t_role_menu` VALUES (2, 117); INSERT INTO `t_role_menu` VALUES (2, 119); INSERT INTO `t_role_menu` VALUES (2, 120); INSERT INTO `t_role_menu` VALUES (2, 121); INSERT INTO `t_role_menu` VALUES (2, 122); INSERT INTO `t_role_menu` VALUES (2, 123); INSERT INTO `t_role_menu` VALUES (2, 118); INSERT INTO `t_role_menu` VALUES (2, 125); 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, 178); COMMIT; -- ---------------------------- -- 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, KEY `t_user_username` (`USERNAME`), KEY `t_user_mobile` (`MOBILE`) ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (1, 'MrBird', 'cb62ad1497597283961545d608f80241', 1, 'mrbird@qq.com', '17788888888', '1', '2019-06-14 20:39:22', '2019-12-04 16:47:11', '2019-12-04 16:48:10', '0', '1', 'black', 'cnrhVkzwxjPwAaCfPbdc.png', '我是帅比作者。'); INSERT INTO `t_user` VALUES (2, 'Scott', '1d685729d113cfd03872f154939bee1c', 10, 'scott@gmail.com', '17722222222', '1', '2019-06-14 20:55:53', '2019-06-14 21:05:43', '2019-08-18 17:36:18', '0', '1', 'black', 'gaOngJwsRYRaVAuXXcmB.png', '我是scott。'); INSERT INTO `t_user` VALUES (3, 'Reina', '1461afff857c02afbfb768aa3771503d', 4, 'Reina@hotmail.com', '17711111111', '0', '2019-06-14 21:07:38', '2019-06-14 21:09:06', '2019-06-14 21:08:26', '1', '1', 'black', '5997fedcc7bd4cffbd350b40d1b5b987.jpg', '由于公款私用,已被封禁。'); INSERT INTO `t_user` VALUES (4, 'Micaela', '9f2daa2c7bed6870fcbb5b9a51d6300e', 10, 'Micaela@163.com', '17733333333', '1', '2019-06-14 21:10:13', '2019-06-14 21:11:26', '2019-06-14 21:10:37', '0', '0', 'white', '20180414165909.jpg', '我叫米克拉'); INSERT INTO `t_user` VALUES (5, 'Jana', '176679b77b3c3e352bd3b30ddc81083e', 8, 'Jana@126.com', '17744444444', '1', '2019-06-14 21:12:16', '2019-06-14 21:12:52', '2019-06-14 21:12:32', '1', '1', 'white', '20180414165821.jpg', '大家好,我叫简娜'); INSERT INTO `t_user` VALUES (6, 'Georgie', 'dffc683378cdaa015a0ee9554c532225', 3, 'Georgie@qq.com', '17766666666', '0', '2019-06-14 21:15:09', '2019-06-14 21:16:25', '2019-06-14 21:16:11', '2', '0', 'black', 'BiazfanxmamNRoxxVxka.png', '生产执行rm -rf *,账号封禁T T'); INSERT INTO `t_user` VALUES (7, 'Margot', '31379841b9f4bfde22b8b40471e9a6ce', 9, 'Margot@qq.com', '13444444444', '1', '2019-06-14 21:17:53', '2019-06-14 21:18:59', '2019-06-14 21:18:07', '1', '1', 'white', '20180414165834.jpg', '大家好我叫玛戈'); -- ---------------------------- -- 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', KEY `t_user_role_user_id` (`USER_ID`), KEY `t_user_role_role_id` (`ROLE_ID`) ) 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 (2, 2); INSERT INTO `t_user_role` VALUES (3, 77); INSERT INTO `t_user_role` VALUES (4, 78); INSERT INTO `t_user_role` VALUES (5, 79); INSERT INTO `t_user_role` VALUES (6, 80); INSERT INTO `t_user_role` VALUES (7, 78); INSERT INTO `t_user_role` VALUES (7, 79); INSERT INTO `t_user_role` VALUES (7, 80); -- ---------------------------- -- 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`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT ='用户数据权限关联表'; -- ---------------------------- -- Records of t_user_data_permission -- ---------------------------- BEGIN; 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 (2, 1); INSERT INTO `t_user_data_permission` VALUES (2, 2); INSERT INTO `t_user_data_permission` VALUES (3, 4); INSERT INTO `t_user_data_permission` VALUES (4, 5); COMMIT; -- ---------------------------- -- Table structure for t_data_permission_test -- ---------------------------- DROP TABLE IF EXISTS `t_data_permission_test`; CREATE TABLE `t_data_permission_test` ( `FIELD1` varchar(20) NOT NULL, `FIELD2` varchar(20) NOT NULL, `FIELD3` varchar(20) NOT NULL, `FIELD4` varchar(20) NOT NULL, `DEPT_ID` int(11) NOT NULL, `CREATE_TIME` datetime NOT NULL, `ID` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT ='用户权限测试'; -- ---------------------------- -- Records of t_data_permission_test -- ---------------------------- BEGIN; 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); COMMIT; SET FOREIGN_KEY_CHECKS = 1;