-- Add unique constraint on number_sequences(type, year) for atomic numbering ALTER TABLE number_sequences ADD UNIQUE INDEX idx_number_sequences_type_year (`type`, `year`);