Extension:CentralAuth/globaluser table
Fields
[edit]Some of this information is adapted from CentralAuth's tables.json file.
gu_id
[edit]Internal unique ID for the authentication server
gu_name
[edit]The user name.
gu_home_db
[edit]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
[edit]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
[edit]Timestamp when the address was confirmed as belonging to the user. NULL if not confirmed.
gu_password
[edit]hashed password
gu_locked
[edit]If true, this account cannot be used to log in on any wiki.
gu_hidden_level
[edit]If true, this account should be hidden from most public user lists. Used for 'deleting' accounts without breaking referential integrity.
gu_registration
[edit]Registration time
gu_password_reset_key
[edit]Random key for password resets
gu_auth_token
[edit]Random key for crosswiki authentication tokens
gu_cas_token
[edit]Value used for CAS operations
Schema summary
[edit]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 | |
+------------------------------+---------------------------------------+------+-----+---------+----------------+
