Extension:CentralAuth/globaluser table
Fields
Some of this information is adapted from CentralAuth's tables.json file.
gu_id
Internal unique ID for the authentication server
gu_name
The user name.
gu_home_db
Local database name of the user's 'home' wiki. By default, the 'winner' of a migration check for old accounts or the account the user was first registered at for new ones. May be changed over time.
Note that this field is not always set (T316472) and may not be reliable.
gu_email
Registered email address. The field is not nullable, so users who have not given an email address have an empty string set.
gu_email_authenticated
Timestamp when the address was confirmed as belonging to the user. NULL if not confirmed.
gu_password
hashed password
gu_locked
If true, this account cannot be used to log in on any wiki.
gu_hidden_level
If true, this account should be hidden from most public user lists. Used for 'deleting' accounts without breaking referential integrity.
gu_registration
Registration time
gu_password_reset_key
Random key for password resets
gu_auth_token
Random key for crosswiki authentication tokens
gu_cas_token
Value used for CAS operations
Schema summary
mysql> describe globaluser;
+------------------------------+---------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+---------------------------------------+------+-----+---------+----------------+
| gu_id | int(11) | NO | PRI | NULL | auto_increment |
| gu_name | varbinary(255) | YES | UNI | NULL | |
| gu_enabled | varbinary(14) | NO | | | |
| gu_enabled_method | enum('opt-in','batch','auto','admin') | YES | | NULL | |
| gu_home_db | varbinary(255) | YES | | NULL | |
| gu_email | varbinary(255) | YES | MUL | NULL | |
| gu_email_authenticated | binary(14) | YES | | NULL | |
| gu_salt | varbinary(16) | YES | | NULL | |
| gu_password | tinyblob | YES | | NULL | |
| gu_locked | tinyint(1) | NO | | 0 | |
| gu_hidden | varbinary(255) | NO | | | |
| gu_registration | varbinary(14) | YES | | NULL | |
| gu_password_reset_key | tinyblob | YES | | NULL | |
| gu_password_reset_expiration | varbinary(14) | YES | | NULL | |
| gu_auth_token | varbinary(32) | YES | | NULL | |
| gu_cas_token | int(10) unsigned | NO | | 1 | |
+------------------------------+---------------------------------------+------+-----+---------+----------------+
