id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
11322	Changes needed to schema for new options table keys	nacin	ryan	"Looks like dbDelta is attempting to modify the new option_name and autoloaded_options keys. Not a blocker as I first thought -- dbDelta fails silently -- but $wp_queries is invalid in dbDelta's eyes, so it should be changed.

This is due to the very finicky nature of dbDelta, in this case requiring the word ""KEY"" in addition to ""UNIQUE"" and not wanting spaces between fields in an index.

Ideally, dbDelta can be improved in the future by preventing such stumbles, particularly with regard to whitespace.

The Codex should probably be updated as well. It currently identifies the two spaces required for primary keys and the need to use KEY over INDEX, but it doesn't mention other whitespace requirements.

Xref: #11266, #10404"	defect (bug)	closed	high	2.9	Database	2.9	major	fixed	has-patch