SchemaSpy Analysis of mangos - Columns UnifiedDB World Database Generated by
SchemaSpy
Generated by SchemaSpy on Fri Feb 11 23:15 MST 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

mangos contains 1577 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
playercreateinfo_action action int unsigned 10 0
creature_ai_scripts action1_param1 int 10 0
creature_ai_scripts action1_param2 int 10 0
creature_ai_scripts action1_param3 int 10 0
creature_ai_scripts action1_type tinyint unsigned 3 0 Action Type
creature_ai_scripts action2_param1 int 10 0
creature_ai_scripts action2_param2 int 10 0
creature_ai_scripts action2_param3 int 10 0
creature_ai_scripts action2_type tinyint unsigned 3 0 Action Type
creature_ai_scripts action3_param1 int 10 0
creature_ai_scripts action3_param2 int 10 0
creature_ai_scripts action3_param3 int 10 0
creature_ai_scripts action3_type tinyint unsigned 3 0 Action Type
gossip_menu_option action_menu_id mediumint unsigned 8 0
gossip_menu_option action_poi_id mediumint unsigned 8 0
gossip_menu_option action_script_id mediumint unsigned 8 0
spell_learn_spell Active tinyint unsigned 3 1
skill_extra_item_template additionalCreateChance float 12 0 chance to create add
skill_extra_item_template additionalMaxNum tinyint unsigned 3 0 max num of adds
pet_levelstats agi smallint unsigned 5
player_levelstats agi tinyint unsigned 3
creature_template AIName char 64
battleground_template AllianceStartLoc mediumint unsigned 8
battleground_template AllianceStartO float 12
item_template AllowableClass mediumint 7 -1
item_template AllowableRace mediumint 7 -1
item_template ammo_type tinyint unsigned 3 0
playercreateinfo_item amount tinyint unsigned 3 1
gameobject animprogress tinyint unsigned 3 0
spell_bonus_data ap_bonus float 12 0
item_template arcane_res tinyint unsigned 3 0
item_template area mediumint unsigned 8 0
spell_area area mediumint unsigned 8 0
creature_template armor mediumint unsigned 8 0
item_template armor smallint unsigned 5 0
pet_levelstats armor int unsigned 10 0
item_template ArmorDamageModifier float 12 0
creature_template attackpower int unsigned 10 0
spell_pet_auras aura mediumint unsigned 8 pet aura id
spell_area aura_spell mediumint 7 0
creature_addon auras text 65535  √  null
creature_template_addon auras text 65535  √  null
spell_area autocast bit 0 0
item_template BagFamily mediumint 7 0
creature_template baseattacktime int unsigned 10 0
player_classlevelstats basehp smallint unsigned 5
player_classlevelstats basemana smallint unsigned 5
exploration_basexp basexp mediumint 7 0
battlemaster_entry bg_template mediumint unsigned 8 0 Battleground template id
item_template block mediumint unsigned 8 0
item_template bonding tinyint unsigned 3 0
quest_template BonusTalents tinyint unsigned 3 0
creature_model_info bounding_radius float 12 0
gossip_menu_option box_coded tinyint unsigned 3 0
gossip_menu_option box_money int unsigned 10 0
gossip_menu_option box_text text 65535  √  null
locales_gossip_menu_option box_text_loc1 text 65535  √  null
locales_gossip_menu_option box_text_loc2 text 65535  √  null
locales_gossip_menu_option box_text_loc3 text 65535  √  null
locales_gossip_menu_option box_text_loc4 text 65535  √  null
locales_gossip_menu_option box_text_loc5 text 65535  √  null
locales_gossip_menu_option box_text_loc6 text 65535  √  null
locales_gossip_menu_option box_text_loc7 text 65535  √  null
locales_gossip_menu_option box_text_loc8 text 65535  √  null
playercreateinfo_action button smallint unsigned 5 0
item_template BuyCount tinyint unsigned 3 1
item_template BuyPrice int unsigned 10 0
creature_addon bytes1 int unsigned 10 0
creature_template_addon bytes1 int unsigned 10 0
creature_addon bytes2 int unsigned 10 0
creature_template_addon bytes2 int unsigned 10 0
db_version cache_id int 10  √  0
npc_spellclick_spells cast_flags tinyint unsigned 3 first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit
gameobject_template castBarCaption varchar 100
locales_gameobject castbarcaption_loc1 varchar 100
locales_gameobject castbarcaption_loc2 varchar 100
locales_gameobject castbarcaption_loc3 varchar 100
locales_gameobject castbarcaption_loc4 varchar 100
locales_gameobject castbarcaption_loc5 varchar 100
locales_gameobject castbarcaption_loc6 varchar 100
locales_gameobject castbarcaption_loc7 varchar 100
locales_gameobject castbarcaption_loc8 varchar 100
item_enchantment_template chance float unsigned 12 0
pool_creature chance float unsigned 12 0
pool_gameobject chance float unsigned 12 0
pool_pool chance float 12 0
skill_discovery_template chance float 12 0 chance to discover
creature_loot_template ChanceOrQuestChance float 12 100
disenchant_loot_template ChanceOrQuestChance float 12 100
fishing_loot_template ChanceOrQuestChance float 12 100
gameobject_loot_template ChanceOrQuestChance float 12 100
item_loot_template ChanceOrQuestChance float 12 100
mail_loot_template ChanceOrQuestChance float 12 100
milling_loot_template ChanceOrQuestChance float 12 100
pickpocketing_loot_template ChanceOrQuestChance float 12 100
prospecting_loot_template ChanceOrQuestChance float 12 100
reference_loot_template ChanceOrQuestChance float 12 100
skinning_loot_template ChanceOrQuestChance float 12 100
spell_loot_template ChanceOrQuestChance float 12 100
quest_template CharTitleId tinyint unsigned 3 0
item_template class tinyint unsigned 3 0
player_classlevelstats class tinyint unsigned 3
player_levelstats class tinyint unsigned 3
playercreateinfo class tinyint unsigned 3 0
playercreateinfo_action class tinyint unsigned 3 0
playercreateinfo_item class tinyint unsigned 3 0
playercreateinfo_spell class tinyint unsigned 3 0
creature_model_info combat_reach float 12 0
creature_movement_scripts command mediumint unsigned 8 0
event_scripts command mediumint unsigned 8 0
gameobject_scripts command mediumint unsigned 8 0
gossip_scripts command mediumint unsigned 8 0
quest_end_scripts command mediumint unsigned 8 0
quest_start_scripts command mediumint unsigned 8 0
spell_scripts command mediumint unsigned 8 0
creature_ai_scripts comment varchar 255 Event Comment
creature_ai_summons comment varchar 255 Summon Comment
creature_ai_texts comment text 65535  √  null
creature_movement_scripts comments varchar 255
event_scripts comments varchar 255
gameobject_scripts comments varchar 255
gossip_scripts comments varchar 255
quest_end_scripts comments varchar 255
quest_start_scripts comments varchar 255
spell_bonus_data comments varchar 255  √  null
spell_scripts comments varchar 255
quest_template CompletedText text 65535  √  null
locales_quest CompletedText_loc1 text 65535  √  null
locales_quest CompletedText_loc2 text 65535  √  null
locales_quest CompletedText_loc3 text 65535  √  null
locales_quest CompletedText_loc4 text 65535  √  null
locales_quest CompletedText_loc5 text 65535  √  null
locales_quest CompletedText_loc6 text 65535  √  null
locales_quest CompletedText_loc7 text 65535  √  null
locales_quest CompletedText_loc8 text 65535  √  null
quest_template CompleteEmote smallint unsigned 5 0
quest_template CompleteScript mediumint unsigned 8 0
gossip_menu cond_1 tinyint unsigned 3 0
gossip_menu_option cond_1 tinyint unsigned 3 0
gossip_menu cond_1_val_1 mediumint unsigned 8 0
gossip_menu_option cond_1_val_1 mediumint unsigned 8 0
gossip_menu cond_1_val_2 mediumint unsigned 8 0
gossip_menu_option cond_1_val_2 mediumint unsigned 8 0
gossip_menu cond_2 tinyint unsigned 3 0
gossip_menu_option cond_2 tinyint unsigned 3 0
gossip_menu cond_2_val_1 mediumint unsigned 8 0
gossip_menu_option cond_2_val_1 mediumint unsigned 8 0
gossip_menu cond_2_val_2 mediumint unsigned 8 0
gossip_menu_option cond_2_val_2 mediumint unsigned 8 0
gossip_menu_option cond_3 tinyint unsigned 3 0
gossip_menu_option cond_3_val_1 mediumint unsigned 8 0
gossip_menu_option cond_3_val_2 mediumint unsigned 8 0
creature_loot_template condition_value1 mediumint unsigned 8 0
disenchant_loot_template condition_value1 mediumint unsigned 8 0
fishing_loot_template condition_value1 mediumint unsigned 8 0
gameobject_loot_template condition_value1 mediumint unsigned 8 0
item_loot_template condition_value1 mediumint unsigned 8 0
mail_loot_template condition_value1 mediumint unsigned 8 0
milling_loot_template condition_value1 mediumint unsigned 8 0
pickpocketing_loot_template condition_value1 mediumint unsigned 8 0
prospecting_loot_template condition_value1 mediumint unsigned 8 0
reference_loot_template condition_value1 mediumint unsigned 8 0
skinning_loot_template condition_value1 mediumint unsigned 8 0
spell_loot_template condition_value1 mediumint unsigned 8 0
creature_loot_template condition_value2 mediumint unsigned 8 0
disenchant_loot_template condition_value2 mediumint unsigned 8 0
fishing_loot_template condition_value2 mediumint unsigned 8 0
gameobject_loot_template condition_value2 mediumint unsigned 8 0
item_loot_template condition_value2 mediumint unsigned 8 0
mail_loot_template condition_value2 mediumint unsigned 8 0
milling_loot_template condition_value2 mediumint unsigned 8 0
pickpocketing_loot_template condition_value2 mediumint unsigned 8 0
prospecting_loot_template condition_value2 mediumint unsigned 8 0
reference_loot_template condition_value2 mediumint unsigned 8 0
skinning_loot_template condition_value2 mediumint unsigned 8 0
spell_loot_template condition_value2 mediumint unsigned 8 0
item_template ContainerSlots tinyint unsigned 3 0
creature_ai_texts content_default text 65535
db_script_string content_default text 65535
mangos_string content_default text 65535
creature_ai_texts content_loc1 text 65535  √  null
db_script_string content_loc1 text 65535  √  null
mangos_string content_loc1 text 65535  √  null
creature_ai_texts content_loc2 text 65535  √  null
db_script_string content_loc2 text 65535  √  null
mangos_string content_loc2 text 65535  √  null
creature_ai_texts content_loc3 text 65535  √  null
db_script_string content_loc3 text 65535  √  null
mangos_string content_loc3 text 65535  √  null
creature_ai_texts content_loc4 text 65535  √  null
db_script_string content_loc4 text 65535  √  null
mangos_string content_loc4 text 65535  √  null
creature_ai_texts content_loc5 text 65535  √  null
db_script_string content_loc5 text 65535  √  null
mangos_string content_loc5 text 65535  √  null
creature_ai_texts content_loc6 text 65535  √  null
db_script_string content_loc6 text 65535  √  null
mangos_string content_loc6 text 65535  √  null
creature_ai_texts content_loc7 text 65535  √  null
db_script_string content_loc7 text 65535  √  null
mangos_string content_loc7 text 65535  √  null
creature_ai_texts content_loc8 text 65535  √  null
db_script_string content_loc8 text 65535  √  null
mangos_string content_loc8 text 65535  √  null
spell_proc_event Cooldown int unsigned 10 0
db_version creature_ai_version varchar 120  √  null
creature_model_race creature_entry mediumint unsigned 8 0 option 1, modelid_N from creature_template
pet_levelstats creature_entry mediumint unsigned 8
creature_ai_scripts creature_id int unsigned 10 0 Creature Template Identifier
creature_onkill_reputation creature_id mediumint unsigned 8 0 Creature Identifier
reputation_reward_rate creature_rate float 12 1
achievement_criteria_requirement criteria_id mediumint 7
creature curhealth int unsigned 10 1
creature curmana int unsigned 10 0
creature currentwaypoint mediumint unsigned 8 0
spell_proc_event CustomChance float 12 0
points_of_interest data mediumint unsigned 8 0
gameobject_template data0 int unsigned 10 0
gameobject_template data1 int unsigned 10 0
gameobject_template data10 int unsigned 10 0
gameobject_template data11 int unsigned 10 0
gameobject_template data12 int unsigned 10 0
gameobject_template data13 int unsigned 10 0
gameobject_template data14 int unsigned 10 0
gameobject_template data15 int unsigned 10 0
gameobject_template data16 int unsigned 10 0
gameobject_template data17 int unsigned 10 0
gameobject_template data18 int unsigned 10 0
gameobject_template data19 int unsigned 10 0
gameobject_template data2 int unsigned 10 0
gameobject_template data20 int unsigned 10 0
gameobject_template data21 int unsigned 10 0
gameobject_template data22 int unsigned 10 0
gameobject_template data23 int unsigned 10 0
gameobject_template data3 int unsigned 10 0
gameobject_template data4 int unsigned 10 0
gameobject_template data5 int unsigned 10 0
gameobject_template data6 int unsigned 10 0
gameobject_template data7 int unsigned 10 0
gameobject_template data8 int unsigned 10 0
gameobject_template data9 int unsigned 10 0
creature_movement_scripts data_flags tinyint unsigned 3 0
event_scripts data_flags tinyint unsigned 3 0
gameobject_scripts data_flags tinyint unsigned 3 0
gossip_scripts data_flags tinyint unsigned 3 0
quest_end_scripts data_flags tinyint unsigned 3 0
quest_start_scripts data_flags tinyint unsigned 3 0
spell_scripts data_flags tinyint unsigned 3 0
creature_movement_scripts dataint int 10 0
event_scripts dataint int 10 0
gameobject_scripts dataint int 10 0
gossip_scripts dataint int 10 0
quest_end_scripts dataint int 10 0
quest_start_scripts dataint int 10 0
spell_scripts dataint int 10 0
creature_movement_scripts dataint2 int 10 0
event_scripts dataint2 int 10 0
gameobject_scripts dataint2 int 10 0
gossip_scripts dataint2 int 10 0
quest_end_scripts dataint2 int 10 0
quest_start_scripts dataint2 int 10 0
spell_scripts dataint2 int 10 0
creature_movement_scripts dataint3 int 10 0
event_scripts dataint3 int 10 0
gameobject_scripts dataint3 int 10 0
gossip_scripts dataint3 int 10 0
quest_end_scripts dataint3 int 10 0
quest_start_scripts dataint3 int 10 0
spell_scripts dataint3 int 10 0
creature_movement_scripts dataint4 int 10 0
event_scripts dataint4 int 10 0
gameobject_scripts dataint4 int 10 0
gossip_scripts dataint4 int 10 0
quest_end_scripts dataint4 int 10 0
quest_start_scripts dataint4 int 10 0
spell_scripts dataint4 int 10 0
creature_movement_scripts datalong mediumint unsigned 8 0
event_scripts datalong mediumint unsigned 8 0
gameobject_scripts datalong mediumint unsigned 8 0
gossip_scripts datalong mediumint unsigned 8 0
quest_end_scripts datalong mediumint unsigned 8 0
quest_start_scripts datalong mediumint unsigned 8 0
spell_scripts datalong mediumint unsigned 8 0
creature_movement_scripts datalong2 int unsigned 10 0
event_scripts datalong2 int unsigned 10 0
gameobject_scripts datalong2 int unsigned 10 0
gossip_scripts datalong2 int unsigned 10 0
quest_end_scripts datalong2 int unsigned 10 0
quest_start_scripts datalong2 int unsigned 10 0
spell_scripts datalong2 int unsigned 10 0
creature_movement_scripts datalong3 int unsigned 10 0
event_scripts datalong3 int unsigned 10 0
gameobject_scripts datalong3 int unsigned 10 0
gossip_scripts datalong3 int unsigned 10 0
quest_end_scripts datalong3 int unsigned 10 0
quest_start_scripts datalong3 int unsigned 10 0
spell_scripts datalong3 int unsigned 10 0
creature_movement_scripts datalong4 int unsigned 10 0
event_scripts datalong4 int unsigned 10 0
gameobject_scripts datalong4 int unsigned 10 0
gossip_scripts datalong4 int unsigned 10 0
quest_end_scripts datalong4 int unsigned 10 0
quest_start_scripts datalong4 int unsigned 10 0
spell_scripts datalong4 int unsigned 10 0
creature DeathState tinyint unsigned 3 0
creature_movement_scripts delay int unsigned 10 0
event_scripts delay int unsigned 10 0
gameobject_scripts delay int unsigned 10 0
gossip_scripts delay int unsigned 10 0
item_template delay smallint unsigned 5 1000
quest_end_scripts delay int unsigned 10 0
quest_start_scripts delay int unsigned 10 0
spell_scripts delay int unsigned 10 0
battleground_events description varchar 255
game_event description varchar 255  √  null Description of the event displayed in console
item_template description varchar 255
pool_creature description varchar 255
pool_gameobject description varchar 255
pool_pool description varchar 255
pool_template description varchar 255
locales_item description_loc1 varchar 255  √  null
locales_item description_loc2 varchar 255  √  null
locales_item description_loc3 varchar 255  √  null
locales_item description_loc4 varchar 255  √  null
locales_item description_loc5 varchar 255  √  null
locales_item description_loc6 varchar 255  √  null
locales_item description_loc7 varchar 255  √  null
locales_item description_loc8 varchar 255  √  null
quest_template Details text 65535  √  null
locales_quest Details_loc1 text 65535  √  null
locales_quest Details_loc2 text 65535  √  null
locales_quest Details_loc3 text 65535  √  null
locales_quest Details_loc4 text 65535  √  null
locales_quest Details_loc5 text 65535  √  null
locales_quest Details_loc6 text 65535  √  null
locales_quest Details_loc7 text 65535  √  null
locales_quest Details_loc8 text 65535  √  null
quest_template DetailsEmote1 smallint unsigned 5 0
quest_template DetailsEmote2 smallint unsigned 5 0
quest_template DetailsEmote3 smallint unsigned 5 0
quest_template DetailsEmote4 smallint unsigned 5 0
quest_template DetailsEmoteDelay1 int unsigned 10 0
quest_template DetailsEmoteDelay2 int unsigned 10 0
quest_template DetailsEmoteDelay3 int unsigned 10 0
quest_template DetailsEmoteDelay4 int unsigned 10 0
creature_template difficulty_entry_1 mediumint unsigned 8 0
creature_template difficulty_entry_2 mediumint unsigned 8 0
creature_template difficulty_entry_3 mediumint unsigned 8 0
spell_bonus_data direct_bonus float 12 0
item_template DisenchantID mediumint unsigned 8 0
gameobject_template displayId mediumint unsigned 8 0
item_template displayid mediumint unsigned 8 0
item_template dmg_max1 float 12 0
item_template dmg_max2 float 12 0
item_template dmg_min1 float 12 0
item_template dmg_min2 float 12 0
creature_template dmg_multiplier float 12 1
item_template dmg_type1 tinyint unsigned 3 0
item_template dmg_type2 tinyint unsigned 3 0
creature_template dmgschool tinyint 3 0
spell_bonus_data dot_bonus float 12 0
item_template Duration int unsigned 10 0
creature_template dynamicflags int unsigned 10 0
spell_pet_auras effectId tinyint unsigned 3
npc_text em0_0 smallint unsigned 5 0
npc_text em0_1 smallint unsigned 5 0
npc_text em0_2 smallint unsigned 5 0
npc_text em0_3 smallint unsigned 5 0
npc_text em0_4 smallint unsigned 5 0
npc_text em0_5 smallint unsigned 5 0
npc_text em1_0 smallint unsigned 5 0
npc_text em1_1 smallint unsigned 5 0
npc_text em1_2 smallint unsigned 5 0
npc_text em1_3 smallint unsigned 5 0
npc_text em1_4 smallint unsigned 5 0
npc_text em1_5 smallint unsigned 5 0
npc_text em2_0 smallint unsigned 5 0
npc_text em2_1 smallint unsigned 5 0
npc_text em2_2 smallint unsigned 5 0
npc_text em2_3 smallint unsigned 5 0
npc_text em2_4 smallint unsigned 5 0
npc_text em2_5 smallint unsigned 5 0
npc_text em3_0 smallint unsigned 5 0
npc_text em3_1 smallint unsigned 5 0
npc_text em3_2 smallint unsigned 5 0
npc_text em3_3 smallint unsigned 5 0
npc_text em3_4 smallint unsigned 5 0
npc_text em3_5 smallint unsigned 5 0
npc_text em4_0 smallint unsigned 5 0
npc_text em4_1 smallint unsigned 5 0
npc_text em4_2 smallint unsigned 5 0
npc_text em4_3 smallint unsigned 5 0
npc_text em4_4 smallint unsigned 5 0
npc_text em4_5 smallint unsigned 5 0
npc_text em5_0 smallint unsigned 5 0
npc_text em5_1 smallint unsigned 5 0
npc_text em5_2 smallint unsigned 5 0
npc_text em5_3 smallint unsigned 5 0
npc_text em5_4 smallint unsigned 5 0
npc_text em5_5 smallint unsigned 5 0
npc_text em6_0 smallint unsigned 5 0
npc_text em6_1 smallint unsigned 5 0
npc_text em6_2 smallint unsigned 5 0
npc_text em6_3 smallint unsigned 5 0
npc_text em6_4 smallint unsigned 5 0
npc_text em6_5 smallint unsigned 5 0
npc_text em7_0 smallint unsigned 5 0
npc_text em7_1 smallint unsigned 5 0
npc_text em7_2 smallint unsigned 5 0
npc_text em7_3 smallint unsigned 5 0
npc_text em7_4 smallint unsigned 5 0
npc_text em7_5 smallint unsigned 5 0
creature_addon emote int unsigned 10 0
creature_ai_texts emote smallint unsigned 5 0
creature_movement emote mediumint unsigned 8 0
creature_movement_template emote mediumint unsigned 8 0
creature_template_addon emote mediumint unsigned 8 0
item_enchantment_template ench mediumint unsigned 8 0
game_event end_time timestamp 19 0000-00-00 00:00:00 Absolute end date, the event will never start afler
quest_template EndText text 65535  √  null
locales_quest EndText_loc1 text 65535  √  null
locales_quest EndText_loc2 text 65535  √  null
locales_quest EndText_loc3 text 65535  √  null
locales_quest EndText_loc4 text 65535  √  null
locales_quest EndText_loc5 text 65535  √  null
locales_quest EndText_loc6 text 65535  √  null
locales_quest EndText_loc7 text 65535  √  null
locales_quest EndText_loc8 text 65535  √  null
achievement_reward entry mediumint unsigned 8 0
battlemaster_entry entry mediumint unsigned 8 0 Entry of a creature
creature_ai_texts entry mediumint 7
creature_equip_template entry mediumint unsigned 8 0 Unique entry
creature_loot_template entry mediumint unsigned 8 0
creature_movement_template entry mediumint unsigned 8 Creature entry
creature_template entry mediumint unsigned 8 0
creature_template_addon entry mediumint unsigned 8 0
db_script_string entry int unsigned 10 0
disenchant_loot_template entry mediumint unsigned 8 0 Recommended id selection: item_level*100 + item_quality
fishing_loot_template entry mediumint unsigned 8 0
game_event entry mediumint unsigned 8 Entry of the game event
gameobject_loot_template entry mediumint unsigned 8 0
gameobject_template entry mediumint unsigned 8 0
gossip_menu entry smallint unsigned 5 0
item_enchantment_template entry mediumint unsigned 8 0
item_loot_template entry mediumint unsigned 8 0
item_required_target entry mediumint unsigned 8
item_template entry mediumint unsigned 8 0
locales_achievement_reward entry mediumint unsigned 8 0
locales_creature entry mediumint unsigned 8 0
locales_gameobject entry mediumint unsigned 8 0
locales_item entry mediumint unsigned 8 0
locales_npc_text entry mediumint unsigned 8 0
locales_page_text entry mediumint unsigned 8 0
locales_points_of_interest entry mediumint unsigned 8 0
locales_quest entry mediumint unsigned 8 0
mail_loot_template entry mediumint unsigned 8 0
mangos_string entry mediumint unsigned 8 0
milling_loot_template entry mediumint unsigned 8 0
npc_trainer entry mediumint unsigned 8 0
npc_vendor entry mediumint unsigned 8 0
page_text entry mediumint unsigned 8 0
pet_name_generation entry mediumint unsigned 8 0
pickpocketing_loot_template entry mediumint unsigned 8 0
points_of_interest entry mediumint unsigned 8 0
pool_template entry mediumint unsigned 8 0 Pool entry
prospecting_loot_template entry mediumint unsigned 8 0
quest_template entry mediumint unsigned 8 0
reference_loot_template entry mediumint unsigned 8 0
scripted_areatrigger entry mediumint 7
skill_fishing_base_level entry mediumint unsigned 8 0 Area identifier
skinning_loot_template entry mediumint unsigned 8 0
spell_affect entry unknown 0
spell_bonus_data entry mediumint unsigned 8
spell_elixir entry int unsigned 10 0 SpellId of potion
spell_learn_spell entry smallint unsigned 5 0
spell_loot_template entry mediumint unsigned 8 0
spell_proc_event entry mediumint unsigned 8 0
spell_proc_item_enchant entry mediumint unsigned 8
spell_script_target entry mediumint unsigned 8
spell_threat entry mediumint unsigned 8
transports entry mediumint unsigned 8 0
creature_equip_template equipentry1 mediumint unsigned 8 0
creature_equip_template equipentry2 mediumint unsigned 8 0
creature_equip_template equipentry3 mediumint unsigned 8 0
creature equipment_id mediumint 7 0
creature_template equipment_id mediumint unsigned 8 0
game_event_model_equip equipment_id mediumint unsigned 8 0
game_event_creature event smallint 5 0 Put negatives values to remove during event
game_event_creature_quest event smallint unsigned 5 0
game_event_gameobject event smallint 5 0 Put negatives values to remove during event
game_event_model_equip event smallint unsigned 5 0
battleground_events event1 tinyint unsigned 3
creature_battleground event1 tinyint unsigned 3 main event
gameobject_battleground event1 tinyint unsigned 3 main event
battleground_events event2 tinyint unsigned 3
creature_battleground event2 tinyint unsigned 3 sub event
gameobject_battleground event2 tinyint unsigned 3 sub event
creature_ai_scripts event_chance int unsigned 10 100
creature_ai_scripts event_flags int unsigned 10 0
creature_ai_scripts event_inverse_phase_mask int 10 0 Mask which phases this event will not trigger in
creature_ai_scripts event_param1 int 10 0
creature_ai_scripts event_param2 int 10 0
creature_ai_scripts event_param3 int 10 0
creature_ai_scripts event_param4 int 10 0
creature_ai_scripts event_type tinyint unsigned 3 0 Event Type
quest_template ExclusiveGroup mediumint 7 0
npc_vendor ExtendedCost mediumint unsigned 8 0
item_template ExtraFlags bit 0 0
game_graveyard_zone faction smallint unsigned 5 0
gameobject_template faction smallint unsigned 5 0
reputation_reward_rate faction mediumint unsigned 8 0
reputation_spillover_template faction smallint unsigned 5 0 faction entry
reputation_spillover_template faction1 smallint unsigned 5 0 faction to give spillover for
reputation_spillover_template faction2 smallint unsigned 5 0
reputation_spillover_template faction3 smallint unsigned 5 0
reputation_spillover_template faction4 smallint unsigned 5 0
creature_template faction_A smallint unsigned 5 0
creature_template faction_H smallint unsigned 5 0
game_weather fall_rain_chance tinyint unsigned 3 25
game_weather fall_snow_chance tinyint unsigned 3 25
game_weather fall_storm_chance tinyint unsigned 3 25
creature_template family tinyint 3 0
item_template fire_res tinyint unsigned 3 0
spell_chain first_spell mediumint 7 0
gameobject_template flags int unsigned 10 0
item_template Flags int unsigned 10 0
points_of_interest flags mediumint unsigned 8 0
item_template Flags2 int unsigned 10 0
creature_template flags_extra int unsigned 10 0
quest_poi floorId tinyint unsigned 3 0
item_template FoodType tinyint unsigned 3 0
item_template frost_res tinyint unsigned 3 0
item_template GemProperties mediumint 7 0
achievement_reward gender tinyint 3 2
creature_model_info gender tinyint unsigned 3 2
locales_achievement_reward gender tinyint 3 2
spell_area gender bit 0 2
game_graveyard_zone ghost_zone mediumint unsigned 8 0
creature_template gossip_menu_id mediumint unsigned 8 0
creature_loot_template groupid tinyint unsigned 3 0
disenchant_loot_template groupid tinyint unsigned 3 0
fishing_loot_template groupid tinyint unsigned 3 0
gameobject_loot_template groupid tinyint unsigned 3 0
item_loot_template groupid tinyint unsigned 3 0
mail_loot_template groupid tinyint unsigned 3 0
milling_loot_template groupid tinyint unsigned 3 0
pickpocketing_loot_template groupid tinyint unsigned 3 0
prospecting_loot_template groupid tinyint unsigned 3 0
reference_loot_template groupid tinyint unsigned 3 0
skinning_loot_template groupid tinyint unsigned 3 0
spell_loot_template groupid tinyint unsigned 3 0
creature guid int unsigned 10  √  Global Unique Identifier
creature_addon guid int unsigned 10 0
creature_battleground guid int unsigned 10 Creature's GUID
creature_respawn guid unknown 0
game_event_creature guid int unsigned 10
game_event_gameobject guid int unsigned 10
game_event_model_equip guid int unsigned 10 0
gameobject guid int unsigned 10  √  Global Unique Identifier
gameobject_battleground guid int unsigned 10 GameObject's GUID
gameobject_respawn guid unknown 0
pool_creature guid int unsigned 10 0
pool_gameobject guid int unsigned 10 0
pet_name_generation half tinyint 3 0
command help longtext 2147483647  √  null
areatrigger_teleport heroic_key mediumint unsigned 8 0
areatrigger_teleport heroic_key2 mediumint unsigned 8 0
game_event holiday mediumint unsigned 8 0 Client side holiday id
item_template HolidayId int unsigned 10 0
item_template holy_res tinyint unsigned 3 0
battleground_template HordeStartLoc mediumint unsigned 8
battleground_template HordeStartO float 12
pet_levelstats hp smallint unsigned 5
points_of_interest icon mediumint unsigned 8 0
points_of_interest icon_name text 65535
locales_points_of_interest icon_name_loc1 text 65535  √  null
locales_points_of_interest icon_name_loc2 text 65535  √  null
locales_points_of_interest icon_name_loc3 text 65535  √  null
locales_points_of_interest icon_name_loc4 text 65535  √  null
locales_points_of_interest icon_name_loc5 text 65535  √  null
locales_points_of_interest icon_name_loc6 text 65535  √  null
locales_points_of_interest icon_name_loc7 text 65535  √  null
locales_points_of_interest icon_name_loc8 text 65535  √  null
creature_template IconName char 100  √  null
gameobject_template IconName varchar 100
achievements_dbc id int unsigned 0
areatable_dbc id int unsigned 0
areatrigger_dbc id int unsigned 0
areatrigger_involvedrelation id mediumint unsigned 8 0 Identifier
areatrigger_tavern id mediumint unsigned 8 0 Identifier
areatrigger_teleport id mediumint unsigned 8 0 Identifier
battleground_template id mediumint unsigned 8
chartitles_dbc id int unsigned 0
creature id mediumint unsigned 8 0 Creature Identifier
creature_ai_scripts id int unsigned 10  √  Identifier
creature_ai_summons id int unsigned 10  √  Location Identifier
creature_involvedrelation id mediumint unsigned 8 0 Identifier
creature_movement id int unsigned 10 Creature GUID
creature_movement_scripts id mediumint unsigned 8 0
creature_questrelation id mediumint unsigned 8 0 Identifier
creaturedisplayinfo_dbc id int unsigned 0
event_scripts id mediumint unsigned 8 0
faction_dbc id int unsigned 0
factiontemplate_dbc id int unsigned 0
game_event_creature_quest id mediumint unsigned 8 0
game_graveyard_zone id mediumint unsigned 8 0
game_tele id mediumint unsigned 8  √ 
gameobject id mediumint unsigned 8 0 Gameobject Identifier
gameobject_involvedrelation id mediumint unsigned 8 0
gameobject_questrelation id mediumint unsigned 8 0
gameobject_scripts id mediumint unsigned 8 0
gemproperties_dbc id int unsigned 0
gossip_menu_option id smallint unsigned 5 0
gossip_scripts id mediumint unsigned 8 0
item_dbc id int unsigned 0
itemset_dbc id int unsigned 0
languages_dbc id int unsigned 0
locales_gossip_menu_option id smallint unsigned 5 0
maps_dbc id int unsigned 0
npc_text ID mediumint unsigned 8 0
pet_name_generation id mediumint unsigned 8  √ 
quest_end_scripts id mediumint unsigned 8 0
quest_start_scripts id mediumint unsigned 8 0
scripted_event_id id mediumint 7
spell_dbc id int unsigned 0
spell_scripts id mediumint unsigned 8 0
spell_target_position id mediumint unsigned 8 0 Identifier
spell_teleport id unknown 0
worldsafelocs_dbc id int unsigned 0
quest_template IncompleteEmote smallint unsigned 5 0
npc_vendor incrtime int unsigned 10 0
creature_template InhabitType tinyint unsigned 3 3
pet_levelstats inte smallint unsigned 5
player_levelstats inte tinyint unsigned 3
item_template InventoryType tinyint unsigned 3 0
creature_onkill_reputation IsTeamAward1 tinyint 3 0
creature_onkill_reputation IsTeamAward2 tinyint 3 0
achievement_reward item mediumint unsigned 8 0
creature_loot_template item mediumint unsigned 8 0
disenchant_loot_template item mediumint unsigned 8 0
fishing_loot_template item mediumint unsigned 8 0
gameobject_loot_template item mediumint unsigned 8 0
item_loot_template item mediumint unsigned 8 0
mail_loot_template item mediumint unsigned 8 0
milling_loot_template item mediumint unsigned 8 0
npc_vendor item mediumint unsigned 8 0
pickpocketing_loot_template item mediumint unsigned 8 0
prospecting_loot_template item mediumint unsigned 8 0
reference_loot_template item mediumint unsigned 8 0
skinning_loot_template item mediumint unsigned 8 0
spell_loot_template item mediumint unsigned 8 0
playercreateinfo_item itemid mediumint unsigned 8 0
item_template ItemLevel smallint unsigned 5 0
item_template ItemLimitCategory smallint 5 0
item_template itemset mediumint unsigned 8 0
creature_template KillCredit1 int unsigned 10 0
creature_template KillCredit2 int unsigned 10 0
npc_text lang0 tinyint unsigned 3 0
npc_text lang1 tinyint unsigned 3 0
npc_text lang2 tinyint unsigned 3 0
npc_text lang3 tinyint unsigned 3 0
npc_text lang4 tinyint unsigned 3 0
npc_text lang5 tinyint unsigned 3 0
npc_text lang6 tinyint unsigned 3 0
npc_text lang7 tinyint unsigned 3 0
creature_ai_texts language tinyint unsigned 3 0
item_template LanguageID tinyint unsigned 3 0
game_event length bigint unsigned 20 2592000 Length in minutes of the event
exploration_basexp level tinyint 3 0
mail_level_reward level tinyint unsigned 3 0
pet_levelstats level tinyint unsigned 3
player_classlevelstats level tinyint unsigned 3
player_levelstats level tinyint unsigned 3
instance_template levelMax tinyint unsigned 3 0
instance_template levelMin tinyint unsigned 3 0
quest_template LimitTime int unsigned 10 0
item_template lockid mediumint unsigned 8 0
creature_loot_template lootcondition tinyint unsigned 3 0
disenchant_loot_template lootcondition tinyint unsigned 3 0
fishing_loot_template lootcondition tinyint unsigned 3 0
gameobject_loot_template lootcondition tinyint unsigned 3 0
item_loot_template lootcondition tinyint unsigned 3 0
mail_loot_template lootcondition tinyint unsigned 3 0
milling_loot_template lootcondition tinyint unsigned 3 0
pickpocketing_loot_template lootcondition tinyint unsigned 3 0
prospecting_loot_template lootcondition tinyint unsigned 3 0
reference_loot_template lootcondition tinyint unsigned 3 0
skinning_loot_template lootcondition tinyint unsigned 3 0
spell_loot_template lootcondition tinyint unsigned 3 0
creature_template lootid mediumint unsigned 8 0
player_xp_for_level lvl int unsigned 10
mail_level_reward mailTemplateId mediumint unsigned 8 0
pet_levelstats mana smallint unsigned 5
battleground_events map smallint 5
creature map smallint unsigned 5 0 Map Identifier
game_tele map smallint unsigned 5 0
gameobject map smallint unsigned 5 0 Map Identifier
instance_template map smallint unsigned 5
item_template Map smallint 5 0
playercreateinfo map smallint unsigned 5 0
quest_poi mapAreaId mediumint unsigned 8 0
quest_poi mapId int unsigned 10 0
spell_elixir mask bit 0 0 Mask 0x1 battle 0x2 guardian 0x3 flask 0x7 unstable flasks 0xB shattrath flasks
item_template Material tinyint 3 0
pool_template max_limit int unsigned 10 0 Max number of objects (0) is no limit
creature_loot_template maxcount tinyint unsigned 3 1
disenchant_loot_template maxcount tinyint unsigned 3 1
fishing_loot_template maxcount tinyint unsigned 3 1
gameobject_loot_template maxcount tinyint unsigned 3 1
item_loot_template maxcount smallint unsigned 5 1
item_template maxcount smallint 5 -1
mail_loot_template maxcount tinyint unsigned 3 1
milling_loot_template maxcount tinyint unsigned 3 1
npc_vendor maxcount tinyint unsigned 3 0
pickpocketing_loot_template maxcount tinyint unsigned 3 1
prospecting_loot_template maxcount tinyint unsigned 3 1
reference_loot_template maxcount tinyint unsigned 3 1
skinning_loot_template maxcount tinyint unsigned 3 1
spell_loot_template maxcount tinyint unsigned 3 1
creature_template maxdmg float 12 0
item_template MaxDurability smallint unsigned 5 0
creature_template maxgold mediumint unsigned 8 0
gameobject_template maxgold mediumint unsigned 8 0
creature_template maxhealth int unsigned 10 0
creature_template maxlevel tinyint unsigned 3 1
creature_template maxmana int unsigned 10 0
item_template maxMoneyLoot int unsigned 10 0
battleground_template MaxPlayersPerTeam smallint unsigned 5 0
creature_template maxrangedmg float 12 0
creature_onkill_reputation MaxStanding1 tinyint 3 0
creature_onkill_reputation MaxStanding2 tinyint 3 0
creature_template mechanic_immune_mask int unsigned 10 0
gossip_menu_option menu_id smallint unsigned 5 0
locales_gossip_menu_option menu_id smallint unsigned 5 0
quest_template Method tinyint unsigned 3 2
creature_loot_template mincountOrRef mediumint 7 1
disenchant_loot_template mincountOrRef mediumint 7 1
fishing_loot_template mincountOrRef mediumint 7 1
gameobject_loot_template mincountOrRef mediumint 7 1
item_loot_template mincountOrRef mediumint 7 1
mail_loot_template mincountOrRef mediumint 7 1
milling_loot_template mincountOrRef mediumint 7 1
pickpocketing_loot_template mincountOrRef mediumint 7 1
prospecting_loot_template mincountOrRef mediumint 7 1
reference_loot_template mincountOrRef mediumint 7 1
skinning_loot_template mincountOrRef mediumint 7 1
spell_loot_template mincountOrRef mediumint 7 1
creature_template mindmg float 12 0
creature_template mingold mediumint unsigned 8 0
gameobject_template mingold mediumint unsigned 8 0
creature_template minhealth int unsigned 10 0
creature_template minlevel tinyint unsigned 3 1
quest_template MinLevel tinyint unsigned 3 0
creature_template minmana int unsigned 10 0
item_template minMoneyLoot int unsigned 10 0
battleground_template MinPlayersPerTeam smallint unsigned 5 0
creature_template minrangedmg float 12 0
creature_movement model1 mediumint 7 0
creature_movement_template model1 mediumint 7 0
creature_movement model2 mediumint 7 0
creature_movement_template model2 mediumint 7 0
creature modelid mediumint unsigned 8 0
creature_model_info modelid mediumint unsigned 8 0
creature_model_race modelid mediumint unsigned 8 0
game_event_model_equip modelid mediumint unsigned 8 0
creature_template modelid_1 mediumint unsigned 8 0
creature_template modelid_2 mediumint unsigned 8 0
creature_template modelid_3 mediumint unsigned 8 0
creature_template modelid_4 mediumint unsigned 8 0
creature_model_info modelid_alternative mediumint unsigned 8 0
creature_model_info modelid_other_gender mediumint unsigned 8 0
creature_model_race modelid_racial mediumint unsigned 8 0 option 2, explicit modelid
pool_pool mother_pool mediumint unsigned 8 0
creature_addon mount mediumint unsigned 8 0
creature_template_addon mount mediumint unsigned 8 0
creature_addon moveflags int unsigned 10 0
creature_template_addon moveflags int unsigned 10 0
creature_template movementId int unsigned 10 0
creature MovementType tinyint unsigned 3 0
creature_template MovementType tinyint unsigned 3 0
areatrigger_tavern name text 65535  √  null
areatrigger_teleport name text 65535  √  null
command name varchar 50
creature_template name char 100 0
game_tele name varchar 100
gameobject_template name varchar 100
item_template name varchar 255
reserved_name name varchar 12
transports name text 65535  √  null
locales_creature name_loc1 varchar 100
locales_gameobject name_loc1 varchar 100
locales_item name_loc1 varchar 100
locales_creature name_loc2 varchar 100
locales_gameobject name_loc2 varchar 100
locales_item name_loc2 varchar 100
locales_creature name_loc3 varchar 100
locales_gameobject name_loc3 varchar 100
locales_item name_loc3 varchar 100
locales_creature name_loc4 varchar 100
locales_gameobject name_loc4 varchar 100
locales_item name_loc4 varchar 100
locales_creature name_loc5 varchar 100
locales_gameobject name_loc5 varchar 100
locales_item name_loc5 varchar 100
locales_creature name_loc6 varchar 100
locales_gameobject name_loc6 varchar 100
locales_item name_loc6 varchar 100
locales_creature name_loc7 varchar 100
locales_gameobject name_loc7 varchar 100
locales_item name_loc7 varchar 100
locales_creature name_loc8 varchar 100
locales_gameobject name_loc8 varchar 100
locales_item name_loc8 varchar 100
item_template nature_res tinyint unsigned 3 0
page_text next_page mediumint unsigned 8 0
quest_template NextQuestId mediumint 7 0
quest_template NextQuestInChain mediumint unsigned 8 0
playercreateinfo_spell Note varchar 255  √  null
npc_spellclick_spells npc_entry int unsigned 10 reference to creature_template
npc_gossip npc_guid int unsigned 10 0
gossip_menu_option npc_option_npcflag int unsigned 10 0
creature_template npcflag int unsigned 10 0
creature_movement_scripts o float 12 0
event_scripts o float 12 0
gameobject_scripts o float 12 0
gossip_scripts o float 12 0
quest_end_scripts o float 12 0
quest_start_scripts o float 12 0
spell_scripts o float 12 0
quest_template Objectives text 65535  √  null
locales_quest Objectives_loc1 text 65535  √  null
locales_quest Objectives_loc2 text 65535  √  null
locales_quest Objectives_loc3 text 65535  √  null
locales_quest Objectives_loc4 text 65535  √  null
locales_quest Objectives_loc5 text 65535  √  null
locales_quest Objectives_loc6 text 65535  √  null
locales_quest Objectives_loc7 text 65535  √  null
locales_quest Objectives_loc8 text 65535  √  null
quest_template ObjectiveText1 text 65535  √  null
locales_quest ObjectiveText1_loc1 text 65535  √  null
locales_quest ObjectiveText1_loc2 text 65535  √  null
locales_quest ObjectiveText1_loc3 text 65535  √  null
locales_quest ObjectiveText1_loc4 text 65535  √  null
locales_quest ObjectiveText1_loc5 text 65535  √  null
locales_quest ObjectiveText1_loc6 text 65535  √  null
locales_quest ObjectiveText1_loc7 text 65535  √  null
locales_quest ObjectiveText1_loc8 text 65535  √  null
quest_template ObjectiveText2 text 65535  √  null
locales_quest ObjectiveText2_loc1 text 65535  √  null
locales_quest ObjectiveText2_loc2 text 65535  √  null
locales_quest ObjectiveText2_loc3 text 65535  √  null
locales_quest ObjectiveText2_loc4 text 65535  √  null
locales_quest ObjectiveText2_loc5 text 65535  √  null
locales_quest ObjectiveText2_loc6 text 65535  √  null
locales_quest ObjectiveText2_loc7 text 65535  √  null
locales_quest ObjectiveText2_loc8 text 65535  √  null
quest_template ObjectiveText3 text 65535  √  null
locales_quest ObjectiveText3_loc1 text 65535  √  null
locales_quest ObjectiveText3_loc2 text 65535  √  null
locales_quest ObjectiveText3_loc3 text 65535  √  null
locales_quest ObjectiveText3_loc4 text 65535  √  null
locales_quest ObjectiveText3_loc5 text 65535  √  null
locales_quest ObjectiveText3_loc6 text 65535  √  null
locales_quest ObjectiveText3_loc7 text 65535  √  null
locales_quest ObjectiveText3_loc8 text 65535  √  null
quest_template ObjectiveText4 text 65535  √  null
locales_quest ObjectiveText4_loc1 text 65535  √  null
locales_quest ObjectiveText4_loc2 text 65535  √  null
locales_quest ObjectiveText4_loc3 text 65535  √  null
locales_quest ObjectiveText4_loc4 text 65535  √  null
locales_quest ObjectiveText4_loc5 text 65535  √  null
locales_quest ObjectiveText4_loc6 text 65535  √  null
locales_quest ObjectiveText4_loc7 text 65535  √  null
locales_quest ObjectiveText4_loc8 text 65535  √  null
quest_poi objIndex int 10 0
game_event occurence bigint unsigned 20 5184000 Delay in minutes between occurences of the event
quest_template OfferRewardEmote1 smallint unsigned 5 0
quest_template OfferRewardEmote2 smallint unsigned 5 0
quest_template OfferRewardEmote3 smallint unsigned 5 0
quest_template OfferRewardEmote4 smallint unsigned 5 0
quest_template OfferRewardEmoteDelay1 int unsigned 10 0
quest_template OfferRewardEmoteDelay2 int unsigned 10 0
quest_template OfferRewardEmoteDelay3 int unsigned 10 0
quest_template OfferRewardEmoteDelay4 int unsigned 10 0
quest_template OfferRewardText text 65535  √  null
locales_quest OfferRewardText_loc1 text 65535  √  null
locales_quest OfferRewardText_loc2 text 65535  √  null
locales_quest OfferRewardText_loc3 text 65535  √  null
locales_quest OfferRewardText_loc4 text 65535  √  null
locales_quest OfferRewardText_loc5 text 65535  √  null
locales_quest OfferRewardText_loc6 text 65535  √  null
locales_quest OfferRewardText_loc7 text 65535  √  null
locales_quest OfferRewardText_loc8 text 65535  √  null
gossip_menu_option option_icon mediumint unsigned 8 0
gossip_menu_option option_id tinyint unsigned 3 0
gossip_menu_option option_text text 65535  √  null
locales_gossip_menu_option option_text_loc1 text 65535  √  null
locales_gossip_menu_option option_text_loc2 text 65535  √  null
locales_gossip_menu_option option_text_loc3 text 65535  √  null
locales_gossip_menu_option option_text_loc4 text 65535  √  null
locales_gossip_menu_option option_text_loc5 text 65535  √  null
locales_gossip_menu_option option_text_loc6 text 65535  √  null
locales_gossip_menu_option option_text_loc7 text 65535  √  null
locales_gossip_menu_option option_text_loc8 text 65535  √  null
creature orientation float 12 0
creature_ai_summons orientation float 12 0
creature_movement orientation float 12 0
creature_movement_template orientation float 12 0
game_tele orientation float 12 0
gameobject orientation float 12 0
playercreateinfo orientation float 12 0
item_template PageMaterial tinyint unsigned 3 0
item_template PageText mediumint unsigned 8 0
instance_template parent smallint unsigned 5 0
transports period mediumint unsigned 8 0
spell_pet_auras pet mediumint unsigned 8 0 pet id; 0 = all
creature_template PetSpellDataId mediumint unsigned 8 0
creature phaseMask smallint unsigned 5 1
gameobject phaseMask smallint unsigned 5 1
creature_template pickpocketloot mediumint unsigned 8 0
quest_template PlayersSlain tinyint unsigned 3 0
quest_poi poiId tinyint unsigned 3 0
quest_poi_points poiId tinyint unsigned 3 0
creature_movement point mediumint unsigned 8 0
creature_movement_template point mediumint unsigned 8 0
quest_template PointMapId smallint unsigned 5 0
quest_template PointOpt mediumint unsigned 8 0
quest_template PointX float 12 0
quest_template PointY float 12 0
pool_creature pool_entry mediumint unsigned 8 0
pool_gameobject pool_entry mediumint unsigned 8 0
pool_pool pool_id mediumint unsigned 8 0
creature position_x float 12 0
creature_ai_summons position_x float 12 0
creature_movement position_x float 12 0
creature_movement_template position_x float 12 0
game_tele position_x float 12 0
gameobject position_x float 12 0
playercreateinfo position_x float 12 0
creature position_y float 12 0
creature_ai_summons position_y float 12 0
creature_movement position_y float 12 0
creature_movement_template position_y float 12 0
game_tele position_y float 12 0
gameobject position_y float 12 0
playercreateinfo position_y float 12 0
creature position_z float 12 0
creature_ai_summons position_z float 12 0
creature_movement position_z float 12 0
creature_movement_template position_z float 12 0
game_tele position_z float 12 0
gameobject position_z float 12 0
playercreateinfo position_z float 12 0
spell_proc_event ppmRate float 12 0
spell_proc_item_enchant ppmRate float 12 0
spell_chain prev_spell mediumint 7 0
quest_template PrevQuestId mediumint 7 0
npc_text prob0 float 12 0
npc_text prob1 float 12 0
npc_text prob2 float 12 0
npc_text prob3 float 12 0
npc_text prob4 float 12 0
npc_text prob5 float 12 0
npc_text prob6 float 12 0
npc_text prob7 float 12 0
spell_proc_event procEx int unsigned 10 0
spell_proc_event procFlags int unsigned 10 0
item_template Quality tinyint unsigned 3 0
areatrigger_involvedrelation quest mediumint unsigned 8 0 Quest Identifier
creature_involvedrelation quest mediumint unsigned 8 0 Quest Identifier
creature_questrelation quest mediumint unsigned 8 0 Quest Identifier
game_event_creature_quest quest mediumint unsigned 8 0
gameobject_involvedrelation quest mediumint unsigned 8 0 Quest Identifier
gameobject_questrelation quest mediumint unsigned 8 0 Quest Identifier
npc_spellclick_spells quest_end mediumint unsigned 8 0
spell_area quest_end mediumint unsigned 8 0
reputation_reward_rate quest_rate float 12 1
npc_spellclick_spells quest_start mediumint unsigned 8 reference to quest_template
spell_area quest_start mediumint unsigned 8 0
npc_spellclick_spells quest_start_active bit 0 0
spell_area quest_start_active bit 0 0
quest_template QuestFlags mediumint unsigned 8 0
quest_poi questId mediumint unsigned 8 0
quest_poi_points questId mediumint unsigned 8 0
creature_template questItem1 int unsigned 10 0
gameobject_template questItem1 int unsigned 10 0
creature_template questItem2 int unsigned 10 0
gameobject_template questItem2 int unsigned 10 0
creature_template questItem3 int unsigned 10 0
gameobject_template questItem3 int unsigned 10 0
creature_template questItem4 int unsigned 10 0
gameobject_template questItem4 int unsigned 10 0
creature_template questItem5 int unsigned 10 0
gameobject_template questItem5 int unsigned 10 0
creature_template questItem6 int unsigned 10 0
gameobject_template questItem6 int unsigned 10 0
quest_template QuestLevel smallint 5 0
player_levelstats race tinyint unsigned 3
playercreateinfo race tinyint unsigned 3 0
playercreateinfo_action race tinyint unsigned 3 0
playercreateinfo_item race tinyint unsigned 3 0
playercreateinfo_spell race tinyint unsigned 3 0
creature_model_race racemask mediumint unsigned 8 0
mail_level_reward raceMask mediumint unsigned 8 0
spell_area racemask mediumint unsigned 8 0
creature_template RacialLeader tinyint unsigned 3 0
item_template RandomProperty mediumint unsigned 8 0
item_template RandomSuffix mediumint unsigned 8 0
creature_template rangeattacktime int unsigned 10 0
creature_template rangedattackpower smallint unsigned 5 0
item_template RangedModRange float 12 0
creature_template rank tinyint unsigned 3 0
spell_chain rank tinyint 3 0
reputation_spillover_template rank_1 tinyint unsigned 3 0 max rank, above this will not give any spillover
reputation_spillover_template rank_2 tinyint unsigned 3 0
reputation_spillover_template rank_3 tinyint unsigned 3 0
reputation_spillover_template rank_4 tinyint unsigned 3 0
reputation_spillover_template rate_1 float 12 0 the given rep points * rate
reputation_spillover_template rate_2 float 12 0
reputation_spillover_template rate_3 float 12 0
reputation_spillover_template rate_4 float 12 0
creature_template RegenHealth tinyint unsigned 3 1
quest_template RepObjectiveFaction smallint unsigned 5 0
quest_template RepObjectiveValue mediumint 7 0
spell_chain req_spell mediumint 7 0
quest_template ReqCreatureOrGOCount1 smallint unsigned 5 0
quest_template ReqCreatureOrGOCount2 smallint unsigned 5 0
quest_template ReqCreatureOrGOCount3 smallint unsigned 5 0
quest_template ReqCreatureOrGOCount4 smallint unsigned 5 0
quest_template ReqCreatureOrGOId1 mediumint 7 0
quest_template ReqCreatureOrGOId2 mediumint 7 0
quest_template ReqCreatureOrGOId3 mediumint 7 0
quest_template ReqCreatureOrGOId4 mediumint 7 0
quest_template ReqItemCount1 smallint unsigned 5 0
quest_template ReqItemCount2 smallint unsigned 5 0
quest_template ReqItemCount3 smallint unsigned 5 0
quest_template ReqItemCount4 smallint unsigned 5 0
quest_template ReqItemCount5 smallint unsigned 5 0
quest_template ReqItemCount6 smallint unsigned 5 0
quest_template ReqItemId1 mediumint unsigned 8 0
quest_template ReqItemId2 mediumint unsigned 8 0
quest_template ReqItemId3 mediumint unsigned 8 0
quest_template ReqItemId4 mediumint unsigned 8 0
quest_template ReqItemId5 mediumint unsigned 8 0
quest_template ReqItemId6 mediumint unsigned 8 0
npc_trainer reqlevel tinyint unsigned 3 0
npc_trainer reqskill smallint unsigned 5 0
npc_trainer reqskillvalue smallint unsigned 5 0
skill_discovery_template reqSkillValue smallint unsigned 5 0 skill points requirement
quest_template ReqSourceCount1 smallint unsigned 5 0
quest_template ReqSourceCount2 smallint unsigned 5 0
quest_template ReqSourceCount3 smallint unsigned 5 0
quest_template ReqSourceCount4 smallint unsigned 5 0
quest_template ReqSourceId1 mediumint unsigned 8 0
quest_template ReqSourceId2 mediumint unsigned 8 0
quest_template ReqSourceId3 mediumint unsigned 8 0
quest_template ReqSourceId4 mediumint unsigned 8 0
skill_discovery_template reqSpell mediumint unsigned 8 0 spell requirement
quest_template ReqSpellCast1 mediumint unsigned 8 0
quest_template ReqSpellCast2 mediumint unsigned 8 0
quest_template ReqSpellCast3 mediumint unsigned 8 0
quest_template ReqSpellCast4 mediumint unsigned 8 0
quest_template RequestItemsText text 65535  √  null
locales_quest RequestItemsText_loc1 text 65535  √  null
locales_quest RequestItemsText_loc2 text 65535  √  null
locales_quest RequestItemsText_loc3 text 65535  √  null
locales_quest RequestItemsText_loc4 text 65535  √  null
locales_quest RequestItemsText_loc5 text 65535  √  null
locales_quest RequestItemsText_loc6 text 65535  √  null
locales_quest RequestItemsText_loc7 text 65535  √  null
locales_quest RequestItemsText_loc8 text 65535  √  null
db_version required_10537_01_mangos_command bit 1  √  null
areatrigger_teleport required_failed_text text 65535  √  null
areatrigger_teleport required_item mediumint unsigned 8 0
areatrigger_teleport required_item2 mediumint unsigned 8 0
areatrigger_teleport required_level tinyint unsigned 3 0
areatrigger_teleport required_quest_done int unsigned 10 0
areatrigger_teleport required_quest_done_heroic int unsigned 10 0
item_template RequiredCityRank mediumint unsigned 8 0
item_template RequiredDisenchantSkill smallint 5 -1
item_template requiredhonorrank mediumint unsigned 8 0
item_template RequiredLevel tinyint unsigned 3 0
quest_template RequiredMaxRepFaction smallint unsigned 5 0
quest_template RequiredMaxRepValue mediumint 7 0
quest_template RequiredMinRepFaction smallint unsigned 5 0
quest_template RequiredMinRepValue mediumint 7 0
quest_template RequiredRaces smallint unsigned 5 0
item_template RequiredReputationFaction smallint unsigned 5 0
item_template RequiredReputationRank smallint unsigned 5 0
item_template RequiredSkill smallint unsigned 5 0
item_template RequiredSkillRank smallint unsigned 5 0
quest_template RequiredSkillValue smallint unsigned 5 0
skill_extra_item_template requiredSpecialization mediumint unsigned 8 0 Specialization spell id
item_template requiredspell mediumint unsigned 8 0
creature_template resistance1 smallint 5 0
creature_template resistance2 smallint 5 0
creature_template resistance3 smallint 5 0
creature_template resistance4 smallint 5 0
creature_template resistance5 smallint 5 0
creature_template resistance6 smallint 5 0
quest_template RewChoiceItemCount1 smallint unsigned 5 0
quest_template RewChoiceItemCount2 smallint unsigned 5 0
quest_template RewChoiceItemCount3 smallint unsigned 5 0
quest_template RewChoiceItemCount4 smallint unsigned 5 0
quest_template RewChoiceItemCount5 smallint unsigned 5 0
quest_template RewChoiceItemCount6 smallint unsigned 5 0
quest_template RewChoiceItemId1 mediumint unsigned 8 0
quest_template RewChoiceItemId2 mediumint unsigned 8 0
quest_template RewChoiceItemId3 mediumint unsigned 8 0
quest_template RewChoiceItemId4 mediumint unsigned 8 0
quest_template RewChoiceItemId5 mediumint unsigned 8 0
quest_template RewChoiceItemId6 mediumint unsigned 8 0
quest_template RewHonorAddition int unsigned 10 0
quest_template RewHonorMultiplier float 12 0
quest_template RewItemCount1 smallint unsigned 5 0
quest_template RewItemCount2 smallint unsigned 5 0
quest_template RewItemCount3 smallint unsigned 5 0
quest_template RewItemCount4 smallint unsigned 5 0
quest_template RewItemId1 mediumint unsigned 8 0
quest_template RewItemId2 mediumint unsigned 8 0
quest_template RewItemId3 mediumint unsigned 8 0
quest_template RewItemId4 mediumint unsigned 8 0
quest_template RewMailDelaySecs int unsigned 10 0
quest_template RewMailTemplateId mediumint unsigned 8 0
quest_template RewMoneyMaxLevel int unsigned 10 0
creature_onkill_reputation RewOnKillRepFaction1 smallint 5 0
creature_onkill_reputation RewOnKillRepFaction2 smallint 5 0
creature_onkill_reputation RewOnKillRepValue1 mediumint 7 0
creature_onkill_reputation RewOnKillRepValue2 mediumint 7 0
quest_template RewOrReqMoney int 10 0
quest_template RewRepFaction1 smallint unsigned 5 0 faction id from Faction.dbc in this case
quest_template RewRepFaction2 smallint unsigned 5 0 faction id from Faction.dbc in this case
quest_template RewRepFaction3 smallint unsigned 5 0 faction id from Faction.dbc in this case
quest_template RewRepFaction4 smallint unsigned 5 0 faction id from Faction.dbc in this case
quest_template RewRepFaction5 smallint unsigned 5 0 faction id from Faction.dbc in this case
quest_template RewRepValue1 mediumint 7 0
quest_template RewRepValue2 mediumint 7 0
quest_template RewRepValue3 mediumint 7 0
quest_template RewRepValue4 mediumint 7 0
quest_template RewRepValue5 mediumint 7 0
quest_template RewRepValueId1 tinyint 3 0
quest_template RewRepValueId2 tinyint 3 0
quest_template RewRepValueId3 tinyint 3 0
quest_template RewRepValueId4 tinyint 3 0
quest_template RewRepValueId5 tinyint 3 0
quest_template RewSpell mediumint unsigned 8 0
quest_template RewSpellCast mediumint unsigned 8 0
quest_template RewXPId tinyint unsigned 3 0
gameobject rotation0 float 12 0
gameobject rotation1 float 12 0
gameobject rotation2 float 12 0
gameobject rotation3 float 12 0
creature_template scale float 12 1
item_template ScalingStatDistribution smallint 5 0
item_template ScalingStatValue int unsigned 10 0
spell_proc_event SchoolMask tinyint unsigned 3 0
creature_movement script_id mediumint unsigned 8 0
creature_movement_template script_id mediumint unsigned 8 0
creature_template ScriptName char 64
gameobject_template ScriptName varchar 64
instance_template ScriptName varchar 128
item_template ScriptName varchar 64
scripted_areatrigger ScriptName char 64
scripted_event_id ScriptName char 64
command security tinyint unsigned 3 0
item_template SellPrice int unsigned 10 0
achievement_reward sender mediumint unsigned 8 0
mail_level_reward senderEntry mediumint unsigned 8 0
item_template shadow_res tinyint unsigned 3 0
item_template sheath tinyint unsigned 3 0
gameobject_template size float 12 1
skill_fishing_base_level skill smallint 5 0 Base skill level requirement
quest_template SkillOrClass smallint 5 0
creature_template skinloot mediumint unsigned 8 0
item_template socketBonus mediumint 7 0
item_template socketColor_1 tinyint 3 0
item_template socketColor_2 tinyint 3 0
item_template socketColor_3 tinyint 3 0
item_template socketContent_1 mediumint 7 0
item_template socketContent_2 mediumint 7 0
item_template socketContent_3 mediumint 7 0
creature_ai_texts sound mediumint unsigned 8 0
creature spawndist float 12 5
creature spawnMask tinyint unsigned 3 1
gameobject spawnMask tinyint unsigned 3 1
creature spawntimesecs int unsigned 10 120
creature_ai_summons spawntimesecs int unsigned 10 120
gameobject spawntimesecs int 10 0
quest_template SpecialFlags tinyint unsigned 3 0
creature_template speed_run float 12 1.14286 Result of 8.0/7.0, most common value
creature_template speed_walk float 12 1 Result of 2.5/2.5, most common value
creature_movement spell mediumint unsigned 8 0
creature_movement_template spell mediumint unsigned 8 0
npc_trainer spell mediumint unsigned 8 0
playercreateinfo_spell Spell mediumint unsigned 8 0
spell_area spell mediumint unsigned 8 0
spell_pet_auras spell mediumint unsigned 8 dummy spell id
creature_template spell1 mediumint unsigned 8 0
creature_template spell2 mediumint unsigned 8 0
creature_template spell3 mediumint unsigned 8 0
creature_template spell4 mediumint unsigned 8 0
npc_spellclick_spells spell_id int unsigned 10 spell which should be casted
spell_chain spell_id mediumint 7 0
reputation_reward_rate spell_rate float 12 1
item_template spellcategory_1 smallint unsigned 5 0
item_template spellcategory_2 smallint unsigned 5 0
item_template spellcategory_3 smallint unsigned 5 0
item_template spellcategory_4 smallint unsigned 5 0
item_template spellcategory_5 smallint unsigned 5 0
item_template spellcategorycooldown_1 int 10 -1
item_template spellcategorycooldown_2 int 10 -1
item_template spellcategorycooldown_3 int 10 -1
item_template spellcategorycooldown_4 int 10 -1
item_template spellcategorycooldown_5 int 10 -1
item_template spellcharges_1 smallint 5 0
item_template spellcharges_2 smallint 5 0
item_template spellcharges_3 smallint 5 0
item_template spellcharges_4 smallint 5 0
item_template spellcharges_5 smallint 5 0
item_template spellcooldown_1 int 10 -1
item_template spellcooldown_2 int 10 -1
item_template spellcooldown_3 int 10 -1
item_template spellcooldown_4 int 10 -1
item_template spellcooldown_5 int 10 -1
npc_trainer spellcost int unsigned 10 0
spell_proc_event SpellFamilyMaskA0 int unsigned 10 0
spell_proc_event SpellFamilyMaskA1 int unsigned 10 0
spell_proc_event SpellFamilyMaskA2 int unsigned 10 0
spell_proc_event SpellFamilyMaskB0 int unsigned 10 0
spell_proc_event SpellFamilyMaskB1 int unsigned 10 0
spell_proc_event SpellFamilyMaskB2 int unsigned 10 0
spell_proc_event SpellFamilyMaskC0 int unsigned 10 0
spell_proc_event SpellFamilyMaskC1 int unsigned 10 0
spell_proc_event SpellFamilyMaskC2 int unsigned 10 0
spell_proc_event SpellFamilyName smallint unsigned 5 0
skill_discovery_template spellId mediumint unsigned 8 0 SpellId of the discoverable spell
skill_extra_item_template spellId mediumint unsigned 8 0 SpellId of the item creation spell
spell_learn_spell SpellID smallint unsigned 5 0
item_template spellid_1 mediumint unsigned 8 0
item_template spellid_2 mediumint unsigned 8 0
item_template spellid_3 mediumint unsigned 8 0
item_template spellid_4 mediumint unsigned 8 0
item_template spellid_5 mediumint unsigned 8 0
item_template spellppmRate_1 float 12 0
item_template spellppmRate_2 float 12 0
item_template spellppmRate_3 float 12 0
item_template spellppmRate_4 float 12 0
item_template spellppmRate_5 float 12 0
item_template spelltrigger_1 tinyint unsigned 3 0
item_template spelltrigger_2 tinyint unsigned 3 0
item_template spelltrigger_3 tinyint unsigned 3 0
item_template spelltrigger_4 tinyint unsigned 3 0
item_template spelltrigger_5 tinyint unsigned 3 0
pet_levelstats spi smallint unsigned 5
player_levelstats spi tinyint unsigned 3
game_weather spring_rain_chance tinyint unsigned 3 25
game_weather spring_snow_chance tinyint unsigned 3 25
game_weather spring_storm_chance tinyint unsigned 3 25
quest_template SrcItemCount tinyint unsigned 3 0
quest_template SrcItemId mediumint unsigned 8 0
quest_template SrcSpell mediumint unsigned 8 0
pet_levelstats sta smallint unsigned 5
player_levelstats sta tinyint unsigned 3
item_template stackable smallint 5 1
game_event start_time timestamp 19 0000-00-00 00:00:00 Absolute start date, the event will never start before
item_template startquest mediumint unsigned 8 0
quest_template StartScript mediumint unsigned 8 0
item_template stat_type1 tinyint unsigned 3 0
item_template stat_type10 tinyint unsigned 3 0
item_template stat_type2 tinyint unsigned 3 0
item_template stat_type3 tinyint unsigned 3 0
item_template stat_type4 tinyint unsigned 3 0
item_template stat_type5 tinyint unsigned 3 0
item_template stat_type6 tinyint unsigned 3 0
item_template stat_type7 tinyint unsigned 3 0
item_template stat_type8 tinyint unsigned 3 0
item_template stat_type9 tinyint unsigned 3 0
item_template stat_value1 smallint 5 0
item_template stat_value10 smallint 5 0
item_template stat_value2 smallint 5 0
item_template stat_value3 smallint 5 0
item_template stat_value4 smallint 5 0
item_template stat_value5 smallint 5 0
item_template stat_value6 smallint 5 0
item_template stat_value7 smallint 5 0
item_template stat_value8 smallint 5 0
item_template stat_value9 smallint 5 0
gameobject state tinyint unsigned 3 0
item_template StatsCount tinyint unsigned 3 0
pet_levelstats str smallint unsigned 5
player_levelstats str tinyint unsigned 3
item_template subclass tinyint unsigned 3 0
achievement_reward subject varchar 255  √  null
locales_achievement_reward subject_loc1 varchar 100
locales_achievement_reward subject_loc2 varchar 100
locales_achievement_reward subject_loc3 varchar 100
locales_achievement_reward subject_loc4 varchar 100
locales_achievement_reward subject_loc5 varchar 100
locales_achievement_reward subject_loc6 varchar 100
locales_achievement_reward subject_loc7 varchar 100
locales_achievement_reward subject_loc8 varchar 100
creature_template subname char 100  √  null
locales_creature subname_loc1 varchar 100  √  null
locales_creature subname_loc2 varchar 100  √  null
locales_creature subname_loc3 varchar 100  √  null
locales_creature subname_loc4 varchar 100  √  null
locales_creature subname_loc5 varchar 100  √  null
locales_creature subname_loc6 varchar 100  √  null
locales_creature subname_loc7 varchar 100  √  null
locales_creature subname_loc8 varchar 100  √  null
quest_template SuggestedPlayers tinyint unsigned 3 0
game_weather summer_rain_chance tinyint unsigned 3 25
game_weather summer_snow_chance tinyint unsigned 3 25
game_weather summer_storm_chance tinyint unsigned 3 25
areatrigger_teleport target_map smallint unsigned 5 0
spell_target_position target_map smallint unsigned 5 0
spell_teleport target_map unknown 0
areatrigger_teleport target_orientation float 12 0
spell_target_position target_orientation float 12 0
areatrigger_teleport target_position_x float 12 0
spell_target_position target_position_x float 12 0
areatrigger_teleport target_position_y float 12 0
spell_target_position target_position_y float 12 0
areatrigger_teleport target_position_z float 12 0
spell_target_position target_position_z float 12 0
item_required_target targetEntry mediumint unsigned 8 0
spell_script_target targetEntry mediumint unsigned 8 0
creature_onkill_reputation TeamDependent tinyint unsigned 3 0
achievement_reward text text 65535  √  null
creature_movement text unknown 0
page_text text longtext 2147483647
npc_text text0_0 longtext 2147483647  √  null
locales_npc_text Text0_0_loc1 longtext 2147483647  √  null
locales_npc_text Text0_0_loc2 longtext 2147483647  √  null
locales_npc_text Text0_0_loc3 longtext 2147483647  √  null
locales_npc_text Text0_0_loc4 longtext 2147483647  √  null
locales_npc_text Text0_0_loc5 longtext 2147483647  √  null
locales_npc_text Text0_0_loc6 longtext 2147483647  √  null
locales_npc_text Text0_0_loc7 longtext 2147483647  √  null
locales_npc_text Text0_0_loc8 longtext 2147483647  √  null
npc_text text0_1 longtext 2147483647  √  null
locales_npc_text Text0_1_loc1 longtext 2147483647  √  null
locales_npc_text Text0_1_loc2 longtext 2147483647  √  null
locales_npc_text Text0_1_loc3 longtext 2147483647  √  null
locales_npc_text Text0_1_loc4 longtext 2147483647  √  null
locales_npc_text Text0_1_loc5 longtext 2147483647  √  null
locales_npc_text Text0_1_loc6 longtext 2147483647  √  null
locales_npc_text Text0_1_loc7 longtext 2147483647  √  null
locales_npc_text Text0_1_loc8 longtext 2147483647  √  null
npc_text text1_0 longtext 2147483647  √  null
locales_npc_text Text1_0_loc1 longtext 2147483647  √  null
locales_npc_text Text1_0_loc2 longtext 2147483647  √  null
locales_npc_text Text1_0_loc3 longtext 2147483647  √  null
locales_npc_text Text1_0_loc4 longtext 2147483647  √  null
locales_npc_text Text1_0_loc5 longtext 2147483647  √  null
locales_npc_text Text1_0_loc6 longtext 2147483647  √  null
locales_npc_text Text1_0_loc7 longtext 2147483647  √  null
locales_npc_text Text1_0_loc8 longtext 2147483647  √  null
npc_text text1_1 longtext 2147483647  √  null
locales_npc_text Text1_1_loc1 longtext 2147483647  √  null
locales_npc_text Text1_1_loc2 longtext 2147483647  √  null
locales_npc_text Text1_1_loc3 longtext 2147483647  √  null
locales_npc_text Text1_1_loc4 longtext 2147483647  √  null
locales_npc_text Text1_1_loc5 longtext 2147483647  √  null
locales_npc_text Text1_1_loc6 longtext 2147483647  √  null
locales_npc_text Text1_1_loc7 longtext 2147483647  √  null
locales_npc_text Text1_1_loc8 longtext 2147483647  √  null
npc_text text2_0 longtext 2147483647  √  null
locales_npc_text Text2_0_loc1 longtext 2147483647  √  null
locales_npc_text Text2_0_loc2 longtext 2147483647  √  null
locales_npc_text Text2_0_loc3 longtext 2147483647  √  null
locales_npc_text Text2_0_loc4 longtext 2147483647  √  null
locales_npc_text Text2_0_loc5 longtext 2147483647  √  null
locales_npc_text Text2_0_loc6 longtext 2147483647  √  null
locales_npc_text Text2_0_loc7 longtext 2147483647  √  null
locales_npc_text Text2_0_loc8 longtext 2147483647  √  null
npc_text text2_1 longtext 2147483647  √  null
locales_npc_text Text2_1_loc1 longtext 2147483647  √  null
locales_npc_text Text2_1_loc2 longtext 2147483647  √  null
locales_npc_text Text2_1_loc3 longtext 2147483647  √  null
locales_npc_text Text2_1_loc4 longtext 2147483647  √  null
locales_npc_text Text2_1_loc5 longtext 2147483647  √  null
locales_npc_text Text2_1_loc6 longtext 2147483647  √  null
locales_npc_text Text2_1_loc7 longtext 2147483647  √  null
locales_npc_text Text2_1_loc8 longtext 2147483647  √  null
npc_text text3_0 longtext 2147483647  √  null
locales_npc_text Text3_0_loc1 longtext 2147483647  √  null
locales_npc_text Text3_0_loc2 longtext 2147483647  √  null
locales_npc_text Text3_0_loc3 longtext 2147483647  √  null
locales_npc_text Text3_0_loc4 longtext 2147483647  √  null
locales_npc_text Text3_0_loc5 longtext 2147483647  √  null
locales_npc_text Text3_0_loc6 longtext 2147483647  √  null
locales_npc_text Text3_0_loc7 longtext 2147483647  √  null
locales_npc_text Text3_0_loc8 longtext 2147483647  √  null
npc_text text3_1 longtext 2147483647  √  null
locales_npc_text Text3_1_loc1 longtext 2147483647  √  null
locales_npc_text Text3_1_loc2 longtext 2147483647  √  null
locales_npc_text Text3_1_loc3 longtext 2147483647  √  null
locales_npc_text Text3_1_loc4 longtext 2147483647  √  null
locales_npc_text Text3_1_loc5 longtext 2147483647  √  null
locales_npc_text Text3_1_loc6 longtext 2147483647  √  null
locales_npc_text Text3_1_loc7 longtext 2147483647  √  null
locales_npc_text Text3_1_loc8 longtext 2147483647  √  null
npc_text text4_0 longtext 2147483647  √  null
locales_npc_text Text4_0_loc1 longtext 2147483647  √  null
locales_npc_text Text4_0_loc2 longtext 2147483647  √  null
locales_npc_text Text4_0_loc3 longtext 2147483647  √  null
locales_npc_text Text4_0_loc4 longtext 2147483647  √  null
locales_npc_text Text4_0_loc5 longtext 2147483647  √  null
locales_npc_text Text4_0_loc6 longtext 2147483647  √  null
locales_npc_text Text4_0_loc7 longtext 2147483647  √  null
locales_npc_text Text4_0_loc8 longtext 2147483647  √  null
npc_text text4_1 longtext 2147483647  √  null
locales_npc_text Text4_1_loc1 longtext 2147483647  √  null
locales_npc_text Text4_1_loc2 longtext 2147483647  √  null
locales_npc_text Text4_1_loc3 longtext 2147483647  √  null
locales_npc_text Text4_1_loc4 longtext 2147483647  √  null
locales_npc_text Text4_1_loc5 longtext 2147483647  √  null
locales_npc_text Text4_1_loc6 longtext 2147483647  √  null
locales_npc_text Text4_1_loc7 longtext 2147483647  √  null
locales_npc_text Text4_1_loc8 longtext 2147483647  √  null
npc_text text5_0 longtext 2147483647  √  null
locales_npc_text Text5_0_loc1 longtext 2147483647  √  null
locales_npc_text Text5_0_loc2 longtext 2147483647  √  null
locales_npc_text Text5_0_loc3 longtext 2147483647  √  null
locales_npc_text Text5_0_loc4 longtext 2147483647  √  null
locales_npc_text Text5_0_loc5 longtext 2147483647  √  null
locales_npc_text Text5_0_loc6 longtext 2147483647  √  null
locales_npc_text Text5_0_loc7 longtext 2147483647  √  null
locales_npc_text Text5_0_loc8 longtext 2147483647  √  null
npc_text text5_1 longtext 2147483647  √  null
locales_npc_text Text5_1_loc1 longtext 2147483647  √  null
locales_npc_text Text5_1_loc2 longtext 2147483647  √  null
locales_npc_text Text5_1_loc3 longtext 2147483647  √  null
locales_npc_text Text5_1_loc4 longtext 2147483647  √  null
locales_npc_text Text5_1_loc5 longtext 2147483647  √  null
locales_npc_text Text5_1_loc6 longtext 2147483647  √  null
locales_npc_text Text5_1_loc7 longtext 2147483647  √  null
locales_npc_text Text5_1_loc8 longtext 2147483647  √  null
npc_text text6_0 longtext 2147483647  √  null
locales_npc_text Text6_0_loc1 longtext 2147483647  √  null
locales_npc_text Text6_0_loc2 longtext 2147483647  √  null
locales_npc_text Text6_0_loc3 longtext 2147483647  √  null
locales_npc_text Text6_0_loc4 longtext 2147483647  √  null
locales_npc_text Text6_0_loc5 longtext 2147483647  √  null
locales_npc_text Text6_0_loc6 longtext 2147483647  √  null
locales_npc_text Text6_0_loc7 longtext 2147483647  √  null
locales_npc_text Text6_0_loc8 longtext 2147483647  √  null
npc_text text6_1 longtext 2147483647  √  null
locales_npc_text Text6_1_loc1 longtext 2147483647  √  null
locales_npc_text Text6_1_loc2 longtext 2147483647  √  null
locales_npc_text Text6_1_loc3 longtext 2147483647  √  null
locales_npc_text Text6_1_loc4 longtext 2147483647  √  null
locales_npc_text Text6_1_loc5 longtext 2147483647  √  null
locales_npc_text Text6_1_loc6 longtext 2147483647  √  null
locales_npc_text Text6_1_loc7 longtext 2147483647  √  null
locales_npc_text Text6_1_loc8 longtext 2147483647  √  null
npc_text text7_0 longtext 2147483647  √  null
locales_npc_text Text7_0_loc1 longtext 2147483647  √  null
locales_npc_text Text7_0_loc2 longtext 2147483647  √  null
locales_npc_text Text7_0_loc3 longtext 2147483647  √  null
locales_npc_text Text7_0_loc4 longtext 2147483647  √  null
locales_npc_text Text7_0_loc5 longtext 2147483647  √  null
locales_npc_text Text7_0_loc6 longtext 2147483647  √  null
locales_npc_text Text7_0_loc7 longtext 2147483647  √  null
locales_npc_text Text7_0_loc8 longtext 2147483647  √  null
npc_text text7_1 longtext 2147483647  √  null
locales_npc_text Text7_1_loc1 longtext 2147483647  √  null
locales_npc_text Text7_1_loc2 longtext 2147483647  √  null
locales_npc_text Text7_1_loc3 longtext 2147483647  √  null
locales_npc_text Text7_1_loc4 longtext 2147483647  √  null
locales_npc_text Text7_1_loc5 longtext 2147483647  √  null
locales_npc_text Text7_1_loc6 longtext 2147483647  √  null
locales_npc_text Text7_1_loc7 longtext 2147483647  √  null
locales_npc_text Text7_1_loc8 longtext 2147483647  √  null
gossip_menu text_id mediumint unsigned 8 0
locales_achievement_reward text_loc1 text 65535  √  null
locales_page_text Text_loc1 longtext 2147483647  √  null
locales_achievement_reward text_loc2 text 65535  √  null
locales_page_text Text_loc2 longtext 2147483647  √  null
locales_achievement_reward text_loc3 text 65535  √  null
locales_page_text Text_loc3 longtext 2147483647  √  null
locales_achievement_reward text_loc4 text 65535  √  null
locales_page_text Text_loc4 longtext 2147483647  √  null
locales_achievement_reward text_loc5 text 65535  √  null
locales_page_text Text_loc5 longtext 2147483647  √  null
locales_achievement_reward text_loc6 text 65535  √  null
locales_page_text Text_loc6 longtext 2147483647  √  null
locales_achievement_reward text_loc7 text 65535  √  null
locales_page_text Text_loc7 longtext 2147483647  √  null
locales_achievement_reward text_loc8 text 65535  √  null
locales_page_text Text_loc8 longtext 2147483647  √  null
npc_gossip textid mediumint unsigned 8 0
creature_movement textid1 int 10 0
creature_movement_template textid1 int 10 0
creature_movement textid2 int 10 0
creature_movement_template textid2 int 10 0
creature_movement textid3 int 10 0
creature_movement_template textid3 int 10 0
creature_movement textid4 int 10 0
creature_movement_template textid4 int 10 0
creature_movement textid5 int 10 0
creature_movement_template textid5 int 10 0
spell_threat Threat smallint 5
quest_template Title text 65535  √  null
achievement_reward title_A mediumint unsigned 8 0
achievement_reward title_H mediumint unsigned 8 0
locales_quest Title_loc1 text 65535  √  null
locales_quest Title_loc2 text 65535  √  null
locales_quest Title_loc3 text 65535  √  null
locales_quest Title_loc4 text 65535  √  null
locales_quest Title_loc5 text 65535  √  null
locales_quest Title_loc6 text 65535  √  null
locales_quest Title_loc7 text 65535  √  null
locales_quest Title_loc8 text 65535  √  null
item_template TotemCategory mediumint 7 0
creature_template trainer_class tinyint unsigned 3 0
creature_template trainer_race tinyint unsigned 3 0
creature_template trainer_spell mediumint unsigned 8 0
creature_template trainer_type tinyint 3 0
achievement_criteria_requirement type tinyint unsigned 3 0
creature_ai_texts type tinyint unsigned 3 0
creature_template type tinyint unsigned 3 0
gameobject_template type tinyint unsigned 3 0
item_required_target type tinyint unsigned 3 0
playercreateinfo_action type smallint unsigned 5 0
quest_template Type smallint unsigned 5 0
spell_script_target type tinyint unsigned 3 0
creature_template type_flags int unsigned 10 0
creature_template unit_class tinyint unsigned 3 0
creature_template unit_flags int unsigned 10 0
item_template unk0 int 10 -1
gameobject_template unk1 varchar 100
creature_template unk16 float 12 1
creature_template unk17 float 12 1
quest_poi unk3 int unsigned 10 0
quest_poi unk4 int unsigned 10 0
achievement_criteria_requirement value1 mediumint unsigned 8 0
achievement_criteria_requirement value2 mediumint unsigned 8 0
db_version version varchar 120  √  null
creature_movement waittime int unsigned 10 0
creature_movement_template waittime int unsigned 10 0
game_weather winter_rain_chance tinyint unsigned 3 25
game_weather winter_snow_chance tinyint unsigned 3 25
game_weather winter_storm_chance tinyint unsigned 3 25
pet_name_generation word tinytext 255
creature_movement wpguid int 10 0
creature_movement_template wpguid int 10 0
creature_movement_scripts x float 12 0
event_scripts x float 12 0
gameobject_scripts x float 12 0
gossip_scripts x float 12 0
points_of_interest x float 12 0
quest_end_scripts x float 12 0
quest_poi_points x int 10 0
quest_start_scripts x float 12 0
spell_scripts x float 12 0
player_xp_for_level xp_for_next_level int unsigned 10
creature_movement_scripts y float 12 0
event_scripts y float 12 0
gameobject_scripts y float 12 0
gossip_scripts y float 12 0
points_of_interest y float 12 0
quest_end_scripts y float 12 0
quest_poi_points y int 10 0
quest_start_scripts y float 12 0
spell_scripts y float 12 0
creature_movement_scripts z float 12 0
event_scripts z float 12 0
gameobject_scripts z float 12 0
gossip_scripts z float 12 0
quest_end_scripts z float 12 0
quest_start_scripts z float 12 0
spell_scripts z float 12 0
game_weather zone mediumint unsigned 8 0
playercreateinfo zone mediumint unsigned 8 0
quest_template ZoneOrSort smallint 5 0