代码拉取完成，页面将自动刷新
同步操作将从 novel/Novel-api 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
/*
Navicat Premium Data Transfer
Source Server : novel
Source Server Type : MySQL
Source Server Version : 80016
Source Schema : novel
Target Server Type : MySQL
Target Server Version : 80016
File Encoding : 65001
Date: 02/01/2020 16:32:43
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门id',
`parent_id` int(11) NULL DEFAULT 0 COMMENT '父部门id',
`ancestors` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '祖级列表',
`dept_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '部门名称',
`order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
`leader` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '负责人',
`phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '联系电话',
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '邮箱',
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
`del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
`create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (100, 0, '0', 'xx科技', 0, 'admin', '15888888888', 'test@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00');
INSERT INTO `sys_dept` VALUES (101, 100, '0,100', '深圳总公司', 1, 'admin', '15888888888', 'test@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00');
INSERT INTO `sys_dept` VALUES (102, 100, '0,100', '长沙分公司', 2, 'admin', '15888888888', 'test@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00');
INSERT INTO `sys_dept` VALUES (103, 101, '0,100,101', '研发部门', 1, 'admin', '15888888888', 'test@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-11-27 08:56:10');
INSERT INTO `sys_dept` VALUES (104, 101, '0,100,101', '市场部门', 2, 'admin', '15888888888', 'test@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00');
INSERT INTO `sys_dept` VALUES (105, 101, '0,100,101', '测试部门', 3, 'admin', '15888888888', 'test1@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-05-15 07:46:27');
INSERT INTO `sys_dept` VALUES (106, 101, '0,100,101', '财务部门', 4, 'admin', '15888888888', 'test@qq.com', '0', '2', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00');
INSERT INTO `sys_dept` VALUES (107, 101, '0,100,101', '运维部门', 5, 'admin', '15888888888', 'test@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-05-20 09:53:41');
INSERT INTO `sys_dept` VALUES (108, 102, '0,100,102', '市场部门', 1, 'admin', '15888888888', 'test@qq.com', '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00');
INSERT INTO `sys_dept` VALUES (109, 102, '0,100,102', '财务部门', 2, 'admin', '15888888888', 'test@qq.com', '0', '2', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00');
INSERT INTO `sys_dept` VALUES (110, 100, '0,100', '测试部门', 3, '王五', '18888888888', '22222', '1', '2', 'admin', '2019-11-27 08:56:44', 'admin', '2019-11-27 08:56:49');
-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
DROP TABLE IF EXISTS `sys_logininfor`;
CREATE TABLE `sys_logininfor` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
`user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户账号',
`ipaddr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '登录IP地址',
`login_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '登录地点',
`browser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '浏览器类型',
`os` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作系统',
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
`msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '提示消息',
`login_time` datetime(0) NULL DEFAULT NULL COMMENT '访问时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 183 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
`menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称',
`parent_id` int(11) NULL DEFAULT 0 COMMENT '父菜单ID',
`order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
`url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#' COMMENT '请求地址',
`menu_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
`visible` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
`perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '权限标识',
`component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件路径',
`redirect` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认跳转地址',
`icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#' COMMENT '菜单图标',
`create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1038 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 1, '/system', 'M', '0', '', 'Layout', '/system/index', 'fa fa-gears', 'admin', '2018-03-16 11:33:00', 'admin', '2019-11-28 03:21:20', '系统管理目录');
INSERT INTO `sys_menu` VALUES (100, '用户管理', 1, 2, '/system/user', 'C', '0', 'system:user:list', 'User', NULL, '', 'admin', '2018-03-16 11:33:00', 'admin', '2018-03-16 11:33:00', '用户管理菜单');
INSERT INTO `sys_menu` VALUES (101, '角色管理', 1, 3, '/system/role', 'C', '0', 'system:role:list', 'Role', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (102, '菜单管理', 1, 4, '/system/menu', 'C', '0', 'system:menu:list', 'Menu', '', '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-05-14 09:57:10', '');
INSERT INTO `sys_menu` VALUES (104, '操作日志', 1, 7, '/system/logs', 'C', '0', 'system:logs:list', 'Logs', NULL, '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-06-11 08:30:43', '操作日志');
INSERT INTO `sys_menu` VALUES (105, '部门管理', 1, 6, '/system/dept', 'C', '0', 'system:dept:list', 'Dept', NULL, '', 'admin', '2019-05-15 03:46:35', 'admin', '2019-06-11 08:30:30', '部门管理');
INSERT INTO `sys_menu` VALUES (106, '岗位管理', 1, 5, '/system/post', 'C', '0', 'system:post:list', 'Post', NULL, '#', '', '2019-06-11 08:29:53', 'admin', '2019-06-11 08:30:17', '岗位管理');
INSERT INTO `sys_menu` VALUES (1000, '用户查询', 100, 1, '#', 'F', '0', 'system:user:query', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-20 07:09:10', '');
INSERT INTO `sys_menu` VALUES (1001, '用户新增', 100, 2, '#', 'F', '0', 'system:user:add', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1002, '用户修改', 100, 3, '#', 'F', '0', 'system:user:edit', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1003, '用户删除', 100, 4, '#', 'F', '0', 'system:user:remove', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1004, '角色查询', 101, 1, '#', 'F', '0', 'system:role:query', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-20 07:09:21', '');
INSERT INTO `sys_menu` VALUES (1005, '角色新增', 101, 2, '#', 'F', '0', 'system:role:add', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1006, '角色修改', 101, 3, '#', 'F', '0', 'system:role:edit', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1007, '角色删除', 101, 4, '#', 'F', '0', 'system:role:remove', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1008, '菜单查询', 102, 1, '#', 'F', '0', 'system:menu:query', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-20 07:09:28', '');
INSERT INTO `sys_menu` VALUES (1009, '菜单新增', 102, 2, '#', 'F', '0', 'system:menu:add', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1010, '菜单修改', 102, 3, '#', 'F', '0', 'system:menu:edit', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1011, '菜单删除', 102, 4, '#', 'F', '0', 'system:menu:remove', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1012, '部门查询', 105, 1, '#', 'F', '0', 'system:dept:query', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-20 07:09:44', '');
INSERT INTO `sys_menu` VALUES (1014, '部门新增', 105, 2, '#', 'F', '0', 'system:dept:add', '', '', '', 'admin', '2019-05-15 03:51:29', 'admin', NULL, '部门新增');
INSERT INTO `sys_menu` VALUES (1015, '部门修改', 105, 3, '#', 'F', '0', 'system:dept:edit', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1016, '部门删除', 105, 4, '#', 'F', '0', 'system:dept:remove', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1018, '日志查询', 104, 1, '#', 'F', '0', 'system:logs:query', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-20 07:09:51', '');
INSERT INTO `sys_menu` VALUES (1019, '日志删除', 104, 2, '#', 'F', '0', 'system:logs:remove', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1020, '日志清空', 104, 3, '#', 'F', '0', 'system:logs:clean', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1021, '日志导出', 104, 4, '#', 'F', '0', 'system:logs:export', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1022, '日志详情', 104, 5, '#', 'F', '0', 'system:logs:detail', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1023, '系统监控', 0, 2, '/monitor', 'M', '0', '', 'Layout', '/server', 'el-icon-camera', '', '2019-05-22 02:07:47', '', NULL, '系统监控');
INSERT INTO `sys_menu` VALUES (1024, '服务监控', 1023, 1, '/monitor/server', 'C', '0', 'monitor:server:list', 'Server', NULL, '#', '', '2019-05-22 02:09:16', '', NULL, '服务监控');
INSERT INTO `sys_menu` VALUES (1025, '岗位查询', 106, 1, '#', 'F', '0', 'system:post:query', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-20 07:09:38', '');
INSERT INTO `sys_menu` VALUES (1026, '岗位新增', 106, 2, '#', 'F', '0', 'system:post:add', '', '', '', 'admin', '2019-05-15 03:51:29', 'admin', NULL, '部门新增');
INSERT INTO `sys_menu` VALUES (1027, '岗位修改', 106, 3, '#', 'F', '0', 'system:post:edit', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1028, '岗位删除', 106, 4, '#', 'F', '0', 'system:post:remove', '', '', '', 'admin', '2018-03-16 11:33:00', 'admin', NULL, '');
INSERT INTO `sys_menu` VALUES (1030, '在线用户', 1023, 2, '/monitor/online', 'C', '0', 'monitor:online:list', 'Online', NULL, '#', '', '2019-12-12 07:45:25', 'test', '2019-12-12 10:01:27', '');
INSERT INTO `sys_menu` VALUES (1031, '强退', 1030, 1, '#', 'F', '0', 'monitor:online:forceLogout', NULL, NULL, '#', 'test', '2019-12-17 03:28:53', 'admin', '2019-12-18 06:20:17', '强制退出登录用户');
INSERT INTO `sys_menu` VALUES (1032, '数据监控', 1023, 3, '/monitor/druid', 'C', '0', 'monitor:druid:list', 'Druid', NULL, '#', 'admin', '2019-12-17 07:53:02', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1033, '登录日志', 1, 8, '/system/logininfor', 'C', '0', 'system:logininfor:list', 'Logininfor', NULL, '#', 'admin', '2019-12-20 07:55:39', 'admin', '2019-12-20 07:55:52', '');
INSERT INTO `sys_menu` VALUES (1034, '登录查询', 1033, 1, '#', 'F', '0', 'system:logininfor:query', NULL, NULL, '#', 'admin', '2019-12-20 07:56:56', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1035, '登录删除', 1033, 2, '#', 'F', '0', 'system:logininfor:remove', NULL, NULL, '#', 'admin', '2019-12-20 07:57:38', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1036, '登录清空', 1033, 3, '#', 'F', '0', 'system:logininfor:clean', NULL, NULL, '#', 'admin', '2019-12-20 07:58:27', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1037, '登录导出', 1033, 4, '#', 'F', '0', 'system:logs:export', NULL, NULL, '#', 'admin', '2019-12-20 07:59:47', '', NULL, '');
-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
`title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '模块标题',
`business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）',
`method` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '方法名称',
`request_method` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求方式',
`operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
`oper_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作人员',
`dept_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '部门名称',
`oper_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '请求URL',
`oper_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '主机地址',
`oper_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作地点',
`oper_param` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '请求参数',
`json_result` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '返回参数',
`status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）',
`error_msg` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '错误消息',
`processing_time` int(11) UNSIGNED ZEROFILL NULL DEFAULT NULL COMMENT '处理耗时',
`oper_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 399 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
`post_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '岗位编码',
`post_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '岗位名称',
`post_sort` int(4) NOT NULL COMMENT '显示顺序',
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态（0正常 1停用）',
`create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_post
-- ----------------------------
INSERT INTO `sys_post` VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '111');
INSERT INTO `sys_post` VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '');
INSERT INTO `sys_post` VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-11-29 07:03:16', '67676');
INSERT INTO `sys_post` VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-11-29 07:01:05', '1212');
INSERT INTO `sys_post` VALUES (6, 'test', '测试', 5, '0', 'admin', '2019-12-18 07:37:14', 'admin', '2019-12-19 09:49:44', '');
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
`role_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
`role_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色权限字符串',
`role_sort` int(4) NOT NULL COMMENT '显示顺序',
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '\0' COMMENT '角色状态（0正常 1停用）',
`del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
`create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '管理员', 'admin', 1, '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-20 08:00:10', '管理员');
INSERT INTO `sys_role` VALUES (2, '普通角色', 'common', 2, '0', '0', 'admin', '2018-03-16 11:33:00', 'admin', '2019-12-30 08:29:24', '普通角色');
-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`role_id` int(11) NOT NULL COMMENT '角色ID',
`menu_id` int(11) NOT NULL COMMENT '菜单ID',
PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (1, 1);
INSERT INTO `sys_role_menu` VALUES (1, 100);
INSERT INTO `sys_role_menu` VALUES (1, 101);
INSERT INTO `sys_role_menu` VALUES (1, 102);
INSERT INTO `sys_role_menu` VALUES (1, 104);
INSERT INTO `sys_role_menu` VALUES (1, 105);
INSERT INTO `sys_role_menu` VALUES (1, 106);
INSERT INTO `sys_role_menu` VALUES (1, 1000);
INSERT INTO `sys_role_menu` VALUES (1, 1001);
INSERT INTO `sys_role_menu` VALUES (1, 1002);
INSERT INTO `sys_role_menu` VALUES (1, 1003);
INSERT INTO `sys_role_menu` VALUES (1, 1004);
INSERT INTO `sys_role_menu` VALUES (1, 1005);
INSERT INTO `sys_role_menu` VALUES (1, 1006);
INSERT INTO `sys_role_menu` VALUES (1, 1007);
INSERT INTO `sys_role_menu` VALUES (1, 1008);
INSERT INTO `sys_role_menu` VALUES (1, 1009);
INSERT INTO `sys_role_menu` VALUES (1, 1010);
INSERT INTO `sys_role_menu` VALUES (1, 1011);
INSERT INTO `sys_role_menu` VALUES (1, 1012);
INSERT INTO `sys_role_menu` VALUES (1, 1014);
INSERT INTO `sys_role_menu` VALUES (1, 1015);
INSERT INTO `sys_role_menu` VALUES (1, 1016);
INSERT INTO `sys_role_menu` VALUES (1, 1023);
INSERT INTO `sys_role_menu` VALUES (1, 1024);
INSERT INTO `sys_role_menu` VALUES (1, 1025);
INSERT INTO `sys_role_menu` VALUES (1, 1026);
INSERT INTO `sys_role_menu` VALUES (1, 1027);
INSERT INTO `sys_role_menu` VALUES (1, 1028);
INSERT INTO `sys_role_menu` VALUES (1, 1030);
INSERT INTO `sys_role_menu` VALUES (1, 1031);
INSERT INTO `sys_role_menu` VALUES (1, 1032);
INSERT INTO `sys_role_menu` VALUES (1, 1033);
INSERT INTO `sys_role_menu` VALUES (1, 1034);
INSERT INTO `sys_role_menu` VALUES (1, 1035);
INSERT INTO `sys_role_menu` VALUES (1, 1036);
INSERT INTO `sys_role_menu` VALUES (1, 1037);
INSERT INTO `sys_role_menu` VALUES (2, 1);
INSERT INTO `sys_role_menu` VALUES (2, 100);
INSERT INTO `sys_role_menu` VALUES (2, 101);
INSERT INTO `sys_role_menu` VALUES (2, 102);
INSERT INTO `sys_role_menu` VALUES (2, 104);
INSERT INTO `sys_role_menu` VALUES (2, 105);
INSERT INTO `sys_role_menu` VALUES (2, 106);
INSERT INTO `sys_role_menu` VALUES (2, 1018);
INSERT INTO `sys_role_menu` VALUES (2, 1033);
INSERT INTO `sys_role_menu` VALUES (2, 1034);
INSERT INTO `sys_role_menu` VALUES (2, 1035);
INSERT INTO `sys_role_menu` VALUES (2, 1036);
INSERT INTO `sys_role_menu` VALUES (2, 1037);
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`dept_id` int(11) NULL DEFAULT NULL COMMENT '部门ID',
`user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号',
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '密码',
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
`avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '头像路径',
`sex` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户邮箱',
`phone_number` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号码',
`age` int(3) NULL DEFAULT NULL COMMENT '年龄',
`salt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '盐加密',
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
`del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
`login_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '最后登陆IP',
`login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登陆时间',
`create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `user_nameUNIQUE`(`user_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '用户' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 100, 'admin', '21f1b450b06590b7c73327748cf05416', 'admin', '/resources/file/2019/12/03/3f6c8020f5bc17cd89d2461126f3fa90.jpeg', '0', '1102@163.com', '15888888889', 18, '6897bb', '0', '0', '116.236.14.114', '2020-01-02 16:31:43', 'admin', '2019-04-28 17:18:07', 'admin', '2020-01-02 08:31:43', '');
INSERT INTO `sys_user` VALUES (13, 105, 'test', '073f61e37a3473667ac8f84fa9b98ffd', '测试', '/resources/file/2019/12/30/e3151b0f8a61be74c8e1e273ad1cded1.jpeg', '0', 'test1@test.com', '18888888888', NULL, '76beb2', '0', '0', '117.144.182.82', '2019-12-30 17:43:28', '', '2019-11-26 09:52:32', 'admin', '2019-12-30 09:43:28', 'aaaa');
INSERT INTO `sys_user` VALUES (14, 103, 'test2', '123456', 'test2', '', '1', 'test2@test.com', '18888888888', NULL, '', '0', '0', '', NULL, '', '2019-11-26 09:54:59', 'admin', '2019-11-27 01:51:44', '');
INSERT INTO `sys_user` VALUES (15, 103, 'test3', 'bec92d371acc88121777ddaca12c944a', '赵六', '', '0', 'zhaoliu@test.com', '13388888888', NULL, '1bc1bc', '0', '0', '', NULL, 'admin', '2019-11-27 02:28:18', 'test3', '2019-11-27 02:28:46', '');
-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
`user_id` int(11) NOT NULL COMMENT '用户ID',
`post_id` int(11) NOT NULL COMMENT '岗位ID',
PRIMARY KEY (`user_id`, `post_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
INSERT INTO `sys_user_post` VALUES (13, 4);
INSERT INTO `sys_user_post` VALUES (15, 2);
-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`user_id` int(11) NOT NULL COMMENT '用户ID',
`role_id` int(11) 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 sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (13, 2);
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手