/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.24.105
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : 192.168.24.105:3306
 Source Schema         : user-center

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

 Date: 14/09/2020 14:01:09
*/

DROP DATABASE IF EXISTS `user-center`;
CREATE DATABASE `user-center`;
USE `user-center`;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
CREATE TABLE `sys_config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `config_type` smallint(6) NULL DEFAULT NULL COMMENT '配置类型标识(0:系统配置 1:flink配置 2: spark配置)',
  `config_value` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置内容',
  `status` int(1) NULL DEFAULT 0 COMMENT '状态',
  `create_time` bigint(20) NULL DEFAULT NULL,
  `update_time` bigint(20) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_config
-- ----------------------------


-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
CREATE TABLE `sys_menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) NOT NULL,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `path` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `css` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sort` int(11) NOT NULL,
  `createTime` datetime(0) NOT NULL,
  `updateTime` datetime(0) NOT NULL,
  `isMenu` int(11) NULL DEFAULT NULL COMMENT '是否菜单 1 是 2 不是',
  `hidden` int(11) NULL DEFAULT NULL COMMENT '是否隐藏,0 false 1 true',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, -1, '后台管理', 'javascript:;', '', 'layui-icon-set', 2, '2019-09-05 11:37:02', '2019-09-05 11:37:02', 1, 0);
INSERT INTO `sys_menu` VALUES (2, 1, '用户管理', '#!user', 'system/user.html', 'layui-icon-friends', 2, '2017-11-17 16:56:59', '2019-09-05 11:37:26', 1, 0);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', '#!role', 'system/role.html', 'layui-icon-friends', 3, '2017-11-17 16:56:59', '2019-09-05 11:37:38', 1, 0);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', '#!menus', 'system/menus.html', 'layui-icon-menu-fill', 4, '2017-11-17 16:56:59', '2019-09-05 11:37:57', 1, 0);
INSERT INTO `sys_menu` VALUES (5, 1, '权限管理', '#!permissions', 'system/permissions.html', 'layui-icon-password', 5, '2017-11-17 16:56:59', '2019-09-05 11:37:47', 1, 0);
INSERT INTO `sys_menu` VALUES (6, 1, '我的信息', '#!myInfo', 'system/myInfo.html', '', 10, '2017-11-17 16:56:59', '2018-09-02 06:12:24', 1, 1);
INSERT INTO `sys_menu` VALUES (7, -1, '认证中心', 'javascript:;', '', 'layui-icon-set', 1, '2017-11-17 16:56:59', '2019-03-26 06:56:46', 1, 0);
INSERT INTO `sys_menu` VALUES (8, 7, '应用管理', '#!app', 'attestation/app.html', 'layui-icon-app', 9, '2017-11-17 16:56:59', '2018-08-25 10:57:42', 1, 0);
INSERT INTO `sys_menu` VALUES (9, 7, '服务管理', '#!services', 'attestation/services.html', 'layui-icon-website', 8, '2017-11-17 16:56:59', '2018-09-02 09:34:13', 1, 0);
INSERT INTO `sys_menu` VALUES (10, 7, '令牌管理', '#!token', 'attestation/token.html', 'layui-icon-util', 11, '2018-09-08 13:19:56', '2019-05-27 09:28:39', 1, 0);
INSERT INTO `sys_menu` VALUES (11, -1, '系统监控', 'javascript:;', '', 'layui-icon-set', 3, '2018-08-25 10:41:58', '2018-08-25 10:41:58', 1, 0);
INSERT INTO `sys_menu` VALUES (12, 11, '注册中心', '#!register', 'http://192.168.24.105:1111/', 'layui-icon-engine', 2, '2017-11-17 16:56:59', '2020-04-22 03:15:07', 1, 0);
INSERT INTO `sys_menu` VALUES (13, 11, '服务治理', '#!eureka', 'eureka/list.html', 'layui-icon-engine', 1, '2018-08-30 15:30:19', '2019-05-25 20:34:40', 1, 0);
INSERT INTO `sys_menu` VALUES (16, 11, '文档中心', '#!swagger', 'http://192.168.24.105:8183', 'layui-icon-app', 9, '2017-11-17 16:56:59', '2020-04-22 03:15:17', 1, 0);
INSERT INTO `sys_menu` VALUES (19, 11, 'prometheus监控', '#!prometheus', 'http://192.168.24.105:9090', 'layui-icon-engine', 1111, '2019-03-27 11:23:31', '2020-04-22 03:26:27', 1, 0);
INSERT INTO `sys_menu` VALUES (25, -1, '路由管理', '#!route', 'route/route.html', 'layui-icon-engine', 111111, '2019-06-14 21:28:54', '2019-06-14 21:28:54', 1, 0);
INSERT INTO `sys_menu` VALUES (26, -1, '客户信息管理', 'javascript:;', '', 'layui-icon-table', 3, '2020-04-20 14:49:00', '2020-04-20 14:49:00', 1, 0);
INSERT INTO `sys_menu` VALUES (27, 26, '企业信息管理', '#!organization', 'clientele/organization.html', 'layui-icon-flag', 1, '2020-04-20 15:16:00', '2020-04-20 15:16:00', 1, 0);
INSERT INTO `sys_menu` VALUES (28, 26, '分组信息管理', '#!group', 'clientele/group.html', 'layui-icon-group', 2, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (29, 26, '监控信息管理', '#!monitor', 'clientele/monitor.html', 'layui-icon-component', 3, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (30, 26, '围栏信息管理', '#!fence', 'clientele/fence.html', 'layui-icon-circle', 4, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (31, 26, '围栏绑定管理', '#!fenceConfig', 'clientele/fence_config.html', 'layui-icon-component', 5, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (32, 26, '报警设置管理', '#!alarmSet', 'clientele/alarm_set.html', 'layui-icon-set-sm', 6, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (33, -1, '项目配置', 'javascript:;', '', 'layui-icon-set', 4, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (34, 33, '系统配置', '#!sysConfig', 'configuration/systemConf.html', 'layui-icon-set-fill', 1, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (35, 26, '从业人员管理', '#!professional', 'clientele/professional.html', 'layui-icon-set-sm', 7, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (36, 33, '报警字典管理', '#!alarmCode', 'clientele/alarm_code.html', 'layui-icon-set-sm', 2, '2020-04-21 15:53:00', '2020-04-21 15:53:00', 1, 0);
INSERT INTO `sys_menu` VALUES (37, 26, '接入平台信息管理', '#!access', 'clientele/access_platform.html', 'layui-icon-set-sm', 7, '2020-07-20 15:53:00', '2020-07-20 15:53:00', 1, 0);

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
CREATE TABLE `sys_permission`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `permission` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `createTime` datetime(0) NOT NULL,
  `updateTime` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `permission`(`permission`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 119 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
INSERT INTO `sys_permission` VALUES (1, 'permission:post/permissions', '保存权限标识', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (2, 'permission:put/permissions', '修改权限标识', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (3, 'permission:delete/permissions/{id}', '删除权限标识', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (4, 'permission:get/permissions', '查询权限标识', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (5, '/permissions/{roleId}/permissions', '查看角色权限', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (6, '/permissions/granted', '角色分配权限', '2018-01-18 17:06:39', '2018-01-18 17:06:39');
INSERT INTO `sys_permission` VALUES (7, 'role:post/roles', '添加角色', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (8, 'role:put/roles', '修改角色', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (9, 'role:delete/roles/{id}', '删除角色', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (10, 'role:post/roles/{id}/permissions', '给角色分配权限', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (11, 'role:get/roles', '查询角色', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (12, 'role:get/roles/{id}/permissions', '获取角色的权限', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (13, 'user:post/users/{id}/roles', '给用户分配角色', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (14, 'user:post/users/{id}/resetPassword', '用户重置密码', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (15, 'user:get/users', '用户查询', '2018-01-18 17:12:00', '2018-01-18 17:12:05');
INSERT INTO `sys_permission` VALUES (16, 'user:put/users/me', '修改用户', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (17, 'user:get/users/{id}/roles', '获取用户的角色', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (18, 'user:post/users/saveOrUpdate', '新增用户', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (19, 'user:post/users/exportUser', '导出用户', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (20, 'user:get/users/updateEnabled', '用户状态修改', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (21, 'user:put/users/password', '修改密码', '2018-01-18 17:06:39', '2018-01-18 17:06:39');
INSERT INTO `sys_permission` VALUES (22, 'menu:get/menus/all', '查询菜单', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (23, 'menu:post/menus/granted', '给角色分配菜单', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (24, 'menu:get/menus/tree', '树形显示', '2018-01-18 17:06:39', '2018-01-18 17:06:39');
INSERT INTO `sys_permission` VALUES (25, 'menu:get/menus/{roleId}/menus', '获取角色的菜单', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (26, 'menu:post/menus', '添加菜单', '2018-01-18 17:06:39', '2018-09-04 07:35:29');
INSERT INTO `sys_permission` VALUES (27, 'menu:put/menus', '修改菜单', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (28, 'menu:delete/menus/{id}', '删除菜单', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (29, 'menu:get/menus/current', '当前用户菜单', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (30, 'menu:get/menus/findAlls', '所有菜单', '2018-01-18 17:06:39', '2018-01-18 17:06:39');
INSERT INTO `sys_permission` VALUES (31, 'client:post/clients', '保存应用', '2018-01-18 17:06:39', '2018-01-18 17:06:39');
INSERT INTO `sys_permission` VALUES (32, 'client:get/clients', '应用列表', '2018-01-18 17:06:39', '2018-01-18 17:06:39');
INSERT INTO `sys_permission` VALUES (33, 'client:get/clients/{id}', '根据id获取应用', '2018-01-18 17:06:39', '2018-01-18 17:06:39');
INSERT INTO `sys_permission` VALUES (34, 'client:delete/clients', '删除应用', '2018-01-18 17:06:39', '2018-01-18 17:06:42');
INSERT INTO `sys_permission` VALUES (35, 'service:get/service/findAlls', '查询所有服务', '2018-01-18 17:06:39', '2018-09-03 08:05:09');
INSERT INTO `sys_permission` VALUES (36, 'service:get/service/findOnes', '服务树', '2018-01-18 17:06:39', '2018-09-08 03:23:28');
INSERT INTO `sys_permission` VALUES (37, 'menu:get/menus/findOnes', '获取菜单以及顶层菜单', '2019-05-09 23:48:13', '2019-05-09 23:48:13');
INSERT INTO `sys_permission` VALUES (38, 'permission:get/permissions/{roleId}/permissions', '根据roleId获取权限', '2019-05-10 00:02:23', '2019-05-10 00:02:23');
INSERT INTO `sys_permission` VALUES (39, 'file:query', '获取文件列表', '2019-05-17 21:34:05', '2019-05-17 21:34:08');
INSERT INTO `sys_permission` VALUES (40, 'file:del', '删除文件', '2019-05-17 21:36:46', '2019-05-17 21:36:48');
INSERT INTO `sys_permission` VALUES (41, 'service:delete/service/{id}', '根据ID删除服务', '2020-03-30 09:09:02', '2020-03-30 09:09:02');
INSERT INTO `sys_permission` VALUES (42, 'permission:post/permissions/granted', '角色分配权限', '2020-03-30 09:11:15', '2020-03-30 09:11:15');
INSERT INTO `sys_permission` VALUES (43, 'service:post/saveOrUpdate', '添加服务', '2020-06-18 14:46:00', '2020-04-21 14:46:00');
INSERT INTO `sys_permission` VALUES (100, 'customer-center:get/organizations', '客户信息-企业列表', '2020-04-20 04:42:27', '2020-04-20 04:42:27');
INSERT INTO `sys_permission` VALUES (101, 'customer-center:get/groups', '客户信息-分组列表', '2020-04-21 16:17:00', '2020-04-21 16:17:00');
INSERT INTO `sys_permission` VALUES (102, 'customer-center:get/monitors', '客户信息-监控对象列表', '2020-04-21 16:17:00', '2020-04-21 16:17:00');
INSERT INTO `sys_permission` VALUES (103, 'customer-center:get/fences', '客户信息-围栏列表', '2020-04-21 16:17:00', '2020-04-21 16:17:00');
INSERT INTO `sys_permission` VALUES (104, 'customer-center:get/fenceConfigs', '客户信息-围栏绑定列表', '2020-04-21 16:17:00', '2020-04-21 16:17:00');
INSERT INTO `sys_permission` VALUES (105, 'customer-center:get/alarmSets', '客户信息-报警设置信息列表', '2020-04-21 16:17:00', '2020-04-21 16:17:00');
INSERT INTO `sys_permission` VALUES (106, 'customer-center:get/professionals', '客户信息-从业人员信息管理', '2020-04-21 16:17:00', '2020-04-21 16:17:00');
INSERT INTO `sys_permission` VALUES (107, 'customer-center:get/alarmCodes', '客户信息-报警字典管理', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (108, 'customer-center:synchronization/professional', '客户信息-从业人员信息缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (109, 'customer-center:synchronization/alarmCode', '客户信息-报警字典管理缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (110, 'customer-center:synchronization/organizations', '客户信息-企业信息缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (111, 'customer-center:synchronization/monitor', '客户信息-监控对象信息缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (112, 'customer-center:synchronization/group', '客户信息-分组信息缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (113, 'customer-center:synchronization/fence', '客户信息-围栏信息缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (114, 'customer-center:synchronization/fenceConfig', '客户信息-围栏绑定信息缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (115, 'customer-center:synchronization/alarmSet', '客户信息-报警设置信息缓存刷新', '2020-04-21 16:17:00', '2020-06-04 07:14:26');
INSERT INTO `sys_permission` VALUES (116, 'customer-center:get/accessList', '客户信息-接入平台信息列表', '2020-07-20 16:17:00', '2020-07-20 16:17:00');
INSERT INTO `sys_permission` VALUES (117, 'customer-center:synchronization/accessPlatform', '客户信息-接入平台信息缓存刷新', '2020-07-20 16:17:00', '2020-07-20 16:17:00');
INSERT INTO `sys_permission` VALUES (118, 'customer-center:system/clean', '认证中心-清除客户基础数据', '2020-09-01 00:46:05', '2020-09-01 00:46:05');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
CREATE TABLE `sys_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色code',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名',
  `createTime` datetime(0) NOT NULL,
  `updateTime` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `code`(`code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, 'ADMIN', '管理员', '2017-11-17 16:56:59', '2017-11-17 16:56:59');

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
CREATE TABLE `sys_role_menu`  (
  `roleId` int(11) NOT NULL,
  `menuId` int(11) NOT NULL,
  PRIMARY KEY (`roleId`, `menuId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (1, 1);
INSERT INTO `sys_role_menu` VALUES (1, 2);
INSERT INTO `sys_role_menu` VALUES (1, 3);
INSERT INTO `sys_role_menu` VALUES (1, 4);
INSERT INTO `sys_role_menu` VALUES (1, 5);
INSERT INTO `sys_role_menu` VALUES (1, 6);
INSERT INTO `sys_role_menu` VALUES (1, 7);
INSERT INTO `sys_role_menu` VALUES (1, 8);
INSERT INTO `sys_role_menu` VALUES (1, 9);
INSERT INTO `sys_role_menu` VALUES (1, 10);
INSERT INTO `sys_role_menu` VALUES (1, 11);
INSERT INTO `sys_role_menu` VALUES (1, 12);
INSERT INTO `sys_role_menu` VALUES (1, 13);
INSERT INTO `sys_role_menu` VALUES (1, 14);
INSERT INTO `sys_role_menu` VALUES (1, 16);
INSERT INTO `sys_role_menu` VALUES (1, 18);
INSERT INTO `sys_role_menu` VALUES (1, 19);
INSERT INTO `sys_role_menu` VALUES (1, 25);
INSERT INTO `sys_role_menu` VALUES (1, 26);
INSERT INTO `sys_role_menu` VALUES (1, 27);
INSERT INTO `sys_role_menu` VALUES (1, 28);
INSERT INTO `sys_role_menu` VALUES (1, 29);
INSERT INTO `sys_role_menu` VALUES (1, 30);
INSERT INTO `sys_role_menu` VALUES (1, 31);
INSERT INTO `sys_role_menu` VALUES (1, 32);
INSERT INTO `sys_role_menu` VALUES (1, 33);
INSERT INTO `sys_role_menu` VALUES (1, 34);
INSERT INTO `sys_role_menu` VALUES (1, 35);
INSERT INTO `sys_role_menu` VALUES (1, 36);
INSERT INTO `sys_role_menu` VALUES (1, 37);

-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
CREATE TABLE `sys_role_permission`  (
  `roleId` int(11) NOT NULL,
  `permissionId` bigint(20) NOT NULL,
  PRIMARY KEY (`roleId`, `permissionId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
INSERT INTO `sys_role_permission` VALUES (1, 1);
INSERT INTO `sys_role_permission` VALUES (1, 2);
INSERT INTO `sys_role_permission` VALUES (1, 3);
INSERT INTO `sys_role_permission` VALUES (1, 4);
INSERT INTO `sys_role_permission` VALUES (1, 5);
INSERT INTO `sys_role_permission` VALUES (1, 6);
INSERT INTO `sys_role_permission` VALUES (1, 7);
INSERT INTO `sys_role_permission` VALUES (1, 8);
INSERT INTO `sys_role_permission` VALUES (1, 9);
INSERT INTO `sys_role_permission` VALUES (1, 10);
INSERT INTO `sys_role_permission` VALUES (1, 11);
INSERT INTO `sys_role_permission` VALUES (1, 12);
INSERT INTO `sys_role_permission` VALUES (1, 13);
INSERT INTO `sys_role_permission` VALUES (1, 14);
INSERT INTO `sys_role_permission` VALUES (1, 15);
INSERT INTO `sys_role_permission` VALUES (1, 16);
INSERT INTO `sys_role_permission` VALUES (1, 17);
INSERT INTO `sys_role_permission` VALUES (1, 18);
INSERT INTO `sys_role_permission` VALUES (1, 19);
INSERT INTO `sys_role_permission` VALUES (1, 20);
INSERT INTO `sys_role_permission` VALUES (1, 21);
INSERT INTO `sys_role_permission` VALUES (1, 22);
INSERT INTO `sys_role_permission` VALUES (1, 23);
INSERT INTO `sys_role_permission` VALUES (1, 24);
INSERT INTO `sys_role_permission` VALUES (1, 25);
INSERT INTO `sys_role_permission` VALUES (1, 26);
INSERT INTO `sys_role_permission` VALUES (1, 27);
INSERT INTO `sys_role_permission` VALUES (1, 28);
INSERT INTO `sys_role_permission` VALUES (1, 29);
INSERT INTO `sys_role_permission` VALUES (1, 30);
INSERT INTO `sys_role_permission` VALUES (1, 31);
INSERT INTO `sys_role_permission` VALUES (1, 32);
INSERT INTO `sys_role_permission` VALUES (1, 33);
INSERT INTO `sys_role_permission` VALUES (1, 34);
INSERT INTO `sys_role_permission` VALUES (1, 35);
INSERT INTO `sys_role_permission` VALUES (1, 36);
INSERT INTO `sys_role_permission` VALUES (1, 37);
INSERT INTO `sys_role_permission` VALUES (1, 38);
INSERT INTO `sys_role_permission` VALUES (1, 39);
INSERT INTO `sys_role_permission` VALUES (1, 40);
INSERT INTO `sys_role_permission` VALUES (1, 41);
INSERT INTO `sys_role_permission` VALUES (1, 42);
INSERT INTO `sys_role_permission` VALUES (1, 43);
INSERT INTO `sys_role_permission` VALUES (1, 100);
INSERT INTO `sys_role_permission` VALUES (1, 101);
INSERT INTO `sys_role_permission` VALUES (1, 102);
INSERT INTO `sys_role_permission` VALUES (1, 103);
INSERT INTO `sys_role_permission` VALUES (1, 104);
INSERT INTO `sys_role_permission` VALUES (1, 105);
INSERT INTO `sys_role_permission` VALUES (1, 106);
INSERT INTO `sys_role_permission` VALUES (1, 107);
INSERT INTO `sys_role_permission` VALUES (1, 108);
INSERT INTO `sys_role_permission` VALUES (1, 109);
INSERT INTO `sys_role_permission` VALUES (1, 110);
INSERT INTO `sys_role_permission` VALUES (1, 111);
INSERT INTO `sys_role_permission` VALUES (1, 112);
INSERT INTO `sys_role_permission` VALUES (1, 113);
INSERT INTO `sys_role_permission` VALUES (1, 114);
INSERT INTO `sys_role_permission` VALUES (1, 115);
INSERT INTO `sys_role_permission` VALUES (1, 116);
INSERT INTO `sys_role_permission` VALUES (1, 117);

-- ----------------------------
-- Table structure for sys_role_user
-- ----------------------------
CREATE TABLE `sys_role_user`  (
  `userId` bigint(20) NOT NULL,
  `roleId` int(11) NOT NULL,
  PRIMARY KEY (`userId`, `roleId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_user
-- ----------------------------
INSERT INTO `sys_role_user` VALUES (1, 1);
INSERT INTO `sys_role_user` VALUES (2, 1);
INSERT INTO `sys_role_user` VALUES (4, 1);
INSERT INTO `sys_role_user` VALUES (8, 1);
INSERT INTO `sys_role_user` VALUES (9, 1);
INSERT INTO `sys_role_user` VALUES (10, 1);
INSERT INTO `sys_role_user` VALUES (11, 1);
INSERT INTO `sys_role_user` VALUES (13, 1);
INSERT INTO `sys_role_user` VALUES (14, 1);
INSERT INTO `sys_role_user` VALUES (15, 3);

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
CREATE TABLE `sys_user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `headImgUrl` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sex` tinyint(1) NULL DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `createTime` datetime(0) NOT NULL,
  `updateTime` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', '$2a$10$Wtw81uu43fGKw9lkOr1RAOTNWxQIZBsB3YDwc/5yDnr/yeG5x92EG', '管理员', '', '13106975707', 1, 1, 'BACKEND', '2017-11-17 16:56:59', '2018-09-15 03:12:44');

