WP options table and auto_increment

Firstly, very nice plugin. 🙂

After successfully using the plugin a while ago, I recently cloned the database from one place to another (using workbench). I received a warning that MySQL wouldn’t add auto_increment to a non-primary column.

The original database does still have auto_increment applied to the option_id column, but the copied version doesn’t.

EDIT: I’m assuming this might be related to how the table is re-created in the clone, as I did read in the plugin comments that’s it’s necessary for option_id unique index to be the first one in order to retain auto_increment (and I assume the cloning process might put the primary key first).

Would it make sense for the plugin to add auto_increment if it’s missing on the option_id column, when reverting to the standard indexes or (re-)applying the optimised indexes?

• This topic was modified 8 months ago by codi0.