Thanks, Luckily the design had not yet been implemented. What does the above mean, Make it and index? And will the autoincrement field be given a value for every row created without specifying it to do so?
You will need to read up on mysql before you dig to far into this project. auto inc type columns will auto increment the value for new inserts this combined with defining the column as unique and indexing will give you what you want.