Description of the 'guild' table for MaNGOSOne

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 'MyISAM' 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 MaNGOSOne

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 MaNGOSOne

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 MaNGOSOne

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 MaNGOSOne

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 varchar(500)

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'guild_eventlog' table for MaNGOSOne

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 MaNGOSOne

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 'MyISAM' 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 MaNGOSOne

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 'MyISAM' 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 MaNGOSOne

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

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 MaNGOSOne

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]

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 MaNGOSOne

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 'MyISAM' 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.

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'item_loot' table for MaNGOSOne

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 'MyISAM' 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 'item_text' table for MaNGOSOne

This table is part of the mail system and holds the text information of every letter.

Table Notes

This table uses the 'MyISAM' DB Engine

The Field definitions follow:

Description of the fields

id int(11) unsigned

The text entry ID. This number is unique to every text entry in this table.

text longtext

The actual text that was sent as mail using the mail system. There are some special messages that are sent through the mail and therefore use this table but have a special format to them:

Auction won (sent to bidder): "<owner's GUID as hex>:<winning bid in copper>:<buyout price in copper>"

Auction successful (sent to owner): "<bidder's GUID as hex>:<winning bid in copper>:0: <deposit in copper>:<auction cut in copper>"

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'mail' table for MaNGOSOne

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

Table Notes

This table uses the 'MyISAM' 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.

itemTextId int(11) unsigned

The item_text ID of the massage within the mail.

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 int(11) unsigned

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

cod int(11) 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 MaNGOSOne

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

Table Notes

This table uses the 'MyISAM' 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 MaNGOSOne

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 'MyISAM' 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 MaNGOSOne

This table holds information on individual pet spells.

Table Notes

This table uses the 'MyISAM' 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 MaNGOSOne

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 MaNGOSOne

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

Table Notes

This table uses the 'MyISAM' 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.

type int(10) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'petition_sign' table for MaNGOSOne

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 'MyISAM' 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.

type int(10) unsigned

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pvpstats_battlegrounds' table for MaNGOSOne

Table Notes

This table uses the 'InnoDB' DB Engine

The Field definitions follow:

Description of the fields

id bigint(20) unsigned

winner_team tinyint(4)

bracket_id tinyint(3) unsigned

type tinyint(3) unsigned

date datetime

auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Description of the 'pvpstats_players' table for MaNGOSOne

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 MaNGOSOne

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

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 MaNGOSOne

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 MaNGOSOne

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