DB:Auth:account access 548

Back to auth database list of tables.

The `account_access` table

This table holds security access level for any realm in realmlist table.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
id	int(10)	unsigned	PRI	NO
gmlevel	tinyint(3)	unsigned		NO
RealmID	int(11)	signed	PRI	NO	-1

DB Structure

CREATE TABLE `account_access` (
	`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.