Extension:CentralAuth/globaluser table

From MediaWiki.org
Jump to navigation Jump to search
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       |                |
+------------------------------+---------------------------------------+------+-----+---------+----------------+