From ce8598cd6c6095f22bd867564c7ca7a77b3ca5bc Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 14 十月 2022 13:40:01 +0800 Subject: [PATCH] 1 --- data/db_fn.sql | 17 ++++++++++++++++- 1 files changed, 16 insertions(+), 1 deletions(-) diff --git a/data/db_fn.sql b/data/db_fn.sql index 1efa683..4e6062c 100644 --- a/data/db_fn.sql +++ b/data/db_fn.sql @@ -152,6 +152,10 @@ alter table lf.sys_role_res add constraint idx_unique_role_res unique (roleid,resid); -- 鑱斿悎鍞竴绱㈠紩 insert into lf.sys_role_res (roleid,resid) values (1,1); select * from lf.sys_role_res; + +alter table lf.sys_role_menu_auth add constraint idx_unique_role_menu_auth unique (roleid,menu_auth_id); -- 鑱斿悎鍞竴绱㈠紩 +insert into lf.sys_role_menu_auth (roleid,menu_auth_id) values (1,1); +select * from lf.sys_role_menu_auth; ----------------------------------------------------------------------------------------------------- select a.*,fn_uname(a.create_user) createUserName,fn_uname(a.update_user) updateUserName from lf.sys_blacklist a order by a.id; select * from lf.sys_user a where uname like '%' and a.depid=ANY(fn_rec_array(1,'dep')); @@ -172,9 +176,20 @@ ------------------------------------------------------------ select * from lf.sys_res; select * from lf.sys_role; -select * from lf.sys_role_res; +select * from lf.sys_role_res;` ` select a.* from lf.sys_res a where not exists (select b.id from lf.sys_role_res b where b.resid = a.id and b.roleid = 1); + +select * from lf.sys_role; +select * from lf.sys_menu; +select * from lf.sys_auth; +select * from lf.sys_menu_auth; +select * from lf.sys_role_menu_auth; + +select a.*,c.name from lf.sys_menu_auth a inner join lf.sys_auth c on a.authid = c.id +where not exists (select b.id from lf.sys_role_menu_auth b where b.menu_auth_id = a.id and b.roleid = 1) and a.menuid = 1; + +select a.*,b.menuid,c.name from lf.sys_role_menu_auth a inner join lf.sys_menu_auth b on a.menu_auth_id = b.id inner join lf.sys_auth c on b.authid = c.id where a.roleid = 1 ----------------------------------------------------------------------------------------------------- -- Gitblit v1.9.3