You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When running the show create table query, the returned create statement does not contain the sequence number for the auto-increment column. It would be good to add this. It can be obtained from the sqlite_sequence table.
Here is an example of a create statement that has the current value for the auto increment column:
CREATETABLE `wp_options` (
`option_id`bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`option_name`varchar(191) NOT NULL DEFAULT '',
`option_value` longtext NOT NULL,
`autoload`varchar(20) NOT NULL DEFAULT 'yes',
PRIMARY KEY (`option_id`),
UNIQUE KEY `option_name` (`option_name`),
KEY `autoload` (`autoload`)
) ENGINE=InnoDB AUTO_INCREMENT=313 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
And here is one that the plugin returns:
DROPTABLE IF EXISTS `wp_options`;
CREATETABLE `wp_options` (
`option_id`bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`option_name`varchar(191) NOT NULL DEFAULT '',
`option_value` longtext NOT NULL DEFAULT '',
`autoload`varchar(20) NOT NULL DEFAULT 'yes',
PRIMARY KEY (`option_id`),
KEY `autoload` (`autoload`),
UNIQUE KEY `option_name` (`option_name`)
);
The text was updated successfully, but these errors were encountered:
When running the
show create table
query, the returned create statement does not contain the sequence number for the auto-increment column. It would be good to add this. It can be obtained from thesqlite_sequence
table.Here is an example of a create statement that has the current value for the auto increment column:
And here is one that the plugin returns:
The text was updated successfully, but these errors were encountered: