Extension:ConfirmAccount/account requests table
Appearance
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 | | | | +-------------------------+-----------------------+------+-----+---------+----------------+