antz

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_pet_declinedname' table for MaNGOSOne Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI '0' owner int(11) unsigned NO MUL '0' genitive varchar(12) NO {Blank String} dative varchar(12) NO {Blank String} accusative varchar(12) NO {Blank String} instrumental varchar(12) NO {Blank String} prepositional varchar(12) NO {Blank String} Description of the fields id int(11) unsigned owner int(11) unsigned genitive varchar(12) dative varchar(12) accusative varchar(12) instrumental varchar(12) prepositional varchar(12) auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_queststatus' table for MaNGOSOne Holds information on the quest status of each character. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the character. [See character.guid]. quest int(11) unsigned NO PRI '0' The quest ID. [See quest_template.entry]. status int(11) unsigned NO '0' The current quest status. rewarded tinyint(1) unsigned NO '0' Boolean 1 or 0 representing whether the quest has been rewarded or not. explored tinyint(1) unsigned NO '0' Boolean 1 or 0 representing if the character has explored what was needed. timer bigint(20) unsigned NO '0' Remaining time left on the quest if the quest has a timer [See quest_template]. mobcount1 int(11) unsigned NO '0' Current count of the first number of kills or casts. mobcount2 int(11) unsigned NO '0' Current count of the second number of kills or casts. mobcount3 int(11) unsigned NO '0' Current count of the third number of kills or casts. mobcount4 int(11) unsigned NO '0' Current count of the forth number of kills or casts. itemcount1 int(11) unsigned NO '0' Current item count for the first item in a delivery quest, if any. itemcount2 int(11) unsigned NO '0' Current item count for the second item in a delivery quest, if any. itemcount3 int(11) unsigned NO '0' Current item count for the third item in a delivery quest, if any. itemcount4 int(11) unsigned NO '0' Current item count for the forth item in a delivery quest, if any. Description of the fields guid int(11) unsigned The GUID of the character. [See character.guid]. quest int(11) unsigned The quest ID. [See quest_template.entry]. status int(11) unsigned The current quest status. Value Status Flag Notes 0 QUEST_STATUS_NONE Quest isn't shown in quest list - default value 1 QUEST_STATUS_COMPLETE Quest has been completed. 2 QUEST_STATUS_UNAVAILABLE Quest is unavailable to the character. 3 QUEST_STATUS_INCOMPLETE Quest is active in quest log but incomplete 4 QUEST_STATUS_AVAILABLE Quest is available to be taken by character 5 QUEST_STATUS_FAILED Quest requires not achieved. (i.e. Woo Ping must survive) 6 QUEST_STATUS_FORCE_COMPLETE This quest was force completed by GM command rewarded tinyint(1) unsigned Boolean 1 or 0 representing whether the quest has been rewarded or not. explored tinyint(1) unsigned Boolean 1 or 0 representing if the character has explored what was needed to explore for the quest. timer bigint(20) unsigned Remaining time left on the quest if the quest has a timer. [See quest_template.LimitTime]. mobcount1 int(11) unsigned Current count of the number of kills or casts on the second creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount1 mobcount2 int(11) unsigned Current count of the number of kills or casts on the second creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount2 mobcount3 int(11) unsigned Current count of the number of kills or casts on the third creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount3 mobcount4 int(11) unsigned Current count of the number of kills or casts on the forth creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount4 itemcount1 int(11) unsigned Current item count for the first item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount1 itemcount2 int(11) unsigned Current item count for the second item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount2 itemcount3 int(11) unsigned Current item count for the third item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount3 itemcount4 int(11) unsigned Current item count for the forth item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount4 auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_reputation' table for MaNGOSOne This table holds the reputation information of each faction for the character. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the character. [See character.guid]. faction int(11) unsigned NO PRI '0' The faction ID that the character has the given reputation in [See Faction.dbc]. standing int(11) NO '0' The current reputation value that the character has. flags int(11) NO '0' This field is a bitmask containing flags that apply to the faction. Description of the fields guid int(11) unsigned The GUID of the character. [See character.guid]. faction int(11) unsigned The faction ID that the character has the given reputation in. [See Faction.dbc]. standing int(11) The current reputation value that the character has. flags int(11) This field is a bitmask containing flags that apply to the faction and how it's displayed to the character. Just like any flag field, you can combine flags by adding them together. If this field is 0, then it is not shown in the reputation list in-game. Flag Flag Name Notes 1 FACTION_FLAG_VISIBLE Displayed in the reputation tab 2 FACTION_FLAG_AT_WAR Active when the player sets the at war checkbox 4 FACTION_FLAG_UNKNOWN UNKNOWN 8 FACTION_FLAG_INVISIBLE Not Displayed in the reputation tab 16 FACTION_FLAG_OWN_TEAM OWN_TEAM 32 FACTION_FLAG_INACTIVE INACTIVE auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_queststatus_daily' table for MaNGOSOne 'Player System' Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' quest int(11) unsigned NO PRI '0' Description of the fields guid int(11) unsigned Notes: Global Unique Identifier quest int(11) unsigned Notes: Quest Identifier auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_skills' table for MaNGOSOne This table holds a listing of all skill for each character. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI NULL The GUID (Global Unique Identifier) of the character. [See character.guid]. skill mediumint(9) unsigned NO PRI NULL The list of skills a character knows. A listing of those can be found in here. value mediumint(9) unsigned NO NULL The current skill rank(value) of the character skills a character has. max mediumint(9) unsigned NO NULL The highest possible value for the given skill within a given rank. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier) of the character. [See character.guid]. skill mediumint(9) unsigned The list of skills a character knows. A listing of those can be found in here. value mediumint(9) unsigned The current skill rank(value) of the character skills a character has. max mediumint(9) unsigned The highest possible value for the given skill within a given rank. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_spell' table for MaNGOSOne Holds information for each character's spells. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID (Global Unique Identifier) of the character. [See character.guid]. spell int(11) unsigned NO PRI '0' The spell ID (Spell Identifier). [See Spell.dbc] active tinyint(3) unsigned NO '1' Boolean 1 or 0 signifying whether the spell is active (appears in the spell book disabled tinyint(3) unsigned NO '0' Boolean flag 0 or 1 when spell is disabled because of talents. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier) of the character. [See character.guid]. spell int(11) unsigned The spell ID (Spell Identifier). [See Spell.dbc column 1] active tinyint(3) unsigned Boolean 1 or 0 signifying whether the spell is active (appears in the spell book). disabled tinyint(3) unsigned Boolean flag 0 or 1 when spell is disabled because talent which teaches it has been unlearned. When talent is learned again the spell will be available again. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_social' table for MaNGOSOne Contains data about character's friends/ignored list. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the character. [See character.guid] friend int(11) unsigned NO PRI '0' The GUID of the friend/ignored. [See character.guid] flags tinyint(1) unsigned NO PRI '0' Whether the character is a friend or ignored. note varchar(48) NO {Blank String} Description of the fields guid int(11) unsigned The GUID of the character. [See character.guid] friend int(11) unsigned The GUID of the friend/ignored. [See character.guid] flags tinyint(1) unsigned The flag indicating whether the entry is either a friend or ignored. Value Meaning 0 Friend 1 Ignored note varchar(48) Notes: Friend Note auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_spell_cooldown' table for MaNGOSOne Holds the remaining cooldowns from either character spells or item spells for each character. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID (Global Unique Identifier, Low part) of the character. spell int(11) unsigned NO PRI '0' The spell ID (Spell Identifier). [See Spell.dbc] item int(11) unsigned NO '0' If the spell was casted from an item, the item ID (Item Identifier). time bigint(20) unsigned NO '0' The time when the spell cooldown will finish, measured in Unix Time. Description of the fields guid int(11) unsigned The GUID (Global Unique Identifier, Low part) of the character. [See character.guid] spell int(11) unsigned The spell ID (Spell Identifier). [See Spell.dbc column 1] item int(11) unsigned If the spell was casted from an item, the item ID (Item Identifier). [See item_template.entry]. time bigint(20) unsigned The time when the spell cooldown will finish, measured in Unix Time. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_stats' table for MaNGOSOne This table holds information on all the stats regarding the character. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The guid of the character. [See character.guid]. maxhealth int(10) unsigned NO '0' Maximum amount of health that the character has. maxpower1 int(10) unsigned NO '0' Max Mana maxpower2 int(10) unsigned NO '0' Max Rage maxpower3 int(10) unsigned NO '0' Max Focus maxpower4 int(10) unsigned NO '0' Max Energy maxpower5 int(10) unsigned NO '0' Max Happiness maxpower6 int(10) unsigned NO '0' Max Rune maxpower7 int(10) unsigned NO '0' Max Runic Power strength int(10) unsigned NO '0' Character's current strength value. agility int(10) unsigned NO '0' Character's current agility value stamina int(10) unsigned NO '0' Character's current stamina value. intellect int(10) unsigned NO '0' Character's current intellect value. spirit int(10) unsigned NO '0' Character's current spirit value. armor int(10) unsigned NO '0' Character's current armor value. resHoly int(10) unsigned NO '0' Character's current holy resistance value. resFire int(10) unsigned NO '0' Character's current fire resistance value. resNature int(10) unsigned NO '0' Character's current nature resistance value. resFrost int(10) unsigned NO '0' Character's current frost resistance value. resShadow int(10) unsigned NO '0' Character's current shadow resistance value. resArcane int(10) unsigned NO '0' Character's current arcane resistance value. blockPct float unsigned NO '0' Character's current block chance dodgePct float unsigned NO '0' Character's current dodge chance. parryPct float unsigned NO '0' Character's current parry chance. critPct float unsigned NO '0' Character's current crit chance. rangedCritPct float unsigned NO '0' Character's current ranged crit chance. spellCritPct float unsigned NO '0' attackPower int(10) unsigned NO '0' Character's current attackpower. rangedAttackPower int(10) unsigned NO '0' Character's current ranged attackpower. spellPower int(10) unsigned NO '0' Description of the fields guid int(11) unsigned The guid of the character. [See character.guid]. maxhealth int(10) unsigned Maximum amount of health that the character has. maxpower1 int(10) unsigned Max Mana maxpower2 int(10) unsigned Max Rage maxpower3 int(10) unsigned Max Focus maxpower4 int(10) unsigned Max Energy maxpower5 int(10) unsigned Max Happiness maxpower6 int(10) unsigned Max Rune maxpower7 int(10) unsigned Max Runic Power strength int(10) unsigned Character's current strength value. agility int(10) unsigned Character's current agility value stamina int(10) unsigned Character's current stamina value. intellect int(10) unsigned Character's current intellect value. spirit int(10) unsigned Character's current spirit value. armor int(10) unsigned Character's current armor value. resHoly int(10) unsigned Character's current holy resistance value. resFire int(10) unsigned Character's current fire resistance value. resNature int(10) unsigned Character's current nature resistance value. resFrost int(10) unsigned Character's current frost resistance value. resShadow int(10) unsigned Character's current shadow resistance value. resArcane int(10) unsigned Character's current arcane resistance value. blockPct float unsigned Character's current block chance dodgePct float unsigned Character's current dodge chance. parryPct float unsigned Character's current parry chance. critPct float unsigned Character's current crit chance. rangedCritPct float unsigned Character's current ranged crit chance. spellCritPct float unsigned attackPower int(10) unsigned Character's current attackpower. rangedAttackPower int(10) unsigned Character's current ranged attackpower. spellPower int(10) unsigned auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_ticket' table for MaNGOSOne Holds ticket information from tickets written through the client help request -function. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes ticket_id int(11) unsigned NO PRI NULL 'auto_increment' A unique ticket ID. guid int(11) unsigned NO '0' The GUID of the character sending the ticket. [See character.guid]. ticket_text text YES NULL The ticket description text; the text written by the player. response_text text YES NULL The ticket solution text; the text written by the GM. ticket_lastchange timestamp NO 'CURRENT_TIMESTAMP' Stores the time when this ticket was last changed. resolved tinyint(1) YES '0' Resolved Flag = set to 1 if the GM has sucessfully resolved the ticket 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. resolved tinyint(1) Resolved Flag = set to 1 if the GM has sucessfully resolved the ticket auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_tutorial' table for MaNGOSOne This table is used to store the tutorial state of all the characters. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes account bigint(20) unsigned NO PRI NULL 'auto_increment' The account id of the user. [See account.id]. tut0 int(11) unsigned NO '0' These values are 32bits flags. tut1 int(11) unsigned NO '0' These values are 32bits flags. tut2 int(11) unsigned NO '0' These values are 32bits flags. tut3 int(11) unsigned NO '0' These values are 32bits flags. tut4 int(11) unsigned NO '0' These values are 32bits flags. tut5 int(11) unsigned NO '0' These values are 32bits flags. tut6 int(11) unsigned NO '0' These values are 32bits flags. tut7 int(11) unsigned NO '0' These values are 32bits flags. 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'character_whispers' table for MaNGOSOne This table is used to store whispers that have been sent by players. By default it only stores whispers made in reply to tickets raised by players, but can be changed in mangos.conf to store all whispers. It can also be completely disabled by the same setting. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI NULL 'auto_increment' The unique id of this whisper message to_guid int(10) NO NULL The GUID of the character receiving the whisper. [See character.guid]. from_guid int(10) NO NULL The GUID of the character sending the whisper. [See character.guid]. message varchar(256) NO {Blank String} The body text of the whisper message regarding_ticket_id int(11) unsigned NO '0' The id of the ticket this whisper relates to. [See character_ticket.ticket_id]. sent_on timestamp NO 'CURRENT_TIMESTAMP' Stores the time when this whisper was sent. Description of the fields id int(11) unsigned The unique id of this whisper message to_guid int(10) The GUID of the character receiving the whisper. [See character.guid]. from_guid int(10) The GUID of the character sending the whisper. [See character.guid]. message varchar(256) The body text of the whisper message regarding_ticket_id int(11) unsigned The id of the ticket this whisper relates to. [See character_ticket.ticket_id]. sent_on timestamp Stores the time when this whisper was sent. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'corpse' table for MaNGOSOne This table is used to store status of players corpse. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The character global unique identifier of the corpse. player int(11) unsigned NO MUL '0' The character global unique identifier. [See characters.guid]. position_x float NO '0' The x position of the character's corpse location. position_y float NO '0' The y position of the character's corpse location. position_z float NO '0' The z position of the character's corpse location. orientation float NO '0' The orientation of the corpse. (North = 0.0, South = 3.14159) map int(11) unsigned NO '0' The map ID the corpse is in. [See maps.dbc] time bigint(20) unsigned NO MUL '0' Time of death. corpse_type tinyint(3) unsigned NO MUL '0' The Display Type of the corpse. instance int(11) unsigned NO MUL '0' The instance ID that the corpse is in. 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] time bigint(20) unsigned Time of death. corpse_type tinyint(3) unsigned The Display Type of the corpse: Value Member Name Description 0 Bones Bones only corpse. 1 ResurrectablePvE Ressurectable corpse, pve only. 2 ResurrectablePvP Ressurectable corpse, pvp only. instance int(11) unsigned The instance ID that the corpse is in. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'db_version' table for MaNGOSOne This table holds the current version of the MaNGOS world database Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes version int(3) NO PRI NULL The Version of the Release structure int(3) NO PRI NULL The current core structure level. content int(3) NO PRI NULL The current core content level. description varchar(30) NO {Blank String} comment varchar(150) YES {Blank String} A comment about the latest database revision. 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'creature_respawn' table for MaNGOSOne 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 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(10) unsigned NO PRI '0' respawntime bigint(20) unsigned NO '0' Time till the creature should respawn. instance mediumint(8) unsigned NO PRI '0' Instance ID of the instance the creature is respawning into. 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'game_event_status' table for MaNGOSOne Lists the currently active game events, ie. Darkmoon faire etc. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes event smallint(6) unsigned NO PRI '0' The Event Id [See game_event.is] of currently active game events. 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'gameobject_respawn' table for MaNGOSOne 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 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(10) unsigned NO PRI '0' Global unique ID of the game object. respawntime bigint(20) unsigned NO '0' Time till the game object should respawn. instance mediumint(8) unsigned NO PRI '0' Instance ID that the game object will spawn in. 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'groups' table for MaNGOSOne This table holds basic info about groups. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes groupId int(11) unsigned NO PRI NULL Uniquie ID for the group. leaderGuid int(11) unsigned NO UNI NULL Guid of the group's leader mainTank int(11) unsigned NO NULL Guid of the character who is that main tank. mainAssistant int(11) unsigned NO NULL Guid of the character who is that main assist. lootMethod tinyint(4) unsigned NO NULL This is the loot method used by the group. looterGuid int(11) unsigned NO NULL Guid of the character who retrieves the loot. lootThreshold tinyint(4) unsigned NO NULL The quality of the items in the loot to be rolled for. icon1 int(11) unsigned NO NULL Guid of the target that has the star raid target on it. icon2 int(11) unsigned NO NULL Guid of the target that has the circle raid target on it. icon3 int(11) unsigned NO NULL Guid of target that has the dimond raid target on it. icon4 int(11) unsigned NO NULL Guid of the target that has the triangler raid target on it. icon5 int(11) unsigned NO NULL Guid of the target that has the moon raid target on it. icon6 int(11) unsigned NO NULL Guid of the target that has the square raid target on it. icon7 int(11) unsigned NO NULL Guid of the target that has the cross raid target on it. icon8 int(11) unsigned NO NULL Guid of the target that has the skull raid target on it. isRaid tinyint(1) unsigned NO NULL Flag set for if group is part of a raid or not. difficulty tinyint(3) unsigned NO '0' 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. Method Value FREE_FOR_ALL 0 ROUND_ROBIN 1 MASTER_LOOT 2 GROUP_LOOT 3 NEED_BEFORE_GREED 4 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. Quality Value Colour ITEM_QUALITY_POOR 0 GREY ITEM_QUALITY_NORMAL 1 WHITE ITEM_QUALITY_UNCOMMON 2 GREEN ITEM_QUALITY_RARE 3 BLUE ITEM_QUALITY_EPIC 4 PURPLE ITEM_QUALITY_LEGENDAR 5 ORANGE ITEM_QUALITY_ARTIFACT 6 LIGHT YELLOW 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. isRaid tinyint(1) unsigned Flag set for if group is part of a raid or not (1 = raid, 0 = not raid). difficulty tinyint(3) unsigned auto-generated by the getMaNGOS.eu MAGNET dbdocs module

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'group_instance' table for MaNGOSOne This table tracks a group of characters in an instance. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes leaderGuid int(11) unsigned NO PRI '0' The Guid of the group leader. [See characters.guid] instance int(11) unsigned NO PRI '0' ID of the Instance session the group has enterd. permanent tinyint(1) unsigned NO '0' Boolean flag if the group is bound to the Instance or not 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. 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: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(6) unsigned NO PRI '0' The ID of the guild. name varchar(255) NO {Blank String} The guild name. leaderguid int(6) unsigned NO '0' The GUID of the character who created the guild. [See characters.guid] EmblemStyle int(5) NO '0' The emblem style of the guild tabard. EmblemColor int(5) NO '0' The emblem color of the guild tabard. BorderStyle int(5) NO '0' The border style of the guild tabard. BorderColor int(5) NO '0' The border color of the guild tabard. BackgroundColor int(5) NO '0' The background color of the guild tabard. info varchar(500) NO {Blank String} The text message that appears in the Guild Information box. motd varchar(128) NO {Blank String} The text that appears in the Message Of The Day box. createdate bigint(20) unsigned NO '0' The date when the guild was created. BankMoney bigint(20) unsigned NO '0' 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'group_member' table for MaNGOSOne This table holds info about group members. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes groupId int(11) unsigned NO PRI NULL The group ID from the groups table. memberGuid int(11) unsigned NO PRI NULL The GUID of the character in the group. assistant tinyint(1) unsigned NO NULL Flag stating whether or not the character is the assist. subgroup smallint(6) unsigned NO NULL This is the group number within a raid (8 groups max) 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'guild_bank_eventlog' table for MaNGOSOne Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(11) unsigned NO PRI '0' LogGuid int(11) unsigned NO PRI '0' TabId tinyint(3) unsigned NO PRI '0' EventType tinyint(3) unsigned NO '0' PlayerGuid int(11) unsigned NO MUL '0' ItemOrMoney int(11) unsigned NO '0' ItemStackCount tinyint(3) unsigned NO '0' DestTabId tinyint(1) unsigned NO '0' TimeStamp bigint(20) unsigned NO '0' 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'guild_bank_item' table for MaNGOSOne Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(11) unsigned NO PRI '0' TabId tinyint(1) unsigned NO PRI '0' SlotId tinyint(3) unsigned NO PRI '0' item_guid int(11) unsigned NO MUL '0' item_entry int(11) unsigned NO '0' 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the 'guild_bank_right' table for MaNGOSOne Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(11) unsigned NO PRI '0' TabId tinyint(1) unsigned NO PRI '0' rid int(11) unsigned NO PRI '0' gbright tinyint(3) unsigned NO '0' SlotPerDay int(11) unsigned NO '0' 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

NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. 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: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(11) unsigned NO PRI NULL Id of related guild. [See guild.guildid]. LogGuid int(11) unsigned NO PRI NULL A unique identifier given to each log entry to distinguish it. EventType tinyint(1) unsigned NO NULL The Guild Event Type. PlayerGuid1 int(11) unsigned NO MUL NULL Guid of character who made the change. [See character.guid] PlayerGuid2 int(11) unsigned NO MUL NULL Guid of character who was "changed". [See character.guid] NewRank tinyint(2) unsigned NO NULL Id of new rank of PlayerGuid2. [See guild_rank.rid] TimeStamp bigint(20) unsigned NO NULL Unix timestamp of when the event happened. 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: Value Meaning 1 GUILD_EVENT_LOG_INVITE_PLAYER 2 GUILD_EVENT_LOG_JOIN_GUILD 3 GUILD_EVENT_LOG_PROMOTE_PLAYER 4 GUILD_EVENT_LOG_DEMOTE_PLAYER 5 GUILD_EVENT_LOG_UNINVITE_PLAYER 6 GUILD_EVENT_LOG_LEAVE_GUILD 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