From 5677ab158fb78d1267c16bbbf29eb690e0b4039f Mon Sep 17 00:00:00 2001
From: qushaowei <qushaowei@163.com>
Date: 星期三, 13 十二月 2023 16:53:39 +0800
Subject: [PATCH] Merge branch 'master' of http://117.34.109.166:18448/r/mdc_430 into develop
---
lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16(lnl)/2023_11_24.sql | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/2023_11_24.sql" "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/2023_11_24.sql"
new file mode 100644
index 0000000..612d22f
--- /dev/null
+++ "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_11_16\050lnl\051/2023_11_24.sql"
@@ -0,0 +1,29 @@
+ALTER TABLE [dbo].[mom_eam_equipment_report_repair] DROP CONSTRAINT [DF__mom_eam_e__err_u__00AD44A9]
+ GO
+
+ALTER TABLE [dbo].[mom_eam_equipment_report_repair] ALTER COLUMN [err_uda5] text NULL
+ GO
+
+ IF ((SELECT COUNT(*) FROM ::fn_listextendedproperty('MS_Description',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment_report_repair',
+ 'COLUMN', N'err_uda5')) > 0)
+ EXEC sp_updateextendedproperty
+ 'MS_Description', N'楠屾敹鎰忚',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment_report_repair',
+ 'COLUMN', N'err_uda5'
+ ELSE
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'楠屾敹鎰忚',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment_report_repair',
+ 'COLUMN', N'err_uda5'
+ALTER TABLE [dbo].[sys_user] ADD [area_id] nvarchar(32) NULL
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'涓績ID',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'sys_user',
+ 'COLUMN', N'area_id'
--
Gitblit v1.9.3