Jump to content

Extension:ConfirmAccount/account requests table

From mediawiki.org

Schema

[edit]
mysql> describe account_requests;
+-------------------------+-----------------------+------+-----+---------+----------------+
| Field                   | Type                  | Null | Key | Default | Extra          |
+-------------------------+-----------------------+------+-----+---------+----------------+
| acr_id                  | int(10) unsigned      | NO   | PRI | NULL    | auto_increment |
| acr_name                | varbinary(255)        | NO   | UNI |         |                |
| acr_real_name           | varbinary(255)        | NO   |     |         |                |
| acr_email               | varbinary(255)        | NO   | MUL | NULL    |                |
| acr_email_authenticated | varbinary(14)         | YES  |     | NULL    |                |
| acr_email_token         | binary(32)            | YES  | MUL | NULL    |                |
| acr_email_token_expires | varbinary(14)         | YES  |     | NULL    |                |
| acr_bio                 | mediumblob            | NO   |     | NULL    |                |
| acr_notes               | mediumblob            | NO   |     | NULL    |                |
| acr_urls                | mediumblob            | NO   |     | NULL    |                |
| acr_ip                  | varbinary(255)        | YES  |     |         |                |
| acr_xff                 | varbinary(255)        | YES  |     |         |                |
| acr_agent               | varbinary(255)        | YES  |     |         |                |
| acr_filename            | varbinary(255)        | YES  |     | NULL    |                |
| acr_storage_key         | varbinary(64)         | YES  |     | NULL    |                |
| acr_type                | tinyint(255) unsigned | NO   | MUL | 0       |                |
| acr_areas               | mediumblob            | NO   |     | NULL    |                |
| acr_registration        | varbinary(14)         | NO   |     | NULL    |                |
| acr_deleted             | tinyint(1)            | NO   |     | NULL    |                |
| acr_rejected            | varbinary(14)         | YES  |     | NULL    |                |
| acr_held                | varbinary(14)         | YES  |     | NULL    |                |
| acr_user                | int(10) unsigned      | NO   |     | 0       |                |
| acr_comment             | varbinary(255)        | NO   |     |         |                |
+-------------------------+-----------------------+------+-----+---------+----------------+