Make WordPress Core


Ignore:
Timestamp:
02/23/2016 11:20:36 PM (8 years ago)
Author:
ocean90
Message:

Schema: Add an index to wp_users.user_email.

Improves lookup of an email address on large user tables.

See #9568.
Fixes #33376.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/src/wp-admin/includes/schema.php

    r36416 r36654  
    205205  PRIMARY KEY  (ID),
    206206  KEY user_login_key (user_login),
    207   KEY user_nicename (user_nicename)
     207  KEY user_nicename (user_nicename),
     208  KEY user_email (user_email)
    208209) $charset_collate;\n";
    209210
     
    224225  PRIMARY KEY  (ID),
    225226  KEY user_login_key (user_login),
    226   KEY user_nicename (user_nicename)
     227  KEY user_nicename (user_nicename),
     228  KEY user_email (user_email)
    227229) $charset_collate;\n";
    228230
Note: See TracChangeset for help on using the changeset viewer.