From 77f44574c00b536ef21286f3898265829e446a52 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 15 八月 2024 11:53:15 +0800
Subject: [PATCH] update 优化 修改spring源码上下文持有者 支持线程切换传递上下文数据 支持一切异步获取用户信息等操作
---
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..18daca4 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 menu_name = N'SnailJob鎺у埗鍙�', path = N'snailjob', component = N'monitor/snailjob/index', perms = N'monitor:snailjob:list', remark = N'SnailJob鎺у埗鍙拌彍鍗�' WHERE menu_id = 120
GO
--
Gitblit v1.9.3