From 5fc0a298a51a36ceeea528b0b46c4947d37521b6 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期二, 21 五月 2024 09:53:19 +0800
Subject: [PATCH] update 优化 切换动态租户 默认线程内切换(如需全局 手动传参)
---
script/sql/update/sqlserver/update_5.1.2-5.2.0.sql | 18 ++++++++++--------
1 files changed, 10 insertions(+), 8 deletions(-)
diff --git a/script/sql/update/sqlserver/update_5.1.2-5.2.0.sql b/script/sql/update/sqlserver/update_5.1.2-5.2.0.sql
index 66335e4..bf69f10 100644
--- a/script/sql/update/sqlserver/update_5.1.2-5.2.0.sql
+++ b/script/sql/update/sqlserver/update_5.1.2-5.2.0.sql
@@ -1,27 +1,29 @@
-ALTER TABLE sys_dept ADD dept_category nvarchar(100) DEFAULT NULL;
+ALTER TABLE sys_dept ADD dept_category nvarchar(100) DEFAULT NULL
EXEC sp_addextendedproperty
'MS_Description', N'閮ㄩ棬绫诲埆缂栫爜',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
- 'COLUMN', N'dept_category';
+ 'COLUMN', N'dept_category'
GO
-ALTER TABLE sys_post ADD dept_id bigint NOT NULL;
+ALTER TABLE sys_post ADD dept_id bigint NOT NULL
GO
-ALTER TABLE sys_post ADD post_category nvarchar(100) DEFAULT NULL;
+ALTER TABLE sys_post ADD post_category nvarchar(100) DEFAULT NULL
GO
EXEC sp_addextendedproperty
'MS_Description', N'閮ㄩ棬id',
'SCHEMA', N'dbo',
'TABLE', N'sys_post',
- 'COLUMN', N'dept_id';
+ 'COLUMN', N'dept_id'
GO
EXEC sp_addextendedproperty
'MS_Description', N'宀椾綅绫诲埆缂栫爜',
'SCHEMA', N'dbo',
'TABLE', N'sys_post',
- 'COLUMN', N'post_category';
+ 'COLUMN', N'post_category'
GO
-UPDATE sys_post SET dept_id = 100;
+UPDATE sys_post SET dept_id = 100
GO
-UPDATE sys_post SET dept_id = 103 where post_id = 1;
+UPDATE sys_post SET dept_id = 103 where post_id = 1
GO
+UPDATE sys_menu SET path = N'snailjob', component = N'monitor/snailjob/index', perms = N'monitor:snailjob:list', remark = N'SnailJob鎺у埗鍙拌彍鍗�' WHERE menu_id = 120
+GO
\ No newline at end of file
--
Gitblit v1.9.3