[wpmu-trac] [WordPress MU Trac] #335: wp_*_options should have UNIQUE index on blog_id AND option_name

[WordPress MU Trac]

#335: wp_*_options should have UNIQUE index on blog_id AND option_name
--------------------------+-------------------------------------------------
 Reporter:  gwagenknecht  |       Owner:  somebody
     Type:  defect        |      Status:  new     
 Priority:  normal        |   Milestone:          
Component:  component1    |     Version:          
 Severity:  normal        |    Keywords:          
--------------------------+-------------------------------------------------
 The primary index is on option_id, blog_id and option_name. I'm not sure
 if that makes sense because option_id looks like the real primary key.

 Anyway, there should be a UNIQUE index on blog_id and option_name.

 Note, I discovered double entries in my database, i.e. in one table
 several options were defined twice for the same blog_id. This probably
 means that some sanity checking and merging is necessary before the index
 can be created on existing blogs

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/335>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser