/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1_3306
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : 127.0.0.1:3306
 Source Schema         : kylin

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

 Date: 06/02/2021 16:35:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键\r\n',
  `dict_sort` int(0) NULL DEFAULT 0 COMMENT '字典排序',
  `dict_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典键',
  `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典值',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
  `is_default` tinyint(1) NULL DEFAULT 0 COMMENT '是否默认（1-是 0否）',
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态（1-正常 0-停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 102 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES (1, 1, '男', '1', 'sys_user_sex', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '性别男');
INSERT INTO `sys_dict_data` VALUES (2, 2, '女', '0', 'sys_user_sex', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '性别女');
INSERT INTO `sys_dict_data` VALUES (3, 3, '未知', '2', 'sys_user_sex', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '性别未知');
INSERT INTO `sys_dict_data` VALUES (4, 1, '显示', '1', 'sys_show_hide', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '显示菜单');
INSERT INTO `sys_dict_data` VALUES (5, 2, '隐藏', '0', 'sys_show_hide', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '隐藏菜单');
INSERT INTO `sys_dict_data` VALUES (6, 1, '正常', '1', 'sys_normal_disable', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '正常状态');
INSERT INTO `sys_dict_data` VALUES (7, 2, '停用', '0', 'sys_normal_disable', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '停用状态');
INSERT INTO `sys_dict_data` VALUES (8, 1, '正常', '1', 'sys_job_status', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '正常状态');
INSERT INTO `sys_dict_data` VALUES (9, 2, '暂停', '0', 'sys_job_status', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '停用状态');
INSERT INTO `sys_dict_data` VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '默认分组');
INSERT INTO `sys_dict_data` VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '系统分组');
INSERT INTO `sys_dict_data` VALUES (12, 1, '是', '1', 'sys_yes_no', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '系统默认是');
INSERT INTO `sys_dict_data` VALUES (13, 2, '否', '0', 'sys_yes_no', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '系统默认否');
INSERT INTO `sys_dict_data` VALUES (14, 1, '通知', '1', 'sys_notice_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '通知');
INSERT INTO `sys_dict_data` VALUES (15, 2, '公告', '2', 'sys_notice_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '公告');
INSERT INTO `sys_dict_data` VALUES (16, 1, '正常', '1', 'sys_notice_status', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '正常状态');
INSERT INTO `sys_dict_data` VALUES (17, 2, '关闭', '0', 'sys_notice_status', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '关闭状态');
INSERT INTO `sys_dict_data` VALUES (18, 99, '其他', '0', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '其他操作');
INSERT INTO `sys_dict_data` VALUES (19, 1, '新增', '1', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '新增操作');
INSERT INTO `sys_dict_data` VALUES (20, 2, '修改', '2', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '修改操作');
INSERT INTO `sys_dict_data` VALUES (21, 3, '删除', '3', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '删除操作');
INSERT INTO `sys_dict_data` VALUES (22, 4, '授权', '4', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '授权操作');
INSERT INTO `sys_dict_data` VALUES (23, 5, '导出', '5', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '导出操作');
INSERT INTO `sys_dict_data` VALUES (24, 6, '导入', '6', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '导入操作');
INSERT INTO `sys_dict_data` VALUES (25, 7, '强退', '7', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '强退操作');
INSERT INTO `sys_dict_data` VALUES (26, 8, '生成代码', '8', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '生成操作');
INSERT INTO `sys_dict_data` VALUES (27, 9, '清空数据', '9', 'sys_oper_type', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '清空操作');
INSERT INTO `sys_dict_data` VALUES (28, 1, '成功', '1', 'sys_common_status', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '正常状态');
INSERT INTO `sys_dict_data` VALUES (29, 2, '失败', '0', 'sys_common_status', 0, 1, 'admin', '2020-12-08 14:18:29', '', '2020-12-22 10:49:13', '停用状态');

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
  `status` tinyint(1) NULL DEFAULT 0 COMMENT '状态（1正常 0停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 121 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES (1, '用户性别', 'sys_user_sex', 1, 'admin', '2020-12-08 14:18:27', '666', '2021-01-22 11:57:10', '用户性别列表');
INSERT INTO `sys_dict_type` VALUES (2, '菜单状态', 'sys_show_hide', 1, 'admin', '2020-12-08 14:18:27', '666', '2020-12-21 14:07:04', '菜单状态列表');
INSERT INTO `sys_dict_type` VALUES (3, '系统开关', 'sys_normal_disable', 1, 'admin', '2020-12-08 14:18:27', '', '2020-12-17 11:15:34', '系统开关列表');
INSERT INTO `sys_dict_type` VALUES (4, '任务状态', 'sys_job_status', 1, 'admin', '2020-12-08 14:18:27', '', '2020-12-17 11:15:35', '任务状态列表');
INSERT INTO `sys_dict_type` VALUES (6, '系统是否', 'sys_yes_no', 1, 'admin', '2020-12-08 14:18:27', '', '2020-12-17 11:15:39', '系统是否列表');
INSERT INTO `sys_dict_type` VALUES (7, '通知类型', 'sys_notice_type', 1, 'admin', '2020-12-08 14:18:27', '', '2020-12-17 11:15:40', '通知类型列表');
INSERT INTO `sys_dict_type` VALUES (8, '通知状态', 'sys_notice_status', 1, 'admin', '2020-12-08 14:18:27', '', '2020-12-17 11:15:42', '通知状态列表');
INSERT INTO `sys_dict_type` VALUES (9, '操作类型', 'sys_oper_type', 1, 'admin', '2020-12-08 14:18:27', '', '2020-12-17 11:15:43', '操作类型列表');
INSERT INTO `sys_dict_type` VALUES (10, '系统状态', 'sys_common_status', 1, 'admin', '2020-12-08 14:18:27', '', '2020-12-17 11:15:44', '登录状态列表');
INSERT INTO `sys_dict_type` VALUES (119, 'qqq', 'qqq', 1, '666', '2021-01-22 11:43:57', '', '2021-01-22 11:43:57', 'qqq');
INSERT INTO `sys_dict_type` VALUES (120, 'yyy', 'yyy', 1, '666', '2021-01-22 11:44:19', '', '2021-01-22 11:44:19', 'yyy');
INSERT INTO `sys_dict_type` VALUES (121, 'ttt', 'ttt', 1, '666', '2021-01-22 11:56:59', '', '2021-01-22 11:56:59', 'ttt');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `pid` int(0) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `is_menu` tinyint(1) NULL DEFAULT NULL,
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 400042 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (100000, '系统管理', '', '', 0, '2020-05-20 10:35:11', 1, '');
INSERT INTO `sys_menu` VALUES (200000, '用户管理', '', 'page/system/setting/user.html', 100000, '2020-05-20 10:35:14', 1, '');
INSERT INTO `sys_menu` VALUES (300000, '角色管理', '', 'page/system/setting/role.html', 100000, '2020-05-20 10:35:20', 1, '');
INSERT INTO `sys_menu` VALUES (400000, '菜单管理', '', 'page/system/setting/menu.html', 100000, '2020-05-20 10:35:22', 1, NULL);
INSERT INTO `sys_menu` VALUES (400001, '查看角色', '', '', 300000, '2020-05-21 09:55:29', 0, NULL);
INSERT INTO `sys_menu` VALUES (400002, '添加角色', '', '', 300000, '2020-05-21 09:55:32', 0, NULL);
INSERT INTO `sys_menu` VALUES (400003, '编辑角色', NULL, '', 300000, '2020-05-21 09:55:35', 0, NULL);
INSERT INTO `sys_menu` VALUES (400004, '删除角色', NULL, '', 300000, '2020-05-21 09:55:38', 0, NULL);
INSERT INTO `sys_menu` VALUES (400005, '查看用户', '', '', 200000, '2020-05-25 13:59:47', 0, '');
INSERT INTO `sys_menu` VALUES (400006, '添加用户', NULL, '', 200000, '2020-05-25 14:00:07', 0, NULL);
INSERT INTO `sys_menu` VALUES (400007, '编辑用户', NULL, '', 200000, '2020-05-25 14:00:26', 0, NULL);
INSERT INTO `sys_menu` VALUES (400008, '删除用户', '', '', 200000, '2020-05-25 14:00:40', 0, NULL);
INSERT INTO `sys_menu` VALUES (400018, '查看菜单', '', '', 400000, '2020-05-28 15:04:11', 0, NULL);
INSERT INTO `sys_menu` VALUES (400019, '添加菜单', '', '', 400000, '2020-05-28 15:05:03', 0, NULL);
INSERT INTO `sys_menu` VALUES (400020, '编辑菜单', '', '', 400000, '2020-05-28 15:34:39', 0, NULL);
INSERT INTO `sys_menu` VALUES (400021, '删除菜单', '', '', 400000, '2020-05-28 15:35:18', 0, NULL);
INSERT INTO `sys_menu` VALUES (400028, '字典管理', '', 'page/system/setting/dict-type.html', 100000, '2020-12-16 15:18:30', 1, NULL);
INSERT INTO `sys_menu` VALUES (400029, '查看字典类型', '', '', 400028, '2020-12-16 15:19:43', 0, NULL);
INSERT INTO `sys_menu` VALUES (400030, '添加字典类型', '', '', 400028, '2020-12-16 15:20:16', 0, NULL);
INSERT INTO `sys_menu` VALUES (400031, '编辑字典类型', '', '', 400028, '2020-12-16 15:20:46', 0, NULL);
INSERT INTO `sys_menu` VALUES (400032, '删除字典类型', '', '', 400028, '2020-12-16 15:21:22', 0, '');
INSERT INTO `sys_menu` VALUES (400033, '字典数据管理', '', '', 400028, '2020-12-21 15:28:05', 0, NULL);
INSERT INTO `sys_menu` VALUES (400034, '查看字典数据', '', '', 400028, '2020-12-21 16:08:01', 0, NULL);
INSERT INTO `sys_menu` VALUES (400035, '添加字典数据', '', '', 400028, '2020-12-21 16:10:01', 0, NULL);
INSERT INTO `sys_menu` VALUES (400036, '删除字典数据', '', '', 400028, '2020-12-21 16:10:23', 0, NULL);
INSERT INTO `sys_menu` VALUES (400037, '编辑字典数据', '', '', 400028, '2020-12-21 16:10:58', 0, NULL);
INSERT INTO `sys_menu` VALUES (400041, '角色授权', '', '', 300000, '2021-02-05 16:28:44', 0, NULL);

-- ----------------------------
-- Table structure for sys_menu_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_permission`;
CREATE TABLE `sys_menu_permission`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `mid` int(0) NULL DEFAULT NULL,
  `pid` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu_permission
-- ----------------------------
INSERT INTO `sys_menu_permission` VALUES (1, 100000, 666667);
INSERT INTO `sys_menu_permission` VALUES (2, 200000, 666668);
INSERT INTO `sys_menu_permission` VALUES (3, 300000, 666669);
INSERT INTO `sys_menu_permission` VALUES (4, 400000, 666670);
INSERT INTO `sys_menu_permission` VALUES (5, 400001, 666671);
INSERT INTO `sys_menu_permission` VALUES (6, 400002, 666672);
INSERT INTO `sys_menu_permission` VALUES (7, 400003, 666673);
INSERT INTO `sys_menu_permission` VALUES (8, 400004, 666674);
INSERT INTO `sys_menu_permission` VALUES (9, 400005, 666675);
INSERT INTO `sys_menu_permission` VALUES (10, 400006, 666676);
INSERT INTO `sys_menu_permission` VALUES (11, 400007, 666677);
INSERT INTO `sys_menu_permission` VALUES (12, 400008, 666678);
INSERT INTO `sys_menu_permission` VALUES (18, 400018, 666685);
INSERT INTO `sys_menu_permission` VALUES (19, 400019, 666686);
INSERT INTO `sys_menu_permission` VALUES (20, 400020, 666687);
INSERT INTO `sys_menu_permission` VALUES (21, 400021, 666688);
INSERT INTO `sys_menu_permission` VALUES (26, 400026, 666693);
INSERT INTO `sys_menu_permission` VALUES (27, 400027, 666694);
INSERT INTO `sys_menu_permission` VALUES (28, 400028, 666695);
INSERT INTO `sys_menu_permission` VALUES (29, 400029, 666696);
INSERT INTO `sys_menu_permission` VALUES (30, 400030, 666697);
INSERT INTO `sys_menu_permission` VALUES (31, 400031, 666698);
INSERT INTO `sys_menu_permission` VALUES (32, 400032, 666699);
INSERT INTO `sys_menu_permission` VALUES (33, 400033, 666700);
INSERT INTO `sys_menu_permission` VALUES (34, 400034, 666701);
INSERT INTO `sys_menu_permission` VALUES (35, 400035, 666702);
INSERT INTO `sys_menu_permission` VALUES (36, 400036, 666703);
INSERT INTO `sys_menu_permission` VALUES (37, 400037, 666704);
INSERT INTO `sys_menu_permission` VALUES (41, 400041, 666708);

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission`  (
  `pid` int(0) NOT NULL AUTO_INCREMENT COMMENT '权限编号',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限类型',
  PRIMARY KEY (`pid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 666708 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
INSERT INTO `sys_permission` VALUES (666667, 'kylin:system:set');
INSERT INTO `sys_permission` VALUES (666668, 'kylin:user:set');
INSERT INTO `sys_permission` VALUES (666669, 'kylin:role:set');
INSERT INTO `sys_permission` VALUES (666670, 'kylin:menu:set');
INSERT INTO `sys_permission` VALUES (666671, 'kylin:role:view');
INSERT INTO `sys_permission` VALUES (666672, 'kylin:role:add');
INSERT INTO `sys_permission` VALUES (666673, 'kylin:role:edit');
INSERT INTO `sys_permission` VALUES (666674, 'kylin:role:delete');
INSERT INTO `sys_permission` VALUES (666675, 'kylin:user:view');
INSERT INTO `sys_permission` VALUES (666676, 'kylin:user:add');
INSERT INTO `sys_permission` VALUES (666677, 'kylin:user:edit');
INSERT INTO `sys_permission` VALUES (666678, 'kylin:user:delete');
INSERT INTO `sys_permission` VALUES (666685, 'kylin:menu:view');
INSERT INTO `sys_permission` VALUES (666686, 'kylin:menu:add');
INSERT INTO `sys_permission` VALUES (666687, 'kylin:menu:edit');
INSERT INTO `sys_permission` VALUES (666688, 'kylin:menu:delete');
INSERT INTO `sys_permission` VALUES (666695, 'kylin:dict:type:set');
INSERT INTO `sys_permission` VALUES (666696, 'kylin:dict:type:view');
INSERT INTO `sys_permission` VALUES (666697, 'kylin:dict:type:add');
INSERT INTO `sys_permission` VALUES (666698, 'kylin:dict:type:edit');
INSERT INTO `sys_permission` VALUES (666699, 'kylin:dict:type:delete');
INSERT INTO `sys_permission` VALUES (666700, 'kylin:dict:data:set');
INSERT INTO `sys_permission` VALUES (666701, 'kylin:dict:data:view');
INSERT INTO `sys_permission` VALUES (666702, 'kylin:dict:data:add');
INSERT INTO `sys_permission` VALUES (666703, 'kylin:dict:data:delete');
INSERT INTO `sys_permission` VALUES (666704, 'kylin:dict:data:edit');
INSERT INTO `sys_permission` VALUES (666708, 'kylin:role:authorization');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `rid` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_name` 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 '角色说明',
  `create_user_id` int(0) NULL DEFAULT NULL COMMENT '创建用户的ID',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`rid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1000011 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (666666, 'ADMIN', '管理员', 7, '2020-05-18 10:09:28');
INSERT INTO `sys_role` VALUES (1000002, 'COMMONADMIN', '只有查看功能的管理员', 7, '2020-05-20 14:23:43');
INSERT INTO `sys_role` VALUES (1000004, 'DEV', '开发人员角色', 7, '2020-05-22 10:15:38');

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `mid` int(0) NULL DEFAULT NULL COMMENT '菜单编号',
  `rid` int(0) NULL DEFAULT NULL COMMENT '用户编号',
  `checked` tinyint(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 235 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (1, 100000, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (2, 200000, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (3, 300000, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (4, 400000, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (6, 400001, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (7, 400002, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (8, 400003, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (9, 400004, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (28, 100000, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (30, 200000, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (31, 300000, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (33, 400000, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (34, 400001, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (35, 400002, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (36, 400003, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (37, 400004, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (38, 400005, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (39, 400006, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (40, 400007, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (41, 400008, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (46, 400005, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (47, 400006, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (48, 400007, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (49, 400008, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (50, 400005, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (51, 400006, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (52, 400007, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (53, 400008, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (62, 100000, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (63, 200000, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (64, 300000, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (65, 400000, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (66, 400001, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (67, 400002, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (68, 400003, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (69, 400004, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (85, 400018, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (86, 400018, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (87, 400018, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (88, 400019, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (89, 400019, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (90, 400019, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (91, 400020, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (92, 400020, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (93, 400020, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (94, 400021, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (95, 400021, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (96, 400021, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (115, 400028, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (116, 400028, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (117, 400028, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (118, 400029, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (119, 400029, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (120, 400029, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (121, 400030, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (122, 400030, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (123, 400030, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (124, 400031, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (125, 400031, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (126, 400031, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (127, 400032, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (128, 400032, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (129, 400032, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (130, 400033, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (131, 400033, 1000002, 1);
INSERT INTO `sys_role_menu` VALUES (132, 400033, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (133, 400034, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (134, 400034, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (135, 400034, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (136, 400035, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (137, 400035, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (138, 400035, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (139, 400036, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (140, 400036, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (141, 400036, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (142, 400037, 666666, 1);
INSERT INTO `sys_role_menu` VALUES (143, 400037, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (144, 400037, 1000004, 1);
INSERT INTO `sys_role_menu` VALUES (232, 400041, 666666, 0);
INSERT INTO `sys_role_menu` VALUES (233, 400041, 1000002, 0);
INSERT INTO `sys_role_menu` VALUES (234, 400041, 1000004, 1);

-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `rid` int(0) NULL DEFAULT NULL,
  `pid` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 216 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
INSERT INTO `sys_role_permission` VALUES (43, 666666, 666667);
INSERT INTO `sys_role_permission` VALUES (45, 666666, 666669);
INSERT INTO `sys_role_permission` VALUES (47, 666666, 666671);
INSERT INTO `sys_role_permission` VALUES (56, 1000002, 666667);
INSERT INTO `sys_role_permission` VALUES (57, 1000002, 666668);
INSERT INTO `sys_role_permission` VALUES (58, 1000002, 666669);
INSERT INTO `sys_role_permission` VALUES (59, 1000002, 666670);
INSERT INTO `sys_role_permission` VALUES (60, 1000002, 666671);
INSERT INTO `sys_role_permission` VALUES (63, 666666, 666673);
INSERT INTO `sys_role_permission` VALUES (64, 666666, 666674);
INSERT INTO `sys_role_permission` VALUES (67, 666666, 666672);
INSERT INTO `sys_role_permission` VALUES (87, 1000002, 666675);
INSERT INTO `sys_role_permission` VALUES (91, 1000004, 666667);
INSERT INTO `sys_role_permission` VALUES (92, 1000004, 666668);
INSERT INTO `sys_role_permission` VALUES (93, 1000004, 666669);
INSERT INTO `sys_role_permission` VALUES (94, 1000004, 666670);
INSERT INTO `sys_role_permission` VALUES (95, 1000004, 666671);
INSERT INTO `sys_role_permission` VALUES (96, 1000004, 666672);
INSERT INTO `sys_role_permission` VALUES (97, 1000004, 666673);
INSERT INTO `sys_role_permission` VALUES (98, 1000004, 666674);
INSERT INTO `sys_role_permission` VALUES (99, 1000004, 666675);
INSERT INTO `sys_role_permission` VALUES (100, 1000004, 666676);
INSERT INTO `sys_role_permission` VALUES (101, 1000004, 666677);
INSERT INTO `sys_role_permission` VALUES (102, 1000004, 666678);
INSERT INTO `sys_role_permission` VALUES (110, 1000002, 666685);
INSERT INTO `sys_role_permission` VALUES (116, 1000004, 666685);
INSERT INTO `sys_role_permission` VALUES (117, 1000004, 666686);
INSERT INTO `sys_role_permission` VALUES (118, 1000004, 666687);
INSERT INTO `sys_role_permission` VALUES (119, 1000004, 666688);
INSERT INTO `sys_role_permission` VALUES (123, 666666, 666668);
INSERT INTO `sys_role_permission` VALUES (124, 666666, 666670);
INSERT INTO `sys_role_permission` VALUES (125, 666666, 666675);
INSERT INTO `sys_role_permission` VALUES (126, 666666, 666676);
INSERT INTO `sys_role_permission` VALUES (127, 666666, 666677);
INSERT INTO `sys_role_permission` VALUES (128, 666666, 666678);
INSERT INTO `sys_role_permission` VALUES (129, 666666, 666685);
INSERT INTO `sys_role_permission` VALUES (130, 666666, 666686);
INSERT INTO `sys_role_permission` VALUES (131, 666666, 666687);
INSERT INTO `sys_role_permission` VALUES (132, 666666, 666688);
INSERT INTO `sys_role_permission` VALUES (139, 1000004, 666695);
INSERT INTO `sys_role_permission` VALUES (140, 1000004, 666696);
INSERT INTO `sys_role_permission` VALUES (141, 1000004, 666697);
INSERT INTO `sys_role_permission` VALUES (142, 1000004, 666698);
INSERT INTO `sys_role_permission` VALUES (143, 1000004, 666699);
INSERT INTO `sys_role_permission` VALUES (144, 666666, 666695);
INSERT INTO `sys_role_permission` VALUES (145, 666666, 666696);
INSERT INTO `sys_role_permission` VALUES (146, 666666, 666697);
INSERT INTO `sys_role_permission` VALUES (147, 666666, 666698);
INSERT INTO `sys_role_permission` VALUES (148, 666666, 666699);
INSERT INTO `sys_role_permission` VALUES (149, 1000002, 666695);
INSERT INTO `sys_role_permission` VALUES (150, 1000002, 666696);
INSERT INTO `sys_role_permission` VALUES (151, 1000004, 666700);
INSERT INTO `sys_role_permission` VALUES (152, 1000004, 666701);
INSERT INTO `sys_role_permission` VALUES (153, 1000004, 666702);
INSERT INTO `sys_role_permission` VALUES (154, 1000004, 666703);
INSERT INTO `sys_role_permission` VALUES (155, 1000004, 666704);
INSERT INTO `sys_role_permission` VALUES (156, 666666, 666700);
INSERT INTO `sys_role_permission` VALUES (157, 666666, 666701);
INSERT INTO `sys_role_permission` VALUES (158, 666666, 666702);
INSERT INTO `sys_role_permission` VALUES (159, 666666, 666703);
INSERT INTO `sys_role_permission` VALUES (160, 666666, 666704);
INSERT INTO `sys_role_permission` VALUES (161, 1000002, 666700);
INSERT INTO `sys_role_permission` VALUES (216, 1000004, 666708);

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `uid` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号-用户名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '盐值-密码加密时的盐值',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (7, '999', 'ded6a38de0a72306fc04f092ce02cfd4', 'muchengxiang@qq.com', '15649862116', '2020-11-09 09:35:32', '2020-12-25 17:29:22', '1', 'ec2fbf24ba6875fd7e8becbe3e7b253b');
INSERT INTO `sys_user` VALUES (14, '666', '3d9929006bd7da1c0513dcbcf95e8d0c', '1150739786@qq.com', '13083802162', '2020-11-09 10:13:44', '2021-02-06 16:26:18', '1', '8a97be3eac2469d292ad5d1510fc534c');
INSERT INTO `sys_user` VALUES (15, 'admin', 'b110102d619d236d6cb56feaeb51aef1', 'muchengxiang@qq.com', '15649862116', '2020-11-09 11:17:59', '2020-12-28 15:25:11', '1', '1efd34a9ac3824a844a23c54f06337d8');

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uid` int(0) NULL DEFAULT NULL COMMENT '用户ID',
  `rid` int(0) NULL DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (1, 7, 666666);
INSERT INTO `sys_user_role` VALUES (6, 14, 1000004);
INSERT INTO `sys_user_role` VALUES (7, 15, 1000002);

SET FOREIGN_KEY_CHECKS = 1;