From 52d437b89025b47713b4079881f2890ee2c939c7 Mon Sep 17 00:00:00 2001
From: jiazx0107@163.com <jiazx0107@163.com>
Date: 星期六, 27 五月 2023 14:37:41 +0800
Subject: [PATCH] 调整模块-取消错误代码，添加TODO标记后期处理

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

diff --git a/igds-doc/sql/update-v35-to-v40.sql b/igds-doc/sql/update-v35-to-v40.sql
index 37622de..49d48fa 100644
--- a/igds-doc/sql/update-v35-to-v40.sql
+++ b/igds-doc/sql/update-v35-to-v40.sql
@@ -1 +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;
+
+--淇敼鍚堝悓淇℃伅
+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