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

Some of this information is adapted fromCentralAuth'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 theuser_id field in the local wiki'suser table

Foreign key to thegu_id field in theglobaluser 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