[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:  tested            |  
------------------------------+---------------------------------------------

Comment(by barry):

 Replying to [comment:42 Denis-de-Bernardy]:
 > Replying to [comment:40 barry]:
 > > KEY autoload (autoload)
 > >
 > > is what we would want.
 >
 > Barry is actually right, here. It's really meant for fetching all
 autoloaded options. The unique index on option name is fine for queries
 that have both in the where clause. I'll attach a patch in a sec.

 The patch still has the UNIQUE in there - it needs to be removed.

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