From 11bfde3dc1f8fbb0bfd681e7ba35d491a4f52a06 Mon Sep 17 00:00:00 2001
From: AprilWind <2100166581@qq.com>
Date: 星期六, 25 五月 2024 22:39:50 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev
---
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