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 '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: 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 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: 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 'groups' table for MaNGOSThree This table holds basic info about groups. Table Notes This table uses the 'InnoDB' 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. groupType tinyint(1) unsigned NO NULL difficulty tinyint(3) unsigned NO '0' raiddifficulty int(11) 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. groupType tinyint(1) unsigned difficulty tinyint(3) unsigned raiddifficulty 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 '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: 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 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: 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 '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: 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 '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: 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 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: 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 'guild_bank_eventlog' table for MaNGOSThree 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 MaNGOSThree 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_tab' table for MaNGOSThree 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' TabName varchar(100) NO {Blank String} TabIcon varchar(100) NO {Blank String} TabText text YES NULL 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

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 MaNGOSThree 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 MaNGOSThree 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

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_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: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(6) unsigned NO MUL '0' The ID of the guild that the member is a part of. [See guild.guildid] guid int(11) unsigned NO PRI '0' The GUID of the player. [See character.guid] rank tinyint(2) unsigned NO '0' The rank that the player has in the guild. [See guild_rank.rid] pnote varchar(31) NO {Blank String} The Player Note set by the player. offnote varchar(31) NO {Blank String} The Officers Note set by officers in the guild. BankResetTimeMoney int(11) unsigned NO '0' BankRemMoney int(11) unsigned NO '0' BankResetTimeTab0 int(11) unsigned NO '0' BankRemSlotsTab0 int(11) unsigned NO '0' BankResetTimeTab1 int(11) unsigned NO '0' BankRemSlotsTab1 int(11) unsigned NO '0' BankResetTimeTab2 int(11) unsigned NO '0' BankRemSlotsTab2 int(11) unsigned NO '0' BankResetTimeTab3 int(11) unsigned NO '0' BankRemSlotsTab3 int(11) unsigned NO '0' BankResetTimeTab4 int(11) unsigned NO '0' BankRemSlotsTab4 int(11) unsigned NO '0' BankResetTimeTab5 int(11) unsigned NO '0' BankRemSlotsTab5 int(11) unsigned NO '0' 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

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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI '0' The instance ID. This number is unique to every instance. map int(11) unsigned NO MUL '0' The map ID the instance is in. [See Map.dbc] resettime bigint(40) unsigned NO MUL '0' The time when the instance will be reset, in Unix time. difficulty tinyint(1) unsigned NO '0' encountersMask int(10) unsigned NO '0' data longtext YES NULL Specific data belonging to the individual instance. 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

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_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: Field Name Field Type Nullable Key Default Value Attributes Notes guildid int(6) unsigned NO PRI '0' The guild ID that the rank is part of. [See guild.guildid] rid int(11) unsigned NO PRI NULL The particular rank ID. This number must be unique to each rank in a guild. rname varchar(255) NO {Blank String} The name of the rank that is displayed in-game. rights int(3) unsigned NO '0' The rights a player with this rank has in the guild. BankMoneyPerDay int(11) unsigned NO '0' 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. Flag Flag Name Meaning 64 GR_RIGHT_EMPTY Having just this flag by itself is equivalent to having no rights at all. 65 GR_RIGHT_GCHATLISTEN Player can read messages in the guild general chat channel. 66 GR_RIGHT_GCHATSPEAK Player can type messages in the guild general chat channel. 68 GR_RIGHT_OFFCHATLISTEN Player can read messages in the guild officers channel. 72 GR_RIGHT_OFFCHATSPEAK Player can type messages in the guild officers channel. 80 GR_RIGHT_INVITE Can invite other players to guild. 96 GR_RIGHT_REMOVE Can kick other players out of guild. 192 GR_RIGHT_PROMOTE Can promote other players. 320 GR_RIGHT_DEMOTE Can demote other players. 4160 GR_RIGHT_SETMOTD Can change the guild message of the day. 8256 GR_RIGHT_EPNOTE Can edit other players' personal notes. 16448 GR_RIGHT_VIEWOFFNOTE Can view the officer notes of other players. 32832 GR_RIGHT_EOFFNOTE Can edit officer notes of other players. 61951 GR_RIGHT_ALL Has all of the rights. BankMoneyPerDay 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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes mapid int(11) unsigned NO PRI '0' The map ID of the instance. [See Map.dbc] difficulty tinyint(1) unsigned NO PRI '0' resettime bigint(40) unsigned NO '0' Dungeon reset time in seconds. 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

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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' Global unique ID of the item loot entry. owner_guid int(11) unsigned NO MUL '0' The GUID of the owner. [See character.guid] itemid int(11) unsigned NO PRI '0' Item template entry ID of the item. amount int(11) unsigned NO '0' Total number of the item. suffix int(11) unsigned NO '0' property int(11) NO '0' Item random property. 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

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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the item. This number is unique for each item instance. owner_guid int(11) unsigned NO MUL '0' The GUID of the character who has ownership of this item. [See character.guid] data longtext YES NULL Much like the playerbytes fields in the characters table. text longtext YES NULL 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. Index Flag Name Meaning 0 OBJECT_FIELD_GUID Item GUID 2 OBJECT_FIELD_TYPE Should be 3 (TYPE_OBJECT + TYPE_ITEM) 3 OBJECT_FIELD_ENTRY Entry 4 OBJECT_FIELD_SCALE_X 1.0 5 OBJECT_FIELD_PADDING Some padding, need more info here. 6 ITEM_FIELD_OWNER owner_guid 8 ITEM_FIELD_CONTAINED If the item is in a bag, the GUID of the bag item; otherwise owner GUID. 10 ITEM_FIELD_CREATOR GUID of character who created the item. 12 ITEM_FIELD_GIFTCREATOR GUID of character who created the "item". [See character_gifts.item_guid]. 14 ITEM_FIELD_STACK_COUNT Current number of item copies in the stack. 15 ITEM_FIELD_DURATION Current duration (in milliseconds) 16 ITEM_FIELD_SPELL_CHARGES Current Number of charges left in the item 21 ITEM_FIELD_FLAGS Flags from "item_template" (See Item_template.flags). 22 ITEM_FIELD_ENCHANTMENT Unknown 55 ITEM_FIELD_PROPERTY_SEED Also called ITEM_FIELD_SUFFIX_FACTOR 56 ITEM_FIELD_RANDOM_PROPERTIES_ID Unknown 57 ITEM_FIELD_ITEM_TEXT_ID Text id used and shown by the item. 58 ITEM_FIELD_DURABILITY Current item durability. 59 ITEM_FIELD_MAXDURABILITY Maximum item durability. text longtext 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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI '0' Unique message id. Every new message gets a new auto incremented id. messageType tinyint(3) unsigned NO '0' message_type. stationery tinyint(3) NO '41' The StationeryID [See Stationery.dbc]. mailTemplateId mediumint(8) unsigned NO '0' The Mail Template Id [See MailTemplate.dbc] sender int(11) unsigned NO '0' Guid of the character who sends the mail. receiver int(11) unsigned NO MUL '0' Guid of the character who receives the mail. subject longtext YES NULL The Subject of the mail. body longtext YES NULL has_items tinyint(3) unsigned NO '0' Boolean value showing whether or not atems have been sent. expire_time bigint(40) unsigned NO '0' Current Unix Time + Unix Time till expiry. deliver_time bigint(40) unsigned NO '0' Current Unix Time + Unix Time till delivery. money bigint(40) unsigned NO '0' Amount of money sent. cod bigint(40) unsigned NO '0' Amount of money needed (COD). checked tinyint(3) unsigned NO '0' checked_flag. 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: Value Type 0 NORMAL 1 COD 2 AUCTION stationery tinyint(3) The StationeryID [See Stationery.dbc]. Value Type 1 plain & purple scroll icon 41 Normal Mail 61 GM Mail 62 Auction House 64 Valentine's Day 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 Hex Value Value Binary ENUM Name 0x00 0 0000 0000 MAIL_CHECK_MASK_NONE 0x01 1 0000 0001 MAIL_CHECK_MASK_READ 0x02 2 0000 0010 MAIL_CHECK_MASK_RETURNED 0x04 4 0000 0100 MAIL_CHECK_MASK_COPIED 0x08 8 0000 1000 MAIL_CHECK_MASK_COD_PAYMENT 0x10 16 0001 0000 MAIL_CHECK_MASK_HAS_BODY Flag Mask: Value ENUM Name 4 Mail has no body (subject only) [TODO: check this behaviour] 16 Mail was not read 17 Mail was read 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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes ownerguid int(10) unsigned NO PRI NULL The petition owner's GUID. [See characters.guid] petitionguid int(10) unsigned YES '0' The GUID of the petition item. See (item_instance.guid) name varchar(255) NO {Blank String} The name of the guild or arena team that the player is trying to petition. 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

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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes mail_id int(11) NO PRI '0' The Mail Id [See mail.id]. item_guid int(11) NO PRI '0' The GUID of the item. item_template int(11) NO '0' The entry ID of the item in the item_template table. receiver int(11) unsigned NO MUL '0' Guid of the character who receives the mail. 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

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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes ownerguid int(10) unsigned NO MUL NULL The GUID of the owner that is trying to make the guild/arena team. petitionguid int(11) unsigned NO PRI '0' The GUID of the charter item. [See item_template.guid] playerguid int(11) unsigned NO PRI '0' The GUID of the player that has signed the charter. [See character.guid] player_account int(11) unsigned NO '0' The account ID of the player that has signed the charter [See account.id]. 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

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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the target affected by the aura. [See character.guid] caster_guid bigint(20) unsigned NO PRI '0' The GUID of the player or creature who casted the aura. [See character.guid] item_guid int(11) unsigned NO PRI '0' Guid of the item that is casting the aura on the pet. spell int(11) unsigned NO PRI '0' The spell from which the aura was applied. [See Spell.dbc column 1] stackcount int(11) unsigned NO '1' This is the total number of times the aura can be stacked on the pet. remaincharges int(11) unsigned NO '0' The number of charges remaining on the aura. basepoints0 int(11) NO '0' Primary effect. basepoints1 int(11) NO '0' Secondary effect (appears to be only healing related) basepoints2 int(11) NO '0' Secondary effect (appears to be only damage related) periodictime0 int(11) unsigned NO '0' Primary effect over time. periodictime1 int(11) unsigned NO '0' Secondary effect (healing) over time periodictime2 int(11) unsigned NO '0' Secondary effect (damage) over time. maxduration int(11) NO '0' The maximum duration of the aura. remaintime int(11) NO '0' The time remaining in seconds on the aura. -1 means that the aura is indefinite. effIndexMask int(11) unsigned NO '0' The effect index of the spell from which the aura came from. 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

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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The pet GUID. [See character_pet.id]. spell int(11) unsigned NO PRI '0' The spell ID.[See (Spell.dbc] active int(11) unsigned NO '0' Boolean 0 or 1 controlling if the spell is active or not. 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