From 105dfd96c12f6f34509f43c870798c3460319773 Mon Sep 17 00:00:00 2001
From: gssong <1742057357@qq.com>
Date: 星期一, 18 三月 2024 20:33:39 +0800
Subject: [PATCH] fix 修复我发起得列表查询错误,调整撤销后未办理任务设置null

---
 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