https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
--- Comment #10 from Joerg <[email protected]> 2012-01-13 13:41:58 UTC --- I could not find anything on changing an existing index into a PK in the MySQL docs. Also professional DB Tools like MySQL GUI Tools, MySQL Workbench (and also phpMyAdmin) just DROP the old index and ADD the new Primary Key (also when you do both at the same time). This is an according example output: ALTER TABLE `x` ADD PRIMARY KEY (`field`), DROP INDEX `field`; -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
