mes_station_time_rule.sql 586 B

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