[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:  Future Release
Component:  Database      |     Version:  2.9           
 Severity:  normal        |    Keywords:  needs-patch   
--------------------------+-------------------------------------------------
Changes (by scribu):

  * keywords:  => needs-patch
  * milestone:  2.9 => Future Release


Comment:

 When trying to add a UNIQUE index to post_id, meta_key and meta_value I
 get an error:

 {{{
 #1170 - BLOB/TEXT column 'meta_value' used in key specification without a
 key length
 }}}

 So this will have to be resolved through the *_metadata() API.

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