[wp-trac] [WordPress Trac] #15004: Missing index on signups table

[WordPress Trac]

#15004: Missing index on signups table
------------------------------+-----------------------
 Reporter:  barry             |       Owner:  pento
     Type:  defect (bug)      |      Status:  assigned
 Priority:  normal            |   Milestone:  3.5
Component:  Database          |     Version:
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |
------------------------------+-----------------------

Comment (by nacin):

 Removal of the `domain` key would happen in `pre_schema_upgrade()`, if
 `is_multisite() && is_main_site() && ! defined(
 'DO_NOT_UPGRADE_GLOBAL_TABLES' )`.

 We need a way to not fire the DROP INDEX for this for every main site of a
 multi-network. There's no harm in running a DROP INDEX on an index that
 doesn't exist (we will need to suppress errors) or we can first check if
 the index is there before dropping it.

 We can do this prior to beta 2.

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