[wp-trac] Re: [WordPress Trac] #5183: General Meta-Data Table

[WordPress Trac]

#5183: General Meta-Data Table
-----------------------------------------+----------------------------------
 Reporter:  filosofo                     |        Owner:  anonymous     
     Type:  enhancement                  |       Status:  reopened      
 Priority:  normal                       |    Milestone:  Future Release
Component:  General                      |      Version:  2.9           
 Severity:  normal                       |   Resolution:                
 Keywords:  needs-patch meta-table meta  |  
-----------------------------------------+----------------------------------

Comment(by Denis-de-Bernardy):

 Personally, I'd rather see the schema changed as follows:

  - wp_posts
  - wp_postmeta
  - wp_users
  - wp_usermeta
  - wp_links
  - wp_linkmeta
  - wp_terms
  - wp_termmeta
  - wp_term2post
  - wp_term2link
  - wp_term2user (assuming we want that around too; this would allow us to
 manage user roles as a taxonomy)

 ... that way you can have foreign keys and proper indexes everywhere. But
 it's a discussion we should be having during an IRC meet-up.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/5183#comment:25>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software