Ext mng / compare: missing columns with auto_increments
I found a plugin where, for some strange reasons, one field was not created upon install of the extension. Nevertheless, the install tool, as well as ext. mng. has no problem of reproducing and displaying the error.
This would ordinary work fine, but with auto_increment values you need to specify the primary key as well in the same SQL stmt.
i.e. my problem was presented as if two sql stmts needed to be fired away:
ALTER TABLE `tx_veguestbook_entries` ADD `uid` INT UNSIGNED NOT NULL AUTO_INCREMENT
ALTER TABLE `tx_veguestbook_entries` PRIMARY KEY
This should of course have been:
ALTER TABLE `tx_veguestbook_entries` ADD `uid` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
Ofcourse this problem might only relate to extensions which exhibit this particular flaw, but AFAIK MySQL will not accept the SQL stmt. 1) since auto_increment should be pri key!
I'd ofcourse be happy to correct the issue if anyone can point me in the direction of the source to diff
(issue imported from #M4125)