Jump to content

Extension:ConfirmAccount/account credentials table

From mediawiki.org

Schema

[edit]
mysql> describe account_credentials;
+-------------------------+------------------+------+-----+---------+----------------+
| Field                   | Type             | Null | Key | Default | Extra          |
+-------------------------+------------------+------+-----+---------+----------------+
| acd_id                  | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| acd_user_id             | int(10) unsigned | NO   | MUL | NULL    |                |
| acd_real_name           | varbinary(255)   | NO   |     |         |                |
| acd_email               | tinyblob         | NO   |     | NULL    |                |
| acd_email_authenticated | varbinary(14)    | YES  |     | NULL    |                |
| acd_bio                 | mediumblob       | NO   |     | NULL    |                |
| acd_notes               | mediumblob       | NO   |     | NULL    |                |
| acd_urls                | mediumblob       | NO   |     | NULL    |                |
| acd_ip                  | varbinary(255)   | YES  |     |         |                |
| acd_xff                 | varbinary(255)   | YES  |     |         |                |
| acd_agent               | varbinary(255)   | YES  |     |         |                |
| acd_filename            | varbinary(255)   | YES  |     | NULL    |                |
| acd_storage_key         | varbinary(64)    | YES  |     | NULL    |                |
| acd_areas               | mediumblob       | NO   |     | NULL    |                |
| acd_registration        | varbinary(14)    | NO   |     | NULL    |                |
| acd_accepted            | varbinary(14)    | YES  |     | NULL    |                |
| acd_user                | int(10) unsigned | NO   |     | 0       |                |
| acd_comment             | varbinary(255)   | NO   |     |         |                |
+-------------------------+------------------+------+-----+---------+----------------+