Skip to content

2.4.1 完善 RBAC 菜单以及按钮权限
Compare
Choose a tag to compare
@LiuYuYang01 LiuYuYang01 released this 25 Jan 12:33
· 26 commits to master since this release
2.4.1
bbc399e

旧版升级

导入此 Sql

DROP TABLE IF EXISTS role;
create table role
(
    id          int auto_increment
        primary key,
    name        varchar(255) not null comment '角色名称',
    mark        varchar(100) not null comment '角色标识',
    description varchar(255) not null comment '角色描述'
);

INSERT INTO role (name, mark, description) VALUES ('管理员', 'admin', '最高权限');
INSERT INTO role (name, mark, description) VALUES ('作者', 'author', '发布文章、查看文章列表');



DROP TABLE IF EXISTS permission;
create table permission
(
    id          int auto_increment
        primary key,
    name        varchar(100) not null comment '权限标识',
    description varchar(255) not null comment '权限介绍',
    `group`     varchar(50)  not null comment '权限分组',
    role_id     int          not null comment '角色ID',
    constraint Permission_pk_2
        unique (id)
)
    comment '角色权限';

INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:add', '新增用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:del', '删除用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:edit', '编辑用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:info', '获取用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:list', '获取用户列表', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:pass', '修改用户密码', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('data:add', '新增数据', 'data', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('data:del', '删除数据', 'data', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:add', '新增文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:del', '删除文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:reduction', '还原被删除的文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:del', '批量删除文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:edit', '编辑文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('cate:add', '新增分类', 'cate', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('cate:del', '删除分类', 'cate', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('cate:edit', '编辑分类', 'cate', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('comment:del', '删除评论', 'comment', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('comment:edit', '编辑评论', 'comment', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('comment:audit', '审核评论', 'comment', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('config:info', '获取项目配置', 'config', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('config:list', '获取项目配置列表', 'config', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('config:edit', '修改项目配置', 'config', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('email:dismiss', '驳回通知邮件', 'email', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:info', '获取文件信息', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:dir', '获取目录列表', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:list', '获取文件列表', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:add', '文件上传', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:del', '删除文件', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:add', '新增oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:del', '删除oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:edit', '更新oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:info', '获取oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:list', '获取oss配置列表', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:enable', '启用oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:getEnableOss', '获取当前启用的oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:getPlatform', '获取支持的oss平台', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('record:add', '新增说说', 'record', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('record:del', '删除说说', 'record', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('record:edit', '编辑说说', 'record', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:add', '新增角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:del', '删除角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:edit', '编辑角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:info', '获取角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:list', '获取角色列表', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:getRouteList', '获取角色路由列表', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:bindingRoute', '分配角色权限', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:add', '新增路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:del', '删除路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:edit', '编辑路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:info', '获取路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:list', '获取路由列表', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('swiper:add', '新增轮播图', 'swiper', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('swiper:del', '删除轮播图', 'swiper', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('swiper:edit', '编辑轮播图', 'swiper', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('tag:add', '新增标签', 'tag', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('tag:del', '删除标签', 'tag', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('tag:edit', '编辑标签', 'tag', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('wall:del', '删除留言', 'wall', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('wall:edit', '编辑留言', 'wall', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('wall:audit', '审核留言', 'wall', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:getPermissionList', '获取角色路由列表', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:add', '新增权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:del', '删除权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:edit', '编辑权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:info', '获取权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:list', '获取权限列表', 'permission', 1);




DROP TABLE IF EXISTS role_permission;
create table role_permission
(
    id            int auto_increment
        primary key,
    role_id       int not null comment '角色ID',
    permission_id int not null comment '权限ID',
    constraint role_permission_pk_2
        unique (id)
)
    comment '角色权限';

INSERT INTO role_permission (role_id, permission_id) VALUES (1, 1);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 2);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 3);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 4);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 5);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 6);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 7);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 8);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 9);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 10);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 11);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 12);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 13);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 14);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 15);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 16);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 17);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 18);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 19);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 20);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 21);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 22);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 23);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 24);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 25);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 26);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 27);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 28);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 29);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 30);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 31);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 32);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 33);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 34);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 35);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 36);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 37);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 38);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 39);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 40);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 41);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 42);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 43);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 44);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 45);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 46);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 61);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 47);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 48);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 49);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 50);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 51);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 52);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 53);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 54);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 55);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 56);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 57);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 58);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 59);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 60);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 62);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 63);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 64);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 65);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 66);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 1);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 2);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 3);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 5);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 7);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 8);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 9);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 10);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 11);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 12);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 13);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 9);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 24);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 25);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 26);
INSERT INTO role_permission (role_id, permission_id) VALUES (2, 27);




DROP TABLE IF EXISTS route_role;
create table route_role
(
    id       int auto_increment
        primary key,
    route_id int not null comment '路由id',
    role_id  int not null comment '角色id',
    constraint routes_role_pk_2
        unique (id)
);

INSERT INTO route_role (route_id, role_id) VALUES (1, 5);
INSERT INTO route_role (route_id, role_id) VALUES (10, 5);
INSERT INTO route_role (route_id, role_id) VALUES (7, 5);
INSERT INTO route_role (route_id, role_id) VALUES (9, 5);
INSERT INTO route_role (route_id, role_id) VALUES (8, 5);
INSERT INTO route_role (route_id, role_id) VALUES (6, 5);
INSERT INTO route_role (route_id, role_id) VALUES (2, 5);
INSERT INTO route_role (route_id, role_id) VALUES (5, 5);
INSERT INTO route_role (route_id, role_id) VALUES (30, 1);
INSERT INTO route_role (route_id, role_id) VALUES (27, 1);
INSERT INTO route_role (route_id, role_id) VALUES (26, 1);
INSERT INTO route_role (route_id, role_id) VALUES (25, 1);
INSERT INTO route_role (route_id, role_id) VALUES (24, 1);
INSERT INTO route_role (route_id, role_id) VALUES (23, 1);
INSERT INTO route_role (route_id, role_id) VALUES (21, 1);
INSERT INTO route_role (route_id, role_id) VALUES (14, 1);
INSERT INTO route_role (route_id, role_id) VALUES (17, 1);
INSERT INTO route_role (route_id, role_id) VALUES (20, 1);
INSERT INTO route_role (route_id, role_id) VALUES (1, 1);
INSERT INTO route_role (route_id, role_id) VALUES (2, 1);
INSERT INTO route_role (route_id, role_id) VALUES (5, 1);
INSERT INTO route_role (route_id, role_id) VALUES (6, 1);
INSERT INTO route_role (route_id, role_id) VALUES (7, 1);
INSERT INTO route_role (route_id, role_id) VALUES (8, 1);
INSERT INTO route_role (route_id, role_id) VALUES (9, 1);
INSERT INTO route_role (route_id, role_id) VALUES (10, 1);
INSERT INTO route_role (route_id, role_id) VALUES (11, 1);
INSERT INTO route_role (route_id, role_id) VALUES (12, 1);
INSERT INTO route_role (route_id, role_id) VALUES (13, 1);
INSERT INTO route_role (route_id, role_id) VALUES (15, 1);
INSERT INTO route_role (route_id, role_id) VALUES (16, 1);
INSERT INTO route_role (route_id, role_id) VALUES (28, 1);
INSERT INTO route_role (route_id, role_id) VALUES (29, 1);
INSERT INTO route_role (route_id, role_id) VALUES (32, 1);
INSERT INTO route_role (route_id, role_id) VALUES (33, 1);
INSERT INTO route_role (route_id, role_id) VALUES (1, 2);
INSERT INTO route_role (route_id, role_id) VALUES (7, 2);
INSERT INTO route_role (route_id, role_id) VALUES (9, 2);
INSERT INTO route_role (route_id, role_id) VALUES (8, 2);
INSERT INTO route_role (route_id, role_id) VALUES (6, 2);
INSERT INTO route_role (route_id, role_id) VALUES (2, 2);
Assets 3
Loading