Description of the 'character_talent' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

talent_id int(11) unsigned

current_rank tinyint(3) unsigned

spec tinyint(3) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_ticket' table for MaNGOSThree

Holds ticket information from tickets written through the client help request -function.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

ticket_id int(11) unsigned

A unique ticket ID.

guid int(11) unsigned

The GUID of the character sending the ticket. [See character.guid].

ticket_text text

The ticket description text; the text written by the player in describing the problem.

response_text text

The ticket description text; the text written by the GM in describing the solution.

ticket_lastchange timestamp

Stores the time when this ticket was last changed.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'character_tutorial' table for MaNGOSThree

This table is used to store the tutorial state of all the characters.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

account bigint(20) unsigned

The account id of the user. [See account.id].

tut0 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

tut1 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

tut2 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

tut3 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

tut4 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

tut5 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

tut6 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

tut7 int(11) unsigned

These values are 32bits flags. So 8 x 32bits values makes 256 bits available to store 256 tutorial messages status. Each bit means: bc. 0 - Not yet shown 1 - Shown This is used to diplay only tutorial messages that the character did not see before. Unselecting the "Show tutorial" option in game, makes all bits to be set, so all tutX columns will contain then 11111111111111111111111111111111 binary = 4294967295 in decimal after this option is changed.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'characters' table for MaNGOSThree

This table holds vital static information for each character. This information loaded and used to create the player objects in-game.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

The character global unique identifier. This number must be unique and is the best way to identify separate characters.

account int(11) unsigned

The account ID in which this character resides. [See account.id] in the realm database.

name varchar(12)

The name of the character.

race tinyint(3) unsigned

The race of the character.

class tinyint(3) unsigned

The Class Id of the character [See chrclasses.dbc]

gender tinyint(3) unsigned

The Sex/Gender of the character.

level tinyint(3) unsigned

The current level of the designated player.

xp int(10) unsigned

The total amount of xp that the signified player has.

money bigint(40) unsigned

This is the amount of copper the character possesses.

playerBytes int(10) unsigned

This defines the following physical attributes of the character:
skin, face, hairstyle, hair colour

playerBytes2 int(10) unsigned

This defines the facial hair physical attribute of the character.

As with playerBytes, playerBytes2's bits (0 to 7) are used to change the character's facial hair

TODO (an example of setting this attribute)

playerFlags int(10) unsigned

These are the player flags. They are represented as decimal values in the database table, and hexidecimal values in the table below.

position_x float

The x position of the character's location.

position_y float

The y position of the character's location.

position_z float

The z position of the character's location.

map int(11) unsigned

The map ID the character is in. [See map.dbc]

dungeon_difficulty tinyint(1) unsigned

orientation float

The orientation the character is facing. (North = 0.0, South = 3.14159)

taximask longtext

online tinyint(3) unsigned

Records whether the character is online (1) or offline (0).

cinematic tinyint(3) unsigned

Boolean 1 or 0 controlling whether the start cinematic has been shown or not.

totaltime int(11) unsigned

The total time that the character has been active in the world, measured in seconds.

leveltime int(11) unsigned

The total time the character has spent in the world at the current level, measured in seconds.

logout_time bigint(20) unsigned

The time when the character last logged out, measured in Unix time.

is_logout_resting tinyint(3) unsigned

Boolean 1 or 0 controlling if the character is currently in a resting zone or not.

rest_bonus float

This is part of the rest system, and is used to calculate how much rest bonus to give the player when they have been offline. Rest bonus affects the amount of experience the character can earn,

resettalents_cost int(11) unsigned

The cost for the character to reset its talents, measured in copper.

resettalents_time bigint(20) unsigned

primary_trees varchar(10)

trans_x float

The X coordinate of the character on the transport it is travelling on at the point of logging off.

trans_y float

The Y coordinate of the character on the transport it is travelling on at the point of logging off.

trans_z float

The Z coordinate of the character on the transport it is travelling on at the point of logging off.

trans_o float

The orientation of the character on the transport it is travelling on at the point of logging off.

transguid bigint(20) unsigned

This is the transprt the character is currently travelling on.

It's the entry ID from the transports table.

extra_flags int(11) unsigned

These flags control certain player specific attributes, mostly GM features

stable_slots tinyint(1) unsigned

The number of stable slots the player has available. Maximum is 2.

at_login int(11) unsigned

The status of the character.

zone int(11) unsigned

The zone ID the character is in.

death_expire_time bigint(20) unsigned

Time when a character can be resurrected in case of a server crash or client exit while in ghost form.

taxi_path text

Stores the players current taxi path (TaxiPath.dbc) if logged off while on one.

totalKills int(10) unsigned

todayKills smallint(5) unsigned

yesterdayKills smallint(5) unsigned

chosenTitle int(10) unsigned

watchedFaction int(10) unsigned

The faction whose rep is being followed on the experience bar.

Only one faction at a time can be followed.

The ID of the faction being followed will appear in this field, e.g.
18 for Gnomeragan Exiles
20 for Ironforge
21 for Darnassus

These are not the same as the Faction IDs from the DBC file.

drunk tinyint(3) unsigned

This represents the alcoholic strength of the drink. The stronger the drinker, the longer your character is drunk for

health int(10) unsigned

The character's health when logging out.

power1 int(10) unsigned

The character's mana level when logging out.

power2 int(10) unsigned

If a warrior, then this is character's rage level when logging out.

power3 int(10) unsigned

This is a hunter pet's focus level at point of logging off.

power4 int(10) unsigned

If a rogue, then this is character's energy level when logging out.

power5 int(10) unsigned

This is the current active pet's happiness level at the point of logging off.

specCount tinyint(3) unsigned

activeSpec tinyint(3) unsigned

exploredZones longtext

This is a record of all areas discovered by the character.

equipmentCache longtext

This is a record of all items that are currently equipped.

Changing this information does not affect what is equipped. It will just revert back to what was originally equipped.

knownTitles longtext

actionBars tinyint(3) unsigned

This represents which action bars are currently active.

slot tinyint(3) unsigned

deleteInfos_Account int(11) unsigned

This is the account number from the characters table, that the deleted character is on.

deleteInfos_Name varchar(12)

The is the name of the character being deleted.

deleteDate bigint(20) unsigned

This is the date the character was deleted,

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'corpse' table for MaNGOSThree

This table is used to store status of players corpse.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

The character global unique identifier of the corpse.

player int(11) unsigned

The character global unique identifier. [See characters.guid].

position_x float

The x position of the character's corpse location.

position_y float

The y position of the character's corpse location.

position_z float

The z position of the character's corpse location.

orientation float

The orientation of the corpse. (North = 0.0, South = 3.14159)

map int(11) unsigned

The map ID the corpse is in. [See map.dbc]

phaseMask int(11) unsigned

time bigint(20) unsigned

Time of death.

corpse_type tinyint(3) unsigned

The Display Type of the corpse:

instance int(11) unsigned

The instance ID that the corpse is in.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'creature_respawn' table for MaNGOSThree

This table holds the respawn time when creatures should be respawned in the world. In case of a server crash, this table holds the respawn data so that the creatures don't respawn immediately on server restart. How often the respawn time is saved for creatures can be controlled in mangosd.conf

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(10) unsigned

Notes: Global Unique Identifier

respawntime bigint(20) unsigned

Time till the creature should respawn.

instance mediumint(8) unsigned

Instance ID of the instance the creature is respawning into.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'db_version' table for MaNGOSThree

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)

Notes: 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 'game_event_status' table for MaNGOSThree

Lists the currently active game events, ie. Darkmoon faire etc.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

event smallint(6) unsigned

The Event Id [See game_event.is] of currently active game events.
Once the event is complete, the entry is removed.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'gameobject_respawn' table for MaNGOSThree

This table holds the re-spawn time when game objects should be respawned in the world. In case of a server crash, this table holds the re-spawn data so that the game objects don't re-spawn immediately on server restart. How often the re-spawn time is saved for game objects can be controlled in mangosd.conf. Usually the only objects that despawn and need to be re-spawned are chests and doors.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(10) unsigned

Global unique ID of the game object.

respawntime bigint(20) unsigned

Time till the game object should respawn, as in 60000 for 1 minute after server start..

instance mediumint(8) unsigned

Instance ID that the game object will spawn in.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'group_instance' table for MaNGOSThree

This table tracks a group of characters in an instance.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

leaderGuid int(11) unsigned

The Guid of the group leader. [See characters.guid]

instance int(11) unsigned

ID of the Instance session the group has enterd.

permanent tinyint(1) unsigned

Boolean flag if the group is bound to the Instance or not

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'group_member' table for MaNGOSThree

This table holds info about group members.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

groupId int(11) unsigned

The group ID from the groups table.

memberGuid int(11) unsigned

The GUID of the character in the group.

assistant tinyint(1) unsigned

Flag stating whether or not the character is the assist.

The assits controls which mobs to attack and in what order.

subgroup smallint(6) unsigned

This is the group number within a raid (8 groups max).

Group numbering starts at 0 and end at 7.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'groups' table for MaNGOSThree

This table holds basic info about groups.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

groupId int(11) unsigned

Uniquie ID for the group.

leaderGuid int(11) unsigned

Guid of the group's leader, from the characters table.

mainTank int(11) unsigned

Guid of the character who is that main tank.

mainAssistant int(11) unsigned

Guid of the character who is that main assit.

This group member calls the shots as to the order in which mobs are taken on.

lootMethod tinyint(4) unsigned

This is the loot method used by the group.

looterGuid int(11) unsigned

Guid of the character who retrieves the loot.

lootThreshold tinyint(4) unsigned

The quality of theitems in the loot to be rolled for. This will be the minimum quality level to throw for, any loot below that will not be thrown for.

icon1 int(11) unsigned

Guid of the target that has the star raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon2 int(11) unsigned

Guid of the target that has the circle raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon3 int(11) unsigned

Guid of target that has the dimond raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon4 int(11) unsigned

Guid of the target that has the triangler raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon5 int(11) unsigned

Guid of the target that has the moon raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon6 int(11) unsigned

Guid of the target that has the square raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon7 int(11) unsigned

Guid of the target that has the cross raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

icon8 int(11) unsigned

Guid of the target that has the skull raid target on it.

These are placed on playesr and mobs, and can be used for controlling kill orders, crowd control, and assigning players to mobs.

groupType tinyint(1) unsigned

difficulty tinyint(3) unsigned

raiddifficulty int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild' table for MaNGOSThree

This table holds the main guild information. All created guilds or all guilds in the process of being created have a record in this table.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(6) unsigned

The ID of the guild. This number is unique to each guild and is the main method to identify a guild.

name varchar(255)

The guild name.

leaderguid int(6) unsigned

The GUID of the character who created the guild. [See characters.guid]

EmblemStyle int(5)

The emblem style of the guild tabard.

EmblemColor int(5)

The emblem color of the guild tabard.

BorderStyle int(5)

The border style of the guild tabard.

BorderColor int(5)

The border color of the guild tabard.

BackgroundColor int(5)

The background color of the guild tabard.

info varchar(500)

The text message that appears in the Guild Information box.

motd varchar(128)

The text that appears in the Message Of The Day box.

createdate bigint(20) unsigned

The date when the guild was created.

BankMoney bigint(20) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_bank_eventlog' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(11) unsigned

Notes: Guild Identificator

LogGuid int(11) unsigned

Notes: Log record identificator - auxiliary column

TabId tinyint(3) unsigned

Notes: Guild bank TabId

EventType tinyint(3) unsigned

Notes: Event type

PlayerGuid int(11) unsigned

ItemOrMoney int(11) unsigned

ItemStackCount tinyint(3) unsigned

DestTabId tinyint(1) unsigned

Notes: Destination Tab Id

TimeStamp bigint(20) unsigned

Notes: Event UNIX time

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_bank_item' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(11) unsigned

TabId tinyint(1) unsigned

SlotId tinyint(3) unsigned

item_guid int(11) unsigned

item_entry int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_bank_right' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(11) unsigned

TabId tinyint(1) unsigned

rid int(11) unsigned

gbright tinyint(3) unsigned

SlotPerDay int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_bank_tab' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(11) unsigned

TabId tinyint(1) unsigned

TabName varchar(100)

TabIcon varchar(100)

TabText text

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_eventlog' table for MaNGOSThree

This table holds information about changes in guilds membership.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(11) unsigned

Id of related guild. [See guild.guildid].

LogGuid int(11) unsigned

A unique identifier given to each log entry to distinguish one entry from another. Two guild event logs can NOT have same GUID.

EventType tinyint(1) unsigned

The Guild Event Type:

PlayerGuid1 int(11) unsigned

Guid of character who made the change. [See character.guid]

PlayerGuid2 int(11) unsigned

Guid of character who was "changed". [See character.guid]

NewRank tinyint(2) unsigned

Id of new rank of PlayerGuid2. [See guild_rank.rid]

TimeStamp bigint(20) unsigned

Unix timestamp of when the event happened.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_member' table for MaNGOSThree

This table holds information on the members of all guilds, their ranks in the guild, and any notes made by them or by guild officers.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(6) unsigned

The ID of the guild that the member is a part of. [See guild.guildid]

guid int(11) unsigned

The GUID of the player. [See character.guid]

rank tinyint(2) unsigned

The rank that the player has in the guild. [See guild_rank.rid]

pnote varchar(31)

The Player Note set by the player, which can be read by everyone in the guild.

offnote varchar(31)

The Officers Note set by officers in the guild, which can only be read by other officers of the guild.

BankResetTimeMoney int(11) unsigned

BankRemMoney int(11) unsigned

BankResetTimeTab0 int(11) unsigned

BankRemSlotsTab0 int(11) unsigned

BankResetTimeTab1 int(11) unsigned

BankRemSlotsTab1 int(11) unsigned

BankResetTimeTab2 int(11) unsigned

BankRemSlotsTab2 int(11) unsigned

BankResetTimeTab3 int(11) unsigned

BankRemSlotsTab3 int(11) unsigned

BankResetTimeTab4 int(11) unsigned

BankRemSlotsTab4 int(11) unsigned

BankResetTimeTab5 int(11) unsigned

BankRemSlotsTab5 int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_rank' table for MaNGOSThree

This table holds the information on all of the ranks available in a guild along with their names and what rights a person with that rank has.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guildid int(6) unsigned

The guild ID that the rank is part of. [See guild.guildid]

rid int(11) unsigned

The particular rank ID. This number must be unique to each rank in a guild.

rname varchar(255)

The name of the rank that is displayed in-game.

rights int(3) unsigned

The rights a player with this rank has in the guild.
The calculation of multiple rights is a bit different in this case as the rights do not all have 2^n values.
To combine ranks, you must do the OR operation (|) on the two flags.

BankMoneyPerDay int(11) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'instance' table for MaNGOSThree

This table holds static information on all current instances that have not yet been reset.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

The instance ID. This number is unique to every instance.

map int(11) unsigned

The map ID the instance is in. [See Map.dbc]

resettime bigint(40) unsigned

The time when the instance will be reset, in Unix time. This field is zero for raid and heroic instances.

difficulty tinyint(1) unsigned

encountersMask int(10) unsigned

data longtext

Specific data belonging to the individual instance.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'instance_reset' table for MaNGOSThree

This table holds information about the instance reset time.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

mapid int(11) unsigned

The map ID of the instance. [See Map.dbc]

difficulty tinyint(1) unsigned

resettime bigint(40) unsigned

Dungeon reset time in seconds.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'item_instance' table for MaNGOSThree

This table holds individual item instance information for all items currently equipped or in some kind of character bag or bank.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

The GUID of the item. This number is unique for each item instance.

owner_guid int(11) unsigned

The GUID of the character who has ownership of this item. [See character.guid]

data longtext

Much like the playerbytes fields in the characters table, this field has many number fields all separated by a space which contain specific individual item information like any enchantments applied to the item, etc.

text longtext

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'item_loot' table for MaNGOSThree

Contains the items associated with a lootable inventory items. This table is populated the first time the player right-clicks to open an item. Rows are deleted when the player either removes an item or destroys the container item.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

Global unique ID of the item loot entry.

owner_guid int(11) unsigned

The GUID of the owner. [See character.guid]

itemid int(11) unsigned

Item template entry ID of the item.

amount int(11) unsigned

Total number of the item.

suffix int(11) unsigned

property int(11)

Item random property.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'mail' table for MaNGOSThree

This table contains main data about all mails in the game.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

Unique message id. Every new message gets a new auto incremented id.

messageType tinyint(3) unsigned

The type of the Message:

stationery tinyint(3)

The StationeryID [See Stationery.dbc].

mailTemplateId mediumint(8) unsigned

The Mail Template Id [See MailTemplate.dbc]

sender int(11) unsigned

Guid of the character who sends the mail.

receiver int(11) unsigned

Guid of the character who receives the mail.

subject longtext

The Subject of the mail.

body longtext

has_items tinyint(3) unsigned

Boolean value showing whether or not atems have been sent.

0 = no item included in the mail.
1 = items included in the mail.

expire_time bigint(40) unsigned

Current Unix Time + Unix Time till expiry.
Example:
current unix time + 86400 (seconds for one day) = expiry date
In this example the mail would expire after one day.

deliver_time bigint(40) unsigned

Current Unix Time + Unix Time till delivery.
Example:
current unix time + 86400 (seconds for one day) = delivery date
In this example the mail would be delivered after one day.

money bigint(40) unsigned

Amount of money sent.
If you want to send 100 gold 55 silver 33 copper then its 1005533

cod bigint(40) unsigned

Amount of money needed (COD).

checked tinyint(3) unsigned

checked_flag

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'mail_items' table for MaNGOSThree

This table contains data regarding items from item_instance which are being sent via email.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

mail_id int(11)

The Mail Id [See mail.id].

item_guid int(11)

The GUID of the item.

item_template int(11)

The entry ID of the item in the item_template table.

receiver int(11) unsigned

Guid of the character who receives the mail.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pet_aura' table for MaNGOSThree

This table contains aura information that is loaded when a pet is loaded, so the auras that were on the pet when the owner character logged out are still kept when they log back in. A spell can have up to three auras, one in each of its effects.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

The GUID of the target affected by the aura. [See character.guid]

caster_guid bigint(20) unsigned

The GUID of the player or creature who casted the aura. [See character.guid]

item_guid int(11) unsigned

Guid of the item that is casting the aura on the pet.

spell int(11) unsigned

The spell from which the aura was applied. [See Spell.dbc column 1]

stackcount int(11) unsigned

This is the total number of times the aura can be stacked on the pet.

remaincharges int(11) unsigned

The number of charges remaining on the aura.

basepoints0 int(11)

Primary effect, such as healing.

basepoints1 int(11)

Secondary effect (appears to be only healing related)

basepoints2 int(11)

Secondary effect (appears to be only damage related)

periodictime0 int(11) unsigned

Primary effect over time.

periodictime1 int(11) unsigned

Secondary effect (healing) over time

periodictime2 int(11) unsigned

Secondary effect (damage) over time.

maxduration int(11)

The maximum duration of the aura.

remaintime int(11)

The time remaining in seconds on the aura. -1 means that the aura is indefinite.

effIndexMask int(11) unsigned

The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pet_spell' table for MaNGOSThree

This table holds information on individual pet spells.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

The pet GUID. [See character_pet.id].

spell int(11) unsigned

The spell ID.[See (Spell.dbc]

active int(11) unsigned

Boolean 0 or 1 controlling if the spell is active or not.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pet_spell_cooldown' table for MaNGOSThree

This table holds information on pet spell cooldowns.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

guid int(11) unsigned

The GUID of the pet. [See character_pet.id]

spell int(11) unsigned

The spell ID to which the cooldown applies.

time bigint(20) unsigned

The time when the cooldown expires, in Unix time.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'petition' table for MaNGOSThree

This table holds information on all ongoing petitions for a guild or for an arena team.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

ownerguid int(10) unsigned

The petition owner's GUID. [See characters.guid]

petitionguid int(10) unsigned

The GUID of the petition item. See (item_instance.guid)

name varchar(255)

The name of the guild or arena team that the player is trying to ask for petitions for.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'petition_sign' table for MaNGOSThree

This table holds information on all the signatures of a petition for either a guild or an arena team.

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

ownerguid int(10) unsigned

The GUID of the owner that is trying to make the guild/arena team. [See characters.guid].

petitionguid int(11) unsigned

The GUID of the charter item. [See item_template.guid]

playerguid int(11) unsigned

The GUID of the player that has signed the charter. [See character.guid]

player_account int(11) unsigned

The account ID of the player that has signed the charter [See account.id]. No two players can sign the same charter from the same account.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pvpstats_players' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

battleground_id bigint(20) unsigned

character_guid int(10) unsigned

score_killing_blows mediumint(8) unsigned

score_deaths mediumint(8) unsigned

score_honorable_kills mediumint(8) unsigned

score_bonus_honor mediumint(8) unsigned

score_damage_done mediumint(8) unsigned

score_healing_done mediumint(8) unsigned

attr_1 mediumint(8) unsigned

attr_2 mediumint(8) unsigned

attr_3 mediumint(8) unsigned

attr_4 mediumint(8) unsigned

attr_5 mediumint(8) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'saved_variables' table for MaNGOSThree

Stores server required values.
i.e. Character Database cleanup flags and Honor Point / Rank reset date

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

NextArenaPointDistributionTime bigint(40) unsigned

NextDailyQuestResetTime bigint(40) unsigned

NextWeeklyQuestResetTime bigint(40) unsigned

NextMonthlyQuestResetTime bigint(40) unsigned

NextRandomBGResetTime bigint(40) unsigned

cleaning_flags int(11) unsigned

The flags controlling character cleanup:

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'warden_action' table for MaNGOSThree

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

wardenId smallint(5) unsigned

action tinyint(3) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'world' table for MaNGOSThree

Stores World Status information

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

map int(11) unsigned

The map ID [See Map.dbc]

data longtext

Specific data belonging to the world.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module