Augustomendes4426: Augustomendes4426 moved page DB:Auth:account access 548 to Account access 548: Removing prefix to match with world and to come characters wiki

2025-06-14T15:51:38Z

Augustomendes4426 moved page DB:Auth:account access 548 to Account access 548: Removing prefix to match with world and to come characters wiki

← Older revision	Revision as of 10:51, 14 June 2025
(No difference)

Admin: Add content and update

2021-08-09T23:24:12Z

Add content and update

New page

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<big>'''The `account_access` table'''</big>

This table holds security access level for any realm in [[DB:Auth:realmlist|realmlist]] table.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#id|id]]
|int(10)
|unsigned
|PRI
|NO
|
|
|
|-
|[[#gmlevel|gmlevel]]
|tinyint(3)
|unsigned
|
|NO
|
|
|
|-
|[[#RealmID|RealmID]]
|int(11)
|signed
|PRI
|NO
|<nowiki>-1</nowiki>
|
|
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
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
;
</pre>

<big>'''Description of the fields'''</big>

==== 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.

Account access 548 - Revision history

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account access 548 to Account access 548: Removing prefix to match with world and to come characters wiki

Admin: Add content and update