From bdcd889df441941304350dcfb6e5f32e35063c44 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期五, 17 五月 2024 10:13:07 +0800
Subject: [PATCH] update 优化 增加 snailjob banner
---
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