WordPress.org

Make WordPress Core

Changeset 36654


Ignore:
Timestamp:
02/23/16 23:20:36 (21 months 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.