WordPress.org

Make WordPress Core

Changeset 36654


Ignore:
Timestamp:
02/23/2016 11:20:36 PM (2 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.

Location:
trunk/src
Files:
2 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
  • trunk/src/wp-includes/version.php

    r36589 r36654  
    1212 * @global int $wp_db_version
    1313 */
    14 $wp_db_version = 36180;
     14$wp_db_version = 36654;
    1515
    1616/**
Note: See TracChangeset for help on using the changeset viewer.