Calculation/sql/update.sql

ALTER TABLE `zh_change_audit_list`
ADD COLUMN `checked_amount` decimal(30, 8) NULL DEFAULT NULL COMMENT '审批变更后数量（整型）' AFTER `samount`,
ADD COLUMN `checked_price` decimal(30, 8) NULL DEFAULT NULL COMMENT '审批变更后金额（整型）' AFTER `checked_amount`;

UPDATE `zh_change_audit_list` SET `checked_amount` = CONVERT(`samount`, DECIMAL) WHERE `samount` != '';