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

[WordPress Trac]

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

Comment(by ryan):

 dbDelta() doesn't handle changing around primary keys so I did it by hand
 in pre_schema_upgrade().  I also kept option_id and blog_id around for now
 just in case some plugins are using it. I'd like to avoid even small
 plugin breakages in 2.9.  We can deprecate these later.  Unfortunately,
 since option_id is auto_increment we have to put a key on it until we are
 rid of it.

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