/* Navicat Premium Data Transfer Source Server : 飞航科技 Source Server Type : MySQL Source Server Version : 80026 Source Host : 47.97.157.209:3306 Source Schema : app_base Target Server Type : MySQL Target Server Version : 80026 File Encoding : 65001 Date: 19/08/2022 09:06:13 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for system_log -- ---------------------------- DROP TABLE IF EXISTS `system_log`; CREATE TABLE `system_log` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '日志ID', `user_id` bigint(0) NULL DEFAULT NULL COMMENT '用户ID', `user_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户IP', `method` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求类型', `platform` int(0) NOT NULL COMMENT '平台类型 1:管理端 2:小程序端', `uri` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求接口名', `success` tinyint(1) NULL DEFAULT NULL COMMENT '是否请求成功', `time` bigint(0) NULL DEFAULT NULL COMMENT '请求耗时', `request` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数', `response` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '响应结果', `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '异常文件', `line_number` int(0) NULL DEFAULT NULL COMMENT '异常行号', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '请求时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 214 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '[\r\n{\r\n \"name\": \"app-base\",\r\n \"group\": \"系统设置-操作日志管理\",\r\n \"prefix\": \"system\",\r\n \"remarks\": \"操作日志\",\r\n \"version\": \"1.0.0\",\r\n \"ext\": 0,\r\n \"add\": 0,\r\n \"remove\": 1,\r\n \"removes\": 1,\r\n \"update\": 0,\r\n \"query\": 0,\r\n \"queries\": 1\r\n}\r\n]' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_log -- ---------------------------- INSERT INTO `system_log` VALUES (211, NULL, '192.168.4.17', 'POST', 1, '/v1/system/user/login', 1, 1288, '{\"systemUserLoginFrom\":{\"username\":\"super_admin\",\"password\":\"e10adc3949ba59abbe56e057f20f883e\"}}', '{\"data\":{\"id\":1,\"username\":\"super_admin\",\"token\":\"eyJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJ1c2VyX3V1aWQiOjkxMDMwODcxMDMzMTM1MTA0LCJuYmYiOjE2NjA3MjU5MTh9.XVA744XENQmZCD2Piyq2xCdMzrCMaezfzHGlsVdZ7ss\",\"permissions\":[\"主页\",\"更新用户密码\",\"系统设置\",\"权限管理\",\"获取所有权限-树形\",\"启用权限\",\"角色管理\",\"添加角色-角色名称验证\",\"删除角色\",\"查询角色列表\",\"更新角色禁用状态\",\"更新角色名称和权限\",\"查询角色权限列表\",\"用户管理\",\"查询用户信息\",\"分页查询用户列表\",\"删除多个用户\",\"删除用户\",\"更新用户禁用状态\",\"更新用户信息\",\"操作日志管理\",\"删除操作日志\",\"删除多条操作日志\",\"分页查询操作日志\",\"登录日志管理\",\"删除登录日志\",\"删除多条登录日志\",\"分页查询登录日志\",\"文档\",\"接口文档\"]},\"message\":\"\",\"code\":200}', NULL, NULL, '2022-08-17 16:45:19'); INSERT INTO `system_log` VALUES (212, NULL, '192.168.4.17', 'POST', 1, '/v1/system/user/login', 1, 296, '{\"systemUserLoginFrom\":{\"username\":\"super_admin\",\"password\":\"e10adc3949ba59abbe56e057f20f883e\"}}', '{\"data\":{\"id\":1,\"username\":\"super_admin\",\"token\":\"eyJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJ1c2VyX3V1aWQiOjkxMDMxNzAzNTQzNzU4ODQ4LCJuYmYiOjE2NjA3MjYxMTd9.Zr8m9MGK9M9n_jKfnS6ItcJxJ8YX2IHKtvrHb81s3fc\",\"permissions\":[\"主页\",\"更新用户密码\",\"系统设置\",\"权限管理\",\"获取所有权限-树形\",\"启用权限\",\"角色管理\",\"添加角色-角色名称验证\",\"删除角色\",\"查询角色列表\",\"更新角色禁用状态\",\"更新角色名称和权限\",\"查询角色权限列表\",\"用户管理\",\"查询用户信息\",\"分页查询用户列表\",\"删除多个用户\",\"删除用户\",\"更新用户禁用状态\",\"更新用户信息\",\"操作日志管理\",\"删除操作日志\",\"删除多条操作日志\",\"分页查询操作日志\",\"登录日志管理\",\"删除登录日志\",\"删除多条登录日志\",\"分页查询登录日志\",\"文档\",\"接口文档\"]},\"message\":\"\",\"code\":200}', NULL, NULL, '2022-08-17 16:48:37'); INSERT INTO `system_log` VALUES (213, NULL, '192.168.4.17', 'POST', 1, '/v1/system/user/login', 1, 903, '{\"systemUserLoginFrom\":{\"username\":\"super_admin\",\"password\":\"e10adc3949ba59abbe56e057f20f883e\"}}', '{\"data\":{\"id\":1,\"username\":\"super_admin\",\"token\":\"eyJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJ1c2VyX3V1aWQiOjkxMDM0NTE0NzA4OTYzMzI4LCJuYmYiOjE2NjA3MjY3ODd9.OQSHQFkLHDeo89XU9ksQ93R1BwGcVOT-bd2pvULSGF4\",\"permissions\":[\"主页\",\"更新用户密码\",\"系统设置\",\"权限管理\",\"获取所有权限-树形\",\"启用权限\",\"角色管理\",\"添加角色-角色名称验证\",\"删除角色\",\"查询角色列表\",\"更新角色禁用状态\",\"更新角色名称和权限\",\"查询角色权限列表\",\"用户管理\",\"查询用户信息\",\"分页查询用户列表\",\"删除多个用户\",\"删除用户\",\"更新用户禁用状态\",\"更新用户信息\",\"操作日志管理\",\"删除操作日志\",\"删除多条操作日志\",\"分页查询操作日志\",\"登录日志管理\",\"删除登录日志\",\"删除多条登录日志\",\"分页查询登录日志\",\"文档\",\"接口文档\"]},\"message\":\"\",\"code\":200}', NULL, NULL, '2022-08-17 16:59:48'); INSERT INTO `system_log` VALUES (214, NULL, '192.168.4.17', 'POST', 1, '/v1/system/user/login', 1, 275, '{\"systemUserLoginFrom\":{\"username\":\"super_admin\",\"password\":\"e10adc3949ba59abbe56e057f20f883e\"}}', '{\"data\":{\"id\":1,\"username\":\"super_admin\",\"token\":\"eyJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJ1c2VyX3V1aWQiOjkxMDM0NTI1MDEwMTczOTUyLCJuYmYiOjE2NjA3MjY3ODl9.YumXAICJIfTUbCeIf_7GLUQfUkaD1EbdFQKMTV15rfo\",\"permissions\":[\"主页\",\"更新用户密码\",\"系统设置\",\"权限管理\",\"获取所有权限-树形\",\"启用权限\",\"角色管理\",\"添加角色-角色名称验证\",\"删除角色\",\"查询角色列表\",\"更新角色禁用状态\",\"更新角色名称和权限\",\"查询角色权限列表\",\"用户管理\",\"查询用户信息\",\"分页查询用户列表\",\"删除多个用户\",\"删除用户\",\"更新用户禁用状态\",\"更新用户信息\",\"操作日志管理\",\"删除操作日志\",\"删除多条操作日志\",\"分页查询操作日志\",\"登录日志管理\",\"删除登录日志\",\"删除多条登录日志\",\"分页查询登录日志\",\"文档\",\"接口文档\"]},\"message\":\"\",\"code\":200}', NULL, NULL, '2022-08-17 16:59:50'); -- ---------------------------- -- Table structure for system_login_log -- ---------------------------- DROP TABLE IF EXISTS `system_login_log`; CREATE TABLE `system_login_log` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '登录日志ID', `user_id` bigint(0) NOT NULL COMMENT '用户ID', `platform` int(0) NOT NULL DEFAULT 0 COMMENT '平台类型 1:管理端 2:小程序端', `login_time` datetime(0) NOT NULL COMMENT '登录时间', `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户IP', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户地址', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id` (`user_id`) USING BTREE, CONSTRAINT `system_login_log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `system_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '[\r\n{\r\n \"name\": \"app-base\",\r\n \"group\": \"系统设置-登录日志管理\",\r\n \"prefix\": \"system\",\r\n \"remarks\": \"登录日志\",\r\n \"version\": \"1.0.0\",\r\n \"ext\": 0,\r\n \"add\": 0,\r\n \"remove\": 1,\r\n \"removes\": 1,\r\n \"update\": 0,\r\n \"query\": 0,\r\n \"queries\": 1\r\n}\r\n]' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_login_log -- ---------------------------- INSERT INTO `system_login_log` VALUES (68, 1, 1, '2022-08-17 16:45:19', '192.168.4.17', '内网IP'); INSERT INTO `system_login_log` VALUES (69, 1, 1, '2022-08-17 16:48:37', '192.168.4.17', '内网IP'); INSERT INTO `system_login_log` VALUES (70, 1, 1, '2022-08-17 16:59:47', '192.168.4.17', '内网IP'); INSERT INTO `system_login_log` VALUES (71, 1, 1, '2022-08-17 16:59:50', '192.168.4.17', '内网IP'); -- ---------------------------- -- Table structure for system_permissions -- ---------------------------- DROP TABLE IF EXISTS `system_permissions`; CREATE TABLE `system_permissions` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '权限ID', `parent_id` bigint(0) NULL DEFAULT NULL COMMENT '父级权限ID', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `method` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '请求类型', `uri` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求路径', `create_time` datetime(0) NOT NULL COMMENT '创建时间', `disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `seq` int(0) NULL DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name` (`name`) USING BTREE, UNIQUE INDEX `method` (`method`, `uri`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3482 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '[\r\n{\r\n \"name\": \"app-base\",\r\n \"group\": \"系统设置-权限管理\",\r\n \"prefix\": \"system\",\r\n \"remarks\": \"权限\",\r\n \"version\": \"1.0.0\",\r\n \"ext\": 1,\r\n \"add\": 0,\r\n \"remove\": 0,\r\n \"removes\": 0,\r\n \"update\": 0,\r\n \"query\": 0,\r\n \"queries\": 0\r\n}\r\n]' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_permissions -- ---------------------------- INSERT INTO `system_permissions` VALUES (3453, 0, '主页', '', NULL, '2022-08-17 16:29:18', 0, 1); INSERT INTO `system_permissions` VALUES (3454, 3453, '更新用户密码', 'PUT', '/v1/home/update/password', '2022-08-17 16:29:18', 0, NULL); INSERT INTO `system_permissions` VALUES (3455, 0, '系统设置', '', NULL, '2022-08-17 16:29:18', 0, 2); INSERT INTO `system_permissions` VALUES (3456, 3455, '权限管理', '', NULL, '2022-08-17 16:29:18', 0, 3); INSERT INTO `system_permissions` VALUES (3457, 3456, '获取所有权限-树形', 'GET', '/v1/system/permissions/list/tree', '2022-08-17 16:29:18', 0, NULL); INSERT INTO `system_permissions` VALUES (3458, 3456, '启用权限', 'PUT', '/v1/system/permissions/update/enable', '2022-08-17 16:29:18', 0, NULL); INSERT INTO `system_permissions` VALUES (3459, 3455, '角色管理', '', NULL, '2022-08-17 16:29:19', 0, 4); INSERT INTO `system_permissions` VALUES (3460, 3459, '添加角色-角色名称验证', 'POST', '/v1/system/role/add', '2022-08-17 16:29:19', 0, NULL); INSERT INTO `system_permissions` VALUES (3461, 3459, '删除角色', 'DELETE', '/v1/system/role/delete', '2022-08-17 16:29:19', 0, NULL); INSERT INTO `system_permissions` VALUES (3462, 3459, '查询角色列表', 'GET', '/v1/system/role/list', '2022-08-17 16:29:19', 0, NULL); INSERT INTO `system_permissions` VALUES (3463, 3459, '更新角色禁用状态', 'PUT', '/v1/system/role/update/status', '2022-08-17 16:29:19', 0, NULL); INSERT INTO `system_permissions` VALUES (3464, 3459, '更新角色名称和权限', 'PUT', '/v1/system/role/update', '2022-08-17 16:29:19', 0, NULL); INSERT INTO `system_permissions` VALUES (3465, 3459, '查询角色权限列表', 'GET', '/v1/system/role/list/{roleId}/permissions', '2022-08-17 16:29:19', 0, NULL); INSERT INTO `system_permissions` VALUES (3466, 3455, '用户管理', '', NULL, '2022-08-17 16:29:19', 0, 5); INSERT INTO `system_permissions` VALUES (3467, 3466, '查询用户信息', 'GET', '/v1/system/user/query/{userId}', '2022-08-17 16:29:19', 0, NULL); INSERT INTO `system_permissions` VALUES (3468, 3466, '分页查询用户列表', 'GET', '/v1/system/user/list', '2022-08-17 16:29:20', 0, NULL); INSERT INTO `system_permissions` VALUES (3469, 3466, '删除多个用户', 'DELETE', '/v1/system/user/delete', '2022-08-17 16:29:20', 0, NULL); INSERT INTO `system_permissions` VALUES (3470, 3466, '删除用户', 'DELETE', '/v1/system/user/delete/{id}', '2022-08-17 16:29:20', 0, NULL); INSERT INTO `system_permissions` VALUES (3471, 3466, '更新用户禁用状态', 'PUT', '/v1/system/user/update/status', '2022-08-17 16:29:20', 0, NULL); INSERT INTO `system_permissions` VALUES (3472, 3466, '更新用户信息', 'PUT', '/v1/system/user/update', '2022-08-17 16:29:20', 0, NULL); INSERT INTO `system_permissions` VALUES (3473, 3455, '操作日志管理', '', NULL, '2022-08-17 16:29:20', 0, 6); INSERT INTO `system_permissions` VALUES (3474, 3473, '删除操作日志', 'DELETE', '/v1/system/log/delete/{id}', '2022-08-17 16:29:20', 0, NULL); INSERT INTO `system_permissions` VALUES (3475, 3473, '删除多条操作日志', 'DELETE', '/v1/system/log/delete', '2022-08-17 16:29:20', 0, NULL); INSERT INTO `system_permissions` VALUES (3476, 3473, '分页查询操作日志', 'GET', '/v1/system/log/list', '2022-08-17 16:29:21', 0, NULL); INSERT INTO `system_permissions` VALUES (3477, 3455, '登录日志管理', '', NULL, '2022-08-17 16:29:21', 0, 7); INSERT INTO `system_permissions` VALUES (3478, 3477, '删除登录日志', 'DELETE', '/v1/system/login/log/delete/{id}', '2022-08-17 16:29:21', 0, NULL); INSERT INTO `system_permissions` VALUES (3479, 3477, '删除多条登录日志', 'DELETE', '/v1/system/login/log/delete', '2022-08-17 16:29:21', 0, NULL); INSERT INTO `system_permissions` VALUES (3480, 3477, '分页查询登录日志', 'GET', '/v1/system/login/log/list', '2022-08-17 16:29:21', 0, NULL); INSERT INTO `system_permissions` VALUES (3481, 0, '文档', '', NULL, '2022-08-17 16:29:21', 0, 8); INSERT INTO `system_permissions` VALUES (3482, 3481, '接口文档', 'GET', '/v1/doc/api', '2022-08-17 16:29:21', 0, NULL); -- ---------------------------- -- Table structure for system_role -- ---------------------------- DROP TABLE IF EXISTS `system_role`; CREATE TABLE `system_role` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '角色ID', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `create_time` datetime(0) NOT NULL COMMENT '创建时间', `disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `name` (`name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '[\r\n{\r\n \"name\": \"app-base\",\r\n \"group\": \"系统设置-角色管理\",\r\n \"prefix\": \"system\",\r\n \"remarks\": \"角色\",\r\n \"version\": \"1.0.0\",\r\n \"ext\": 1,\r\n \"add\": 0,\r\n \"remove\": 0,\r\n \"removes\": 0,\r\n \"update\": 0,\r\n \"query\": 0,\r\n \"queries\": 0\r\n}\r\n]' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_role -- ---------------------------- INSERT INTO `system_role` VALUES (1, '超级管理员', '2022-03-13 11:24:38', 0); -- ---------------------------- -- Table structure for system_role_and_permissions -- ---------------------------- DROP TABLE IF EXISTS `system_role_and_permissions`; CREATE TABLE `system_role_and_permissions` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '角色权限ID', `role_id` bigint(0) NOT NULL COMMENT '角色ID', `permissions_id` bigint(0) NOT NULL COMMENT '权限ID', PRIMARY KEY (`id`) USING BTREE, INDEX `role_id` (`role_id`) USING BTREE, INDEX `permissions_id` (`permissions_id`) USING BTREE, CONSTRAINT `system_role_and_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `system_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `system_role_and_permissions_ibfk_2` FOREIGN KEY (`permissions_id`) REFERENCES `system_permissions` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4036 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色与权限' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_role_and_permissions -- ---------------------------- INSERT INTO `system_role_and_permissions` VALUES (4007, 1, 3453); INSERT INTO `system_role_and_permissions` VALUES (4008, 1, 3454); INSERT INTO `system_role_and_permissions` VALUES (4009, 1, 3455); INSERT INTO `system_role_and_permissions` VALUES (4010, 1, 3456); INSERT INTO `system_role_and_permissions` VALUES (4011, 1, 3457); INSERT INTO `system_role_and_permissions` VALUES (4012, 1, 3458); INSERT INTO `system_role_and_permissions` VALUES (4013, 1, 3459); INSERT INTO `system_role_and_permissions` VALUES (4014, 1, 3460); INSERT INTO `system_role_and_permissions` VALUES (4015, 1, 3461); INSERT INTO `system_role_and_permissions` VALUES (4016, 1, 3462); INSERT INTO `system_role_and_permissions` VALUES (4017, 1, 3463); INSERT INTO `system_role_and_permissions` VALUES (4018, 1, 3464); INSERT INTO `system_role_and_permissions` VALUES (4019, 1, 3465); INSERT INTO `system_role_and_permissions` VALUES (4020, 1, 3466); INSERT INTO `system_role_and_permissions` VALUES (4021, 1, 3467); INSERT INTO `system_role_and_permissions` VALUES (4022, 1, 3468); INSERT INTO `system_role_and_permissions` VALUES (4023, 1, 3469); INSERT INTO `system_role_and_permissions` VALUES (4024, 1, 3470); INSERT INTO `system_role_and_permissions` VALUES (4025, 1, 3471); INSERT INTO `system_role_and_permissions` VALUES (4026, 1, 3472); INSERT INTO `system_role_and_permissions` VALUES (4027, 1, 3473); INSERT INTO `system_role_and_permissions` VALUES (4028, 1, 3474); INSERT INTO `system_role_and_permissions` VALUES (4029, 1, 3475); INSERT INTO `system_role_and_permissions` VALUES (4030, 1, 3476); INSERT INTO `system_role_and_permissions` VALUES (4031, 1, 3477); INSERT INTO `system_role_and_permissions` VALUES (4032, 1, 3478); INSERT INTO `system_role_and_permissions` VALUES (4033, 1, 3479); INSERT INTO `system_role_and_permissions` VALUES (4034, 1, 3480); INSERT INTO `system_role_and_permissions` VALUES (4035, 1, 3481); INSERT INTO `system_role_and_permissions` VALUES (4036, 1, 3482); -- ---------------------------- -- Table structure for system_user -- ---------------------------- DROP TABLE IF EXISTS `system_user`; CREATE TABLE `system_user` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码', `disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `create_time` datetime(0) NOT NULL COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '[\r\n{\r\n \"name\": \"app-base\",\r\n \"group\": \"系统设置-用户管理\",\r\n \"prefix\": \"system\",\r\n \"remarks\": \"用户\",\r\n \"version\": \"1.0.0\",\r\n \"ext\": 1,\r\n \"add\": 0,\r\n \"remove\": 0,\r\n \"removes\": 0,\r\n \"update\": 0,\r\n \"query\": 0,\r\n \"queries\": 0\r\n}\r\n]' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_user -- ---------------------------- INSERT INTO `system_user` VALUES (1, 'super_admin', 'KlrqTdfrGm9U63VZGx+xwxENIXRVj8hcHjyyBCrBhESj/tAxW2MWB9BXIZMV/QyD', 0, '2022-08-17 16:13:42', '2022-08-17 16:13:44'); -- ---------------------------- -- Table structure for system_user_and_role -- ---------------------------- DROP TABLE IF EXISTS `system_user_and_role`; CREATE TABLE `system_user_and_role` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '用户角色ID', `user_id` bigint(0) NOT NULL COMMENT '用户ID', `role_id` bigint(0) NOT NULL COMMENT '角色ID', PRIMARY KEY (`id`) USING BTREE, INDEX `user_role_ibfk_1` (`user_id`) USING BTREE, INDEX `user_role_ibfk_2` (`role_id`) USING BTREE, CONSTRAINT `system_user_and_role_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `system_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `system_user_and_role_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `system_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与角色' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of system_user_and_role -- ---------------------------- INSERT INTO `system_user_and_role` VALUES (1, 1, 1); SET FOREIGN_KEY_CHECKS = 1;