Account access 548

From Project Skyfire
Revision as of 10:51, 14 June 2025 by Augustomendes4426 (talk | contribs) (Augustomendes4426 moved page DB:Auth:account access 548 to Account access 548: Removing prefix to match with world and to come characters wiki)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.