/*
 Navicat Premium Data Transfer

 Source Server         : ECS(主节点)
 Source Server Type    : MySQL
 Source Server Version : 50736 (5.7.36)
 Source Host           : 47.99.161.255:33306
 Source Schema         : sean-security

 Target Server Type    : MySQL
 Target Server Version : 50736 (5.7.36)
 File Encoding         : 65001

 Date: 13/02/2023 09:05:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_data_dict
-- ----------------------------
DROP TABLE IF EXISTS `t_data_dict`;
CREATE TABLE `t_data_dict`  (
  `id` bigint(20) NOT NULL,
  `dict_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '字典编码',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '字典值编码',
  `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '字典名称',
  `parent_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '父节点ID',
  `parent_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '父级编码',
  `sort_number` int(11) NULL DEFAULT 0 COMMENT '排序',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '状态 0-启用 1-禁用',
  `dict_remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '描述',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `UK_CODE_IDX`(`dict_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '数据字典表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_data_dict
-- ----------------------------
INSERT INTO `t_data_dict` VALUES (18944617923743744, 'post_status', NULL, '岗位可用状态', 0, NULL, 1, '0', '岗位管理', 'system', '2022-12-30 22:23:46', 'system', '2022-12-30 22:23:46');
INSERT INTO `t_data_dict` VALUES (18944677797433344, 'post_status_0', '0', '正常', 18944617923743744, 'post_status', 2, '0', NULL, 'system', '2022-12-30 22:24:00', 'system', '2022-12-30 22:24:14');
INSERT INTO `t_data_dict` VALUES (18944719702724608, 'post_status_1', '1', '禁用', 18944617923743744, 'post_status', 1, '0', NULL, 'system', '2022-12-30 22:24:10', 'system', '2022-12-30 22:24:10');
INSERT INTO `t_data_dict` VALUES (19281439866490880, 'dept_status', NULL, '部门可用状态', 0, NULL, 1, '0', '部门管理', 'system', '2022-12-31 20:42:11', 'system', '2022-12-31 20:42:11');
INSERT INTO `t_data_dict` VALUES (19281581860458496, 'dept_status_0', '0', '正常', 19281439866490880, 'dept_status', 1, '0', NULL, 'system', '2022-12-31 20:42:44', 'system', '2022-12-31 20:42:44');
INSERT INTO `t_data_dict` VALUES (19281642593980416, 'dept_status_1', '1', '禁用', 19281439866490880, 'dept_status', 2, '0', NULL, 'system', '2022-12-31 20:42:59', 'system', '2022-12-31 20:42:59');
INSERT INTO `t_data_dict` VALUES (19984051284742144, 'menu_type', NULL, '菜单类型', 0, NULL, 3, '0', '菜单管理', 'system', '2023-01-02 19:14:06', 'system', '2023-01-02 19:14:30');
INSERT INTO `t_data_dict` VALUES (19984271288569856, 'menu_type_0', '0', '菜单', 19984051284742144, 'menu_type', 1, '0', NULL, 'system', '2023-01-02 19:14:59', 'system', '2023-01-02 19:14:59');
INSERT INTO `t_data_dict` VALUES (19984348593786880, 'menu_type_1', '1', '方法', 19984051284742144, 'menu_type', 2, '0', NULL, 'system', '2023-01-02 19:15:17', 'system', '2023-01-02 19:15:17');
INSERT INTO `t_data_dict` VALUES (19984428499472384, 'menu_type_2', '2', '按钮', 19984051284742144, 'menu_type', 3, '0', NULL, 'system', '2023-01-02 19:15:36', 'system', '2023-01-02 19:15:36');
INSERT INTO `t_data_dict` VALUES (19984985524015104, 'menu_visible', NULL, '菜单隐藏', 0, NULL, 4, '0', '菜单管理', 'system', '2023-01-02 19:17:49', 'system', '2023-01-02 19:17:49');
INSERT INTO `t_data_dict` VALUES (19985105070067712, 'menu_visible_0', '0', '显示', 19984985524015104, 'menu_visible', 1, '0', NULL, 'system', '2023-01-02 19:18:17', 'system', '2023-01-02 19:18:17');
INSERT INTO `t_data_dict` VALUES (19985159948341248, 'menu_visible_1', '1', '隐藏', 19984985524015104, 'menu_visible', 2, '0', NULL, 'system', '2023-01-02 19:18:31', 'system', '2023-01-02 19:18:31');
INSERT INTO `t_data_dict` VALUES (19985317591257088, 'menu_status', NULL, '菜单可用状态', 0, NULL, 6, '0', '菜单管理', 'system', '2023-01-02 19:19:08', 'system', '2023-01-02 19:19:08');
INSERT INTO `t_data_dict` VALUES (19985908115705856, 'menu_status_0', '0', '正常', 19985317591257088, 'menu_status', 1, '0', NULL, 'system', '2023-01-02 19:21:29', 'system', '2023-01-02 19:21:29');
INSERT INTO `t_data_dict` VALUES (19985969583230976, 'menu_status_1', '1', '停用', 19985317591257088, 'menu_status', 2, '0', NULL, 'system', '2023-01-02 19:21:44', 'system', '2023-01-02 19:21:44');
INSERT INTO `t_data_dict` VALUES (20208344899784704, 'role_statue', NULL, '角色可用状态', 0, NULL, 7, '0', '角色管理', 'system', '2023-01-03 10:05:22', 'system', '2023-01-03 10:05:41');
INSERT INTO `t_data_dict` VALUES (20208482649116672, 'role_statue_0', '0', '正常', 20208344899784704, 'role_statue', 1, '0', NULL, 'system', '2023-01-03 10:05:55', 'system', '2023-01-03 10:05:55');
INSERT INTO `t_data_dict` VALUES (20208527029047296, 'role_statue_1', '1', '禁用', 20208344899784704, 'role_statue', 2, '0', NULL, 'system', '2023-01-03 10:06:05', 'system', '2023-01-03 10:06:05');
INSERT INTO `t_data_dict` VALUES (23194384010842112, 'menu_method', NULL, '菜单请求方式', 0, NULL, 11, '0', '菜单管理', 'system', '2023-01-11 15:50:49', 'system', '2023-01-11 15:50:59');
INSERT INTO `t_data_dict` VALUES (23195097621336064, 'menu_method_0', '0', 'GET', 23194384010842112, 'menu_method', 1, '0', NULL, 'system', '2023-01-11 15:53:39', 'system', '2023-01-11 15:53:39');
INSERT INTO `t_data_dict` VALUES (23195242744254464, 'menu_method_1', '1', 'POST', 23194384010842112, 'menu_method', 2, '0', NULL, 'system', '2023-01-11 15:54:14', 'system', '2023-01-11 15:54:14');
INSERT INTO `t_data_dict` VALUES (23195298385891328, 'menu_method_2', '2', 'PUT', 23194384010842112, 'menu_method', 3, '0', NULL, 'system', '2023-01-11 15:54:27', 'system', '2023-01-11 15:54:27');
INSERT INTO `t_data_dict` VALUES (23195358574153728, 'menu_method_3', '3', 'DELETE', 23194384010842112, 'menu_method', 4, '0', NULL, 'system', '2023-01-11 15:54:42', 'system', '2023-01-11 15:54:42');
INSERT INTO `t_data_dict` VALUES (23548252016087040, 'role_status', NULL, '角色状态', 0, NULL, 8, '0', '角色管理', 'system', '2023-01-12 15:16:58', 'system', '2023-01-12 15:16:58');
INSERT INTO `t_data_dict` VALUES (23548299885678592, 'role_status_0', '0', '正常', 23548252016087040, 'role_status', 1, '0', NULL, 'system', '2023-01-12 15:17:09', 'system', '2023-01-12 15:17:09');
INSERT INTO `t_data_dict` VALUES (23548339274387456, 'role_status_1', '1', '禁用', 23548252016087040, 'role_status', 2, '0', NULL, 'system', '2023-01-12 15:17:19', 'system', '2023-01-12 15:17:19');
INSERT INTO `t_data_dict` VALUES (23928243803394048, 'user_status', NULL, '用户状态', 0, NULL, 9, '0', '用户管理', 'system', '2023-01-13 16:26:55', 'system', '2023-01-13 16:26:55');
INSERT INTO `t_data_dict` VALUES (23928308366315520, 'user_status_0', '0', '正常', 23928243803394048, 'user_status', 1, '0', NULL, 'system', '2023-01-13 16:27:10', 'system', '2023-01-13 16:27:10');
INSERT INTO `t_data_dict` VALUES (23928343170650112, 'user_status_1', '1', '禁用', 23928243803394048, 'user_status', 2, '0', NULL, 'system', '2023-01-13 16:27:19', 'system', '2023-01-13 16:27:19');
INSERT INTO `t_data_dict` VALUES (25829660789051392, 'user_sex', NULL, '用户性别', 0, NULL, 10, '0', '用户管理', 'system', '2023-01-18 22:22:28', 'system', '2023-01-18 22:22:28');
INSERT INTO `t_data_dict` VALUES (25829706452439040, 'user_sex_0', '0', '男', 25829660789051392, 'user_sex', 1, '0', NULL, 'system', '2023-01-18 22:22:39', 'system', '2023-01-18 22:22:39');
INSERT INTO `t_data_dict` VALUES (25829751008530432, 'user_sex_1', '1', '女', 25829660789051392, 'user_sex', 2, '0', NULL, 'system', '2023-01-18 22:22:50', 'system', '2023-01-18 22:22:50');

-- ----------------------------
-- Table structure for t_dept
-- ----------------------------
DROP TABLE IF EXISTS `t_dept`;
CREATE TABLE `t_dept`  (
  `id` bigint(20) NOT NULL COMMENT '部门id',
  `parent_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '父部门id',
  `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '部门名称',
  `order_num` int(4) NOT NULL DEFAULT 0 COMMENT '显示顺序',
  `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '邮箱',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除标志（0代表正常 1代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '部门表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_dept
-- ----------------------------
INSERT INTO `t_dept` VALUES (1, 0, '肖恩科技', 1, '张三', '12345678', '1234578', '0', '0', '', '2022-12-31 20:40:44', 'system', '2023-01-10 23:38:26');
INSERT INTO `t_dept` VALUES (2, 1, '人事部门', 4, '李四', '12323123', '3123123', '0', '0', '', '2022-12-31 20:41:14', 'system', '2023-01-01 21:36:59');
INSERT INTO `t_dept` VALUES (19647908756328448, 1, '开发部门', 3, '张三', '123456', NULL, '0', '0', 'system', '2023-01-01 20:58:24', 'system', '2023-01-10 23:53:53');
INSERT INTO `t_dept` VALUES (19654771275206656, 19647908756328448, '研发A部', 9, '王五', '1772937132', '123456@qq.com', '0', '0', 'system', '2023-01-01 21:25:40', 'system', '2023-01-01 21:27:37');
INSERT INTO `t_dept` VALUES (19655494259970048, 19647908756328448, '研发B组', 1, '赵六', NULL, NULL, '0', '0', 'system', '2023-01-01 21:28:32', 'system', '2023-01-01 21:28:32');
INSERT INTO `t_dept` VALUES (19656087489744896, 1, '财务部门', 2, NULL, NULL, NULL, '0', '0', 'system', '2023-01-01 21:30:54', 'system', '2023-01-01 21:37:11');
INSERT INTO `t_dept` VALUES (19656565552320512, 1, '保卫部门', 5, NULL, NULL, NULL, '0', '0', 'system', '2023-01-01 21:32:48', 'system', '2023-01-01 21:36:53');
INSERT INTO `t_dept` VALUES (19656682846031872, 1, '测试部门', 6, NULL, NULL, NULL, '0', '0', 'system', '2023-01-01 21:33:16', 'system', '2023-01-01 21:33:16');
INSERT INTO `t_dept` VALUES (19656742761664512, 1, '销售部门', 7, NULL, NULL, NULL, '0', '1', 'system', '2023-01-01 21:33:30', 'system', '2023-01-01 21:56:16');

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu`  (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父菜单ID',
  `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '路由地址',
  `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '重定向地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '组件路径',
  `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '菜单类型（0菜单 1方法 2按钮）',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perm_code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '菜单图标',
  `method` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '请求方式（0：GET,1: POST,2: PUT,3: DELETE）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34555998089777153 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
INSERT INTO `t_menu` VALUES (23222708070256640, '系统管理', 0, 1, '/pages', '/pages/user', 'Layout', '0', '0', '0', NULL, 'el-icon-menu', NULL, 'system', '2023-01-11 17:43:22', 'system', '2023-02-11 05:39:22', '');
INSERT INTO `t_menu` VALUES (23223389464301568, '数据字典', 23222708070256640, 1, 'dictType', NULL, 'pages/dict/dictType/index', '0', '0', '0', NULL, 'el-icon-notebook-1', NULL, 'system', '2023-01-11 17:46:05', 'system', '2023-01-11 17:46:05', '');
INSERT INTO `t_menu` VALUES (23223988901646336, '字典数据', 23222708070256640, 1, 'dictValue', NULL, 'pages/dict/dictValue/index', '0', '1', '0', NULL, '', NULL, 'system', '2023-01-11 17:48:28', 'system', '2023-02-11 05:16:25', '');
INSERT INTO `t_menu` VALUES (23224396478943232, '岗位管理', 23222708070256640, 0, 'post', NULL, 'pages/post/index', '0', '0', '0', NULL, 'el-icon-help', NULL, 'system', '2023-01-11 17:50:05', 'system', '2023-01-11 17:50:05', '');
INSERT INTO `t_menu` VALUES (23224672791302144, '部门管理', 23222708070256640, 4, 'dept', NULL, 'pages/dept/index', '0', '0', '0', NULL, 'el-icon-collection', NULL, 'system', '2023-01-11 17:51:11', 'system', '2023-01-11 18:20:14', '');
INSERT INTO `t_menu` VALUES (23224989616443392, '菜单管理', 23222708070256640, 3, 'menu', NULL, 'pages/menu/index', '0', '0', '0', NULL, 'el-icon-s-grid', NULL, 'system', '2023-01-11 17:52:26', 'system', '2023-01-11 17:52:26', '');
INSERT INTO `t_menu` VALUES (23225383285428224, '角色管理', 23222708070256640, 5, 'role', NULL, 'pages/role/index', '0', '0', '0', NULL, 'el-icon-s-management', NULL, 'system', '2023-01-11 17:54:00', 'system', '2023-01-11 17:54:00', '');
INSERT INTO `t_menu` VALUES (23225570112311296, '用户管理', 23222708070256640, 6, 'user', NULL, 'pages/user/index', '0', '0', '0', NULL, 'el-icon-s-custom', NULL, 'system', '2023-01-11 17:54:45', 'system', '2023-01-11 17:54:45', '');
INSERT INTO `t_menu` VALUES (23924225525944320, '公共方法', 0, 1, '/', NULL, NULL, '1', '0', '0', 'commond', '', '0', 'system', '2023-01-13 16:10:57', 'system', '2023-01-13 16:10:57', '');
INSERT INTO `t_menu` VALUES (34552407719415808, '用户列表', 23225570112311296, 0, '/user/page', NULL, NULL, '1', '0', '0', 'user:page', '', '0', 'system', '2023-02-12 00:03:33', 'system', '2023-02-12 00:03:33', '');
INSERT INTO `t_menu` VALUES (34553424892661760, '分配用户', 23222708070256640, 0, 'ruser', NULL, 'pages/role/roleUser', '0', '1', '0', NULL, '', NULL, 'system', '2023-02-12 00:07:36', 'system', '2023-02-12 00:07:36', '');
INSERT INTO `t_menu` VALUES (34555998089777152, '编辑用户', 23225570112311296, 0, '/user/edit', NULL, NULL, '2', '0', '0', 'user:edit', '', '2', 'system', '2023-02-12 00:17:49', 'system', '2023-02-12 00:17:49', '');

-- ----------------------------
-- Table structure for t_post
-- ----------------------------
DROP TABLE IF EXISTS `t_post`;
CREATE TABLE `t_post`  (
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '岗位编码',
  `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '岗位名称',
  `post_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '岗位信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_post
-- ----------------------------
INSERT INTO `t_post` VALUES (19230529962381312, '0', '总经理', 10, '0', 'system', '2022-12-31 17:19:53', 'system', '2022-12-31 20:35:21', NULL);
INSERT INTO `t_post` VALUES (19232322096205824, '1', '人事主管', 9, '0', 'system', '2022-12-31 17:27:00', 'system', '2022-12-31 20:35:28', NULL);
INSERT INTO `t_post` VALUES (19232404774326272, '2', '财务主管', 1, '0', 'system', '2022-12-31 17:27:20', 'system', '2022-12-31 17:27:20', NULL);
INSERT INTO `t_post` VALUES (19232504670064640, '4', '研发主管', 4, '0', 'system', '2022-12-31 17:27:44', 'system', '2022-12-31 17:27:44', NULL);
INSERT INTO `t_post` VALUES (19232566854815744, '5', '产品经理', 5, '0', 'system', '2022-12-31 17:27:58', 'system', '2022-12-31 20:34:53', NULL);
INSERT INTO `t_post` VALUES (19232644491382784, '6', '后端开发', 7, '0', 'system', '2022-12-31 17:28:17', 'system', '2022-12-31 20:34:58', NULL);
INSERT INTO `t_post` VALUES (19232697431887872, '7', '前端开发', 8, '0', 'system', '2022-12-31 17:28:30', 'system', '2022-12-31 20:35:13', NULL);
INSERT INTO `t_post` VALUES (19232850528178176, '8', '运维人员', 3, '0', 'system', '2022-12-31 17:29:06', 'system', '2022-12-31 20:34:49', NULL);
INSERT INTO `t_post` VALUES (19232899135967232, '9', '测试人员', 6, '0', 'system', '2022-12-31 17:29:18', 'system', '2022-12-31 20:35:02', NULL);
INSERT INTO `t_post` VALUES (19233229668093952, '11', '大数据人员', 2, '0', 'system', '2022-12-31 17:30:36', 'system', '2022-12-31 20:34:44', NULL);

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role`  (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '角色状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '角色信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES (0, '超级管理员', 0, '0', 'system', '2023-01-12 16:19:03', 'system', '2023-01-12 16:19:03', NULL);
INSERT INTO `t_role` VALUES (23571642324094976, '管理员', 1, '0', 'system', '2023-01-12 16:49:55', 'system', '2023-01-12 16:49:55', NULL);

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu`  (
  `role_id` bigint(20) NOT NULL,
  `menu_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
INSERT INTO `t_role_menu` VALUES (0, 23222708070256640);
INSERT INTO `t_role_menu` VALUES (0, 23223389464301568);
INSERT INTO `t_role_menu` VALUES (0, 23223988901646336);
INSERT INTO `t_role_menu` VALUES (0, 23224396478943232);
INSERT INTO `t_role_menu` VALUES (0, 23224672791302144);
INSERT INTO `t_role_menu` VALUES (0, 23224989616443392);
INSERT INTO `t_role_menu` VALUES (0, 23225383285428224);
INSERT INTO `t_role_menu` VALUES (0, 23225570112311296);
INSERT INTO `t_role_menu` VALUES (0, 23924225525944320);
INSERT INTO `t_role_menu` VALUES (0, 34552407719415808);
INSERT INTO `t_role_menu` VALUES (0, 34553424892661760);
INSERT INTO `t_role_menu` VALUES (0, 34555998089777152);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23222708070256640);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23223389464301568);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23223988901646336);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23224396478943232);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23224672791302144);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23224989616443392);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23225383285428224);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23225570112311296);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 23924225525944320);
INSERT INTO `t_role_menu` VALUES (23571642324094976, 34552407719415808);

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户账号',
  `nick_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户昵称',
  `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '用户邮箱',
  `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '手机号码',
  `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '0' COMMENT '用户性别（0男 1女）',
  `avatar` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '头像地址',
  `password` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '密码',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `key_idx_username`(`username`) USING BTREE COMMENT '账号唯一'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (0, NULL, 'admin', '超级管理员', '', '', '0', '', 'p8LPhb+pcmvnwobJqKb/kczAwrB02cRcqWJEItTWZgD4kkcGAg2YRHo0w7rvqhkpWPraMyqubbUMQiqoOpWn+g==', '0', '0', 'system', '2023-01-31 13:43:50', 'system', '2023-01-31 13:45:28', '');
INSERT INTO `t_user` VALUES (30087680905711616, 1, 'lisi', '李四', '', '', '0', '', 'VBL+V2wWEYIEkVzOR3TA/i26aE9JpD+edxG8lhpNWRYgTi/X37CQQlfOVQ3CNjuUj4m8CpRKrnyg+PICfKQ5A7E17QaXikY650AsI/vtaq1FO6MzdDhAB7jujS4ORa+7APtH3AjAHy665VGtop9IrYbnXEgZOn2tYfb9hvSumoA=', '0', '0', 'system', '2023-01-30 16:22:19', 'system', '2023-02-03 18:02:36', '');

-- ----------------------------
-- Table structure for t_user_post
-- ----------------------------
DROP TABLE IF EXISTS `t_user_post`;
CREATE TABLE `t_user_post`  (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `post_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`, `post_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user_post
-- ----------------------------
INSERT INTO `t_user_post` VALUES (30074838458568704, 19230529962381312);

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

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES (0, 23571642324094976);
INSERT INTO `t_user_role` VALUES (30087680905711616, 23571642324094976);

SET FOREIGN_KEY_CHECKS = 1;