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';