zkxw/docs/sql/migrations/2026-10-27-rename-reception-check-needle-path.sql

-- =============================================================================
-- 样本接收检查项改名：针头无暴露 → 针路密闭
-- 配置表与结果快照一并更新，接收表单和已保存的接收详情显示同一名称。
-- 可重复执行：名称已改过后 WHERE 不再命中。
-- =============================================================================

UPDATE biz_sample_reception_check_item
SET item_code = '针路密闭',
    item_name = '针路密闭',
    update_time = NOW()
WHERE del_flag = 0
  AND item_code = '针头无暴露'
  AND item_name = '针头无暴露';

UPDATE biz_sample_reception_check_result
SET item_code = '针路密闭',
    item_name = '针路密闭',
    update_time = NOW()
WHERE item_code = '针头无暴露'
   OR item_name = '针头无暴露';