[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 has-patch 2nd-opinion  |  
-----------------------------------------+----------------------------------
Changes (by Denis-de-Bernardy):

  * keywords:  early => early has-patch 2nd-opinion


Comment:

 suggesting we do the following:

  - ensure no more dups exist in 2.8
  - drop the option_id field
  - primary key (blog_id, option_name)
  - drop key(option_name), when then becomes unneeded (and which is useless
 when there are several blog_ids)

 or:

  - keep option_id field and ignore it
  - primary key (blog_id, option_name)
  - drop key(option_name)

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