From 1e02ddcd520c15fbcb11cc060dd3d00e183a6ce8 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周六, 31 8月 2024 14:49:11 +0800
Subject: [PATCH] 定时删除表数据成功

---
 DBScript/02_DDL_TABLE_Edit.sql |  118 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 117 insertions(+), 1 deletions(-)

diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql
index c2127ff..8614fe5 100644
--- a/DBScript/02_DDL_TABLE_Edit.sql
+++ b/DBScript/02_DDL_TABLE_Edit.sql
@@ -240,4 +240,120 @@
 --鏂板鑾峰彇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銆�
\ No newline at end of file
+									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)
+
+      
\ No newline at end of file

--
Gitblit v1.9.3