From 8f21e9e2fde6f1e5acc5355f3a9a4c8dbfbeba47 Mon Sep 17 00:00:00 2001
From: AprilWind <2100166581@qq.com>
Date: 星期三, 15 一月 2025 20:46:11 +0800
Subject: [PATCH] update 优化代码以及注释
---
script/sql/update/sqlserver/update_5.0-5.1.sql | 12 +++++++++---
1 files changed, 9 insertions(+), 3 deletions(-)
diff --git a/script/sql/update/sqlserver/update_5.0-5.1.sql b/script/sql/update/sqlserver/update_5.0-5.1.sql
index 63fa937..81434a3 100644
--- a/script/sql/update/sqlserver/update_5.0-5.1.sql
+++ b/script/sql/update/sqlserver/update_5.0-5.1.sql
@@ -188,7 +188,7 @@
'COLUMN', N'oauth_token_secret'
GO
EXEC sys.sp_addextendedproperty
- 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�' ,
+ 'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_social',
'COLUMN', N'del_flag'
@@ -250,7 +250,7 @@
GO
EXEC sp_addextendedproperty
-'MS_Description', N'涓诲缓',
+'MS_Description', N'涓婚敭',
'SCHEMA', N'dbo',
'TABLE', N'sys_client',
'COLUMN', N'id'
@@ -304,7 +304,7 @@
'COLUMN', N'status'
GO
EXEC sp_addextendedproperty
-'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+'MS_Description', N'鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 1浠ｈ〃鍒犻櫎锛�',
'SCHEMA', N'dbo',
'TABLE', N'sys_client',
'COLUMN', N'del_flag'
@@ -401,3 +401,9 @@
GO
INSERT sys_role_menu VALUES (2, 1065)
GO
+
+
+UPDATE sys_dept SET leader = null
+GO
+ALTER TABLE sys_dept ALTER COLUMN leader bigint NULL
+GO
--
Gitblit v1.9.3