-- 工位最长加工时长(分钟),用于 OP015/OP200/OP210/OP260 等时效管控 ALTER TABLE mes_line_process ADD COLUMN max_duration int(11) DEFAULT NULL COMMENT '最长加工时长(分钟)' AFTER duration; -- 可选:为默认管控工位预置 15 分钟(仅主工位,子工位 A/B 继承主工位配置) UPDATE mes_line_process SET max_duration = 15 WHERE oprno IN ('OP015','OP200','OP210','OP260') AND pid IS NULL AND max_duration IS NULL; -- OP030 建议配置为不可重复加工 UPDATE mes_line_process SET `repeat` = '0' WHERE oprno IN ('OP030','OP030A');