登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 0

清风/backAdmin

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
文件
克隆/下载
qf-admin.sql 22.44 KB
一键复制 编辑 原始数据 按行查看 历史
清风 提交于 2024-06-11 12:29 . 移除冗余代码，加入缓存、系统监控功能
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313
/*

 Navicat Premium Data Transfer



 Source Server         : 2

 Source Server Type    : MySQL

 Source Server Version : 80200

 Source Host           : 192.168.1.110:3306

 Source Schema         : qf-admin



 Target Server Type    : MySQL

 Target Server Version : 80200

 File Encoding         : 65001



 Date: 11/06/2024 15:56:44

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for sys_dict

-- ----------------------------

DROP TABLE IF EXISTS `sys_dict`;

CREATE TABLE `sys_dict`  (

  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',

  `type_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典类型编码',

  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典项名称',

  `value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典项值',

  `sort` int NULL DEFAULT 0 COMMENT '排序',

  `status` tinyint NULL DEFAULT 0 COMMENT '状态(1:正常;0:禁用)',

  `defaulted` tinyint NULL DEFAULT 0 COMMENT '是否默认(1:是;0:否)',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除标识(0-未删除；1-已删除)',

  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',

  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '创建者',

  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '更新者',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注信息',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典数据表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_dict

-- ----------------------------

INSERT INTO `sys_dict` VALUES (1, 'gender', '男', '1', 1, 1, 0, 0, '2024-06-11 03:19:24', '2024-06-11 03:19:24', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_dict` VALUES (2, 'gender', '女', '2', 2, 1, 0, 0, '2024-06-11 03:19:24', '2024-06-11 03:19:24', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_dict` VALUES (3, 'gender', '未知', '3', 3, 1, 0, 0, '2024-06-11 03:19:24', '2024-06-11 03:19:24', 'ADMIN', 'ADMIN', '');



-- ----------------------------

-- Table structure for sys_dict_type

-- ----------------------------

DROP TABLE IF EXISTS `sys_dict_type`;

CREATE TABLE `sys_dict_type`  (

  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键 ',

  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '类型名称',

  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '类型编码',

  `status` tinyint(1) NULL DEFAULT 0 COMMENT '状态(0:正常;1:禁用)',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除标识(0-未删除；1-已删除)',

  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',

  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '创建者',

  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '更新者',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注信息',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `type_code`(`code` ASC) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典类型表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_dict_type

-- ----------------------------

INSERT INTO `sys_dict_type` VALUES (1, '性别', 'gender', 1, 0, '2024-06-11 03:19:24', '2024-06-11 03:19:24', 'ADMIN', 'ADMIN', '性别');



-- ----------------------------

-- Table structure for sys_menu

-- ----------------------------

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu`  (

  `id` bigint NOT NULL AUTO_INCREMENT,

  `parent_id` bigint NOT NULL COMMENT '父菜单ID',

  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '菜单名称',

  `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '路由路径(浏览器地址栏路径)',

  `component` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组件路径(vue页面完整路径，省略.vue后缀)',

  `visible` tinyint(1) NOT NULL DEFAULT 1 COMMENT '显示状态(1-显示;0-隐藏)',

  `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '菜单图标',

  `sort` int NULL DEFAULT 0 COMMENT '排序',

  `redirect` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '跳转路径',

  `type` tinyint(1) NOT NULL COMMENT '菜单类型(1:目录 2:菜单 3:外链)',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除标识(0-未删除；1-已删除)',

  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',

  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '创建者',

  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '更新者',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注信息',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 117 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '菜单管理' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_menu

-- ----------------------------

INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', '/system', 'Layout', 1, 'system', 1, '/system/user', 1, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '系统管理目录');

INSERT INTO `sys_menu` VALUES (2, 0, '系统监控', '/monitor', 'Layout', 1, 'monitor', 2, '/monitor/online', 1, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '系统监控目录');

INSERT INTO `sys_menu` VALUES (3, 0, '文章管理', '/article', 'Layout', 1, 'article', 3, '/article/list', 1, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '文章管理目录');

INSERT INTO `sys_menu` VALUES (4, 0, '日志管理', '/notice', 'Layout', 1, 'log', 4, '/log/operlog', 1, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '日志管理目录');

INSERT INTO `sys_menu` VALUES (101, 1, '用户管理', '/system/user', 'system/user/index', 1, 'user', 1, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '用户管理菜单');

INSERT INTO `sys_menu` VALUES (102, 1, '角色管理', '/system/role', 'system/role/index', 1, 'role', 2, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '角色管理菜单');

INSERT INTO `sys_menu` VALUES (103, 1, '菜单管理', '/system/menu', 'system/menu/index', 1, 'menu', 3, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '菜单管理菜单');

INSERT INTO `sys_menu` VALUES (104, 1, '字典管理', '/system/dict', 'system/dict/index', 1, 'dict', 4, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '字典管理菜单');

INSERT INTO `sys_menu` VALUES (105, 1, '通知公告', '/system/notice', 'system/notice/index', 1, 'message', 5, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '通知公告菜单');

INSERT INTO `sys_menu` VALUES (106, 2, '在线用户', '/monitor/online', 'monitor/online/index', 1, 'online', 1, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '在线用户菜单');

INSERT INTO `sys_menu` VALUES (107, 2, '数据监控', '/monitor/druid', 'monitor/druid/index', 1, 'druid', 2, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '数据监控菜单');

INSERT INTO `sys_menu` VALUES (108, 2, '服务监控', '/monitor/server', 'monitor/server/index', 1, 'server', 3, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '服务监控菜单');

INSERT INTO `sys_menu` VALUES (109, 2, '缓存监控', '/monitor/cache', 'monitor/cache/server/index', 1, 'redis', 4, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '缓存监控菜单');

INSERT INTO `sys_menu` VALUES (110, 2, '缓存列表', '/monitor/cacheList', 'monitor/cache/list/index', 1, 'redis-list', 5, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '缓存列表菜单');

INSERT INTO `sys_menu` VALUES (111, 3, '文章列表', '/article/articleList', 'article/list/index', 1, 'article-list', 1, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '文章列表菜单');

INSERT INTO `sys_menu` VALUES (112, 3, '发布文章', '/article/addArticle', 'article/index', 1, 'add-article', 2, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '发布文章菜单');

INSERT INTO `sys_menu` VALUES (113, 3, '标签管理', '/article/tag', 'article/tag/index', 1, 'tag', 3, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '标签管理菜单');

INSERT INTO `sys_menu` VALUES (114, 3, '分类管理', '/article/category', 'article/category/index', 1, 'category', 4, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '分类管理菜单');

INSERT INTO `sys_menu` VALUES (115, 4, '操作日志', '/monitor/operlog', 'monitor/log/operlog', 1, 'form', 1, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '操作日志菜单');

INSERT INTO `sys_menu` VALUES (116, 4, '登录日志', '/monitor/logininfor', 'monitor/log/logininfor', 1, 'logininfor', 2, NULL, 2, 0, '2024-06-11 03:07:42', '2024-06-11 03:07:42', 'ADMIN', 'ADMIN', '登录日志菜单');



-- ----------------------------

-- Table structure for sys_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_permission`;

CREATE TABLE `sys_permission`  (

  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',

  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限名称',

  `menu_id` int NULL DEFAULT NULL COMMENT '菜单模块ID',

  `url_perm` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'URL权限标识',

  `btn_perm` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '按钮权限标识',

  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',

  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '创建者',

  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '更新者',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注信息',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `id`(`id` ASC, `name` ASC) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '权限表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_permission

-- ----------------------------

INSERT INTO `sys_permission` VALUES (1, '查看用户', 101, 'GET:/api/v1/users/*', 'sys:user:list', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (2, '编辑用户', 101, 'PUT:/api/v1/users/*', 'sys:user:edit', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (3, '新增用户', 101, 'POST:/api/v1/users/*', 'sys:user:add', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (4, '删除用户', 101, 'DELETE:/api/v1/users/*', 'sys:user:delete', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (5, '查看角色', 102, 'GET:/api/v1/roles/*', 'sys:role:list', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (6, '编辑角色', 102, 'PUT:/api/v1/roles/*', 'sys:role:edit', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (7, '新增角色', 102, 'POST:/api/v1/roles/*', 'sys:role:add', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (8, '删除角色', 102, 'DELETE:/api/v1/roles/*', 'sys:role:delete', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (9, '查看菜单', 103, 'GET:/api/v1/menus/*', 'sys:menu:list', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (10, '编辑菜单', 103, 'PUT:/api/v1/menus/*', 'sys:menu:edit', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (11, '新增菜单', 103, 'POST:/api/v1/menus/*', 'sys:menu:add', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_permission` VALUES (12, '删除菜单', 103, 'DELETE:/api/v1/menus/*', 'sys:menu:delete', '2024-06-11 03:13:11', '2024-06-11 03:13:11', 'ADMIN', 'ADMIN', '');



-- ----------------------------

-- Table structure for sys_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role`  (

  `id` bigint NOT NULL AUTO_INCREMENT,

  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '角色名称',

  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色编码',

  `sort` int NULL DEFAULT NULL COMMENT '显示顺序',

  `status` tinyint(1) NULL DEFAULT 1 COMMENT '角色状态(1-正常；0-停用)',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除标识(0-未删除；1-已删除)',

  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',

  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '创建者',

  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '更新者',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注信息',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `name`(`name` ASC) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_role

-- ----------------------------

INSERT INTO `sys_role` VALUES (1, '超级管理员', 'ROOT', 1, 1, 0, '2024-06-11 03:12:27', '2024-06-11 03:12:27', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_role` VALUES (2, '系统管理员', 'ADMIN', 1, 1, 0, '2024-06-11 03:12:27', '2024-06-11 03:12:27', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_role` VALUES (3, '测试管理员', 'TEST', 1, 1, 0, '2024-06-11 03:12:27', '2024-06-11 03:12:27', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_role` VALUES (4, '访问游客', 'GUEST', 1, 1, 0, '2024-06-11 03:12:27', '2024-06-11 03:12:27', 'ADMIN', 'ADMIN', '');



-- ----------------------------

-- Table structure for sys_role_menu

-- ----------------------------

DROP TABLE IF EXISTS `sys_role_menu`;

CREATE TABLE `sys_role_menu`  (

  `role_id` bigint NOT NULL COMMENT '角色ID',

  `menu_id` bigint NOT NULL COMMENT '菜单ID'

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_role_menu

-- ----------------------------

INSERT INTO `sys_role_menu` VALUES (1, 1);

INSERT INTO `sys_role_menu` VALUES (1, 2);

INSERT INTO `sys_role_menu` VALUES (1, 3);

INSERT INTO `sys_role_menu` VALUES (1, 101);

INSERT INTO `sys_role_menu` VALUES (1, 102);

INSERT INTO `sys_role_menu` VALUES (1, 103);

INSERT INTO `sys_role_menu` VALUES (1, 104);

INSERT INTO `sys_role_menu` VALUES (1, 105);

INSERT INTO `sys_role_menu` VALUES (1, 106);

INSERT INTO `sys_role_menu` VALUES (1, 107);

INSERT INTO `sys_role_menu` VALUES (1, 108);

INSERT INTO `sys_role_menu` VALUES (1, 109);

INSERT INTO `sys_role_menu` VALUES (1, 110);

INSERT INTO `sys_role_menu` VALUES (1, 111);

INSERT INTO `sys_role_menu` VALUES (1, 112);

INSERT INTO `sys_role_menu` VALUES (2, 1);

INSERT INTO `sys_role_menu` VALUES (2, 2);

INSERT INTO `sys_role_menu` VALUES (2, 3);

INSERT INTO `sys_role_menu` VALUES (2, 4);

INSERT INTO `sys_role_menu` VALUES (2, 101);

INSERT INTO `sys_role_menu` VALUES (2, 102);

INSERT INTO `sys_role_menu` VALUES (2, 103);

INSERT INTO `sys_role_menu` VALUES (2, 106);

INSERT INTO `sys_role_menu` VALUES (2, 107);

INSERT INTO `sys_role_menu` VALUES (2, 108);

INSERT INTO `sys_role_menu` VALUES (2, 111);

INSERT INTO `sys_role_menu` VALUES (2, 112);

INSERT INTO `sys_role_menu` VALUES (2, 113);

INSERT INTO `sys_role_menu` VALUES (2, 114);



-- ----------------------------

-- Table structure for sys_role_permission

-- ----------------------------

DROP TABLE IF EXISTS `sys_role_permission`;

CREATE TABLE `sys_role_permission`  (

  `role_id` bigint NOT NULL COMMENT '角色ID',

  `permission_id` bigint NOT NULL COMMENT '访问权限ID'

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色权限关联表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_role_permission

-- ----------------------------

INSERT INTO `sys_role_permission` VALUES (1, 1);

INSERT INTO `sys_role_permission` VALUES (1, 2);

INSERT INTO `sys_role_permission` VALUES (1, 3);

INSERT INTO `sys_role_permission` VALUES (1, 4);

INSERT INTO `sys_role_permission` VALUES (1, 5);

INSERT INTO `sys_role_permission` VALUES (1, 6);

INSERT INTO `sys_role_permission` VALUES (1, 7);

INSERT INTO `sys_role_permission` VALUES (1, 8);

INSERT INTO `sys_role_permission` VALUES (1, 9);

INSERT INTO `sys_role_permission` VALUES (1, 10);

INSERT INTO `sys_role_permission` VALUES (1, 11);

INSERT INTO `sys_role_permission` VALUES (1, 12);

INSERT INTO `sys_role_permission` VALUES (2, 1);

INSERT INTO `sys_role_permission` VALUES (2, 2);

INSERT INTO `sys_role_permission` VALUES (2, 3);

INSERT INTO `sys_role_permission` VALUES (2, 4);

INSERT INTO `sys_role_permission` VALUES (2, 5);

INSERT INTO `sys_role_permission` VALUES (2, 6);

INSERT INTO `sys_role_permission` VALUES (2, 7);

INSERT INTO `sys_role_permission` VALUES (2, 8);

INSERT INTO `sys_role_permission` VALUES (2, 9);

INSERT INTO `sys_role_permission` VALUES (2, 10);

INSERT INTO `sys_role_permission` VALUES (2, 11);

INSERT INTO `sys_role_permission` VALUES (2, 12);



-- ----------------------------

-- Table structure for sys_user

-- ----------------------------

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user`  (

  `id` bigint NOT NULL AUTO_INCREMENT,

  `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',

  `nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称',

  `gender` tinyint(1) NULL DEFAULT 1 COMMENT '性别((1:男;2:女))',

  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',

  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '用户头像',

  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系方式',

  `status` tinyint(1) NULL DEFAULT 1 COMMENT '用户状态((1:正常;0:禁用))',

  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户邮箱',

  `is_deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除标识(0:未删除;1:已删除)',

  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '个人简介',

  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',

  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '创建者',

  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'ADMIN' COMMENT '更新者',

  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '备注信息',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `login_name`(`username` ASC) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_user

-- ----------------------------

INSERT INTO `sys_user` VALUES (1, 'root', '清风', 0, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', 'http://', '1559211****', 1, '123@qq.com', 0, NULL, '2024-06-11 03:11:52', '2024-06-11 03:11:52', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_user` VALUES (2, 'admin', '管理员', 1, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', 'http://', '1559211****', 1, '123@qq.com', 0, NULL, '2024-06-11 03:11:52', '2024-06-11 03:11:52', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_user` VALUES (3, 'test', '测试用户', 0, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', 'http://', '1559211****', 1, '123@qq.com', 0, NULL, '2024-06-11 03:11:52', '2024-06-11 03:11:52', 'ADMIN', 'ADMIN', '');

INSERT INTO `sys_user` VALUES (4, 'guest', '游客', 1, '$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', 'http://', '1559211****', 1, '123@qq.com', 0, NULL, '2024-06-11 03:11:52', '2024-06-11 03:11:52', 'ADMIN', 'ADMIN', '');



-- ----------------------------

-- Table structure for sys_user_role

-- ----------------------------

DROP TABLE IF EXISTS `sys_user_role`;

CREATE TABLE `sys_user_role`  (

  `user_id` bigint NOT NULL COMMENT '用户ID',

  `role_id` bigint NOT NULL COMMENT '角色ID',

  PRIMARY KEY (`user_id`, `role_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户和角色关联表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of sys_user_role

-- ----------------------------

INSERT INTO `sys_user_role` VALUES (1, 1);

INSERT INTO `sys_user_role` VALUES (2, 2);

INSERT INTO `sys_user_role` VALUES (3, 3);

INSERT INTO `sys_user_role` VALUES (4, 4);



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/qinfeng_wei/back-admin.git
git@gitee.com:qinfeng_wei/back-admin.git
qinfeng_wei
back-admin
backAdmin
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部
0d507c66 1850385 C8b1a773 1850385