account_banned Table¶
Account ban records with reason and expiration.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
banid |
bigint(20) | UNI | NO | auto_increment | |
id |
bigint(20) | PRI | NO | 0 | |
bandate |
bigint(40) | PRI | NO | 0 | |
unbandate |
bigint(40) | NO | 0 | ||
bannedby |
varchar(50) | NO | |||
banreason |
varchar(255) | NO | |||
active |
tinyint(4) | NO | 1 | ||
realm |
tinyint(4) | NO | 1 | ||
gmlevel |
tinyint(4) unsigned | NO | 0 |
Field Breakdown¶
banid- Unique. Ban record id.id- Primary Key. Account id fromaccount.id.bandate- Primary Key. Start unix timestamp of the ban.unbandate- End unix timestamp of the ban (equal tobandatefor permanent bans).bannedby- Name of the staff member or console that issued the ban.banreason- Reason text shown to staff.active- 1 while ban is in effect; expired bans are deactivated at startup.realm- Id of the realm that issued the ban.gmlevel- Minimum GM level required to view the ban reason via.baninfo(note: the core currently misreads the joined realm-name column for this check, so the value has no effect).