====== character_banned 表 ====== ---- [[数据库:characters数据库:首页|<-返回:Characters 数据库]] This table lists all of the characters that have been banned along with the date when (or if) the ban will expire. **表结构** ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ |[[#guid|guid]]|INT|UNSIGNED|PRI|NO|0| |Global Unique Identifier| |[[#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| | | ===== 字段说明 ===== ---- ==== guid ==== The character guid. See characters.guid. ==== bandate ==== The date when the character was banned, in Unix time. ==== unbandate ==== The date when the character will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban. ==== bannedby ==== The character with the rights to the .ban command that banned the character. ==== banreason ==== The reason for the ban. ==== active ==== Boolean 0 or 1 controlling if the ban is currently active or not.