ALTER TABLE `$table` CHANGE `id` `id` INT( 11 ) NOT NULL; ALTER TABLE `$table` DROP PRIMARY KEY ; ALTER TABLE `$table` ADD `version_id` INT NOT NULL AUTO_INCREMENT , ADD `version_created` DATETIME NOT NULL , ADD PRIMARY KEY ( `version_id` ) ; ALTER TABLE `$table` DROP PRIMARY KEY , ADD PRIMARY KEY ( `version_id` )