From f0826424c58f3e925a77437111a2e06808bfff26 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 02 9月 2024 17:48:25 +0800
Subject: [PATCH] //处理OP30的数据
---
DBScript/02_DDL_TABLE_Edit.sql | 203 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 202 insertions(+), 1 deletions(-)
diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql
index 294e0a4..9081bbc 100644
--- a/DBScript/02_DDL_TABLE_Edit.sql
+++ b/DBScript/02_DDL_TABLE_Edit.sql
@@ -191,9 +191,210 @@
+ALTER TABLE EquipmentBaseInfo Add DetergentAddtime datetime, -- 娓呮礂娑叉坊鍔犳椂闂� 銆怑ditby shaocx,2024-06-11銆�
+ CuttingFluidAddTime datetime -- 鍒囧墛娑叉坊鍔犳椂闂� 銆怑ditby shaocx,2024-06-11銆�
+
+
+
+--鏂板OP80鐨勪竴浜涜川閲忔暟鎹� 銆怑ditby shaocx,2024-06-13銆�
+ ALTER TABLE QualityDataInfo Add QualityOP80_Houdu nvarchar(15), -- OP80 璐ㄩ噺鏁版嵁-鍘氬害
+ QualityOP80_ZXJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-涓績璺�
+ QualityOP80_DTKYZD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご瀛斿渾鏌卞害
+ QualityOP80_XTSMYD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰鍦嗗害
+ QualityOP80_XTXMYD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰鍦嗗害
+
+ QualityOP80_D_TKZJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご瀛旂洿寰�,澶уご瀛旂洿寰�=锛堝ぇ澶翠笂闈鏂瑰悜鐩村緞+澶уご涓婇潰Y鏂瑰悜鐩村緞+澶уご涓嬮潰X鏂瑰悜鐩村緞+澶уご涓嬮潰Y鏂瑰悜鐩村緞锛�/4
+ QualityOP80_D_S_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓婇潰X鏂瑰悜鐩村緞
+ QualityOP80_D_S_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓婇潰Y鏂瑰悜鐩村緞
+ QualityOP80_D_X_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓嬮潰X鏂瑰悜鐩村緞
+ QualityOP80_D_X_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓嬮潰Y鏂瑰悜鐩村緞
+
+
+ QualityOP80_X_TKZJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご瀛旂洿寰�,灏忓ご瀛旂洿寰�=锛堝皬澶翠笂闈鏂瑰悜鐩村緞+灏忓ご涓婇潰Y鏂瑰悜鐩村緞+灏忓ご涓嬮潰X鏂瑰悜鐩村緞+灏忓ご涓嬮潰Y鏂瑰悜鐩村緞锛�/4
+ QualityOP80_X_S_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰X鏂瑰悜鐩村緞
+ QualityOP80_X_S_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰Y鏂瑰悜鐩村緞
+ QualityOP80_X_X_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰X鏂瑰悜鐩村緞
+ QualityOP80_X_X_Y nvarchar(15) -- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰Y鏂瑰悜鐩村緞
+
+ ALTER TABLE QualityDataInfoLog Add QualityOP80_Houdu nvarchar(15), -- OP80 璐ㄩ噺鏁版嵁-鍘氬害
+ QualityOP80_ZXJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-涓績璺�
+ QualityOP80_DTKYZD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご瀛斿渾鏌卞害
+ QualityOP80_XTSMYD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰鍦嗗害
+ QualityOP80_XTXMYD nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰鍦嗗害
+
+ QualityOP80_D_TKZJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご瀛旂洿寰�,澶уご瀛旂洿寰�=锛堝ぇ澶翠笂闈鏂瑰悜鐩村緞+澶уご涓婇潰Y鏂瑰悜鐩村緞+澶уご涓嬮潰X鏂瑰悜鐩村緞+澶уご涓嬮潰Y鏂瑰悜鐩村緞锛�/4
+ QualityOP80_D_S_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓婇潰X鏂瑰悜鐩村緞
+ QualityOP80_D_S_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓婇潰Y鏂瑰悜鐩村緞
+ QualityOP80_D_X_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓嬮潰X鏂瑰悜鐩村緞
+ QualityOP80_D_X_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-澶уご涓嬮潰Y鏂瑰悜鐩村緞
+
+
+ QualityOP80_X_TKZJ nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご瀛旂洿寰�,灏忓ご瀛旂洿寰�=锛堝皬澶翠笂闈鏂瑰悜鐩村緞+灏忓ご涓婇潰Y鏂瑰悜鐩村緞+灏忓ご涓嬮潰X鏂瑰悜鐩村緞+灏忓ご涓嬮潰Y鏂瑰悜鐩村緞锛�/4
+ QualityOP80_X_S_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰X鏂瑰悜鐩村緞
+ QualityOP80_X_S_Y nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓婇潰Y鏂瑰悜鐩村緞
+ QualityOP80_X_X_X nvarchar(15),-- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰X鏂瑰悜鐩村緞
+ QualityOP80_X_X_Y nvarchar(15) -- OP80 璐ㄩ噺鏁版嵁-灏忓ご涓嬮潰Y鏂瑰悜鐩村緞
+
+
+
+--鏂板鑾峰彇QC鏁版嵁鏍囪 銆怑ditby shaocx,2024-06-13銆�
+ ALTER TABLE WorkPieceProcess Add GetQcDataFlag int, -- 鑾峰彇QC鏁版嵁鏍囪,0琛ㄧず寰呰幏鍙栵紝1琛ㄧず鑾峰彇鎴愬姛锛�2琛ㄧず鑾峰彇澶辫触 銆怑ditby shaocx,2024-06-15銆�
+ GetQcDataCount int,-- 鑾峰彇QC鏁版嵁鏍囪娆℃暟 銆怑ditby shaocx,2024-06-15銆�
+ GetQcDataFlag_Remark nvarchar(100) -- 鑾峰彇QC鏁版嵁鏍囪鎻忚堪 銆怑ditby shaocx,2024-06-15銆�
+
+
+
+
+ alter table WorkPieceInfo ADD OutTime datetime, -- 鍑哄簱鏃堕棿
+ OutPerson nvarchar(255), -- 鍑哄簱浜�
+ OutRemark nvarchar(255), -- 鍑哄簱澶囨敞
+ 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)
-
\ No newline at end of file
+
+ -- 娣诲姞鍞竴绱㈠紩 [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