I want to create a MySQL database to hold the results of a race that will take place annually.
The details I want in the table are:-
surname, firstname, racenumber, finishtime, year
Each year, runners will be issued a unique race (bib) number. However, the same set of numbers will be used each year.
What is the best way of keeping the racenumber field unique for each year? (i.e. racenumber must be a unique number between 1 and 200 for year 2015, and then again must be a unique number between 1 and 200 for year 2016 etc)