[wp-trac] [WordPress Trac] #10905: Add UNIQUE(post_id, meta_key, meta_value) constraint to meta tables

[WordPress Trac]

#10905: Add UNIQUE(post_id, meta_key, meta_value) constraint to meta tables
--------------------------+-------------------------------------------------
 Reporter:  scribu        |       Owner:  ryan
     Type:  defect (bug)  |      Status:  new 
 Priority:  normal        |   Milestone:  2.9 
Component:  Database      |     Version:  2.9 
 Severity:  normal        |    Keywords:      
--------------------------+-------------------------------------------------
 Having these two rows in a meta table shouldn't be allowed:


 {{{
 meta_id         post_id         meta_key        meta_value
 1000            1               foo             bar
 1001            1               foo             bar
 }}}

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