From 03fe1cf38ad470ad333ad78c5aa797c52cbdb465 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期四, 21 十一月 2024 09:37:49 +0800 Subject: [PATCH] 1 --- docker-compose/mysql/initdb/se_cloud_20241119.sql | 35 +++++++++++++++++++++++++++++++++++ 1 files changed, 35 insertions(+), 0 deletions(-) diff --git a/docker-compose/mysql/initdb/se_cloud_20241119.sql b/docker-compose/mysql/initdb/se_cloud_20241119.sql index 45b711f..38dc72e 100644 --- a/docker-compose/mysql/initdb/se_cloud_20241119.sql +++ b/docker-compose/mysql/initdb/se_cloud_20241119.sql @@ -182,3 +182,38 @@ ) 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; + -- Gitblit v1.9.3