From ae33e68baf21878ce145d75ac377d14c1e2b2a82 Mon Sep 17 00:00:00 2001
From: “linengliang” <vanSuperEnergy@163.com>
Date: 星期三, 13 十二月 2023 14:59:26 +0800
Subject: [PATCH] 设备台账
---
lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11(lnl)/lnl.sql | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql" "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql"
index 73ed997..5de1d5c 100644
--- "a/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql"
+++ "b/lxzn-module-system/lxzn-system-start/src/main/resources/db/2023_12_11\050lnl\051/lnl.sql"
@@ -13,3 +13,22 @@
'SCHEMA', N'dbo',
'TABLE', N'mom_eam_equipment_maintenance_plan',
'COLUMN', N'create_reason'
+-- 璁惧鍙拌处澧炲姞涓や釜瀛楁
+ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_line_equip] nvarchar(32) NULL
+ GO
+
+ALTER TABLE [dbo].[mom_eam_equipment] ADD [is_judging] nvarchar(32) NULL
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鏄惁鐢熶骇绾胯澶囷紙鏄細yes锛屽惁锛歯o锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment',
+ 'COLUMN', N'is_line_equip'
+ GO
+
+ EXEC sp_addextendedproperty
+ 'MS_Description', N'鏄惁鍦ㄨ瘎鍒嗗綋涓紙鏄細yes锛屽惁锛歯o锛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'mom_eam_equipment',
+ 'COLUMN', N'is_judging'
--
Gitblit v1.9.3