/* Navicat MySQL Data Transfer Source Server : 本地 Source Server Type : MySQL Source Server Version : 80022 Source Host : localhost:3306 Source Schema : canadames Target Server Type : MySQL Target Server Version : 80022 File Encoding : 65001 Date: 25/08/2023 09:02:30 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for category -- ---------------------------- DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `parent_id` bigint NULL DEFAULT NULL COMMENT '父级id', `path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径', `level` int NULL DEFAULT NULL COMMENT '等级', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `creator` bigint NULL DEFAULT NULL COMMENT '创建人', `state` tinyint NOT NULL DEFAULT 1 COMMENT '状态：0/下架 1/上架', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品分类' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of category -- ---------------------------- INSERT INTO `category` VALUES (1, NULL, NULL, NULL, '测试分类', 1, 1, '2021-11-28 15:08:32', '2021-11-28 15:08:32'); -- ---------------------------- -- Table structure for menu_list -- ---------------------------- DROP TABLE IF EXISTS `menu_list`; CREATE TABLE `menu_list` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `parent_id` bigint NULL DEFAULT NULL COMMENT '父级id', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标', `priority` int NULL DEFAULT NULL COMMENT '优先级', `router` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由', `state` tinyint NOT NULL DEFAULT 1 COMMENT '状态 1/正常', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of menu_list -- ---------------------------- INSERT INTO `menu_list` VALUES (1, NULL, '用户管理', 'el-icon-user-solid', 1, '', 1, '2021-11-28 14:30:27', '2021-11-28 15:06:04'); INSERT INTO `menu_list` VALUES (2, NULL, '设备管理', 'el-icon-s-flag', 2, '', 1, '2023-08-23 20:11:38', '2023-08-23 20:14:45'); INSERT INTO `menu_list` VALUES (5, NULL, '权限管理', 'el-icon-collection-tag', 5, '', 1, '2021-11-28 14:30:27', '2021-11-28 15:06:04'); INSERT INTO `menu_list` VALUES (6, NULL, '角色管理', 'el-icon-s-flag', 6, '', 1, '2021-11-28 14:30:27', '2021-11-28 15:06:04'); INSERT INTO `menu_list` VALUES (7, 1, '用户列表', '', 7, 'user', 1, '2021-11-28 14:30:27', '2021-11-28 15:06:04'); INSERT INTO `menu_list` VALUES (11, 5, '权限列表', '', 11, 'power', 1, '2021-11-28 14:30:28', '2021-11-28 15:06:04'); INSERT INTO `menu_list` VALUES (12, 6, '角色列表', '', 12, 'role', 1, '2021-11-28 14:30:28', '2021-11-28 15:06:04'); INSERT INTO `menu_list` VALUES (49, 2, '报警信息', '', 49, 'device/alarm', 1, '2021-11-28 14:30:28', '2023-08-24 13:42:47'); INSERT INTO `menu_list` VALUES (50, 2, '下发参数', '', 50, 'device/parameter', 0, '2021-11-28 14:30:28', '2023-08-24 13:45:57'); INSERT INTO `menu_list` VALUES (51, 2, '开关控制', '', 51, 'device/control', 0, '2021-11-28 14:30:28', '2023-08-24 13:46:00'); INSERT INTO `menu_list` VALUES (53, 2, 'I/O状态', NULL, 53, 'device/iostate', 0, '2023-08-24 13:03:52', '2023-08-24 13:46:04'); -- ---------------------------- -- Table structure for permission -- ---------------------------- DROP TABLE IF EXISTS `permission`; CREATE TABLE `permission` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识', `description` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限描述', `state` tinyint NOT NULL DEFAULT 1 COMMENT '状态 1/正常', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of permission -- ---------------------------- INSERT INTO `permission` VALUES (1, 'user:select', '用户查询', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (2, 'user:update', '用户修改', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (3, 'user:delete', '用户删除', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (7, 'role:add', '角色添加', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (8, 'role:update', '角色修改', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (9, 'role:delete', '角色删除', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (10, 'role:select', '角色查询', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (11, 'menuList:delete', '菜单删除', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (12, 'menuList:add', '菜单添加', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (13, 'menuList:update', '菜单修改', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (16, 'rolePermission:add', '授权添加', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (17, 'rolePermission:delete', '授权删除', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (18, 'rolePermission:select', '授权查询', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (19, 'permission:select', '权限查询', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (20, 'user:add', '用户添加', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (22, 'menuList:select', '菜单查询', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (25, 'category:select', '分类查询', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (26, 'category:delete', '分类删除', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (27, 'category:update', '分类修改', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (28, 'category:add', '分类添加', 1, '2021-11-28 15:07:36', '2021-11-28 15:07:36'); INSERT INTO `permission` VALUES (29, 'device:select', '下发参数查询', 1, '2021-11-28 15:07:36', '2023-08-24 08:48:37'); INSERT INTO `permission` VALUES (30, 'device:add', '下发参数添加', 1, '2023-08-24 08:48:53', '2023-08-24 08:49:18'); INSERT INTO `permission` VALUES (31, 'device:update', '下发参数修改', 1, '2023-08-24 08:49:23', '2023-08-24 08:49:44'); -- ---------------------------- -- Table structure for role -- ---------------------------- DROP TABLE IF EXISTS `role`; CREATE TABLE `role` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `parent_id` bigint NULL DEFAULT NULL COMMENT '上级角色', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称', `description` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `state` tinyint NOT NULL DEFAULT 1 COMMENT '状态 1/正常', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of role -- ---------------------------- INSERT INTO `role` VALUES (1, NULL, 'admin', '系统管理员', 1, '2021-01-10 22:49:17', '2021-03-29 15:19:15'); INSERT INTO `role` VALUES (2, 1, 'user', '普通用户', 1, '2021-01-13 00:28:58', '2021-03-29 15:19:15'); INSERT INTO `role` VALUES (5, 1, 'user3', NULL, 1, '2023-08-24 10:02:58', '2023-08-24 10:05:03'); -- ---------------------------- -- Table structure for role_menu_list -- ---------------------------- DROP TABLE IF EXISTS `role_menu_list`; CREATE TABLE `role_menu_list` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `role_id` bigint NULL DEFAULT NULL COMMENT '角色id', `menu_list_id` bigint NULL DEFAULT NULL COMMENT '菜单id', `state` tinyint NULL DEFAULT 1 COMMENT '状态 1/正常', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of role_menu_list -- ---------------------------- INSERT INTO `role_menu_list` VALUES (1, 1, 1, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (2, 1, 2, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (3, 1, 3, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (4, 1, 4, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (5, 1, 5, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (6, 1, 6, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (7, 1, 7, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (8, 1, 8, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (9, 1, 9, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (10, 1, 10, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (11, 1, 11, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (12, 1, 12, 1, '2021-11-28 15:10:03', '2021-11-28 15:10:03'); INSERT INTO `role_menu_list` VALUES (19, 1, 50, 1, '2023-08-24 09:13:00', '2023-08-24 09:13:00'); INSERT INTO `role_menu_list` VALUES (20, 2, 49, 1, '2023-08-24 10:08:38', '2023-08-24 13:20:23'); INSERT INTO `role_menu_list` VALUES (21, 2, 51, 1, '2023-08-24 10:08:56', '2023-08-24 13:20:47'); INSERT INTO `role_menu_list` VALUES (22, 2, 52, 1, '2023-08-24 10:08:56', '2023-08-24 13:20:48'); INSERT INTO `role_menu_list` VALUES (23, 2, 53, 1, '2023-08-24 10:08:56', '2023-08-24 13:20:51'); -- ---------------------------- -- Table structure for role_permission -- ---------------------------- DROP TABLE IF EXISTS `role_permission`; CREATE TABLE `role_permission` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `role_id` bigint NULL DEFAULT NULL COMMENT '角色id', `permission_id` bigint NULL DEFAULT NULL COMMENT '权限id', `state` tinyint NOT NULL DEFAULT 1 COMMENT '状态 1/正常', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of role_permission -- ---------------------------- INSERT INTO `role_permission` VALUES (1, 1, 1, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (2, 1, 2, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (3, 1, 3, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (7, 1, 7, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (8, 1, 8, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (9, 1, 9, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (10, 1, 10, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (11, 1, 11, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (12, 1, 12, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (13, 1, 13, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (16, 1, 16, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (17, 1, 17, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (18, 1, 18, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (19, 1, 19, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (20, 1, 20, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (22, 1, 22, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (25, 1, 25, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (26, 1, 26, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (27, 1, 27, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (28, 1, 28, 1, '2021-11-28 15:07:54', '2021-11-28 15:07:54'); INSERT INTO `role_permission` VALUES (37, 2, 25, 1, '2021-11-28 16:30:57', '2021-11-28 16:31:04'); INSERT INTO `role_permission` VALUES (38, 2, 26, 1, '2021-11-28 16:30:57', '2021-11-28 16:31:04'); INSERT INTO `role_permission` VALUES (39, 2, 27, 1, '2021-11-28 16:30:57', '2021-11-28 16:31:04'); INSERT INTO `role_permission` VALUES (40, 2, 28, 1, '2021-11-28 16:32:35', '2021-11-28 16:37:20'); INSERT INTO `role_permission` VALUES (41, 2, 22, 1, '2021-11-28 19:57:35', '2021-11-28 19:57:35'); INSERT INTO `role_permission` VALUES (42, 1, 30, 1, '2023-08-24 08:55:34', '2023-08-24 08:55:34'); INSERT INTO `role_permission` VALUES (43, 1, 29, 1, '2023-08-24 08:56:15', '2023-08-24 08:56:15'); INSERT INTO `role_permission` VALUES (44, 1, 31, 1, '2023-08-24 08:56:23', '2023-08-24 08:56:23'); INSERT INTO `role_permission` VALUES (45, 2, 29, 1, '2023-08-24 09:59:43', '2023-08-24 09:59:43'); INSERT INTO `role_permission` VALUES (46, 2, 30, 1, '2023-08-24 09:59:54', '2023-08-24 09:59:54'); INSERT INTO `role_permission` VALUES (47, 2, 31, 1, '2023-08-24 10:00:02', '2023-08-24 10:00:02'); INSERT INTO `role_permission` VALUES (48, 5, 1, 1, '2023-08-24 10:03:18', '2023-08-24 10:03:18'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `parent_id` bigint NOT NULL DEFAULT 1 COMMENT '上级id', `path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1-' COMMENT '路径', `level` int NOT NULL DEFAULT 1 COMMENT '等级', `role_id` bigint NOT NULL DEFAULT 2 COMMENT '角色id', `username` 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 '密码', `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'qq号', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式', `state` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0/禁止 1/正常', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (2, 1, '1-', 1, 2, 'user1', '601b99523f82de29f87771d5f95accdc', 'user1@qq.com', NULL, NULL, 1, '2021-11-28 14:31:39', '2021-11-28 15:09:36'); INSERT INTO `user` VALUES (3, 1, '1-', 1, 2, 'user2', 'f403c87893db29eb71b21905b57bbd0d', 'user2@qq.com', NULL, NULL, 1, '2021-11-28 14:31:39', '2021-11-28 15:09:36'); INSERT INTO `user` VALUES (8, 1, '1-', 1, 2, 'yyyyy', '1e150ad1105f2e75ca287425868b9cab', '2265557248@qq.com', NULL, NULL, 1, '2023-08-23 20:08:44', '2023-08-23 20:08:44'); INSERT INTO `user` VALUES (9, 1, '1-', 1, 1, 'yttttttttttt', '3c37d269aab46b73a4ff2a43f5e34702', '666@qq.com', NULL, NULL, 1, '2023-08-23 20:35:32', '2023-08-23 20:35:32'); INSERT INTO `user` VALUES (10, 1, '1-', 1, 2, '767655555', '500637c0d48b442a3be6d4fce12e0910', NULL, NULL, NULL, 1, '2023-08-23 20:42:58', '2023-08-23 20:42:58'); INSERT INTO `user` VALUES (11, 1, '1-', 1, 5, 'uiuyiuy', '601b99523f82de29f87771d5f95accdc', '767676767676@qq.com', NULL, NULL, 1, '2023-08-23 20:43:42', '2023-08-23 20:43:42'); INSERT INTO `user` VALUES (12, 1, '1-', 1, 1, 'iiiii', 'b2f0c414a5ffb6944c424bc18ae3a8a0', NULL, NULL, NULL, 1, '2023-08-24 08:01:00', '2023-08-24 16:50:38'); INSERT INTO `user` VALUES (13, 1, '1-', 1, 2, 'user3', '500637c0d48b442a3be6d4fce12e0910', '2265557345@qq.com', NULL, NULL, 1, '2023-08-24 09:58:40', '2023-08-24 09:58:40'); INSERT INTO `user` VALUES (14, 1, '1-', 1, 1, 'admin', 'b2f0c414a5ffb6944c424bc18ae3a8a0', NULL, NULL, NULL, 1, '2023-08-25 08:58:58', '2023-08-25 09:00:56'); SET FOREIGN_KEY_CHECKS = 1;