id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
4780	$table_prefix should not be encoded in table_names.	docwhat	anonymous	"Currently, the following columns have the $table_prefix within their name:

 table_prefix_options.table_prefix_user_roles
 table_prefix_usermeta.table_prefix_capabilities
 table_prefix_usermeta.table_prefix_user_level
 table_prefix_usermeta.table_prefix_autosave_draft_ids

Where 'table_prefix_' is the $table_prefx.

Using the $table_prefix this way causes needless headaches(1) and
makes the database schema more brittle than it needs to be.

Making this change will allow changing the $table_prefix to be trivial.

Ciao!

(1)
  http://www.eligeotravez.net/2007/04/17/changing-table-prefix-for-wordpress/
  http://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-to-access-this-page/
"	defect (bug)	closed	normal		Administration		normal	invalid		Converting2wp