/*
MySQL Backup
Source Host:           localhost
Source Server Version: 4.1.15-nt
Source Database:       world
Date:                  2007-09-29 14:30:52
*/

SET FOREIGN_KEY_CHECKS=0;
use runwow;
#----------------------------
# Table structure for area
#----------------------------
CREATE TABLE `area` (
  `AreaFlag` int(11) default NULL,
  `FishGroupID` int(11) default NULL,
  `Level` int(11) default NULL,
  `Name` varchar(100) default NULL,
  `Type` int(11) default NULL,
  `Weather` int(11) default NULL,
  `WorldMapID` int(11) default NULL,
  `Area_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Area_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table area
#----------------------------

#----------------------------
# Table structure for areatrigger
#----------------------------
CREATE TABLE `areatrigger` (
  `Enabled` varchar(100) default NULL,
  `Facing` float default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `Dismount` varchar(100) default NULL,
  `WorldMapID` int(11) default NULL,
  `AreaTrigger_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`AreaTrigger_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table areatrigger
#----------------------------

#----------------------------
# Table structure for creature
#----------------------------
CREATE TABLE `creature` (
  `AttackTime` int(11) default NULL,
  `AttackTime1` int(11) default NULL,
  `CreatureFamily` int(11) default NULL,
  `CreatureType` int(11) default NULL,
  `Default_Level` int(11) NOT NULL default '1',
  `Default_Faction` int(11) default NULL,
  `Default_Flags` int(11) default NULL,
  `Default_NpcFlags` int(11) default NULL,
  `Default_BehaivorID` int(11) default NULL,
  `Default_SpellGroupID` int(11) default NULL,
  `Default_TradeGroupID` int(11) default NULL,
  `Default_TrainGroupID` int(11) default NULL,
  `Default_LootGroupID` int(11) default NULL,
  `Default_VItemDisplay_0` int(11) default NULL,
  `Default_VItemDisplay_1` int(11) default NULL,
  `Default_VItemDisplay_2` int(11) default NULL,
  `Default_VItemInfo_0` bigint(20) default NULL,
  `Default_VItemInfo_1` bigint(20) default NULL,
  `Default_VItemInfo_2` bigint(20) default NULL,
  `DisplayID` int(11) default NULL,
  `Elite` int(11) default NULL,
  `HealthPerLevel` float NOT NULL default '1.7',
  `CombatReach` float default NULL,
  `Bounding` float default NULL,
  `MountDisplayID` int(11) default NULL,
  `Name` varchar(100) default NULL,
  `Name1` varchar(100) default NULL,
  `Name2` varchar(100) default NULL,
  `Name3` varchar(100) default NULL,
  `Named` varchar(100) default NULL,
  `PowerPerLevel` float NOT NULL default '1.7',
  `Resistance_Physical` int(11) default NULL,
  `Resistance_Holy` int(11) default NULL,
  `Resistance_Fire` int(11) default NULL,
  `Resistance_Nature` int(11) default NULL,
  `Resistance_Frost` int(11) default NULL,
  `Resistance_Shadow` int(11) default NULL,
  `Resistance_Arcane` int(11) default NULL,
  `RunningSpeed` float default NULL,
  `Scale` float default NULL,
  `Title` varchar(100) default NULL,
  `WalkSpeed` float default NULL,
  `Creature_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Creature_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# Records for table creature
#----------------------------


insert  into creature values 
(2000, 2200, 0, 7, 1, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10913, 0, '1.7', '2.6', '2', 0, 'Kobold Vermin', null, null, null, null, '1.7', 6, 0, 0, 0, 0, 0, 0, '6.3', '0.7', null, '6.3', 6);
#----------------------------
# Table structure for dialog
#----------------------------
CREATE TABLE `dialog` (
  `Count` int(11) default NULL,
  `Entry_0_Code` int(11) default NULL,
  `Entry_0_Text` varchar(100) default NULL,
  `Entry_0_Next` int(11) default NULL,
  `Entry_1_Code` int(11) default NULL,
  `Entry_1_Text` varchar(100) default NULL,
  `Entry_1_Next` int(11) default NULL,
  `Entry_2_Code` int(11) default NULL,
  `Entry_2_Text` varchar(100) default NULL,
  `Entry_2_Next` int(11) default NULL,
  `Entry_3_Code` int(11) default NULL,
  `Entry_3_Text` varchar(100) default NULL,
  `Entry_3_Next` int(11) default NULL,
  `Entry_4_Code` int(11) default NULL,
  `Entry_4_Text` varchar(100) default NULL,
  `Entry_4_Next` int(11) default NULL,
  `Entry_5_Code` int(11) default NULL,
  `Entry_5_Text` varchar(100) default NULL,
  `Entry_5_Next` int(11) default NULL,
  `Entry_6_Code` int(11) default NULL,
  `Entry_6_Text` varchar(100) default NULL,
  `Entry_6_Next` int(11) default NULL,
  `Entry_7_Code` int(11) default NULL,
  `Entry_7_Text` varchar(100) default NULL,
  `Entry_7_Next` int(11) default NULL,
  `Entry_8_Code` int(11) default NULL,
  `Entry_8_Text` varchar(100) default NULL,
  `Entry_8_Next` int(11) default NULL,
  `Entry_9_Code` int(11) default NULL,
  `Entry_9_Text` varchar(100) default NULL,
  `Entry_9_Next` int(11) default NULL,
  `Entry_10_Code` int(11) default NULL,
  `Entry_10_Text` varchar(100) default NULL,
  `Entry_10_Next` int(11) default NULL,
  `Entry_11_Code` int(11) default NULL,
  `Entry_11_Text` varchar(100) default NULL,
  `Entry_11_Next` int(11) default NULL,
  `Text_ID` int(11) default NULL,
  `Dialog_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Dialog_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table dialog
#----------------------------

#----------------------------
# Table structure for disenchant
#----------------------------
CREATE TABLE `disenchant` (
  `ItemTemplate_ID` int(11) default NULL,
  `Name` varchar(100) default NULL,
  `Reagent_0_ID` int(11) default NULL,
  `Reagent_0_Count` int(11) default NULL,
  `Reagent_1_ID` int(11) default NULL,
  `Reagent_1_Count` int(11) default NULL,
  `Reagent_2_ID` int(11) default NULL,
  `Reagent_2_Count` int(11) default NULL,
  `Disenchant_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Disenchant_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table disenchant
#----------------------------

#----------------------------
# Table structure for factiontemplate
#----------------------------
CREATE TABLE `factiontemplate` (
  `Description` varchar(100) default NULL,
  `Enemies` int(11) default NULL,
  `Faction_ID` int(11) default NULL,
  `Friends` int(11) default NULL,
  `Hostiles` int(11) default NULL,
  `Reputation` int(11) default NULL,
  `FactionTemplate_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`FactionTemplate_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table factiontemplate
#----------------------------

#----------------------------
# Table structure for gameobject
#----------------------------
CREATE TABLE `gameobject` (
  `Facing` float default NULL,
  `Faction` int(11) default NULL,
  `Flags` int(11) default NULL,
  `Level` int(11) default NULL,
  `LootGroupID` int(11) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `QuestGroupID` int(11) default NULL,
  `Rotation_0` float default NULL,
  `Rotation_1` float default NULL,
  `Rotation_2` float default NULL,
  `Rotation_3` float default NULL,
  `State` int(11) default NULL,
  `TemplateID` int(11) default NULL,
  `WorldMapID` int(11) default NULL,
  `GameObject_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`GameObject_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table gameobject
#----------------------------

#----------------------------
# Table structure for goloot
#----------------------------
CREATE TABLE `goloot` (
  `Category` int(11) default NULL,
  `LootGroupID` int(11) default NULL,
  `Percentage` float default NULL,
  `LootTargetID` int(11) default NULL,
  `GOLoot_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`GOLoot_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table goloot
#----------------------------

#----------------------------
# Table structure for gotemplate
#----------------------------
CREATE TABLE `gotemplate` (
  `DisplayID` int(11) default NULL,
  `LootGroupID` int(11) default NULL,
  `Name` varchar(100) default NULL,
  `Name1` varchar(100) default NULL,
  `Name2` varchar(100) default NULL,
  `Name3` varchar(100) default NULL,
  `Scale` float default NULL,
  `Sound_0` int(11) default NULL,
  `Sound_1` int(11) default NULL,
  `Sound_2` int(11) default NULL,
  `Sound_3` int(11) default NULL,
  `Sound_4` int(11) default NULL,
  `Sound_5` int(11) default NULL,
  `Sound_6` int(11) default NULL,
  `Sound_7` int(11) default NULL,
  `Sound_8` int(11) default NULL,
  `Sound_9` int(11) default NULL,
  `Transport` int(11) default NULL,
  `TypeID` int(11) default NULL,
  `GOTemplate_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`GOTemplate_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table gotemplate
#----------------------------

#----------------------------
# Table structure for itemloot
#----------------------------
CREATE TABLE `itemloot` (
  `Category` int(11) default NULL,
  `LootGroupID` int(11) default NULL,
  `Percentage` float default NULL,
  `LootTargetID` int(11) default NULL,
  `ItemLoot_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ItemLoot_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table itemloot
#----------------------------

#----------------------------
# Table structure for itemrandomproperties
#----------------------------
CREATE TABLE `itemrandomproperties` (
  `Enchantment_0` int(11) default NULL,
  `Enchantment_1` int(11) default NULL,
  `Enchantment_2` int(11) default NULL,
  `Flags` int(11) default NULL,
  `Suffix` varchar(100) default NULL,
  `ItemRandomProperties_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ItemRandomProperties_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table itemrandomproperties
#----------------------------

#----------------------------
# Table structure for itemtemplate
#----------------------------
CREATE TABLE `itemtemplate` (
  `Allowable_Class` int(11) default NULL,
  `Allowable_Races` int(11) default NULL,
  `Ammunition_Type` int(11) default NULL,
  `BagType` int(11) default NULL,
  `Block` int(11) default NULL,
  `Bounding` int(11) default NULL,
  `Buy_Price` int(11) default NULL,
  `Class` int(11) default NULL,
  `Container_Slots` int(11) default NULL,
  `Damage_0_Min` float default NULL,
  `Damage_0_Max` float default NULL,
  `Damage_0_Type` int(11) default NULL,
  `Damage_1_Min` float default NULL,
  `Damage_1_Max` float default NULL,
  `Damage_1_Type` int(11) default NULL,
  `Damage_2_Min` float default NULL,
  `Damage_2_Max` float default NULL,
  `Damage_2_Type` int(11) default NULL,
  `Damage_3_Min` float default NULL,
  `Damage_3_Max` float default NULL,
  `Damage_3_Type` int(11) default NULL,
  `Damage_4_Min` float default NULL,
  `Damage_4_Max` float default NULL,
  `Damage_4_Type` int(11) default NULL,
  `Description` varchar(100) default NULL,
  `Icon_ID` int(11) default NULL,
  `Flags` int(11) default NULL,
  `Inventory_Type` int(11) default NULL,
  `Bonus_0_Stat` int(11) default NULL,
  `Bonus_0_Amount` int(11) default NULL,
  `Bonus_1_Stat` int(11) default NULL,
  `Bonus_1_Amount` int(11) default NULL,
  `Bonus_2_Stat` int(11) default NULL,
  `Bonus_2_Amount` int(11) default NULL,
  `Bonus_3_Stat` int(11) default NULL,
  `Bonus_3_Amount` int(11) default NULL,
  `Bonus_4_Stat` int(11) default NULL,
  `Bonus_4_Amount` int(11) default NULL,
  `Bonus_5_Stat` int(11) default NULL,
  `Bonus_5_Amount` int(11) default NULL,
  `Bonus_6_Stat` int(11) default NULL,
  `Bonus_6_Amount` int(11) default NULL,
  `Bonus_7_Stat` int(11) default NULL,
  `Bonus_7_Amount` int(11) default NULL,
  `Bonus_8_Stat` int(11) default NULL,
  `Bonus_8_Amount` int(11) default NULL,
  `Bonus_9_Stat` int(11) default NULL,
  `Bonus_9_Amount` int(11) default NULL,
  `Item_Level` int(11) default NULL,
  `Language_ID` int(11) default NULL,
  `Lock_ID` int(11) default NULL,
  `Material` int(11) default NULL,
  `Max_Count` int(11) default NULL,
  `Max_Durability` int(11) default NULL,
  `Stackable` int(11) default NULL,
  `Required_Skill_Rank` int(11) default NULL,
  `InventoryName` varchar(100) default NULL,
  `QuestName` varchar(100) default NULL,
  `Name3` varchar(100) default NULL,
  `Name4` varchar(100) default NULL,
  `Overall_Quality` int(11) default NULL,
  `Page_Material` int(11) default NULL,
  `Page_Text` int(11) default NULL,
  `RandomProperties` int(11) default NULL,
  `Range` float default NULL,
  `Rank` int(11) default NULL,
  `Required_Level` int(11) default NULL,
  `Required_Skill` int(11) default NULL,
  `ReqSpell` int(11) default NULL,
  `Resistance_Physical` int(11) default NULL,
  `Resistance_Holy` int(11) default NULL,
  `Resistance_Fire` int(11) default NULL,
  `Resistance_Nature` int(11) default NULL,
  `Resistance_Frost` int(11) default NULL,
  `Resistance_Shadow` int(11) default NULL,
  `Resistance_Arcane` int(11) default NULL,
  `Sell_Price` int(11) default NULL,
  `SetID` int(11) default NULL,
  `Sheath` int(11) default NULL,
  `SocketBonus` int(11) default NULL,
  `Socket_0_Type` int(11) default NULL,
  `Socket_0_Bonus` int(11) default NULL,
  `Socket_1_Type` int(11) default NULL,
  `Socket_1_Bonus` int(11) default NULL,
  `Socket_2_Type` int(11) default NULL,
  `Socket_2_Bonus` int(11) default NULL,
  `Spell_0_ID` int(11) default NULL,
  `Spell_0_Trigger` int(11) default NULL,
  `Spell_0_Charges` int(11) default NULL,
  `Spell_0_Cooldown` int(11) default NULL,
  `Spell_0_Category` int(11) default NULL,
  `Spell_0_CategoryCooldown` int(11) default NULL,
  `Spell_1_ID` int(11) default NULL,
  `Spell_1_Trigger` int(11) default NULL,
  `Spell_1_Charges` int(11) default NULL,
  `Spell_1_Cooldown` int(11) default NULL,
  `Spell_1_Category` int(11) default NULL,
  `Spell_1_CategoryCooldown` int(11) default NULL,
  `Spell_2_ID` int(11) default NULL,
  `Spell_2_Trigger` int(11) default NULL,
  `Spell_2_Charges` int(11) default NULL,
  `Spell_2_Cooldown` int(11) default NULL,
  `Spell_2_Category` int(11) default NULL,
  `Spell_2_CategoryCooldown` int(11) default NULL,
  `Spell_3_ID` int(11) default NULL,
  `Spell_3_Trigger` int(11) default NULL,
  `Spell_3_Charges` int(11) default NULL,
  `Spell_3_Cooldown` int(11) default NULL,
  `Spell_3_Category` int(11) default NULL,
  `Spell_3_CategoryCooldown` int(11) default NULL,
  `Spell_4_ID` int(11) default NULL,
  `Spell_4_Trigger` int(11) default NULL,
  `Spell_4_Charges` int(11) default NULL,
  `Spell_4_Cooldown` int(11) default NULL,
  `Spell_4_Category` int(11) default NULL,
  `Spell_4_CategoryCooldown` int(11) default NULL,
  `Start_Quest_ID` int(11) default NULL,
  `SubClass` int(11) default NULL,
  `ToolID` int(11) default NULL,
  `unk3` int(11) default NULL,
  `unk4` int(11) default NULL,
  `unk5` int(11) default NULL,
  `unk6` int(11) default NULL,
  `unk8` int(11) default NULL,
  `Unknown9` int(11) default NULL,
  `Delay` int(11) default NULL,
  `World` int(11) default NULL,
  `ItemTemplate_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ItemTemplate_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# Records for table itemtemplate
#----------------------------


insert  into itemtemplate values 
(-1, -1, 0, 0, 0, 0, 0, 2, 0, '1', '3', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 1542, 0, 21, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 0, 1, 0, 20, 1, 0, 'Worn Shortsword', 'Worn Shortsword', 'Worn Shortsword', 'Worn Shortsword', 1, 0, 0, 0, '0', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 1900, 0, 25), 
(-1, -1, 0, 0, 0, 0, 0, 4, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 9891, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 1, 0, 'Recruit\'s Shirt', 'Recruit\'s Shirt', 'Recruit\'s Shirt', 'Recruit\'s Shirt', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 38), 
(-1, -1, 0, 0, 0, 0, 0, 4, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 9892, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 1, 0, 'Recruit\'s Pants', 'Recruit\'s Pants', 'Recruit\'s Pants', 'Recruit\'s Pants', 0, 0, 0, 0, '0', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 39), 
(-1, -1, 0, 0, 0, 0, 0, 4, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '', 10141, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 1, 0, 'Recruit\'s Boots', 'Recruit\'s Boots', 'Recruit\'s Boots', 'Recruit\'s Boots', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40), 
(-1, -1, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 1069, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'Test Stationery', 'Test Stationery', 'Test Stationery', 'Test Stationery', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8164), 
(-1, -1, 0, 0, 0, 0, 0, 15, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 7798, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'Plain Letter', 'Plain Letter', 'Plain Letter', 'Plain Letter', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8383), 
(-1, -1, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 7798, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'Default Stationery', 'Default Stationery', 'Default Stationery', 'Default Stationery', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9311), 
(-1, -1, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 30658, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'Blizzard Stationery', 'Blizzard Stationery', 'Blizzard Stationery', 'Blizzard Stationery', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18154), 
(-1, -1, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 1102, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'Auction Stationery', 'Auction Stationery', 'Auction Stationery', 'Auction Stationery', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21140), 
(-1, -1, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, '0', '0', 0, null, 34508, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 'Valentine\'s Day  Stationery', 'Valentine\'s Day  Stationery', 'Valentine\'s Day  Stationery', 'Valentine\'s Day  Stationery', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22058);
#----------------------------
# Table structure for lock
#----------------------------
CREATE TABLE `lock` (
  `Level_0` int(11) default NULL,
  `Level_1` int(11) default NULL,
  `Level_2` int(11) default NULL,
  `Level_3` int(11) default NULL,
  `Level_4` int(11) default NULL,
  `Target_0` int(11) default NULL,
  `Target_1` int(11) default NULL,
  `Target_2` int(11) default NULL,
  `Target_3` int(11) default NULL,
  `Target_4` int(11) default NULL,
  `Type` int(11) default NULL,
  `Lock_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Lock_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table lock
#----------------------------

#----------------------------
# Table structure for loot
#----------------------------
CREATE TABLE `loot` (
  `Category` int(11) default NULL,
  `LootGroupID` int(11) default NULL,
  `Percentage` float default NULL,
  `LootTargetID` int(11) default NULL,
  `Loot_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Loot_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table loot
#----------------------------

#----------------------------
# Table structure for monsterspell
#----------------------------
CREATE TABLE `monsterspell` (
  `AutoCast` varchar(100) default NULL,
  `SpellGroupID` int(11) default NULL,
  `Offensive` varchar(100) default NULL,
  `SpellID` int(11) default NULL,
  `MonsterSpell_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`MonsterSpell_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table monsterspell
#----------------------------

#----------------------------
# Table structure for movepoint
#----------------------------
CREATE TABLE `movepoint` (
  `Number` int(11) default NULL,
  `OwnerID` int(11) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `Movepoint_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Movepoint_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table movepoint
#----------------------------

#----------------------------
# Table structure for nskill
#----------------------------
CREATE TABLE `nskill` (
  `Craft` int(11) default NULL,
  `MaxLevel` int(11) default NULL,
  `MinLevel` int(11) default NULL,
  `SpellRank` varchar(100) default NULL,
  `Skill_ID` int(11) default NULL,
  `SkillName` varchar(100) default NULL,
  `Spell_ID` int(11) default NULL,
  `SpellName` varchar(100) default NULL,
  `NSkill_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`NSkill_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table nskill
#----------------------------

#----------------------------
# Table structure for page
#----------------------------
CREATE TABLE `page` (
  `NextPageID` int(11) default NULL,
  `Text` varchar(100) default NULL,
  `Page_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Page_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table page
#----------------------------

#----------------------------
# Table structure for point
#----------------------------
CREATE TABLE `point` (
  `Description` varchar(100) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `Type` int(11) default NULL,
  `WorldMapID` int(11) default NULL,
  `Point_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Point_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table point
#----------------------------

#----------------------------
# Table structure for quest
#----------------------------
CREATE TABLE `quest` (
  `ClassFlag` int(11) default NULL,
  `Complete` varchar(100) default NULL,
  `Description` varchar(100) default NULL,
  `EndGroup` int(11) default NULL,
  `RewardExp` int(11) default NULL,
  `Faction_0` int(11) default NULL,
  `Faction_1` int(11) default NULL,
  `Flags` int(11) default NULL,
  `Incomplete` varchar(100) default NULL,
  `MaxLevel` int(11) default NULL,
  `MinLevel` int(11) default NULL,
  `Required_Skill_Level` int(11) default NULL,
  `RewardMoney` int(11) default NULL,
  `Name` varchar(100) default NULL,
  `Next` int(11) default NULL,
  `PointFlags` int(11) default NULL,
  `PointID` int(11) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `RaceFlag` int(11) default NULL,
  `Reputation_0` int(11) default NULL,
  `Reputation_1` int(11) default NULL,
  `Required_Skill` int(11) default NULL,
  `Requires_0` int(11) default NULL,
  `Requires_1` int(11) default NULL,
  `RewardReputation` int(11) default NULL,
  `RewardItem_0_ID` int(11) default NULL,
  `RewardItem_0_Count` int(11) default NULL,
  `RewardItem_0_Type` int(11) default NULL,
  `RewardItem_1_ID` int(11) default NULL,
  `RewardItem_1_Count` int(11) default NULL,
  `RewardItem_1_Type` int(11) default NULL,
  `RewardItem_2_ID` int(11) default NULL,
  `RewardItem_2_Count` int(11) default NULL,
  `RewardItem_2_Type` int(11) default NULL,
  `RewardItem_3_ID` int(11) default NULL,
  `RewardItem_3_Count` int(11) default NULL,
  `RewardItem_3_Type` int(11) default NULL,
  `RewardItem_4_ID` int(11) default NULL,
  `RewardItem_4_Count` int(11) default NULL,
  `RewardItem_4_Type` int(11) default NULL,
  `RewardItem_5_ID` int(11) default NULL,
  `RewardItem_5_Count` int(11) default NULL,
  `RewardItem_5_Type` int(11) default NULL,
  `StartGroup` int(11) default NULL,
  `Target_0_ID` int(11) default NULL,
  `Target_0_Count` int(11) default NULL,
  `Target_0_Type` int(11) default NULL,
  `Target_1_ID` int(11) default NULL,
  `Target_1_Count` int(11) default NULL,
  `Target_1_Type` int(11) default NULL,
  `Target_2_ID` int(11) default NULL,
  `Target_2_Count` int(11) default NULL,
  `Target_2_Type` int(11) default NULL,
  `Target_3_ID` int(11) default NULL,
  `Target_3_Count` int(11) default NULL,
  `Target_3_Type` int(11) default NULL,
  `Target_4_ID` int(11) default NULL,
  `Target_4_Count` int(11) default NULL,
  `Target_4_Type` int(11) default NULL,
  `Target_5_ID` int(11) default NULL,
  `Target_5_Count` int(11) default NULL,
  `Target_5_Type` int(11) default NULL,
  `Text` varchar(100) default NULL,
  `Time` int(11) default NULL,
  `Type` int(11) default NULL,
  `WorldMap_ID` int(11) default NULL,
  `Zone` int(11) default NULL,
  `Quest_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Quest_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table quest
#----------------------------

#----------------------------
# Table structure for randompropertiesgroups
#----------------------------
CREATE TABLE `randompropertiesgroups` (
  `GroupID` int(11) default NULL,
  `Percent` float default NULL,
  `ItemRandomPropertiesID` int(11) default NULL,
  `RandomPropertiesGroups_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`RandomPropertiesGroups_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table randompropertiesgroups
#----------------------------

#----------------------------
# Table structure for repair
#----------------------------
CREATE TABLE `repair` (
  `Armor_0` int(11) default NULL,
  `Armor_1` int(11) default NULL,
  `Armor_2` int(11) default NULL,
  `Armor_3` int(11) default NULL,
  `Armor_4` int(11) default NULL,
  `Armor_5` int(11) default NULL,
  `Armor_6` int(11) default NULL,
  `Weapon_0` int(11) default NULL,
  `Weapon_1` int(11) default NULL,
  `Weapon_2` int(11) default NULL,
  `Weapon_3` int(11) default NULL,
  `Weapon_4` int(11) default NULL,
  `Weapon_5` int(11) default NULL,
  `Weapon_6` int(11) default NULL,
  `Weapon_7` int(11) default NULL,
  `Weapon_8` int(11) default NULL,
  `Weapon_9` int(11) default NULL,
  `Weapon_10` int(11) default NULL,
  `Weapon_11` int(11) default NULL,
  `Weapon_12` int(11) default NULL,
  `Weapon_13` int(11) default NULL,
  `Weapon_14` int(11) default NULL,
  `Weapon_15` int(11) default NULL,
  `Weapon_16` int(11) default NULL,
  `Weapon_17` int(11) default NULL,
  `Weapon_18` int(11) default NULL,
  `Weapon_19` int(11) default NULL,
  `Weapon_20` int(11) default NULL,
  `Repair_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Repair_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table repair
#----------------------------

#----------------------------
# Table structure for spawn
#----------------------------
CREATE TABLE `spawn` (
  `BehaivorID` int(11) default NULL,
  `CreatureID` int(11) default NULL,
  `Facing` float default NULL,
  `Faction` int(11) default NULL,
  `Flags` int(11) default NULL,
  `Health` int(11) default NULL,
  `Level` int(11) NOT NULL default '1',
  `LootGroupID` int(11) default NULL,
  `NpcFlags` int(11) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `Power` int(11) default NULL,
  `QuestGroupID` int(11) default NULL,
  `SpellGroupID` int(11) default NULL,
  `TaxiID` int(11) default NULL,
  `TextID` int(11) default NULL,
  `TradeGroupID` int(11) default NULL,
  `TrainGroupID` int(11) default NULL,
  `VItem0` bigint(20) default NULL,
  `VItem0D` int(11) default NULL,
  `VItem1` bigint(20) default NULL,
  `VItem1D` int(11) default NULL,
  `VItem2` bigint(20) default NULL,
  `VItem2D` int(11) default NULL,
  `WorldMapID` int(11) default NULL,
  `Spawn_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Spawn_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# Records for table spawn
#----------------------------


insert  into spawn values 
(0, 6, '1', 0, 0, 20, 1, 0, 0, '-8949.95', '-132.493', '83.531', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
#----------------------------
# Table structure for speech
#----------------------------
CREATE TABLE `speech` (
  `Class_0` int(11) default NULL,
  `Class_1` int(11) default NULL,
  `Class_2` int(11) default NULL,
  `Class_3` int(11) default NULL,
  `Class_4` int(11) default NULL,
  `Class_5` int(11) default NULL,
  `Class_6` int(11) default NULL,
  `Class_7` int(11) default NULL,
  `Class_8` int(11) default NULL,
  `Class_9` int(11) default NULL,
  `Class_10` int(11) default NULL,
  `Speech_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Speech_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table speech
#----------------------------

#----------------------------
# Table structure for spell_bk
#----------------------------
CREATE TABLE `spell_bk` (
  `CastTime` int(11) default NULL,
  `Category` int(11) default NULL,
  `CoolDown` int(11) default NULL,
  `CraftReqs_0_ItemTemplateID` int(11) default NULL,
  `CraftReqs_0_Quantity` int(11) default NULL,
  `CraftReqs_1_ItemTemplateID` int(11) default NULL,
  `CraftReqs_1_Quantity` int(11) default NULL,
  `CraftReqs_2_ItemTemplateID` int(11) default NULL,
  `CraftReqs_2_Quantity` int(11) default NULL,
  `CraftReqs_3_ItemTemplateID` int(11) default NULL,
  `CraftReqs_3_Quantity` int(11) default NULL,
  `CraftReqs_4_ItemTemplateID` int(11) default NULL,
  `CraftReqs_4_Quantity` int(11) default NULL,
  `CraftReqs_5_ItemTemplateID` int(11) default NULL,
  `CraftReqs_5_Quantity` int(11) default NULL,
  `CraftReqs_6_ItemTemplateID` int(11) default NULL,
  `CraftReqs_6_Quantity` int(11) default NULL,
  `CreatureType` int(11) default NULL,
  `DispelType` int(11) default NULL,
  `Duration` int(11) default NULL,
  `Effect_0_Type` int(11) default NULL,
  `Effect_0_RandomDamage` int(11) default NULL,
  `Effect_0_Speed` int(11) default NULL,
  `Effect_0_Damage` int(11) default NULL,
  `Effect_0_Radius` float default NULL,
  `Effect_0_Aura` int(11) default NULL,
  `Effect_0_AuraPeriod` int(11) default NULL,
  `Effect_0_Category` int(11) default NULL,
  `Effect_0_AuraParam` int(11) default NULL,
  `Effect_0_Percent` float default NULL,
  `Effect_0_NumTargets` int(11) default NULL,
  `Effect_0_Spell` int(11) default NULL,
  `Effect_0_Combo` float default NULL,
  `Effect_0_ImplicitTargetA` int(11) default NULL,
  `Effect_0_ImplicitTargetB` int(11) default NULL,
  `Effect_1_Type` int(11) default NULL,
  `Effect_1_RandomDamage` int(11) default NULL,
  `Effect_1_Speed` int(11) default NULL,
  `Effect_1_Damage` int(11) default NULL,
  `Effect_1_Radius` float default NULL,
  `Effect_1_Aura` int(11) default NULL,
  `Effect_1_AuraPeriod` int(11) default NULL,
  `Effect_1_Category` int(11) default NULL,
  `Effect_1_AuraParam` int(11) default NULL,
  `Effect_1_Percent` float default NULL,
  `Effect_1_NumTargets` int(11) default NULL,
  `Effect_1_Spell` int(11) default NULL,
  `Effect_1_Combo` float default NULL,
  `Effect_1_ImplicitTargetA` int(11) default NULL,
  `Effect_1_ImplicitTargetB` int(11) default NULL,
  `Effect_2_Type` int(11) default NULL,
  `Effect_2_RandomDamage` int(11) default NULL,
  `Effect_2_Speed` int(11) default NULL,
  `Effect_2_Damage` int(11) default NULL,
  `Effect_2_Radius` float default NULL,
  `Effect_2_Aura` int(11) default NULL,
  `Effect_2_AuraPeriod` int(11) default NULL,
  `Effect_2_Category` int(11) default NULL,
  `Effect_2_AuraParam` int(11) default NULL,
  `Effect_2_Percent` float default NULL,
  `Effect_2_NumTargets` int(11) default NULL,
  `Effect_2_Spell` int(11) default NULL,
  `Effect_2_Combo` float default NULL,
  `Effect_2_ImplicitTargetA` int(11) default NULL,
  `Effect_2_ImplicitTargetB` int(11) default NULL,
  `Flags_0` int(11) default NULL,
  `Flags_1` int(11) default NULL,
  `Flags_2` int(11) default NULL,
  `Flags_3` int(11) default NULL,
  `InventoryTypeTarget` int(11) default NULL,
  `MaxLevel` int(11) default NULL,
  `MaxRange` int(11) default NULL,
  `DispelMechanicType` int(11) default NULL,
  `MinRange` int(11) default NULL,
  `PlayerLevel` int(11) default NULL,
  `PowerCost` int(11) default NULL,
  `PowerCostPercent` int(11) default NULL,
  `ManaCostPerLevel` int(11) default NULL,
  `PowerType` int(11) default NULL,
  `ProcChance` int(11) default NULL,
  `ProcCharges` int(11) default NULL,
  `ProcFlag` int(11) default NULL,
  `Rank` int(11) default NULL,
  `ReqSpell` int(11) default NULL,
  `RequiredItemClass` int(11) default NULL,
  `RequiredItemSubclass` int(11) default NULL,
  `School` int(11) default NULL,
  `SpellFocus` int(11) default NULL,
  `SpellGroupID` int(11) default NULL,
  `SpellLevel` int(11) default NULL,
  `SpellName` varchar(100) default NULL,
  `Tool_0` int(11) default NULL,
  `Tool_1` int(11) default NULL,
  `ToolType_0` int(11) default NULL,
  `ToolType_1` int(11) default NULL,
  `Spell_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Spell_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table spell_bk
#----------------------------

#----------------------------
# Table structure for spellcost
#----------------------------
CREATE TABLE `spellcost` (
  `Cost` int(11) default NULL,
  `Spell_ID` int(11) default NULL,
  `SpellCost_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`SpellCost_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table spellcost
#----------------------------

#----------------------------
# Table structure for sskill
#----------------------------
CREATE TABLE `sskill` (
  `ClassFlag` int(11) default NULL,
  `RaceFlag` int(11) default NULL,
  `Skill_ID` int(11) default NULL,
  `SkillName` varchar(100) default NULL,
  `Spell_ID` int(11) default NULL,
  `SpellName` varchar(100) default NULL,
  `StartSkill` int(11) default NULL,
  `SSkill_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`SSkill_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table sskill
#----------------------------

#----------------------------
# Table structure for startoutfit
#----------------------------
CREATE TABLE `startoutfit` (
  `Class` int(11) default NULL,
  `Gender` int(11) default NULL,
  `Item_0` int(11) default NULL,
  `Item_1` int(11) default NULL,
  `Item_2` int(11) default NULL,
  `Item_3` int(11) default NULL,
  `Item_4` int(11) default NULL,
  `Item_5` int(11) default NULL,
  `Item_6` int(11) default NULL,
  `Item_7` int(11) default NULL,
  `Item_8` int(11) default NULL,
  `Item_9` int(11) default NULL,
  `Item_10` int(11) default NULL,
  `Item_11` int(11) default NULL,
  `Race` int(11) default NULL,
  `StartOutfit_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`StartOutfit_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# Records for table startoutfit
#----------------------------


insert  into startoutfit values 
(1, 0, 25, 38, 39, 40, null, null, null, null, null, null, null, null, 1, 1);
#----------------------------
# Table structure for talent
#----------------------------
CREATE TABLE `talent` (
  `Level` int(11) default NULL,
  `TalentIDNeeded` int(11) default NULL,
  `SpellID_0` int(11) default NULL,
  `SpellID_1` int(11) default NULL,
  `SpellID_2` int(11) default NULL,
  `SpellID_3` int(11) default NULL,
  `SpellID_4` int(11) default NULL,
  `TabNum` int(11) default NULL,
  `Talent_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Talent_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table talent
#----------------------------

#----------------------------
# Table structure for taxinode
#----------------------------
CREATE TABLE `taxinode` (
  `LocationName` varchar(100) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `WorldMapID` int(11) default NULL,
  `TaxiNode_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`TaxiNode_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table taxinode
#----------------------------

#----------------------------
# Table structure for taxipath
#----------------------------
CREATE TABLE `taxipath` (
  `Cost` int(11) default NULL,
  `EndPoint` int(11) default NULL,
  `StartPoint` int(11) default NULL,
  `TaxiPath_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`TaxiPath_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table taxipath
#----------------------------

#----------------------------
# Table structure for taxipathnode
#----------------------------
CREATE TABLE `taxipathnode` (
  `Num` int(11) default NULL,
  `PathID` int(11) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `WorldMapID` int(11) default NULL,
  `TaxiPathNode_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`TaxiPathNode_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table taxipathnode
#----------------------------

#----------------------------
# Table structure for text
#----------------------------
CREATE TABLE `text` (
  `Text` varchar(100) default NULL,
  `Text_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Text_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table text
#----------------------------

#----------------------------
# Table structure for trade
#----------------------------
CREATE TABLE `trade` (
  `Count` int(11) default NULL,
  `TradeGroupID` int(11) default NULL,
  `Quantity` int(11) default NULL,
  `RandomID` int(11) default NULL,
  `TradeTargetID` int(11) default NULL,
  `Trade_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Trade_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table trade
#----------------------------

#----------------------------
# Table structure for train
#----------------------------
CREATE TABLE `train` (
  `TrainGroupID` int(11) default NULL,
  `TrainTargetID` int(11) default NULL,
  `Train_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Train_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table train
#----------------------------

#----------------------------
# Table structure for worldmap
#----------------------------
CREATE TABLE `worldmap` (
  `BottomX` int(11) default NULL,
  `BottomY` int(11) default NULL,
  `EnterLevel` int(11) default NULL,
  `RessurectPosition_X` float default NULL,
  `RessurectPosition_Y` float default NULL,
  `RessurectPosition_Z` float default NULL,
  `RessurectWorld` int(11) default NULL,
  `SpiritHealerID` int(11) default NULL,
  `TileSize` int(11) default NULL,
  `TopX` int(11) default NULL,
  `TopY` int(11) default NULL,
  `WorldMap_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`WorldMap_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# Records for table worldmap
#----------------------------


insert  into worldmap values 
(-20000, -20000, 0, '0', '0', '0', 0, 0, 100, 20000, 20000, 0);
#----------------------------
# Table structure for abilities
#----------------------------
CREATE TABLE `abilities` (
  `Cooldown` date default NULL,
  `Unknown` int(11) default NULL,
  `Level` int(11) default NULL,
  `MaxLevel` int(11) default NULL,
  `Owner_ID` int(11) default NULL,
  `SkillID` int(11) default NULL,
  `SpellID` int(11) default NULL,
  `TalentID` int(11) default NULL,
  `Type` int(11) default NULL,
  `Abilities_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Abilities_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table abilities
#----------------------------

#----------------------------
# Table structure for account
#----------------------------
CREATE TABLE `account` (
  `AccessLvl` int(11) default NULL,
  `CreationDate` date default NULL,
  `LastAccess` date default NULL,
  `LastIP` varchar(100) default NULL,
  `Name` varchar(100) default NULL,
  `Password` varchar(100) default NULL,
  `SessionKey` text,
  `Account_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Account_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table account
#----------------------------

#----------------------------
# Table structure for actionbutton
#----------------------------
CREATE TABLE `actionbutton` (
  `Action` int(11) default NULL,
  `Misc` int(11) default NULL,
  `Owner_ID` int(11) default NULL,
  `Slot` int(11) default NULL,
  `Type` int(11) default NULL,
  `ActionButton_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ActionButton_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table actionbutton
#----------------------------

#----------------------------
# Table structure for auction
#----------------------------
CREATE TABLE `auction` (
  `BuyOutPrice` int(11) default NULL,
  `CreateTime` date default NULL,
  `ExpirationTime` date default NULL,
  `House` int(11) default NULL,
  `ItemClass` int(11) default NULL,
  `ItemEnchantments` int(11) default NULL,
  `ItemID` int(11) default NULL,
  `ItemInventoryType` int(11) default NULL,
  `ItemLevel` int(11) default NULL,
  `ItemName` varchar(100) default NULL,
  `ItemQuality` int(11) default NULL,
  `ItemRandomProperties` int(11) default NULL,
  `ItemStackCount` int(11) default NULL,
  `ItemSubClass` int(11) default NULL,
  `ItemTemplateID` int(11) default NULL,
  `LastBid` int(11) default NULL,
  `OwnerID` int(11) default NULL,
  `AuctionPoolID` int(11) default NULL,
  `StartPrice` int(11) default NULL,
  `TradeTime` int(11) default NULL,
  `Auction_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Auction_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table auction
#----------------------------

#----------------------------
# Table structure for auctionbids
#----------------------------
CREATE TABLE `auctionbids` (
  `AuctionID` int(11) default NULL,
  `BidAmount` int(11) default NULL,
  `BidOwnerID` int(11) default NULL,
  `AuctionBids_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`AuctionBids_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table auctionbids
#----------------------------

#----------------------------
# Table structure for characters
#----------------------------
CREATE TABLE `characters` (
  `AccountID` int(11) default NULL,
  `ActionBars` int(11) default NULL,
  `IsActive` int(11) default NULL,
  `Agility` int(11) default NULL,
  `Ammo` int(11) default NULL,
  `BankSlots` int(11) default NULL,
  `BindPoint_X` float default NULL,
  `BindPoint_Y` float default NULL,
  `BindPoint_Z` float default NULL,
  `BindWorld` int(11) default NULL,
  `BindZone` int(11) default NULL,
  `Class` int(11) default NULL,
  `CreationDate` date default NULL,
  `DeathPoint_X` float default NULL,
  `DeathPoint_Y` float default NULL,
  `DeathPoint_Z` float default NULL,
  `DeathWorld` int(11) default NULL,
  `DisplayID` int(11) default NULL,
  `Exp` int(11) default NULL,
  `Face` int(11) default NULL,
  `FacialHairStyle` int(11) default NULL,
  `Facing` float default NULL,
  `Faction` int(11) default NULL,
  `Gender` int(11) default NULL,
  `GroupID` int(11) default NULL,
  `GuildID` int(11) default NULL,
  `GuildRank` int(11) default NULL,
  `HairColor` int(11) default NULL,
  `HairStyle` int(11) default NULL,
  `Health` int(11) default NULL,
  `HKills` int(11) default NULL,
  `Honor` int(11) default NULL,
  `Intellect` int(11) default NULL,
  `LastAccess` date default NULL,
  `LastPetID` int(11) default NULL,
  `Level` int(11) default NULL,
  `MaxHealth` int(11) default NULL,
  `MaxPower` int(11) default NULL,
  `Money` int(11) default NULL,
  `Name` varchar(100) default NULL,
  `GuildOfficerNote` varchar(100) default NULL,
  `OriginalClass` int(11) default NULL,
  `Outfit_0` int(11) default NULL,
  `Outfit_1` int(11) default NULL,
  `Outfit_2` int(11) default NULL,
  `Outfit_3` int(11) default NULL,
  `Outfit_4` int(11) default NULL,
  `Outfit_5` int(11) default NULL,
  `Outfit_6` int(11) default NULL,
  `Outfit_7` int(11) default NULL,
  `Outfit_8` int(11) default NULL,
  `Outfit_9` int(11) default NULL,
  `Outfit_10` int(11) default NULL,
  `Outfit_11` int(11) default NULL,
  `Outfit_12` int(11) default NULL,
  `Outfit_13` int(11) default NULL,
  `Outfit_14` int(11) default NULL,
  `Outfit_15` int(11) default NULL,
  `Outfit_16` int(11) default NULL,
  `Outfit_17` int(11) default NULL,
  `Outfit_18` int(11) default NULL,
  `Position_X` float default NULL,
  `Position_Y` float default NULL,
  `Position_Z` float default NULL,
  `Power` int(11) default NULL,
  `PowerType` int(11) default NULL,
  `ProfPoints` int(11) default NULL,
  `ProfsWiped` int(11) default NULL,
  `GuildPublicNote` varchar(100) default NULL,
  `PVPRank` int(11) default NULL,
  `Race` int(11) default NULL,
  `RankPoints` int(11) default NULL,
  `RestedState` int(11) default NULL,
  `RPAll` int(11) default NULL,
  `Scale` float default NULL,
  `Skin` int(11) default NULL,
  `Spirit` int(11) default NULL,
  `Stamina` int(11) default NULL,
  `Strength` int(11) default NULL,
  `TalentPoints` int(11) default NULL,
  `TalentsWiped` int(11) default NULL,
  `Taxi_0` int(11) default NULL,
  `Taxi_1` int(11) default NULL,
  `Taxi_2` int(11) default NULL,
  `Taxi_3` int(11) default NULL,
  `Taxi_4` int(11) default NULL,
  `Taxi_5` int(11) default NULL,
  `Taxi_6` int(11) default NULL,
  `Taxi_7` int(11) default NULL,
  `TutorialFlags_0` int(11) default NULL,
  `TutorialFlags_1` int(11) default NULL,
  `TutorialFlags_2` int(11) default NULL,
  `TutorialFlags_3` int(11) default NULL,
  `TutorialFlags_4` int(11) default NULL,
  `TutorialFlags_5` int(11) default NULL,
  `TutorialFlags_6` int(11) default NULL,
  `TutorialFlags_7` int(11) default NULL,
  `UHKills` int(11) default NULL,
  `WeeklyStanding` int(11) default NULL,
  `WorldMapID` int(11) default NULL,
  `Zone` int(11) default NULL,
  `Characters_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Characters_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table characters
#----------------------------

#----------------------------
# Table structure for friendlist
#----------------------------
CREATE TABLE `friendlist` (
  `Friend_ID` int(11) default NULL,
  `Owner_ID` int(11) default NULL,
  `Type` int(11) default NULL,
  `FriendList_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`FriendList_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table friendlist
#----------------------------

#----------------------------
# Table structure for guild
#----------------------------
CREATE TABLE `guild` (
  `Border` int(11) default NULL,
  `BorderColor` int(11) default NULL,
  `Color` int(11) default NULL,
  `CreationDate` date default NULL,
  `GuildInfo` varchar(100) default NULL,
  `Icon` int(11) default NULL,
  `IconColor` int(11) default NULL,
  `Leader` int(11) default NULL,
  `MaxRank` int(11) default NULL,
  `MOTD` varchar(100) default NULL,
  `Name` varchar(100) default NULL,
  `RankFlags_0` int(11) default NULL,
  `RankFlags_1` int(11) default NULL,
  `RankFlags_2` int(11) default NULL,
  `RankFlags_3` int(11) default NULL,
  `RankFlags_4` int(11) default NULL,
  `RankFlags_5` int(11) default NULL,
  `RankFlags_6` int(11) default NULL,
  `RankFlags_7` int(11) default NULL,
  `RankFlags_8` int(11) default NULL,
  `RankFlags_9` int(11) default NULL,
  `RankName_0` varchar(100) default NULL,
  `RankName_1` varchar(100) default NULL,
  `RankName_2` varchar(100) default NULL,
  `RankName_3` varchar(100) default NULL,
  `RankName_4` varchar(100) default NULL,
  `RankName_5` varchar(100) default NULL,
  `RankName_6` varchar(100) default NULL,
  `RankName_7` varchar(100) default NULL,
  `RankName_8` varchar(100) default NULL,
  `RankName_9` varchar(100) default NULL,
  `Guild_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Guild_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table guild
#----------------------------

#----------------------------
# Table structure for item
#----------------------------
CREATE TABLE `item` (
  `ContainerID` bigint(20) default NULL,
  `Cooldown` date default NULL,
  `Creator` int(11) default NULL,
  `Durability` int(11) default NULL,
  `DynamicFlags` int(11) default NULL,
  `Enchantment_0_id` int(11) default NULL,
  `Enchantment_0_expiration` int(11) default NULL,
  `Enchantment_0_chargesRemaining` int(11) default NULL,
  `Enchantment_1_id` int(11) default NULL,
  `Enchantment_1_expiration` int(11) default NULL,
  `Enchantment_1_chargesRemaining` int(11) default NULL,
  `Enchantment_2_id` int(11) default NULL,
  `Enchantment_2_expiration` int(11) default NULL,
  `Enchantment_2_chargesRemaining` int(11) default NULL,
  `Enchantment_3_id` int(11) default NULL,
  `Enchantment_3_expiration` int(11) default NULL,
  `Enchantment_3_chargesRemaining` int(11) default NULL,
  `Enchantment_4_id` int(11) default NULL,
  `Enchantment_4_expiration` int(11) default NULL,
  `Enchantment_4_chargesRemaining` int(11) default NULL,
  `Enchantment_5_id` int(11) default NULL,
  `Enchantment_5_expiration` int(11) default NULL,
  `Enchantment_5_chargesRemaining` int(11) default NULL,
  `Enchantment_6_id` int(11) default NULL,
  `Enchantment_6_expiration` int(11) default NULL,
  `Enchantment_6_chargesRemaining` int(11) default NULL,
  `Expiration` date default NULL,
  `OwnerID` int(11) default NULL,
  `OwnerSlot` int(11) default NULL,
  `PropertyID` int(11) default NULL,
  `PropertySeed` int(11) default NULL,
  `SpellCharge_0` int(11) default NULL,
  `SpellCharge_1` int(11) default NULL,
  `SpellCharge_2` int(11) default NULL,
  `SpellCharge_3` int(11) default NULL,
  `SpellCharge_4` int(11) default NULL,
  `StackCount` int(11) default NULL,
  `StaticFlags` int(11) default NULL,
  `TemplateID` int(11) default NULL,
  `ItemTextID` int(11) default NULL,
  `Item_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table item
#----------------------------

#----------------------------
# Table structure for mail
#----------------------------
CREATE TABLE `mail` (
  `COD` int(11) default NULL,
  `ExpirationTime` date default NULL,
  `ItemID` int(11) default NULL,
  `MailType` int(11) default NULL,
  `MessageID` int(11) default NULL,
  `Money` int(11) default NULL,
  `OwnerID` int(11) default NULL,
  `HasRead` int(11) default NULL,
  `SenderID` int(11) default NULL,
  `Subject` varchar(100) default NULL,
  `DispatchTime` date default NULL,
  `Mail_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Mail_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table mail
#----------------------------

#----------------------------
# Table structure for mailmessage
#----------------------------
CREATE TABLE `mailmessage` (
  `BodyText` varchar(100) default NULL,
  `MailMessage_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`MailMessage_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table mailmessage
#----------------------------

#----------------------------
# Table structure for pet
#----------------------------
CREATE TABLE `pet` (
  `CreatureID` int(11) default NULL,
  `Exp` int(11) default NULL,
  `Grows` int(11) default NULL,
  `Happyness` int(11) default NULL,
  `Level` int(11) default NULL,
  `Name` varchar(100) default NULL,
  `Owner_ID` int(11) default NULL,
  `TrueCreatureID` int(11) default NULL,
  `Pet_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Pet_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table pet
#----------------------------

#----------------------------
# Table structure for petspell
#----------------------------
CREATE TABLE `petspell` (
  `Cooldown` date default NULL,
  `Owner_ID` int(11) default NULL,
  `SpellID` int(11) default NULL,
  `PetSpell_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`PetSpell_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table petspell
#----------------------------

#----------------------------
# Table structure for questlog
#----------------------------
CREATE TABLE `questlog` (
  `Owner_ID` int(11) default NULL,
  `Quest_ID` int(11) default NULL,
  `Status` int(11) default NULL,
  `Target_0` int(11) default NULL,
  `Target_1` int(11) default NULL,
  `Target_2` int(11) default NULL,
  `Target_3` int(11) default NULL,
  `Target_4` int(11) default NULL,
  `QuestLog_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`QuestLog_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# No records for table questlog
#----------------------------