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