From 1e423facaa8d2de58ec2dbed70f5562d620ece17 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期三, 09 八月 2023 12:06:22 +0800
Subject: [PATCH] add 增加 !pr410 sql变更

---
 script/sql/update/oracle/update_5.0-5.1.sql |    4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)

diff --git a/script/sql/update/oracle/update_5.0-5.1.sql b/script/sql/update/oracle/update_5.0-5.1.sql
index bf178ec..72f1170 100644
--- a/script/sql/update/oracle/update_5.0-5.1.sql
+++ b/script/sql/update/oracle/update_5.0-5.1.sql
@@ -145,3 +145,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