[wp-trac] [WordPress Trac] #33376: Create index on user_email and UNIQUE on user_nicename, user_email and user_login

[WordPress Trac]

#33376: Create index on user_email and UNIQUE on user_nicename, user_email and
user_login
------------------------------------+-----------------------------
 Reporter:  chriscct7               |       Owner:  chriscct7
     Type:  enhancement             |      Status:  assigned
 Priority:  normal                  |   Milestone:  Future Release
Component:  Database                |     Version:
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |     Focuses:  performance
------------------------------------+-----------------------------

Comment (by chriscct7):

 Replying to [comment:6 knutsp]:
 > If this goes in, please use localpart+username at example.com to make
 duplicate email unique and not vice versa. Gmail supports
 localpart+somestring at gmail.com as aliases for localpart at gmail.com. Then,
 for all users with Gmail, and maybe more, this will work out of the box.

 The patch does exactly this :-) so no worries there.


 > Core has allowed duplicate emails on users for a decade (?), even if
 it's not the internal default and intention.

 Core actually hasn't supported this. Calling any register user function
 checks fora unique email and has for a while plugins like multiple email
 employ methods that work around all of WordPress's internal checks.

 That being said this is still a proposal and there is alot more that will
 be done on this. If you subscribe to the ticket, you'll get an email
 anytime someone comments or the status of this proposal changes.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/33376#comment:7>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform