-- =============================================
-- 修复：车间设置 -> 车间编码 -> 生成，报“编码规则不存在”
-- 原因：mes_md_auto_code_rule 中缺少 code = 'MD_WORKSHOP_CODE' 的规则数据
-- 说明：本脚本可重复执行，不会删除/覆盖已有规则
-- 生成格式：WSP + 6 位流水号，例如 WSP000001
-- =============================================

-- 1. 车间编码规则主表
INSERT INTO mes_md_auto_code_rule
    (code, name, description, max_length, padded, padded_char, padded_method, status, remark, creator, updater)
SELECT 'MD_WORKSHOP_CODE', '车间编码', '用于生成车间编码', 12, b'0', NULL, NULL, 0, NULL, '1', '1'
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM mes_md_auto_code_rule WHERE code = 'MD_WORKSHOP_CODE'
);

-- 2. 固定前缀 WSP
INSERT INTO mes_md_auto_code_part
    (rule_id, sort, type, length, fix_character, serial_start_no, serial_step, cycle_flag, remark, creator, updater)
SELECT r.id, 1, 3, 3, 'WSP', NULL, NULL, NULL, '固定前缀', '1', '1'
FROM mes_md_auto_code_rule r
WHERE r.code = 'MD_WORKSHOP_CODE'
  AND NOT EXISTS (
      SELECT 1 FROM mes_md_auto_code_part p WHERE p.rule_id = r.id AND p.sort = 1
  );

-- 3. 6 位流水号（从 1 开始，步长 1，不循环）
INSERT INTO mes_md_auto_code_part
    (rule_id, sort, type, length, fix_character, serial_start_no, serial_step, cycle_flag, remark, creator, updater)
SELECT r.id, 2, 4, 6, NULL, 1, 1, b'0', '流水号', '1', '1'
FROM mes_md_auto_code_rule r
WHERE r.code = 'MD_WORKSHOP_CODE'
  AND NOT EXISTS (
      SELECT 1 FROM mes_md_auto_code_part p WHERE p.rule_id = r.id AND p.sort = 2
  );