From 6f4a366cad9109ddc338fd13c9d43ca2ce516f6b Mon Sep 17 00:00:00 2001
From: jiazx0107@163.com <jiazx0107@163.com>
Date: 星期五, 26 五月 2023 16:53:07 +0800
Subject: [PATCH] 调整计划管理模块4

---
 igds-doc/sql/update-v35-to-v40.sql |   25 +++++++++++++++++++++++--
 1 files changed, 23 insertions(+), 2 deletions(-)

diff --git a/igds-doc/sql/update-v35-to-v40.sql b/igds-doc/sql/update-v35-to-v40.sql
index 5e4b783..49d48fa 100644
--- a/igds-doc/sql/update-v35-to-v40.sql
+++ b/igds-doc/sql/update-v35-to-v40.sql
@@ -1,5 +1,26 @@
--- 鐗堟湰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;
\ No newline at end of file
+RENAME TABLE D_M_PLAN_DETAIL TO D_INOUT_PLAN_DETAIL;
+
+--淇敼鍚堝悓淇℃伅
+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;
\ No newline at end of file

--
Gitblit v1.9.3