-- 质量巡检单自动编码规则:XJ_ + yyyyMMdd + 3 位流水,例如 XJ_20261106001 -- 可重复执行:已存在则跳过。 INSERT INTO mes_md_auto_code_rule (code, name, description, max_length, padded, padded_char, padded_method, status, creator, create_time, update_time) SELECT 'QC_PATROL_CODE', '质量巡检单编码', '质量巡检单自动编码', 16, 1, '0', 1, 0, '1', NOW(), NOW() FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM mes_md_auto_code_rule WHERE code = 'QC_PATROL_CODE' AND deleted = 0); SET @patrol_rule_id = (SELECT id FROM mes_md_auto_code_rule WHERE code = 'QC_PATROL_CODE' AND deleted = 0 LIMIT 1); INSERT INTO mes_md_auto_code_part (rule_id, sort, type, length, fix_character, creator, create_time, update_time) SELECT @patrol_rule_id, 1, 3, 4, 'XJ_', '1', NOW(), NOW() FROM DUAL WHERE @patrol_rule_id IS NOT NULL AND NOT EXISTS (SELECT 1 FROM mes_md_auto_code_part WHERE rule_id = @patrol_rule_id AND sort = 1 AND deleted = 0); INSERT INTO mes_md_auto_code_part (rule_id, sort, type, length, date_format, creator, create_time, update_time) SELECT @patrol_rule_id, 2, 2, 8, 'yyyyMMdd', '1', NOW(), NOW() FROM DUAL WHERE @patrol_rule_id IS NOT NULL AND NOT EXISTS (SELECT 1 FROM mes_md_auto_code_part WHERE rule_id = @patrol_rule_id AND sort = 2 AND deleted = 0); INSERT INTO mes_md_auto_code_part (rule_id, sort, type, length, serial_start_no, serial_step, cycle_flag, cycle_method, creator, create_time, update_time) SELECT @patrol_rule_id, 3, 4, 3, 1, 1, 1, 3, '1', NOW(), NOW() FROM DUAL WHERE @patrol_rule_id IS NOT NULL AND NOT EXISTS (SELECT 1 FROM mes_md_auto_code_part WHERE rule_id = @patrol_rule_id AND sort = 3 AND deleted = 0);