====== account_banned 表 ====== ---- [[数据库:auth数据库:首页|<-返回:Auth 数据库]] This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire. **表结构** ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ |[[#id|id]]|INT|UNSIGNED|PRI|NO|0| |Account id| |[[#bandate|bandate]]|INT|UNSIGNED|PRI|NO|0| | | |[[#unbandate|unbandate]]|INT|UNSIGNED| |NO|0| | | |[[#bannedby|bannedby]]|VARCHAR(50)|SIGNED| |NO| | | | |[[#banreason|banreason]]|VARCHAR(255)|SIGNED| |NO| | | | |[[#active|active]]|TINYINT|UNSIGNED| |NO|1| | | ===== 字段说明 ===== ---- ==== id ==== The account ID. See [[数据库:auth数据库:account#id|account.id]]. ==== bandate ==== The date when the account was banned, in Unix time. ==== unbandate ==== The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban. ==== bannedby ==== The GM character's name who banned that account. If banned from the console, then it will be empty (until improved). ==== banreason ==== The reason for the ban. ==== active ==== Boolean 0 or 1 controlling if the ban is currently active or not.