数据库: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 | ||||
| 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.1695515467.txt.gz · 最后更改: 2023/09/24 08:31 由 admin