From 60862ffc3e18ffdbe7ec22f99e41f026cb5c2b14 Mon Sep 17 00:00:00 2001 From: LiuHao <liuhaoai545@gmail.com> Date: 星期四, 07 三月 2024 15:14:27 +0800 Subject: [PATCH] update 优化 重复get方法 --- script/sql/update/postgres/update_5.0-5.1.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/script/sql/update/postgres/update_5.0-5.1.sql b/script/sql/update/postgres/update_5.0-5.1.sql index a0107ae..fa2eb3e 100644 --- a/script/sql/update/postgres/update_5.0-5.1.sql +++ b/script/sql/update/postgres/update_5.0-5.1.sql @@ -144,3 +144,7 @@ insert into sys_role_menu values ('2', '1063'); insert into sys_role_menu values ('2', '1064'); insert into sys_role_menu values ('2', '1065'); + + +update sys_dept set leader = null; +ALTER TABLE sys_dept ALTER COLUMN leader TYPE int8; -- Gitblit v1.9.3