Extension:CentralAuth/localuser table

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

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

Migration status/logging information, to help diagnose issues

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.

Part of a pending schema migration for lu_attached_method (T304015)

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

Foreign key to the gu_id field in the globaluser table

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 | |
+-----------------------+-----------------------------------------------------------------+------+-----+---------+-------+

• Wikimedia extension database tables