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

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 MaNGOSThree 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 'pet_spell_cooldown' table for MaNGOSThree This table holds information on pet spell cooldowns. Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: 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 'warden_action' 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 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 MaNGOSThree Stores server required values. i.e. Character Database cleanup flags and Honor Point / Rank reset date Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes NextArenaPointDistributionTime bigint(40) unsigned NO '0' NextDailyQuestResetTime bigint(40) unsigned NO '0' NextWeeklyQuestResetTime bigint(40) unsigned NO '0' NextMonthlyQuestResetTime bigint(40) unsigned NO '0' NextRandomBGResetTime 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 NextWeeklyQuestResetTime bigint(40) unsigned NextMonthlyQuestResetTime bigint(40) unsigned NextRandomBGResetTime 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 'world' table for MaNGOSThree 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 'account_data' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes account int(11) unsigned NO PRI '0' type int(11) unsigned NO PRI '0' time bigint(11) unsigned NO '0' data longblob NO NULL Description of the fields account int(11) unsigned type int(11) unsigned time bigint(11) unsigned data longblob 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 MaNGOSTwo 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' category varchar(45) YES MUL {Blank String} multiplier decimal(20,2) NO NULL max_auction_count bigint(20) NO NULL expire_time bigint(20) NO NULL Description of the fields id bigint(20) Notes: Unique identifier of the category category varchar(45) Notes: An Item category Id multiplier decimal(20,2) Notes: The cost multiplier max_auction_count bigint(20) Notes: The max number of items of this category in the AH. expire_time bigint(20) Notes: 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 MaNGOSTwo 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 'ahbot_history' table for MaNGOSTwo 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} 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) Notes: An Item category Id from the list below: 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 MaNGOSTwo 'PlayerbotAI AutoBot names' 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 race smallint(5) unsigned NO NULL 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 Notes: The Gender of the bot race smallint(5) unsigned Notes: The Race of the bot 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 'ai_playerbot_random_bots' table for MaNGOSTwo 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' owner bigint(20) NO MUL NULL bot bigint(20) NO MUL NULL time bigint(20) NO NULL validIn bigint(20) YES NULL event varchar(45) YES MUL {Blank String} value bigint(20) YES NULL data varchar(255) YES {Blank String} Description of the fields id bigint(20) owner bigint(20) bot bigint(20) time bigint(20) validIn bigint(20) event varchar(45) value bigint(20) data varchar(255) 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 'arena_team' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes arenateamid int(10) unsigned NO PRI '0' name char(255) NO {Blank String} captainguid int(10) unsigned NO '0' type tinyint(3) unsigned NO '0' BackgroundColor int(10) unsigned NO '0' EmblemStyle int(10) unsigned NO '0' EmblemColor int(10) unsigned NO '0' BorderStyle int(10) unsigned NO '0' BorderColor int(10) unsigned NO '0' Description of the fields arenateamid int(10) unsigned name char(255) captainguid int(10) unsigned type tinyint(3) unsigned BackgroundColor int(10) unsigned EmblemStyle int(10) unsigned EmblemColor int(10) unsigned BorderStyle int(10) unsigned BorderColor 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 'arena_team_stats' table for MaNGOSTwo Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes arenateamid int(10) unsigned NO PRI '0' rating int(10) unsigned NO '0' games_week int(10) unsigned NO '0' wins_week int(10) unsigned NO '0' games_season int(10) unsigned NO '0' wins_season int(10) unsigned NO '0' rank int(10) unsigned NO '0' Description of the fields arenateamid int(10) unsigned rating int(10) unsigned games_week int(10) unsigned wins_week int(10) unsigned games_season int(10) unsigned wins_season int(10) unsigned rank int(10) unsigned auto-generated by the getMaNGOS.eu MAGNET dbdocs module