数据库:auth数据库:account
这是本文档旧的修订版！
account 表
表结构
| Field | Type | Attributes | Key | Null | Default | extra | Comment |
|---|---|---|---|---|---|---|---|
| id | INT | UNSIGNED | PRI | NO | AUTO_INCREMENT | Identifier | |
| username | VARCHAR(32) | SIGNED | UNI | NO | | | |
|salt|BINARY(32)|SIGNED| |NO| | | |
|verifier|BINARY(32)|SIGNED| |NO| | | |
|session_key|BINARY(40)|SIGNED| |YES| | | |
|totp_secret|VARBINARY(100)|SIGNED| |YES| | | |
|email|VARCHAR(255)|SIGNED| |NO| | ||
| reg_mail | VARCHAR(255) | SIGNED | NO | | | |
|joindate|TIMESTAMP|SIGNED| |NO|CURRENT_TIMESTAMP| | |
|last_ip|VARCHAR(15)|SIGNED| |NO|127.0.0.1| | |
|last_attempt_ip|VARCHAR(15)|SIGNED| |NO|127.0.0.1| | |
|failed_logins|INT|UNSIGNED| |NO|0| | |
|locked|TINYINT|UNSIGNED| |NO|0| | |
|lock_country|VARCHAR(2)|SIGNED| |NO|0| | |
|last_login|TIMESTAMP|SIGNED| |YES| | | |
|online|INT|UNSIGNED| |NO|0| | |
|expansion|TINYINT|UNSIGNED| |NO|2| | |
|mutetime|BIGINT|SIGNED| |NO|0| | |
|mutereason|VARCHAR(255)|SIGNED| |NO| | |||
| muteby | VARCHAR(50) | SIGNED | NO | | | |
|locale|TINYINT|UNSIGNED| |NO|0| | |
|os|VARCHAR(3)|SIGNED| |NO| | |||
| recruiter | INT | UNSIGNED | NO | 0 | |||
| totaltime | INT | UNSIGNED | NO | 0 |
字段说明
数据库/auth数据库/account.1695515408.txt.gz · 最后更改: 2023/09/24 08:30 由 admin