mescloud/db/mysql/mes_line_process_material_consume_nums.sql

-- 工序物料配置：新增单次消耗数量
-- 数据库：mes_cloud_199_0y7a

ALTER TABLE `mes_line_process_material`
    ADD COLUMN `consume_nums` int(10) NULL DEFAULT 1 COMMENT '单次消耗数量' AFTER `nums`;

UPDATE `mes_line_process_material` SET `consume_nums` = 1 WHERE `consume_nums` IS NULL;

ALTER TABLE `mes_line_process_material`
    MODIFY COLUMN `nums` int(10) NULL DEFAULT NULL COMMENT '数量';