xunjian_houtai/resources/sql/app-base/app_base.sql

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