Description of the 'account' table.

This table holds information on all available accounts.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

The unique account ID.

username varchar(32)

The account user name.

sha_pass_hash varchar(40)

This field contains the encrypted password. The encryption is SHA1 and is in the following format: username:password. The SQL to create the password (or to compare with the current hash) is:

SELECT SHA1(CONCAT(UPPER(`username`), ':', UPPER({pass})));

gmlevel tinyint(3) unsigned

The account security level. Different levels have access to different commands. The individual level required for a command is defined in the Mangos command table. Valid values are:

Value	Description
0	Player
1	Moderator
2	Gamemaster
3	Administrator
4	Access control within the world server console only

sessionkey longtext

The SessionKey - this is the validated result of the login negotiation. This allows disconnected clients to reconnection to their previous session.

v longtext

The validated Hash Value, this is created by using the 'Salt' value [See account.s] applied to the username/password SHA1 hash (See account.sha_pass_hash).

s longtext

Password 'Salt' Value. Initially a randomly generated value, which when applied against the SHA1 hash of the username / password combo [See account.sha_pass_hash] produces the validation hash (See account.v).

email text

The e-mail address associated with this account.

joindate timestamp

The date when the account was created.

last_ip varchar(30)

The last IP used by the person who last logged into the account.

failed_logins int(11) unsigned

The number of failed logins attempted on the account. Monitoring this field may help spotting users who try to gain access to accounts which are not their own, or who have forgotten their passwords.

locked tinyint(3) unsigned

Boolean 0 or 1 controlling if the account has been locked or not.

last_login timestamp

The date when the account was last logged into.

active_realm_id int(11) unsigned

This Field contains the RealmId of the last realm that the account was used on.

expansion tinyint(3) unsigned

The field controls to which expansion's content a user has access. By default this is set to 0, allowing access to vanilla WoW content. In mangos-zero, other values can be ignored, since there is no expansion.

Value	Expansion
0	World of Warcraft *
1	Burning Crusade
2	Wrath of the Lich King
3	Cataclysm
4	Mists of Pandaria
5	Warlords of Draenor
6	Legion
7	Battle for Azeroth

* Base Game Version of World of Warcraft, otherwise known as Vanilla. The world server will block access to accounts with 0 in this field from accessing the TBC and WotLK areas in-game. The world server will block access to accounts with 1 in this field from accessing the WotLK areas in-game and so on.

mutetime bigint(40) unsigned

The time, in Unix time, when the account will be unmuted.

SELECT `username`, FROM_UNIXTIME(`mutetime`) FROM `account`;

locale tinyint(3) unsigned

The locale used by the client logged into this account. If multiple locale data has been configured and added to the world servers, the world servers will return the proper locale strings to the client.

Value	Language
0	English
1	Korean
2	French
3	German
4	Chinese
5	Taiwanese
6	Spanish Spain
7	Spanish Latin America
8	Russian

os varchar(3)

The Operating System of the connected client. This is used by the Warden Module

playerBot bit(1)

Determines whether the account is a User or a PlayerBot.

Value	Account Type
0	Normal User
1	Playerbot account

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'account_banned' table.

This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

The account ID [See account.id].

bandate bigint(40)

The date when the account was banned, in Unix time.

unbandate bigint(40)

The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.

bannedby varchar(50)

The character with the rights to the .ban command that banned the account.

banreason varchar(255)

The reason for the ban.

active tinyint(4)

This is a Boolean field controlling if the ban is currently active or not.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'db_version' table.

This table holds the current version of the MaNGOS world database

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

version int(3)

The Version of the Release, any mismatch prevents the server from starting.

structure int(3)

The current core structure level, any mismatch prevents the server from starting.

content int(3)

The current core content level, The server will start if there is a mismatch, but will issue a warning message

description varchar(30)

A short description of the latest database revision.

comment varchar(150)

A comment about the latest database revision.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'ip_banned' table.

This table contains all of the banned IPs and the date when (or if) the ban will expire.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

ip varchar(32)

The IP address that is banned.

bandate bigint(40)

The date when the IP was first banned, in Unix time.

unbandate bigint(40)

The date when the IP will be unbanned in Unix time. Any date that is set lower than the current date basically classifies as a permanent ban as it will never auto expire.

bannedby varchar(50)

The name of the character that banned the IP. The character should belong to an account with the rights to the .ban command in-game.

banreason varchar(255)

The reason given for the IP ban.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'realmcharacters' table.

This table holds information on the number of characters each account has for each realm.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

realmid int(11) unsigned

The ID of the realm [See realmlist.id].

acctid int(11) unsigned

The account ID [See account.id].

numchars tinyint(3) unsigned

The number of characters the account has on the realm.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'realmlist' table.

This table holds information for the realms.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

The realm ID. This number is unique for every realm and it MUST correlate with the RealmID configuration value in mangosd.conf.

name varchar(32)

The name of the realm. This will appear in the realm selection list as well as in the character selection screen.

address varchar(32)

The public IP address of the world server. 127.0.0.1 works for LAN play only.

localAddress varchar(255)

The local IP address of the world server. 127.0.0.1 works for LAN play only.

localSubnetMask varchar(255)

The subnet mask used for the local network. By default this is 255.255.255.0

port int(11)

The port that the world server is running on. Default is 8085. If you will run more than one world server on the same machine, e.g. develop and production, they will all need to use a different port.

icon tinyint(3) unsigned

The icon of the realm.

realmflags tinyint(3) unsigned

Supported masks for the realm, based on the table below.

timezone tinyint(3) unsigned

The realm timezone, it will be displayed in the tabs of the realmlist.

allowedSecurityLevel tinyint(3) unsigned

The minimum account [See account.gmlevel] required for accounts to log in to this realm. Normally 0 - that means normal players allowed on this realm. Just useful if you make a GM-only developement realm.
Changing this value will automatically update the visible in-game realm list, but the realm server must be restarted for it to take effect.

population float unsigned

This field shows the current population and is automatically updated at regular intervals and will . The formula to calculate the value in this field is:

playerCount / maxPlayerCount * 2

realmbuilds varchar(64)

The accepted client builds that the realm will accept. (You can see this version at the clients left lower corner when starting.)
The format is version No. {space} version No. (i.e. space separated)

xxxx xxxx xxxx

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'uptime' table.

This table holds the uptime of all realms. Each realm will automatically update it's latest entry's value until it crashes and a new record is added. Doing so also some statistical/historical information is collected - about the availability of your machine.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

realmid int(11) unsigned

The realm id [See realmlist.id].

starttime bigint(20) unsigned

The time when the server was started, in Unix time.

startstring varchar(64)

The time when the server started, formated as a readable string.

uptime bigint(20) unsigned

The uptime of the server, in seconds.

maxplayers smallint(5) unsigned

The maximum number of players connected

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'warden_log' table.

This table stores alerts raised by Warden from players actions.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

entry int(11) unsigned

Notes: Log entry ID

check smallint(5) unsigned

Notes: Failed Warden check ID

action tinyint(3) unsigned

Notes: Action taken (enum WardenActions)

account int(11) unsigned

The account ID of the player [See account.id].

guid int(11) unsigned

Notes: Player GUID

map int(11) unsigned

The map id. The value has to match with a map identifier defined [See Map.dbc].

position_x float

The x location of the player.

position_y float

The y location of the player.

position_z float

The z location of the player.

date timestamp

The date/time when the alert was raised, in Unix time.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module