| | |
| | | ) engine=innodb auto_increment=1 comment = '控制日志表'; |
| | | select * from sys_ctrl_log order by log_id; |
| | | |
| | | |
| | | -- ---------------------------- |
| | | -- 09、角色控制表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_role_ctrl; |
| | | create table sys_role_ctrl ( |
| | | role_id bigint(20) not null comment '角色ID', |
| | | ctrl_id bigint(20) not null comment '控制ID', |
| | | primary key(role_id, ctrl_id) |
| | | ) engine=innodb comment = '角色控制表'; |
| | | select * from sys_role_ctrl; |
| | | |
| | | |
| | | -- ---------------------------- |
| | | -- 10、角色接口表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_role_inte; |
| | | create table sys_role_inte ( |
| | | role_id bigint(20) not null comment '角色ID', |
| | | inte_id bigint(20) not null comment '接口ID', |
| | | primary key(role_id, inte_id) |
| | | ) engine=innodb comment = '角色接口表'; |
| | | select * from sys_role_inte; |
| | | |
| | | -- ---------------------------- |
| | | -- 11、角色资源表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_role_res; |
| | | create table sys_role_res ( |
| | | role_id bigint(20) not null comment '角色ID', |
| | | res_id bigint(20) not null comment '资源ID', |
| | | primary key(role_id, res_id) |
| | | ) engine=innodb comment = '角色资源表'; |
| | | select * from sys_role_res; |
| | | |