Extension:CentralAuth/localuser table

This table contains an entry for each local user account in the wiki farm which is globally attached.

Fields

Some of this information is adapted from CentralAuth's tables.json file.

lu_wiki

lu_name

lu_attached_timestamp

Migration status/logging information, to help diagnose issues

lu_attached_method

Migration status/logging information, to help diagnose issues. See CentralAuthUser::attach()

Possible values:

  • primary: This account existed before central accounts were introduced, and got picked as the central account owner. See CentralAuthUser::chooseHomeWiki().
  • new: Created during signup (ie. the user registered when central accounts were already enabled, and this is their first account).
  • empty: Not used anymore - probably accounts with zero edits that got merged into the global account by the same name, regardless of email etc?
  • mail: Merged because it had the same email as the central account, or a connected local account.
  • password: Merged (on login or via Special:MergeAccount) because it had the same password as the central account. (Or in some historical edge cases because it had no password - T63876.)
  • admin: Merged by an admin.
  • login: Autocreated when the central user visited a wiki with no local account.

lu_attachment_method

Part of a pending schema migration for lu_attached_method (T304015)

lu_local_id

Foreign key to the user_id field in the local wiki's user table

lu_global_id

Foreign key to the gu_id field in the globaluser table

Schema summary

mysql> describe localuser;
+-----------------------+-----------------------------------------------------------------+------+-----+---------+-------+
| Field                 | Type                                                            | Null | Key | Default | Extra |
+-----------------------+-----------------------------------------------------------------+------+-----+---------+-------+
| lu_wiki               | varbinary(255)                                                  | NO   | PRI | NULL    |       |
| lu_name               | varbinary(255)                                                  | NO   | PRI | NULL    |       |
| lu_attached_timestamp | varbinary(14)                                                   | YES  |     | NULL    |       |
| lu_attached_method    | enum('primary','empty','mail','password','admin','new','login') | YES  |     | NULL    |       |
| lu_local_id           | int(10) unsigned                                                | YES  |     | NULL    |       |
| lu_global_id          | int(10) unsigned                                                | YES  |     | NULL    |       |
+-----------------------+-----------------------------------------------------------------+------+-----+---------+-------+
Category:Wikimedia extension database tables#localuser%20table
Category:Wikimedia extension database tables