mescloud/db/mes_wuliao_cz_tare_split.sql

-- 称重表去皮字段拆分：原铝锭去皮 / 回炉料去皮
-- 执行前请备份 mes_wuliao_cz

ALTER TABLE mes_wuliao_cz ADD COLUMN y_qp_zl VARCHAR(64) NULL COMMENT '原铝锭去皮' AFTER h_zl;
ALTER TABLE mes_wuliao_cz ADD COLUMN h_qp_zl VARCHAR(64) NULL COMMENT '回炉料去皮' AFTER y_qp_zl;

-- 若存在旧字段 qp_zl，可将历史数据迁移到回炉料去皮（按需执行）
-- UPDATE mes_wuliao_cz SET h_qp_zl = qp_zl WHERE (h_qp_zl IS NULL OR h_qp_zl = '') AND qp_zl IS NOT NULL;
-- ALTER TABLE mes_wuliao_cz DROP COLUMN qp_zl;