From dfd793f14e51c48c3322f1b36f543179043bd45d Mon Sep 17 00:00:00 2001 From: jiazx0107@163.com <jiazx0107@163.com> Date: 星期日, 22 十月 2023 18:25:27 +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