代码拉取完成,页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : 192.168.47.128
Source Server Type : MySQL
Source Server Version : 80027
Source Host : 192.168.47.128:3306
Source Schema : permission-serve
Target Server Type : MySQL
Target Server Version : 80027
File Encoding : 65001
Date: 02/08/2022 16:51:46
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`login_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号',
`creator_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录IP',
`creator_address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录地址',
`browser` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录浏览器',
`operating_system` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录操作系统',
`status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录状态(1:成功,2:失败)',
`message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作信息',
`create_time` datetime NULL DEFAULT NULL COMMENT '登录日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '登录日志表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称',
`parent_id` int NULL DEFAULT NULL COMMENT '父菜单ID',
`order_num` int NULL DEFAULT 0 COMMENT '显示顺序',
`path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由地址',
`menu_type` int NULL DEFAULT NULL COMMENT '菜单类型(1-目录, 2-菜单,3-按钮,4-按钮)',
`menu_status` int NULL DEFAULT 0 COMMENT '菜单状态(0-启用,1-停用)',
`icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
`perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识',
`upd_cnt` int NULL DEFAULT 0 COMMENT '更新次数',
`del_flg` int NULL DEFAULT 0 COMMENT '删除区分(0-未删除,1-已删除)',
`creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`creator_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人IP地址',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
`updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
`update_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人IP地址',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, '首页', 0, 0, '/', 1, 0, 'home', NULL, 0, 0, 'admin', NULL, '2021-10-15 14:16:48', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (2, '系统管理', 0, 1, '/system', 1, 0, 'system-management', NULL, 0, 0, 'admin', NULL, '2021-10-15 16:43:02', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (3, '用户管理', 2, 3, '/system/user', 2, 0, 'user-management', NULL, 0, 0, 'admin', NULL, '2021-10-15 16:45:49', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (4, '角色管理', 2, 4, '/system/role', 2, 0, 'role-management', NULL, 0, 0, 'admin', NULL, '2021-10-15 16:46:48', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (5, '菜单管理', 2, 5, '/system/menu', 2, 0, 'menu-management', NULL, 0, 0, 'admin', NULL, '2021-10-15 16:47:29', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (6, '分页查询用户信息接口', 3, 31, '/api/user/queryUser', 4, 0, NULL, 'queryUser', 0, 0, 'admin', NULL, '2021-11-18 13:29:44', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (7, '删除用户接口', 3, 32, '/api/user/delUser', 4, 0, NULL, 'delUser', 0, 0, 'admin', NULL, '2021-11-18 13:32:08', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (8, '冻结账号接口', 3, 33, '/api/user/frozenAccount', 4, 0, NULL, 'frozenAccount', 0, 0, 'admin', NULL, '2021-11-18 13:34:30', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (9, '解冻账号接口', 3, 34, '/api/user/thawAccount', 4, 0, NULL, 'thawAccount', 0, 0, 'admin', NULL, '2021-11-18 13:36:06', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (10, '完善用户信息接口', 3, 35, '/api/userInfo/insertUserInfo', 4, 0, NULL, 'insertUserInfo', 0, 0, 'admin', NULL, '2021-11-18 13:36:29', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (11, '常用工具', 0, 3, '/tool', 1, 0, 'tool', NULL, 0, 0, 'admin', NULL, '2021-12-13 15:05:33', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (12, 'SVG图标', 11, 1, '/tool/icon', 2, 0, 'example', NULL, 0, 0, 'admin', NULL, '2021-12-10 16:38:56', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (13, '富文本编辑器', 11, 2, '/tool/tinymce', 2, 0, 'text-editor', NULL, 0, 0, 'admin', NULL, '2021-12-13 15:11:31', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (14, '日志管理', 0, 4, '/systemlog/login-log', 1, 0, 'logs-management', NULL, 0, 0, 'admin', NULL, '2021-12-29 17:14:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (15, '登录日志', 14, 1, '/systemlog/login-log', 2, 0, 'login-log', NULL, 0, 0, 'admin', NULL, '2021-12-29 17:16:53', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (16, '操作日志', 14, 2, '/systemlog/system-log', 2, 0, 'operation-log', NULL, 0, 0, 'admin', NULL, '2021-12-29 17:17:29', 'admin', NULL, '2021-12-29 21:46:44');
INSERT INTO `sys_menu` VALUES (17, '地图管理', 0, 2, '/echart/index', 1, 0, 'map-management', NULL, 0, 0, 'admin', NULL, '2022-07-25 10:44:54', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (18, '中国地图', 17, 1, '/echart/map', 2, 0, 'china-map', NULL, 0, 0, 'admin', NULL, '2022-07-25 10:48:13', NULL, NULL, '2022-08-02 16:41:20');
INSERT INTO `sys_menu` VALUES (19, '分页查询角色接口', 4, 1, '/api/role/queryRole', 4, 0, '', 'queryRole', 0, 0, 'admin', NULL, '2022-08-02 14:37:42', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (20, '新增角色接口', 4, 2, '/api/role/insertRole', 4, 0, NULL, 'insertRole', 0, 0, 'admin', NULL, '2022-08-02 14:38:30', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (21, '删除角色接口', 4, 3, '/api/role/delRole', 4, 0, NULL, 'delRole', 0, 0, 'admin', NULL, '2022-08-02 14:39:22', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (22, '编辑角色接口', 4, 4, '/api/role/updateRole', 4, 0, '', 'updateRole', 0, 0, 'admin', NULL, '2022-08-02 14:41:00', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (23, '分配权限接口', 4, 5, '/api/role/addPermissions', 4, 0, NULL, 'addPermissions', 0, 0, 'admin', NULL, '2022-08-02 14:48:03', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (24, '修改密码接口', 3, 1, '/api/userInfo/updatePwd', 4, 0, NULL, 'updatePwd', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (25, '设置角色接口', 4, 5, '/api/userInfo/setRole', 4, 0, NULL, 'setRole', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (26, '新增菜单接口', 5, 1, '/api/menu/insertMenu', 4, 0, '', 'insertMenu', 0, 0, 'test', NULL, '2022-08-02 15:37:08', NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (27, '查询菜单接口', 5, 3, '/api/menu/selectMenu', 4, 0, '', 'selectMenu', 0, 0, 'admin', NULL, '2022-08-02 15:40:02', NULL, NULL, '2022-08-02 16:21:48');
INSERT INTO `sys_menu` VALUES (28, '编辑菜单接口', 5, 2, '/api/menu/updatetMenu', 4, 0, '', 'updatetMenu', 0, 0, 'admin', NULL, '2022-08-02 16:18:05', NULL, NULL, NULL);
-- ----------------------------
-- Table structure for sys_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_log`;
CREATE TABLE `sys_operation_log` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`system_module` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '系统模块',
`request_api` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求API接口',
`request_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求方式',
`request_parame` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求参数',
`request_token` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求token',
`res_code` int NULL DEFAULT NULL COMMENT '返回的状态码',
`res_msg` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '返回的信息描述',
`res_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '返回的参数',
`start_time` datetime NULL DEFAULT NULL COMMENT '请求开始时间',
`end_time` datetime NULL DEFAULT NULL COMMENT '请求结束时间',
`cost_time` bigint NULL DEFAULT NULL COMMENT '请求结束时间',
`creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人',
`creator_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人IP',
`creator_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作人地址',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '操作记录表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`role_nm` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
`role_sort` int NULL DEFAULT NULL COMMENT '显示顺序',
`role_status` int NULL DEFAULT 0 COMMENT '角色状态(0-启用,1-停用)',
`upd_cnt` int NULL DEFAULT 0 COMMENT '更新次数',
`del_flg` int NULL DEFAULT 0 COMMENT '删除区分(0-未删除,1-已删除)',
`creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`creator_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人IP地址',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
`updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
`update_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人IP地址',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '管理员', 1, 0, 0, 0, NULL, NULL, '2021-10-15 09:59:39', 'admin', NULL, '2022-08-02 15:58:09');
INSERT INTO `sys_role` VALUES (2, '普通用户', 2, 0, 0, 0, 'admin', NULL, '2021-10-15 10:17:50', 'admin', NULL, '2022-08-02 15:58:12');
INSERT INTO `sys_role` VALUES (3, '测试人员', 3, 0, 0, 0, 'admin', NULL, '2022-08-02 15:46:02', 'admin', NULL, '2022-08-02 15:57:46');
-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
`role_id` int NOT NULL COMMENT '角色Id',
`permission_id` int NOT NULL COMMENT '权限Id',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (1, 1, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 2, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 3, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 22, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 6, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 7, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 8, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 9, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 10, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 4, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 25, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 26, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 27, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 17, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 21, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 28, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 5, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 20, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 18, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 19, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 23, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 24, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 11, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 12, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 13, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 14, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 15, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (1, 16, '2022-08-02 16:18:31');
INSERT INTO `sys_role_menu` VALUES (2, 1, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 3, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 24, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 6, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 10, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 19, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 23, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 18, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 27, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 17, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 11, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 12, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 13, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 2, '2022-08-02 16:41:01');
INSERT INTO `sys_role_menu` VALUES (2, 4, '2022-08-02 16:41:02');
INSERT INTO `sys_role_menu` VALUES (2, 5, '2022-08-02 16:41:02');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`login_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号',
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录密码',
`user_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '用户状态(0-正常,1-冻结)',
`pwd_err_num` int NULL DEFAULT 0 COMMENT '密码输入错误次数(初期为0,登录成功后变为0,密码输入错误后累计,累计5次,该用户将被锁定,密码重置或用户解锁后,变为0)',
`upd_cnt` int NULL DEFAULT 0 COMMENT '更新次数',
`del_flg` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除区分(0-未删除,1-已删除)',
`creator` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`creator_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人IP地址',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
`updater` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
`update_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人IP地址',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', '81dc9bdb52d04dc20036dbd8313ed055', '0', 0, 0, '0', '', '', '2021-10-14 14:23:08', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES (2, 'test', '098f6bcd4621d373cade4e832627b4f6', '0', 0, 0, '0', NULL, NULL, '2022-05-24 17:43:59', 'admin', NULL, '2022-07-25 10:38:32');
-- ----------------------------
-- Table structure for sys_user_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_info`;
CREATE TABLE `sys_user_info` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`login_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '登录账号',
`user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
`user_picture` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像',
`birthday` date NULL DEFAULT NULL COMMENT '生日',
`sex` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别(1:男.2:女)',
`mobile_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
`mailbox` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
`creator` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`creator_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人IP地址',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
`updater` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`update_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人IP地址',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_user_info
-- ----------------------------
INSERT INTO `sys_user_info` VALUES (1, 'admin', '系统管理员', '/static/img/1.jpeg', '2021-10-14', '1', '13299778364', '[email protected]', 'admin', NULL, '2021-10-14 14:21:57', 'admin', NULL, '2022-08-02 15:58:20');
INSERT INTO `sys_user_info` VALUES (2, 'test', '测试人员', '/static/img/2.jpeg', '1991-01-15', '2', '15508906578', '[email protected]', 'admin', NULL, '2022-08-02 15:34:13', 'admin', NULL, '2022-08-02 15:58:28');
-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`user_id` int NOT NULL COMMENT '用户Id',
`role_id` int NOT NULL COMMENT '角色Id',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (1, 1, '2021-11-16 16:14:11');
INSERT INTO `sys_user_role` VALUES (2, 2, '2022-08-02 15:34:26');
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。