From 7903954e19f91f5213d60535a22438cfe10df1a7 Mon Sep 17 00:00:00 2001
From: liuying <1427574514@qq.com>
Date: 周三, 23 10月 2024 15:05:37 +0800
Subject: [PATCH] 一汽地址配置
---
DBScript/02_DDL_TABLE_Edit.sql | 174 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 173 insertions(+), 1 deletions(-)
diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql
index a622546..df42102 100644
--- a/DBScript/02_DDL_TABLE_Edit.sql
+++ b/DBScript/02_DDL_TABLE_Edit.sql
@@ -248,4 +248,176 @@
alter table WorkPieceInfo ADD OutTime datetime, -- 鍑哄簱鏃堕棿
OutPerson nvarchar(255), -- 鍑哄簱浜�
OutRemark nvarchar(255), -- 鍑哄簱澶囨敞
- IsOut bit -- 鏄惁鍑哄簱
\ No newline at end of file
+ IsOut bit -- 鏄惁鍑哄簱
+
+
+
+
+ alter table WorkPieceInfo ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨�
+ QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥�
+
+ alter table WorkPieceInfoLog ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨�
+ QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥�
+
+ alter table WorkPieceLog ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨�
+ QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥�
+
+ alter table WorkPieceProcess ADD QualityNoOk int, -- 璐ㄩ噺涓嶅悎鏍煎師鍥犵被鍨�
+ QualityNoOkReason nvarchar(255), -- 璐ㄩ噺涓嶅悎鏍煎師鍥�
+
+
+
+ -- QualityDataInfo
+
+ alter table QualityDataInfo Add QualityNoOk_OP10 int
+
+
+ alter table QualityDataInfo Add QualityNoOkReason_OP10 nvarchar(255)
+
+
+ alter table QualityDataInfo Add QualityNoOk_OP20 int
+
+
+ alter table QualityDataInfo Add QualityNoOkReason_OP20 nvarchar(255)
+
+
+ alter table QualityDataInfo Add QualityNoOk_OP30 int
+
+
+ alter table QualityDataInfo Add QualityNoOkReason_OP30 nvarchar(255)
+
+
+ alter table QualityDataInfo Add QualityNoOk_OP35 int
+
+
+ alter table QualityDataInfo Add QualityNoOkReason_OP35 nvarchar(255)
+
+
+ alter table QualityDataInfo Add QualityNoOk_OP40 int
+
+
+ alter table QualityDataInfo Add QualityNoOkReason_OP40 nvarchar(255)
+
+
+
+ alter table QualityDataInfo Add QualityNoOk_OP60 int
+
+
+ alter table QualityDataInfo Add QualityNoOkReason_OP60 nvarchar(255)
+
+
+ alter table QualityDataInfo Add QualityNoOk_OP80 int
+
+
+ alter table QualityDataInfo Add QualityNoOkReason_OP80 nvarchar(255)
+
+
+ -- QualityDataInfoLog
+
+ alter table QualityDataInfoLog Add QualityNoOk_OP10 int
+
+
+ alter table QualityDataInfoLog Add QualityNoOkReason_OP10 nvarchar(255)
+
+
+ alter table QualityDataInfoLog Add QualityNoOk_OP20 int
+
+
+ alter table QualityDataInfoLog Add QualityNoOkReason_OP20 nvarchar(255)
+
+
+ alter table QualityDataInfoLog Add QualityNoOk_OP30 int
+
+
+ alter table QualityDataInfoLog Add QualityNoOkReason_OP30 nvarchar(255)
+
+
+ alter table QualityDataInfoLog Add QualityNoOk_OP35 int
+
+
+ alter table QualityDataInfoLog Add QualityNoOkReason_OP35 nvarchar(255)
+
+
+ alter table QualityDataInfoLog Add QualityNoOk_OP40 int
+
+
+ alter table QualityDataInfoLog Add QualityNoOkReason_OP40 nvarchar(255)
+
+
+
+ alter table QualityDataInfoLog Add QualityNoOk_OP60 int
+
+
+ alter table QualityDataInfoLog Add QualityNoOkReason_OP60 nvarchar(255)
+
+
+ alter table QualityDataInfoLog Add QualityNoOk_OP80 int
+
+
+ alter table QualityDataInfoLog Add QualityNoOkReason_OP80 nvarchar(255)
+
+
+
+
+
+
+ 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)
+
+ alter table WorkPieceProcess Add MyRemarks nvarchar(255) -- 鑷垜鎻忚堪鐨勫娉�
+
+
+ alter table AccessInterfaceLog Add WorkPieceID nvarchar(255)
+ alter table AccessInterfaceLog Add WorkingProcedureCurrent nvarchar(255)
+
+
+
+ alter table WorkPieceLog Add MyRemarks nvarchar(255) -- 鑷垜鎻忚堪鐨勫娉�
+
+ alter table WorkPieceLog Add PieceLogType int
+ alter table WorkPieceLog Add PieceLogTypeName nvarchar(255)
+
+
+ alter table AccessInterfaceLog Add QualityState int
+
+
+ alter table WorkPieceProcess Add Update70Flag int -- 闇�瑕佹洿鏂�70璐ㄩ噺鏁版嵁鐨勬爣璁� 锛� 1锛氶渶瑕佹洿鏂� 2锛氫笉闇�瑕佹洿鏂帮級
+
+
+ alter table WorkPieceProcess Add JiaJuGongWei nvarchar(50) -- 澶瑰叿宸ヤ綅
+
+ alter table WorkPieceLog Add JiaJuGongWei nvarchar(50) -- 澶瑰叿宸ヤ綅
+
\ No newline at end of file
--
Gitblit v1.9.3