[wp-trac] Re: [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             |  
------------------------------+---------------------------------------------

Comment(by ryan):

 Adds a function that is run before the schema is upgraded. That function
 deletes duplicate options.  The high option ID is kept, the rest deleted.
 Then a new unique key is added. dbDelta doesn't seem to delete the old
 key, so we might need to add an explicit delete to the upgrade.

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