From a066604943cd69ba5c10a400aa55f8f39b4f4ff3 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周一, 17 6月 2024 10:42:13 +0800 Subject: [PATCH] 修复 --- DBScript/02_DDL_TABLE_Edit.sql | 46 +++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 45 insertions(+), 1 deletions(-) diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index 294e0a4..c2127ff 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -191,9 +191,53 @@ +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鏂瑰悜鐩村緞 - \ No newline at end of file + +--鏂板鑾峰彇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 -- Gitblit v1.9.3