From fae4bd828a6b81b95f53e285fcb4749fbd80c7bf Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期一, 04 九月 2023 17:31:46 +0800 Subject: [PATCH] 增加粮情层行转换配置 --- igds-doc/sql/update-v35-to-v40.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/igds-doc/sql/update-v35-to-v40.sql b/igds-doc/sql/update-v35-to-v40.sql index d67444e..7c0a02a 100644 --- a/igds-doc/sql/update-v35-to-v40.sql +++ b/igds-doc/sql/update-v35-to-v40.sql @@ -48,6 +48,11 @@ -- 璋冩暣鍑哄叆搴撴暟鎹姸鎬� UPDATE D_INOUT_RECORD SET RECORD_STATUS_ ='DEL' WHERE RECORD_STATUS_='ERROR'; +-- 璋冩暣缁撶畻瀛楁 +ALTER TABLE `d_inout_settle` +CHANGE COLUMN `PAY_SUM_` `PAY_MONEY_` double NULL DEFAULT NULL AFTER `PAY_PRICE_`; + + -- 鏇存柊鍖栭獙椤� UPDATE D_DIC_CHECK_ITEM SET CODE_ = '020101' WHERE CODE_ ='C01'; UPDATE D_DIC_CHECK_ITEM SET CODE_ = '01010301' WHERE CODE_ ='C02'; -- Gitblit v1.9.3