MYSQL recreate primary key/ index

https://stackoverflow.com/questions/5132923/how-to-add-a-primary-key-to-a-mysql-table

alter table goods drop column `id`;

alter table goods add column `id` int(11) unsigned primary KEY AUTO_INCREMENT;