From 75e83ba772ef70396b2595ccab646edf8ec4df51 Mon Sep 17 00:00:00 2001
From: jiazx0107@163.com <jiazx0107@163.com>
Date: 星期五, 26 五月 2023 12:20:13 +0800
Subject: [PATCH] 调整计划管理模块3

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

--
Gitblit v1.9.3