From 39d37c53444c20780cd05b5b958693cf532c2597 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 02 9月 2024 11:25:18 +0800
Subject: [PATCH] 优化
---
DBScript/02_DDL_TABLE_Edit.sql | 43 ++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 42 insertions(+), 1 deletions(-)
diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql
index 8614fe5..9081bbc 100644
--- a/DBScript/02_DDL_TABLE_Edit.sql
+++ b/DBScript/02_DDL_TABLE_Edit.sql
@@ -356,4 +356,45 @@
alter table QualityDataInfoLog Add QualityNoOkReason_OP80 nvarchar(255)
-
\ No newline at end of file
+
+
+
+
+
+ alter table WorkPieceOutbound Add CarNo nvarchar(255) -- 灏忚溅鐮�
+ alter table WorkPieceOutbound Add UnLineStage int
+ alter table WorkPieceOutbound Add UnLineStageName nvarchar(255)
+ alter table WorkPieceOutbound Add WorkPieceUnLineTime datetime
+ alter table WorkPieceOutbound Add WorkPieceUnLineUserId bigint
+ alter table WorkPieceOutbound Add WorkPieceUnLineUserName nvarchar(255)
+
+
+ -- 娣诲姞鍞竴绱㈠紩 [Editby liuwq,2024-07-20]
+IF EXISTS(select 1 from sysindexes where id=object_id('WorkPieceOutbound ') and name='idx_WorkPieceOutbound')
+DROP INDEX idx_WorkPieceOutbound ON WorkPieceOutbound
+CREATE UNIQUE INDEX
+idx_WorkPieceOutbound ON WorkPieceOutbound (OP80NewCode)
+GO
+
+
+
+ alter table WorkPieceInfo Add UnLineStage int
+ alter table WorkPieceInfo Add UnLineStageName nvarchar(255)
+ alter table WorkPieceInfo Add WorkPieceUnLineTime datetime
+ alter table WorkPieceInfo Add WorkPieceUnLineUserId bigint
+ alter table WorkPieceInfo Add WorkPieceUnLineUserName nvarchar(255)
+
+
+ -- 澧炲姞 瀵瑰垱寤轰汉銆佷慨鏀逛汉鐨勮В閲� [Editby shaocx,2024-08-31]
+ alter table WorkPieceLog Add DataCapturePointCname nvarchar(255)
+ alter table WorkPieceLog Add UpdateDataCapturePointCname nvarchar(255)
+
+
+ alter table WorkPieceInfo Add DataCapturePointCname nvarchar(255)
+ alter table WorkPieceInfo Add UpdateDataCapturePointCname nvarchar(255)
+
+
+ alter table WorkPieceProcess Add DataCapturePointCname nvarchar(255)
+ alter table WorkPieceProcess Add UpdateDataCapturePointCname nvarchar(255)
+
+
\ No newline at end of file
--
Gitblit v1.9.3