It appears I may have been redundant with my 'unique index' comments - oh 
well :D

By the way, in response to the original query. I havent used MySQL, but 
you *should* be able to 

   a) drop the primary key on the table
   b) add the auto-increment field to the table (it doesnt really have to 
be the first field, but it is neater)
   c) create the primary key again using the auto increment field

Or, more than likely, create the new table in the structure you require, 
copy the data over, then drop the original table and rename the new one to 
the old one's name.


