[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):

 @dd32: A foreign key constraint can only reference a single table.
 Currently, a constraint on wp_term_relationships(object_id) referencing
 wp_posts(ID) would fail for this reason -- it could also be a link id. The
 performance implication is you cannot easily do: delete from
 wp_term_relationships where object_id = $post->ID. Merging meta tables
 would lead us to similar problems.

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