ALTER TABLE table ADD COLUMN id INT(10) UNSIGNED NOT NULL auto_increment PRIMARY KEY;
ή
ALTER TABLE table ADD COLUMN id INT(10) UNSIGNED NOT NULL auto_increment, ADD PRIMARY KEY (id);
ALTER TABLE table DROP COLUMN id
#unique #auto_increment
ή
#unique #auto_increment