| 12345678 |
- -- 工位最长加工时长(分钟),用于 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');
|