-- 补齐来料检验供应商批次号的编码规则。 INSERT INTO mes_md_auto_code_rule (code, name, description, max_length, padded, status, creator, create_time, updater, update_time, deleted) SELECT 'QC_IQC_VENDOR_BATCH_CODE', '来料检验供应商批次号', '来料检验供应商批次号自动编码', 14, b'0', 0, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS ( SELECT 1 FROM mes_md_auto_code_rule WHERE code = 'QC_IQC_VENDOR_BATCH_CODE' AND deleted = 0 ); SET @vendor_batch_rule_id = ( SELECT id FROM mes_md_auto_code_rule WHERE code = 'QC_IQC_VENDOR_BATCH_CODE' AND deleted = 0 LIMIT 1 ); INSERT INTO mes_md_auto_code_part (rule_id, sort, type, length, fix_character, serial_start_no, serial_step, cycle_flag, cycle_method, creator, create_time, updater, update_time, deleted) SELECT @vendor_batch_rule_id, 1, 3, 3, 'VB_', NULL, NULL, NULL, NULL, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS (SELECT 1 FROM mes_md_auto_code_part WHERE rule_id = @vendor_batch_rule_id AND sort = 1 AND deleted = 0); INSERT INTO mes_md_auto_code_part (rule_id, sort, type, length, date_format, serial_start_no, serial_step, cycle_flag, cycle_method, creator, create_time, updater, update_time, deleted) SELECT @vendor_batch_rule_id, 2, 2, 8, 'yyyyMMdd', NULL, NULL, NULL, NULL, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS (SELECT 1 FROM mes_md_auto_code_part WHERE rule_id = @vendor_batch_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, updater, update_time, deleted) SELECT @vendor_batch_rule_id, 3, 4, 3, 1, 1, b'1', 3, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS (SELECT 1 FROM mes_md_auto_code_part WHERE rule_id = @vendor_batch_rule_id AND sort = 3 AND deleted = 0);