id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
11266	Database upgrade error on wp_options key	nacin	ryan	"Updating to trunk, I got:

WordPress database error: [Incorrect table definition; there can be only one auto column and it must be defined as a key]
ALTER TABLE wp_options DROP INDEX option_id

This is the structure of wp_options.

CREATE TABLE `wp_options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `blog_id` int(11) NOT NULL DEFAULT '0',
  `option_name` varchar(64) 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`),
  UNIQUE KEY `autoloaded_options` (`autoload`,`option_name`),
  KEY `option_id` (`option_id`)
)

Probably related: #2699, #10994."	defect (bug)	closed	normal	2.9	Database	2.9	major	fixed	needs-testing