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