DB:Auth:account access 548

From Project Skyfire
Jump to navigation Jump to search

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.