[wp-trac] [WordPress Trac] #4780: $table_prefix should not be encoded in table_names.

[WordPress Trac]

#4780: $table_prefix should not be encoded in table_names.
----------------------------+-----------------------------------------------
 Reporter:  docwhat         |       Owner:  anonymous   
     Type:  defect          |      Status:  new         
 Priority:  normal          |   Milestone:  2.4 (future)
Component:  Administration  |     Version:              
 Severity:  normal          |    Keywords:              
----------------------------+-----------------------------------------------
 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/

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4780>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software