lcx
/
lcxlite.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : lcxlite

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

 Date: 01/05/2021 10:07:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details`  (
  `client_id` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户端Id',
  `resource_ids` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可以访问的资源Ids',
  `client_secret` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `scope` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `authorized_grant_types` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `web_server_redirect_uri` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `authorities` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `access_token_validity` int NULL DEFAULT NULL,
  `refresh_token_validity` int NULL DEFAULT NULL,
  `additional_information` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `autoapprove` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`client_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
INSERT INTO `oauth_client_details` VALUES ('lcx-sys-client', NULL, '$2a$10$oVg4.ctxWJciD5U.lC7H6ekKF5bK2ug3oZ2ESJnIyTwNQbyzSn/NG', 'read', 'authorization_code,password,refresh_token,implicit,client_credentials', 'https://www.baidu.com/', NULL, NULL, NULL, NULL, 'true');

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `id` int NOT NULL COMMENT '主键',
  `parent` int NOT NULL COMMENT '父级ID',
  `parents` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '所有父级',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名字',
  `orders` int NOT NULL COMMENT '排序',
  `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '状态 0关闭 1开启',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `modify_date` datetime NOT NULL COMMENT '更新时间',
  `modify_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '更新者',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建者',
  `version` int NOT NULL COMMENT '乐观锁',
  `enKey` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '部门机构表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------

-- ----------------------------
-- Table structure for sys_file_dir
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_dir`;
CREATE TABLE `sys_file_dir`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `file_dir_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件夹名称',
  `file_dir_parent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件夹父路径',
  `file_dir_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '父子路径',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name_dir_uni`(`file_dir_name`, `file_dir_parent`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 118 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_file_dir
-- ----------------------------
INSERT INTO `sys_file_dir` VALUES (1, '顶级文件夹', '0', '0', '2021-02-23 17:24:14');
INSERT INTO `sys_file_dir` VALUES (2, '文档', '1', '0,1', '2021-02-23 17:28:41');
INSERT INTO `sys_file_dir` VALUES (3, '公司', '2', '0,1,2', '2021-02-23 17:35:56');
INSERT INTO `sys_file_dir` VALUES (4, '我的', '2', '0,1,2', '2021-02-23 17:36:34');

-- ----------------------------
-- Table structure for sys_files
-- ----------------------------
DROP TABLE IF EXISTS `sys_files`;
CREATE TABLE `sys_files`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名',
  `file_original_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原始名称',
  `file_ext` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '拓展名',
  `file_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件类别',
  `file_dir` bigint NOT NULL COMMENT '文件夹',
  `file_size` bigint NULL DEFAULT NULL COMMENT '文件大小',
  `file_up_time` datetime NULL DEFAULT NULL COMMENT '上传日期',
  `file_rubbish` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否垃圾',
  `file_net_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '网络路径',
  `file_local_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '本地路径',
  `file_up_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传方式',
  `file_up_from` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上传端口',
  `file_img_ext` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片类参数',
  `file_use_sence` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用场景',
  `file_md_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `file_md_user_info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人信息',
  `file_create_user_info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_files
-- ----------------------------

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userId` bigint NOT NULL COMMENT '用户id',
  `tag` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签',
  `msg_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息',
  `login_time` datetime NOT NULL COMMENT '登录时间',
  `login_way` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录端口',
  `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录设备',
  `engine` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '浏览器',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录ip',
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录token',
  `loginId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'loginId',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_login_log
-- ----------------------------
INSERT INTO `sys_login_log` VALUES (1, 1, 'USER_LOGOUT', '用户登出', '2021-04-29 03:12:18', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '2390a145a081c318295d89bd9a3eb84e', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (2, 1, 'USER_LOGIN', '用户登录', '2021-04-29 03:13:32', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '951f1888c0ba6f2982fc27bbe3179475', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (3, 1, 'USER_LOGIN', '用户登录', '2021-04-29 03:15:57', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', 'a6b775b60777c34bed2f3062552989eb', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (4, 1, 'USER_LOGIN', '用户登录', '2021-04-29 07:01:27', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', 'a086c3bb3fc1616056caa95a3b61f406', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (5, 1, 'USER_LOGIN', '用户登录', '2021-04-29 09:12:48', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', 'ca2a2d148922774b11af80192c232f5a', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (6, 1, 'USER_LOGIN', '用户登录', '2021-04-29 09:18:27', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '2a5aaef756a38ee3afafa3b8f13e983b', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (7, 1, 'USER_LOGIN', '用户登录', '2021-04-29 09:24:38', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '68ad62559ebb3bc55489a71ce44bcb3c', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (8, 1, 'USER_LOGIN', '用户登录', '2021-04-29 09:28:44', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', 'f3eea4ff796af0f9b7f88fc05626c403', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (9, 1, 'USER_LOGIN', '用户登录', '2021-04-30 02:50:10', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '2a274b1ffa87bb2f0732d184455a5d53', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (10, 1, 'USER_LOGIN', '用户登录', '2021-04-30 02:54:16', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '41d46a8654642ca33aa3dc34616d5f00', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (11, 1, 'USER_LOGIN', '用户登录', '2021-04-30 03:27:56', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '487797d560b8db33791398b900e1c876', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (12, 1, 'USER_LOGIN', '用户登录', '2021-04-30 03:31:25', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', '58e4607c6c7c94973336ea0fb9fd500d', 'QURNSU46YWRtaW46MQ==');
INSERT INTO `sys_login_log` VALUES (13, 1, 'USER_LOGIN', '用户登录', '2021-04-30 03:32:46', 'ADMIN', 'Windows 10 or Windows Server 2016', 'MSEdge【Webkit-537.36】', '0:0:0:0:0:0:0:1', 'dae6e3cbc1564366ff68b919c415f7d5', 'QURNSU46YWRtaW46MQ==');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '菜单名称',
  `parent` bigint NULL DEFAULT 0 COMMENT '父菜单ID',
  `orders` int NULL DEFAULT 0 COMMENT '显示顺序',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '#' COMMENT '请求地址',
  `menu_type` char(8) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '菜单类型（M模块 C菜单 F按钮）',
  `visible` char(8) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '创建者',
  `create_date` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `modify_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '更新者',
  `modify_date` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `version` int NOT NULL COMMENT '乐观锁',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '菜单权限表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, '系统管理', 0, 0, '#', 'MODEL', 'NORMAL', 'modal:system', 'layui-icon-tabs', '1', '2020-01-01 15:15:34', '1', '2020-04-21 16:38:37', 2, '系统模块');
INSERT INTO `sys_menu` VALUES (2, '系统概览', 1, 1, '#', 'MENU', 'NORMAL', 'menus:dashboard', 'layui-icon-auz', '1', '2020-01-01 15:15:34', '1', '2020-02-10 10:42:15', 2, '系统概览');
INSERT INTO `sys_menu` VALUES (3, '基本信息', 2, 1, '/doc.html', 'MENU', 'NORMAL', 'menus:control', 'layui-icon-theme', 'admin', '2020-01-01 15:15:34', '1', '2021-04-29 02:14:37', 3, '基本信息');
INSERT INTO `sys_menu` VALUES (4, '用户权限', 1, 2, '#', 'MENU', 'NORMAL', 'menus:manager', 'layui-icon-username', '1', '2020-01-01 15:15:34', '1', '2020-02-10 10:41:48', 2, '用户权限');
INSERT INTO `sys_menu` VALUES (5, '菜单管理', 4, 1, '/system/menu', 'MENU', 'NORMAL', 'menus:menus', 'layui-icon-app', '1', '2020-01-01 15:15:34', '1', '2020-02-10 10:41:21', 2, '菜单管理');
INSERT INTO `sys_menu` VALUES (7, '用户管理', 4, 2, '/user/', 'MENU', 'NORMAL', 'menus:user', 'layui-icon-username', '1', '2020-01-11 22:34:09', '1', '2020-02-10 10:43:23', 2, '用户管理');
INSERT INTO `sys_menu` VALUES (9, '新增菜单', 5, 1, '/system/menus/add', 'BUTTON', 'NORMAL', 'menus:menus:add', 'layui-icon-star-fill', 'admin', '2020-01-21 10:59:23', '1', '2021-04-28 14:09:33', 1, '新增菜单');
INSERT INTO `sys_menu` VALUES (10, '修改菜单', 5, 2, '/system/menus/edit', 'BUTTON', 'NORMAL', 'menus:menus:edit', 'layui-icon-star-fill', 'admin', '2020-01-21 11:01:02', '1', '2021-04-28 14:09:51', 2, '修改菜单');
INSERT INTO `sys_menu` VALUES (11, '删除菜单', 5, 3, '/system/menus/del', 'BUTTON', 'NORMAL', 'menus:menus:del', 'layui-icon-star-fill', 'admin', '2020-01-21 11:02:59', '1', '2021-04-28 14:10:07', 1, '删除菜单');
INSERT INTO `sys_menu` VALUES (12, '角色管理', 4, 3, '/role/', 'MENU', 'NORMAL', 'menus:role:list', 'layui-icon-user', '1', '2020-02-10 10:39:44', '1', '2020-04-04 15:38:00', 2, '角色管理');
INSERT INTO `sys_menu` VALUES (13, '部门管理', 4, 3, '/dept/', 'MENU', 'NORMAL', 'menus:dept:list', 'layui-icon-dialogue', '1', '2020-04-18 14:58:47', '1', '2020-04-18 14:59:14', 1, NULL);
INSERT INTO `sys_menu` VALUES (14, '系统监控', 1, 3, '#', 'MENU', 'NORMAL', 'menu:monitor', 'layui-icon-layouts', 'admin', '2020-04-21 16:30:34', '1', '2021-04-28 14:08:22', 6, '');
INSERT INTO `sys_menu` VALUES (15, '数据库监控', 14, 0, '/druid/index.html', 'MENU', 'NORMAL', 'menus:druid', 'layui-icon-tabs', '1', '2020-04-21 16:37:21', '1', '2020-04-25 22:12:20', 8, '');
INSERT INTO `sys_menu` VALUES (17, '在线日志', 14, 2, '#', 'MENU', 'NORMAL', 'menu:logger:line', 'layui-icon-chart-screen', 'admin', '2020-05-03 12:04:24', '1', '2021-04-28 14:08:29', 1, '');
INSERT INTO `sys_menu` VALUES (18, '日志管理', 14, 3, '/log/sys', 'MENU', 'NORMAL', '', 'layui-icon-template-1', '1', '2020-06-03 15:11:14', '1', '2020-06-03 15:11:14', 0, '');
INSERT INTO `sys_menu` VALUES (19, '内容管理', 0, 1, '#', 'MODEL', 'NORMAL', 'modal:cms', 'layui-icon-star-fill', 'admin', '2021-02-23 03:21:47', NULL, '2021-02-23 03:21:47', 0, NULL);
INSERT INTO `sys_menu` VALUES (20, '文件管理', 19, 1, '#', 'MENU', 'NORMAL', 'menus:file', 'layui-icon-star-fill', 'admin', '2021-02-23 03:22:43', NULL, '2021-02-23 03:22:43', 0, NULL);
INSERT INTO `sys_menu` VALUES (21, '文件管理', 20, 1, '/cms/fileDir', 'MENU', 'NORMAL', 'menu:file:manage', 'layui-icon-star-fill', 'admin', '2021-02-23 03:23:55', NULL, '2021-02-23 03:23:55', 0, NULL);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` int NOT NULL COMMENT '主键',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名字',
  `role_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '前缀',
  `orders` int NOT NULL COMMENT '排序',
  `dept` int NOT NULL COMMENT '所属机构',
  `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '数据范围（0，未设置，1，本部门，2，本部门及以下，3，本人，4，本人）',
  `system` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '是否系统角色',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '状态 0关闭 1开启',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `modify_date` datetime NOT NULL COMMENT '更新时间',
  `modify_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '更新者',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '创建者',
  `version` int NOT NULL COMMENT '乐观锁',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of sys_role
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`  (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `dept_id` bigint NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`, `dept_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '角色和部门关联表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '角色和菜单关联表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码盐',
  `account` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账号',
  `password` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头像',
  `birthday` datetime NULL DEFAULT NULL COMMENT '生日',
  `sex` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别（1：男 2：女）',
  `email` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件',
  `phone` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `dept_id` int NULL DEFAULT NULL COMMENT '部门id',
  `is_enable` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态(1：启用  2：冻结 )',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `modify_date` datetime NOT NULL COMMENT '更新时间',
  `version` int NOT NULL COMMENT '保留字段',
  `login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录IP',
  `login_date` datetime NULL DEFAULT NULL COMMENT '登陆时间',
  `user_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型（0系统用户，1常规后台用户，2，前台用户）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, '@#$DSWW!@', 'admin', 'YzAyNDAwNzZjY2I0NTRkOTkwNTVkMjM0ZjA4ZTBmYTg=', '李超', '', '2020-10-12 11:07:46', 'MAN', '[email protected]', '13022779066', 1, 'YES', '2020-10-12 11:08:15', '2020-10-12 11:08:18', 0, '127.0.0.1', '2020-10-12 11:08:55', 'ADMIN');

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '用户和角色关联表' ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;