[wp-trac] [WordPress Trac] #2699: Make option_name index unique

[WordPress Trac]

#2699: Make option_name index unique
-----------------------------------------+----------------------------------
 Reporter:  johnjosephbachir             |        Owner:  ryan    
     Type:  task (blessed)               |       Status:  reopened
 Priority:  high                         |    Milestone:  2.9     
Component:  Optimization                 |      Version:  2.8     
 Severity:  normal                       |   Resolution:          
 Keywords:  early has-patch 2nd-opinion  |  
-----------------------------------------+----------------------------------

Comment(by ryan):

 Some WPMU installs use InnoDB for the options table.  Having a varchar as
 the primary key isn't the best for InnoDB since it prefers small,
 sequential primary keys.  Should we make option_id primary and option_name
 unique?

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