From ef57259386e58c3c12e44760e8e41aade68d219e Mon Sep 17 00:00:00 2001
From: dhb52 <dhb52@126.com>
Date: 星期五, 17 五月 2024 09:54:18 +0800
Subject: [PATCH] !535 feat: EasyRetry-v3.2.0 => SnailJob-v1.0.0beta1 * feat: EasyRetry-v3.2.0 => SnailJob-v1.0.0beta1
---
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