ALTER TABLE `x` DROP `id`;
ALTER TABLE `x` AUTO_INCREMENT = 1;
ALTER TABLE `x` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;