From 921ed67368431c332b68450a0407b0bd151052c5 Mon Sep 17 00:00:00 2001
From: jiazx0107@163.com <jiazx0107@163.com>
Date: 星期五, 26 五月 2023 12:20:33 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 igds-doc/sql/update-v35-to-v40.sql |   18 +++++++++++++++++-
 1 files changed, 17 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..5d15af6 100644
--- a/igds-doc/sql/update-v35-to-v40.sql
+++ b/igds-doc/sql/update-v35-to-v40.sql
@@ -1 +1,17 @@
--- 鐗堟湰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';
\ No newline at end of file

--
Gitblit v1.9.3