/*
|
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;
|
