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 'guild_bank_tab' 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' TabName varchar(100) NO {Blank String} TabIcon varchar(100) NO {Blank String} TabText varchar(500) YES {Blank String} 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

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 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: 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 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: 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' 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 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 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: 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 MaNGOSOne 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] 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] 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_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: 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. 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. 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 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: 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 '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: 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. itemTextId int(11) unsigned NO '0' The item_text ID of the massage within the mail. 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 int(11) unsigned NO '0' Amount of money sent. cod int(11) 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. 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 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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI '0' The text entry ID. This number is unique to every text entry in this table. text longtext YES NULL The actual text that was sent as mail using the mail system. 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

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 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: 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 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: 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]. type int(10) unsigned NO '0' 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

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 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: 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. type int(10) unsigned NO PRI '0' 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

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 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: 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_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: Field Name Field Type Nullable Key Default Value Attributes Notes guid int(11) unsigned NO PRI '0' The GUID of the pet. [See character_pet.id] spell int(11) unsigned NO PRI '0' The spell ID to which the cooldown applies. time bigint(20) unsigned NO '0' The time when the cooldown expires, in Unix time. 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

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 MaNGOSOne This table holds information on individual pet 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 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

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 'pvpstats_players' 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 battleground_id bigint(20) unsigned NO PRI NULL character_guid int(10) unsigned NO PRI NULL score_killing_blows mediumint(8) unsigned NO NULL score_deaths mediumint(8) unsigned NO NULL score_honorable_kills mediumint(8) unsigned NO NULL score_bonus_honor mediumint(8) unsigned NO NULL score_damage_done mediumint(8) unsigned NO NULL score_healing_done mediumint(8) unsigned NO NULL attr_1 mediumint(8) unsigned NO '0' attr_2 mediumint(8) unsigned NO '0' attr_3 mediumint(8) unsigned NO '0' attr_4 mediumint(8) unsigned NO '0' attr_5 mediumint(8) unsigned NO '0' 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

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 'pvpstats_battlegrounds' 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 id bigint(20) unsigned NO PRI NULL 'auto_increment' winner_team tinyint(4) NO NULL bracket_id tinyint(3) unsigned NO NULL type tinyint(3) unsigned NO NULL date datetime NO NULL 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

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 'world' table for MaNGOSOne Stores World Status information Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes map int(11) unsigned NO PRI '0' The map ID [See Map.dbc] data longtext YES NULL Specific data belonging to the world. 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

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 'warden_action' 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 wardenId smallint(5) unsigned NO PRI NULL action tinyint(3) unsigned YES NULL Description of the fields wardenId smallint(5) unsigned action 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 '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: Field Name Field Type Nullable Key Default Value Attributes Notes NextArenaPointDistributionTime bigint(40) unsigned NO '0' NextDailyQuestResetTime bigint(40) unsigned NO '0' cleaning_flags int(11) unsigned NO '0' The flags controlling character cleanup. Description of the fields NextArenaPointDistributionTime bigint(40) unsigned NextDailyQuestResetTime bigint(40) unsigned cleaning_flags int(11) unsigned The flags controlling character cleanup: Value Enum Name Meaning 0x2 CLEANING_FLAG_SKILLS Clean out obsolete Skills [See character_skills]. 0x4 CLEANING_FLAG_SPELLS Clean out obsolete Spells (See character_spells). 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 'ahbot_history' table for MaNGOSZero Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment' buytime bigint(20) NO NULL item bigint(20) NO NULL bid bigint(20) NO NULL buyout bigint(20) NO NULL won bigint(20) NO MUL NULL category varchar(45) YES MUL {Blank String} An Item category Id from the list below: auction_house bigint(20) NO MUL NULL Description of the fields id bigint(20) buytime bigint(20) item bigint(20) bid bigint(20) buyout bigint(20) won bigint(20) category varchar(45) An Item category Id from the list below: Item Category Enum Category Id ITEM_CLASS_CONSUMABLE 0 ITEM_CLASS_CONTAINER 1 ITEM_CLASS_WEAPON 2 ITEM_CLASS_RESERVED_1 3 ITEM_CLASS_ARMOR 4 ITEM_CLASS_REAGENT 5 ITEM_CLASS_PROJECTILE 6 ITEM_CLASS_TRADE_GOODS 7 ITEM_CLASS_RESERVED_2 8 ITEM_CLASS_RECIPE 9 ITEM_CLASS_RESERVED_3 10 ITEM_CLASS_QUIVER 11 ITEM_CLASS_QUEST 12 ITEM_CLASS_KEY 13 ITEM_CLASS_RESERVED_4 14 ITEM_CLASS_MISC 15 auction_house bigint(20) 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 'ahbot_category' table for MaNGOSZero Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment' Unique identifier of the category category varchar(45) YES MUL {Blank String} An Item category Id multiplier decimal(20,2) NO NULL The cost multiplier max_auction_count bigint(20) NO NULL The max number of items of this category in the AH. expire_time bigint(20) NO NULL The UNIX time when the item will expire. Description of the fields id bigint(20) Unique identifier of the category category varchar(45) An Item category Id from the list below: Item Category Enum Category Id ITEM_CLASS_CONSUMABLE 0 ITEM_CLASS_CONTAINER 1 ITEM_CLASS_WEAPON 2 ITEM_CLASS_RESERVED_1 3 ITEM_CLASS_ARMOR 4 ITEM_CLASS_REAGENT 5 ITEM_CLASS_PROJECTILE 6 ITEM_CLASS_TRADE_GOODS 7 ITEM_CLASS_RESERVED_2 8 ITEM_CLASS_RECIPE 9 ITEM_CLASS_RESERVED_3 10 ITEM_CLASS_QUIVER 11 ITEM_CLASS_QUEST 12 ITEM_CLASS_KEY 13 ITEM_CLASS_RESERVED_4 14 ITEM_CLASS_MISC 15 multiplier decimal(20,2) The cost multiplier max_auction_count bigint(20) The max number of items of this category in the AH. expire_time bigint(20) The UNIX time when the item will expire. 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 'ahbot_price' table for MaNGOSZero Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment' item varchar(45) YES MUL {Blank String} price decimal(20,2) NO NULL auction_house bigint(20) NO NULL Description of the fields id bigint(20) item varchar(45) price decimal(20,2) auction_house bigint(20) 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 'ai_playerbot_names' table for MaNGOSZero This table stores a list of playbot names from which a selection are randomly chosen. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes name_id mediumint(8) NO PRI NULL 'auto_increment' name varchar(13) NO UNI {Blank String} gender tinyint(3) unsigned NO NULL The Gender of the bot race smallint(5) unsigned NO NULL The Race of the bot class smallint(5) unsigned NO NULL purpose int(11) unsigned NO NULL priority bit(1) NO NULL in_use bit(1) NO NULL Description of the fields name_id mediumint(8) name varchar(13) gender tinyint(3) unsigned Value Gender 0 Male 1 Female race smallint(5) unsigned Index Value Race Name 1 1 Human 2 2 Orc 3 4 Dwarf 4 8 Night Elf 5 16 Undead 6 32 Tauren 7 64 Gnome 8 128 Troll class smallint(5) unsigned purpose int(11) unsigned priority bit(1) in_use bit(1) 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 'auction' table for MaNGOSZero Contains all information about the currently ongoing auctions in the auction houses. It controls what items are put up for auction and who put it up, who is the highest bidder, etc. 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 identifier for every auction. houseid int(11) unsigned NO '0' The AuctionHouseId [See AuctionHouse.dbc] itemguid int(11) unsigned NO '0' The GUID of the item that is up for auction. [See item_instance.guid] item_template int(11) unsigned NO '0' The entry of the item up for auction. See (item_template.entry) item_count int(11) unsigned NO '0' The stack count of the item item_randompropertyid int(11) NO '0' A link to the Item's RandomProperty Id [See item_template.Randompropertyid]. itemowner int(11) unsigned NO '0' The GUID of the owner of the item up for auction. [See character.guid] buyoutprice int(11) NO '0' The buyout price of the item in copper. time bigint(40) unsigned NO '0' The time when this auction will end, measured in Unix time. buyguid int(11) unsigned NO '0' The GUID of the highest bidder. See (character.guid) lastbid int(11) NO '0' The amount of copper of the last bid made on the item. startbid int(11) NO '0' The amount of copper of the starting bid made on the item. deposit int(11) NO '0' The amount of copper spent on the deposit. Description of the fields id int(11) unsigned Unique identifier for every auction. houseid int(11) unsigned The AuctionHouseId [See AuctionHouse.dbc] itemguid int(11) unsigned The GUID of the item that is up for auction. [See item_instance.guid] item_template int(11) unsigned The entry of the item up for auction. See (item_template.entry) item_count int(11) unsigned The stack count of the item item_randompropertyid int(11) A link to the Item's RandomProperty Id [See item_template.Randompropertyid]. itemowner int(11) unsigned The GUID of the owner of the item up for auction. [See character.guid] buyoutprice int(11) The buyout price of the item in copper. Divide by 100 to get silver and by 100 again to get gold. time bigint(40) unsigned The time when this auction will end, measured in Unix time (number of seconds from 00:00 Jan 1, 1970). buyguid int(11) unsigned The GUID of the highest bidder. See (character.guid) lastbid int(11) The amount of copper of the last bid made on the item. startbid int(11) The amount of copper of the starting bid made on the item. deposit int(11) The amount of copper spent on the deposit. auto-generated by the getMaNGOS.eu MAGNET dbdocs module