From d0c6c53ce449c422d7446c0406d0a711c76424f3 Mon Sep 17 00:00:00 2001 From: jiazx0107@163.com <jiazx0107@163.com> Date: 星期四, 29 六月 2023 19:40:02 +0800 Subject: [PATCH] 优化出入库信息 --- igds-doc/sql/update-v35-to-v40.sql | 46 ++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 44 insertions(+), 2 deletions(-) diff --git a/igds-doc/sql/update-v35-to-v40.sql b/igds-doc/sql/update-v35-to-v40.sql index d1ed658..e67f078 100644 --- a/igds-doc/sql/update-v35-to-v40.sql +++ b/igds-doc/sql/update-v35-to-v40.sql @@ -1,8 +1,50 @@ --- 鐗堟湰V35鍗囩骇V40鑴氭湰 ---2023骞�5鏈�17鏃� +-- 鐗堟湰V35鍗囩骇V40鑴氭湰 ---2023骞�5鏈� -- 淇敼璁″垝琛ㄥ悕绉� RENAME TABLE D_M_PLAN TO D_INOUT_PLAN RENAME TABLE D_M_PLAN_DETAIL TO D_INOUT_PLAN_DETAIL; --淇敼鍚堝悓淇℃伅 -RENAME TABLE D_M_CONTRACT TO D_INOUT_CONTRACT; \ No newline at end of file +RENAME TABLE D_M_CONTRACT TO D_INOUT_CONTRACT; + +--鎬ц川鍙樻洿 +RENAME TABLE D_M_VARIETY_CHANGE TO D_INOUT_VARIETY_CHANGE; + +--璐ㄩ噺绠＄悊-妫�楠岀被鍨嬪崌绾�--寰呴厤缃� +UPDATE D_M_QUALITY SET TYPE_ = '', WHERE TYPE_ =''; + +UPDATE D_M_QUALITY SET STANDARD_ = '1', WHERE STANDARD_ ='01'; +UPDATE D_M_QUALITY SET STANDARD_ = '0', WHERE STANDARD_ ='02'; + +-- 鎹熸孩琛� +RENAME TABLE D_M_LOSS_OVER TO D_INOUT_LOSS_OVER; + +-- 鍊掍粨 +RENAME TABLE D_M_STOCK_CHANGE TO D_INOUT_STOCK_CHANGE; + +--瀹㈡埛淇＄敤 +RENAME TABLE D_CREDIT TO D_INTOU_CREDIT; + + +-- 鍗囩骇浠撴埧鐘舵�� 1=绌轰粨銆�2=鍏ュ簱涓��3=婊′粨銆�4=鍑哄簱涓��9=鍏朵粬 銆�31姘旇皟涓��32鐔忚捀涓��33閫氶涓� 34娓╂帶涓� +UPDATE D_DEPOT SET DEPOT_STATUS_ = '1' WHERE DEPOT_STATUS_ ='01'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '2' WHERE DEPOT_STATUS_ ='03'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '3' WHERE DEPOT_STATUS_ ='02'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '4' WHERE DEPOT_STATUS_ ='04'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '31' WHERE DEPOT_STATUS_ ='05'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '32' WHERE DEPOT_STATUS_ ='06'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '33' WHERE DEPOT_STATUS_ ='07'; +UPDATE D_DEPOT SET DEPOT_STATUS_ = '34' WHERE DEPOT_STATUS_ ='09'; + +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '1' WHERE DEPOT_STATUS_ ='01'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '2' WHERE DEPOT_STATUS_ ='03'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '3' WHERE DEPOT_STATUS_ ='02'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '4' WHERE DEPOT_STATUS_ ='04'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '31' WHERE DEPOT_STATUS_ ='05'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '32' WHERE DEPOT_STATUS_ ='06'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '33' WHERE DEPOT_STATUS_ ='07'; +UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '34' WHERE DEPOT_STATUS_ ='09'; + +-- 璋冩暣鍑哄叆搴撴暟鎹姸鎬� +UPDATE D_INOUT_RECORD SET RECORD_STATUS_ ='DEL' WHERE RECORD_STATUS_='ERROR'; + -- Gitblit v1.9.3