DB:Auth:account banned 548

Back to auth database list of tables.

The `account_banned` table

This table holds banned users

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
id	int(10)	unsigned	PRI	NO
bandate	int(10)	unsigned		NO
unbandate	int(10)	unsigned		NO
bannedby	varchar(50)	unsigned		NO
banreason	varchar(255)	unsigned		NO
active	tinyint(5)	unsigned		NO	-1

DB Structure

CREATE TABLE `account_banned` (
	`id` INT NOT NULL,
	`gmlevel` TINYINT NOT NULL,
	`RealmID` INT NOT NULL DEFAULT -1,
	PRIMARY KEY (`id`, `RealmID`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

Description of the fields

id

The account ID.

gmlevel

The account security level. Different levels have access to different commands. The individual level required for a command is defined in the command table in each realm.

RealmID

The Realm ID.