mescloud/db/mysql/mes_material_check_sample_tighten.sql

-- 来料检查加严：实测值扩展至8个，记录抽样数
-- 规则：本周同物料累计3次不合格后加严为8个；加严期间连续3次合格后恢复5个，并清空本轮不合格计数

ALTER TABLE mes_material_check_record_items
  ADD COLUMN a6 varchar(255) NULL COMMENT '实测值6' AFTER a5,
  ADD COLUMN a7 varchar(255) NULL COMMENT '实测值7' AFTER a6,
  ADD COLUMN a8 varchar(255) NULL COMMENT '实测值8' AFTER a7;

ALTER TABLE mes_material_check_record
  ADD COLUMN sample_count int NULL DEFAULT 5 COMMENT '实测值抽样数(5正常/8加严)' AFTER state;