TDB 6.0.1 - 2015/03/21TDB6.01

Closes #13816
Closes #13792

Ref #14139

1 files changed, 1274 insertions, 0 deletions

diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
new file mode 100644
index 00000000000..1dcaf45bdab
--- /dev/null
+++ b/sql/base/dev/hotfixes_database.sql
@@ -0,0 +1,1274 @@
+-- MySQL dump 10.13  Distrib 5.6.9-rc, for Win64 (x86_64)
+--
+-- Host: localhost    Database: hotfixes
+-- ------------------------------------------------------
+-- Server version	5.6.9-rc
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `area_group`
+--
+
+DROP TABLE IF EXISTS `area_group`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `area_group` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `area_group_member`
+--
+
+DROP TABLE IF EXISTS `area_group_member`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `area_group_member` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `AreaGroupID` int(10) unsigned NOT NULL DEFAULT '0',
+  `AreaID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `area_poi`
+--
+
+DROP TABLE IF EXISTS `area_poi`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `area_poi` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Flags` mediumint(8) NOT NULL DEFAULT '0',
+  `Importance` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `FactionID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `MapID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `AreaID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Icon` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `PositionX` float NOT NULL DEFAULT '0',
+  `PositionY` float NOT NULL DEFAULT '0',
+  `Name` text NOT NULL,
+  `Description` text NOT NULL,
+  `WorldStateID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `PlayerConditionID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `WorldMapLink` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `PortLocID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `area_poi_state`
+--
+
+DROP TABLE IF EXISTS `area_poi_state`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `area_poi_state` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `AreaPOIID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `State` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Icon` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Description` text NOT NULL,
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `broadcast_text`
+--
+
+DROP TABLE IF EXISTS `broadcast_text`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `broadcast_text` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Language` int(11) NOT NULL DEFAULT '0',
+  `MaleText` text,
+  `FemaleText` text,
+  `EmoteID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `EmoteID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `EmoteID3` int(10) unsigned NOT NULL DEFAULT '0',
+  `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0',
+  `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0',
+  `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0',
+  `SoundID` int(10) unsigned NOT NULL DEFAULT '0',
+  `UnkEmoteID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Type` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `broadcast_text_locale`
+--
+
+DROP TABLE IF EXISTS `broadcast_text_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `broadcast_text_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `MaleText_lang` text,
+  `FemaleText_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `creature`
+--
+
+DROP TABLE IF EXISTS `creature`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Type` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `ItemID1` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `ItemID2` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `ItemID3` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Mount` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `DisplayID1` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `DisplayID2` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `DisplayID3` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `DisplayID4` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `DisplayIDProbability1` float NOT NULL DEFAULT '0',
+  `DisplayIDProbability2` float NOT NULL DEFAULT '0',
+  `DisplayIDProbability3` float NOT NULL DEFAULT '0',
+  `DisplayIDProbability4` float NOT NULL DEFAULT '0',
+  `Name` text NOT NULL,
+  `FemaleName` text NOT NULL,
+  `SubName` text NOT NULL,
+  `FemaleSubName` text NOT NULL,
+  `Rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `InhabitType` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `creature_difficulty`
+--
+
+DROP TABLE IF EXISTS `creature_difficulty`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_difficulty` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `FactionID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Expansion` mediumint(8) NOT NULL DEFAULT '0',
+  `MinLevel` mediumint(8) NOT NULL DEFAULT '0',
+  `MaxLevel` mediumint(8) NOT NULL DEFAULT '0',
+  `Flags1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags3` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags4` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags5` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `currency_types`
+--
+
+DROP TABLE IF EXISTS `currency_types`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `currency_types` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `CategoryID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `InventoryIcon1` text,
+  `InventoryIcon2` text,
+  `SpellWeight` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellCategory` int(10) unsigned NOT NULL DEFAULT '0',
+  `MaxQty` int(10) unsigned NOT NULL DEFAULT '0',
+  `MaxEarnablePerWeek` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `Quality` int(10) unsigned NOT NULL DEFAULT '0',
+  `Description` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `currency_types_locale`
+--
+
+DROP TABLE IF EXISTS `currency_types_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `currency_types_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `InventoryIcon1_lang` text,
+  `InventoryIcon2_lang` text,
+  `Description_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `curve_point`
+--
+
+DROP TABLE IF EXISTS `curve_point`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `curve_point` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `CurveID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Index` int(10) unsigned NOT NULL DEFAULT '0',
+  `X` float NOT NULL DEFAULT '0',
+  `Y` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `gameobjects`
+--
+
+DROP TABLE IF EXISTS `gameobjects`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `gameobjects` (
+  `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `MapID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `DisplayID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `PositionX` float NOT NULL DEFAULT '0',
+  `PositionY` float NOT NULL DEFAULT '0',
+  `PositionZ` float NOT NULL DEFAULT '0',
+  `RotationX` float NOT NULL DEFAULT '0',
+  `RotationY` float NOT NULL DEFAULT '0',
+  `RotationZ` float NOT NULL DEFAULT '0',
+  `RotationW` float NOT NULL DEFAULT '0',
+  `Size` float NOT NULL DEFAULT '0',
+  `PhaseUseFlags` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `PhaseID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `PhaseGroupID` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Type` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `Data0` int(10) unsigned NOT NULL DEFAULT '0',
+  `Data1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Data2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Data3` int(10) unsigned NOT NULL DEFAULT '0',
+  `Data4` int(10) unsigned NOT NULL DEFAULT '0',
+  `Data5` int(10) unsigned NOT NULL DEFAULT '0',
+  `Data6` int(10) unsigned NOT NULL DEFAULT '0',
+  `Data7` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text NOT NULL,
+  `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `holidays`
+--
+
+DROP TABLE IF EXISTS `holidays`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `holidays` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration3` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration4` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration5` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration6` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration7` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration8` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration9` int(10) unsigned NOT NULL DEFAULT '0',
+  `Duration10` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date3` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date4` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date5` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date6` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date7` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date8` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date9` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date10` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date11` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date12` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date13` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date14` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date15` int(10) unsigned NOT NULL DEFAULT '0',
+  `Date16` int(10) unsigned NOT NULL DEFAULT '0',
+  `Region` int(10) unsigned NOT NULL DEFAULT '0',
+  `Looping` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags1` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags2` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags3` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags4` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags5` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags6` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags7` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags8` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags9` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFlags10` int(10) unsigned NOT NULL DEFAULT '0',
+  `HolidayNameID` int(10) unsigned NOT NULL DEFAULT '0',
+  `HolidayDescriptionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `TextureFilename` text,
+  `Priority` int(10) unsigned NOT NULL DEFAULT '0',
+  `CalendarFilterType` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `holidays_locale`
+--
+
+DROP TABLE IF EXISTS `holidays_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `holidays_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `TextureFilename_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `hotfix_data`
+--
+
+DROP TABLE IF EXISTS `hotfix_data`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `hotfix_data` (
+  `TableHash` int(10) unsigned NOT NULL DEFAULT '0',
+  `RecordID` int(10) NOT NULL,
+  `Timestamp` int(10) unsigned NOT NULL DEFAULT '0',
+  `Deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`TableHash`,`RecordID`,`Timestamp`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item`
+--
+
+DROP TABLE IF EXISTS `item`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Class` int(10) unsigned NOT NULL DEFAULT '0',
+  `SubClass` int(10) unsigned NOT NULL DEFAULT '0',
+  `SoundOverrideSubclass` int(11) NOT NULL DEFAULT '0',
+  `Material` int(11) NOT NULL DEFAULT '0',
+  `InventoryType` int(10) unsigned NOT NULL DEFAULT '0',
+  `Sheath` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GroupSoundsID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_appearance`
+--
+
+DROP TABLE IF EXISTS `item_appearance`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_appearance` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `DisplayID` int(10) unsigned NOT NULL DEFAULT '0',
+  `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_bonus`
+--
+
+DROP TABLE IF EXISTS `item_bonus`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_bonus` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `BonusListID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Type` int(10) unsigned NOT NULL DEFAULT '0',
+  `Value1` int(11) NOT NULL DEFAULT '0',
+  `Value2` int(11) NOT NULL DEFAULT '0',
+  `Index` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_bonus_tree_node`
+--
+
+DROP TABLE IF EXISTS `item_bonus_tree_node`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_bonus_tree_node` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `BonusTreeID` int(10) unsigned NOT NULL DEFAULT '0',
+  `BonusTreeModID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SubTreeID` int(10) unsigned NOT NULL DEFAULT '0',
+  `BonusListID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_currency_cost`
+--
+
+DROP TABLE IF EXISTS `item_currency_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_currency_cost` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemId` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`),
+  UNIQUE KEY `idx_itemId` (`ItemId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_effect`
+--
+
+DROP TABLE IF EXISTS `item_effect`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_effect` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemID` int(10) unsigned NOT NULL DEFAULT '0',
+  `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Trigger` int(10) unsigned NOT NULL DEFAULT '0',
+  `Charges` int(10) unsigned NOT NULL DEFAULT '0',
+  `Cooldown` int(11) NOT NULL DEFAULT '0',
+  `Category` int(10) unsigned NOT NULL DEFAULT '0',
+  `CategoryCooldown` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_extended_cost`
+--
+
+DROP TABLE IF EXISTS `item_extended_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_extended_cost` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredArenaSlot` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItem1` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItem2` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItem3` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItem4` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItem5` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItemCount1` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItemCount2` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItemCount3` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItemCount4` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredItemCount5` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredPersonalArenaRating` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemPurchaseGroup` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrency1` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrency2` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrency3` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrency4` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrency5` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrencyCount1` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrencyCount2` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrencyCount3` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrencyCount4` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCurrencyCount5` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredFactionId` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredFactionStanding` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequirementFlags` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredAchievement` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredMoney` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_modified_appearance`
+--
+
+DROP TABLE IF EXISTS `item_modified_appearance`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_modified_appearance` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemID` int(10) unsigned NOT NULL DEFAULT '0',
+  `AppearanceModID` int(10) unsigned NOT NULL DEFAULT '0',
+  `AppearanceID` int(10) unsigned NOT NULL DEFAULT '0',
+  `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Index` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_sparse`
+--
+
+DROP TABLE IF EXISTS `item_sparse`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_sparse` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Quality` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags3` int(10) unsigned NOT NULL DEFAULT '0',
+  `Unk1` float NOT NULL DEFAULT '0',
+  `Unk2` float NOT NULL DEFAULT '0',
+  `BuyCount` int(10) unsigned NOT NULL DEFAULT '0',
+  `BuyPrice` int(10) unsigned NOT NULL DEFAULT '0',
+  `SellPrice` int(10) unsigned NOT NULL DEFAULT '0',
+  `InventoryType` int(10) unsigned NOT NULL DEFAULT '0',
+  `AllowableClass` int(11) NOT NULL DEFAULT '0',
+  `AllowableRace` int(11) NOT NULL DEFAULT '0',
+  `ItemLevel` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredLevel` int(11) NOT NULL DEFAULT '0',
+  `RequiredSkill` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredSkillRank` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredSpell` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredHonorRank` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredCityRank` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredReputationFaction` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredReputationRank` int(10) unsigned NOT NULL DEFAULT '0',
+  `MaxCount` int(10) unsigned NOT NULL DEFAULT '0',
+  `Stackable` int(10) unsigned NOT NULL DEFAULT '0',
+  `ContainerSlots` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemStatType1` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType2` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType3` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType4` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType5` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType6` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType7` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType8` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType9` int(11) NOT NULL DEFAULT '0',
+  `ItemStatType10` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue1` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue2` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue3` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue4` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue5` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue6` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue7` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue8` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue9` int(11) NOT NULL DEFAULT '0',
+  `ItemStatValue10` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation1` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation2` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation3` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation4` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation5` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation6` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation7` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation8` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation9` int(11) NOT NULL DEFAULT '0',
+  `ItemStatAllocation10` int(11) NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier1` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier2` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier3` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier4` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier5` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier6` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier7` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier8` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier9` float NOT NULL DEFAULT '0',
+  `ItemStatSocketCostMultiplier10` float NOT NULL DEFAULT '0',
+  `ScalingStatDistribution` int(10) unsigned NOT NULL DEFAULT '0',
+  `DamageType` int(10) unsigned NOT NULL DEFAULT '0',
+  `Delay` int(10) unsigned NOT NULL DEFAULT '0',
+  `RangedModRange` float NOT NULL DEFAULT '0',
+  `Bonding` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `Name2` text,
+  `Name3` text,
+  `Name4` text,
+  `Description` text,
+  `PageText` int(10) unsigned NOT NULL DEFAULT '0',
+  `LanguageID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PageMaterial` int(10) unsigned NOT NULL DEFAULT '0',
+  `StartQuest` int(10) unsigned NOT NULL DEFAULT '0',
+  `LockID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Material` int(11) NOT NULL DEFAULT '0',
+  `Sheath` int(10) unsigned NOT NULL DEFAULT '0',
+  `RandomProperty` int(10) unsigned NOT NULL DEFAULT '0',
+  `RandomSuffix` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemSet` int(10) unsigned NOT NULL DEFAULT '0',
+  `Area` int(10) unsigned NOT NULL DEFAULT '0',
+  `Map` int(10) unsigned NOT NULL DEFAULT '0',
+  `BagFamily` int(10) unsigned NOT NULL DEFAULT '0',
+  `TotemCategory` int(10) unsigned NOT NULL DEFAULT '0',
+  `SocketColor1` int(10) unsigned NOT NULL DEFAULT '0',
+  `SocketColor2` int(10) unsigned NOT NULL DEFAULT '0',
+  `SocketColor3` int(10) unsigned NOT NULL DEFAULT '0',
+  `SocketBonus` int(10) unsigned NOT NULL DEFAULT '0',
+  `GemProperties` int(10) unsigned NOT NULL DEFAULT '0',
+  `ArmorDamageModifier` float NOT NULL DEFAULT '0',
+  `Duration` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemLimitCategory` int(10) unsigned NOT NULL DEFAULT '0',
+  `HolidayID` int(10) unsigned NOT NULL DEFAULT '0',
+  `StatScalingFactor` float NOT NULL DEFAULT '0',
+  `CurrencySubstitutionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `CurrencySubstitutionCount` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemNameDescriptionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_sparse_locale`
+--
+
+DROP TABLE IF EXISTS `item_sparse_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_sparse_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `Name2_lang` text,
+  `Name3_lang` text,
+  `Name4_lang` text,
+  `Description_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_x_bonus_tree`
+--
+
+DROP TABLE IF EXISTS `item_x_bonus_tree`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `item_x_bonus_tree` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ItemID` int(10) unsigned NOT NULL DEFAULT '0',
+  `BonusTreeID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `key_chain`
+--
+
+DROP TABLE IF EXISTS `key_chain`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `key_chain` (
+  `Id` int(10) unsigned NOT NULL DEFAULT '0',
+  `Key1` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key2` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key3` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key4` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key5` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key6` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key7` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key8` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key9` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key10` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key11` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key12` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key13` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key14` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key15` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key16` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key17` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key18` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key19` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key20` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key21` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key22` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key23` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key24` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key25` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key26` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key27` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key28` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key29` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key30` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key31` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Key32` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `mount`
+--
+
+DROP TABLE IF EXISTS `mount`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `mount` (
+  `Id` int(10) unsigned NOT NULL DEFAULT '0',
+  `MountTypeId` int(10) unsigned NOT NULL DEFAULT '0',
+  `DisplayId` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `Description` text,
+  `SourceDescription` text,
+  `Source` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellId` int(10) unsigned NOT NULL DEFAULT '0',
+  `PlayerConditionId` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `mount_locale`
+--
+
+DROP TABLE IF EXISTS `mount_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `mount_locale` (
+  `Id` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `Description_lang` text,
+  `SourceDescription_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`Id`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `override_spell_data`
+--
+
+DROP TABLE IF EXISTS `override_spell_data`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `override_spell_data` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID3` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID4` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID5` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID6` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID7` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID8` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID9` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID10` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `PlayerActionbarFileDataID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `phase_group`
+--
+
+DROP TABLE IF EXISTS `phase_group`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `phase_group` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PhaseID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PhaseGroupID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `sound_entries`
+--
+
+DROP TABLE IF EXISTS `sound_entries`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `sound_entries` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SoundType` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `FileDataID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID3` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID4` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID5` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID6` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID7` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID8` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID9` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID10` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID11` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID12` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID13` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID14` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID15` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID16` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID17` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID18` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID19` int(10) unsigned NOT NULL DEFAULT '0',
+  `FileDataID20` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq3` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq4` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq5` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq6` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq7` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq8` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq9` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq10` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq11` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq12` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq13` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq14` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq15` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq16` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq17` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq18` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq19` int(10) unsigned NOT NULL DEFAULT '0',
+  `Freq20` int(10) unsigned NOT NULL DEFAULT '0',
+  `VolumeFloat` float NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `MinDistance` float NOT NULL DEFAULT '0',
+  `DistanceCutoff` float NOT NULL DEFAULT '0',
+  `EAXDef` int(10) unsigned NOT NULL DEFAULT '0',
+  `SoundEntriesAdvancedID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VolumeVariationPlus` float NOT NULL DEFAULT '0',
+  `VolumeVariationMinus` float NOT NULL DEFAULT '0',
+  `PitchVariationPlus` float NOT NULL DEFAULT '0',
+  `PitchVariationMinus` float NOT NULL DEFAULT '0',
+  `PitchAdjust` float NOT NULL DEFAULT '0',
+  `DialogType` int(10) unsigned NOT NULL DEFAULT '0',
+  `BusOverwriteID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `sound_entries_locale`
+--
+
+DROP TABLE IF EXISTS `sound_entries_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `sound_entries_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_aura_restrictions`
+--
+
+DROP TABLE IF EXISTS `spell_aura_restrictions`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_aura_restrictions` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `CasterAuraState` int(10) unsigned NOT NULL DEFAULT '0',
+  `TargetAuraState` int(10) unsigned NOT NULL DEFAULT '0',
+  `ExcludeCasterAuraState` int(10) unsigned NOT NULL DEFAULT '0',
+  `ExcludeTargetAuraState` int(10) unsigned NOT NULL DEFAULT '0',
+  `CasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
+  `TargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
+  `ExcludeCasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
+  `ExcludeTargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_casting_requirements`
+--
+
+DROP TABLE IF EXISTS `spell_casting_requirements`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_casting_requirements` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `FacingCasterFlags` int(10) unsigned NOT NULL DEFAULT '0',
+  `MinFactionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `MinReputation` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredAreasID` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredAuraVision` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiresSpellFocus` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_class_options`
+--
+
+DROP TABLE IF EXISTS `spell_class_options`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_class_options` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ModalNextSpell` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellClassMask1` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellClassMask2` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellClassMask3` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellClassMask4` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellClassSet` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_learn_spell`
+--
+
+DROP TABLE IF EXISTS `spell_learn_spell`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_learn_spell` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `LearnSpellID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID` int(10) unsigned NOT NULL DEFAULT '0',
+  `OverridesSpellID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_misc`
+--
+
+DROP TABLE IF EXISTS `spell_misc`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_misc` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Attributes` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesEx` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExB` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExC` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExD` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExE` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExF` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExG` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExH` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExI` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExJ` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExK` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExL` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesExM` int(10) unsigned NOT NULL DEFAULT '0',
+  `CastingTimeIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `DurationIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `RangeIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `Speed` float NOT NULL DEFAULT '0',
+  `SpellVisualID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellVisualID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellIconID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ActiveIconID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `MultistrikeSpeedMod` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_power`
+--
+
+DROP TABLE IF EXISTS `spell_power`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_power` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PowerIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `PowerType` int(10) unsigned NOT NULL DEFAULT '0',
+  `ManaCost` int(10) unsigned NOT NULL DEFAULT '0',
+  `ManaCostPerLevel` int(10) unsigned NOT NULL DEFAULT '0',
+  `ManaCostPerSecond` int(10) unsigned NOT NULL DEFAULT '0',
+  `ManaCostAdditional` int(10) unsigned NOT NULL DEFAULT '0',
+  `PowerDisplayID` int(10) unsigned NOT NULL DEFAULT '0',
+  `UnitPowerBarID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ManaCostPercentage` float NOT NULL DEFAULT '0',
+  `ManaCostPercentagePerSecond` float NOT NULL DEFAULT '0',
+  `RequiredAura` int(10) unsigned NOT NULL DEFAULT '0',
+  `HealthCostPercentage` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_power_difficulty`
+--
+
+DROP TABLE IF EXISTS `spell_power_difficulty`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_power_difficulty` (
+  `SpellPowerID` int(10) unsigned NOT NULL DEFAULT '0',
+  `DifficultyID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PowerIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`SpellPowerID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_reagents`
+--
+
+DROP TABLE IF EXISTS `spell_reagents`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_reagents` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Reagent1` int(11) NOT NULL DEFAULT '0',
+  `Reagent2` int(11) NOT NULL DEFAULT '0',
+  `Reagent3` int(11) NOT NULL DEFAULT '0',
+  `Reagent4` int(11) NOT NULL DEFAULT '0',
+  `Reagent5` int(11) NOT NULL DEFAULT '0',
+  `Reagent6` int(11) NOT NULL DEFAULT '0',
+  `Reagent7` int(11) NOT NULL DEFAULT '0',
+  `Reagent8` int(11) NOT NULL DEFAULT '0',
+  `ReagentCount1` int(10) unsigned NOT NULL DEFAULT '0',
+  `ReagentCount2` int(10) unsigned NOT NULL DEFAULT '0',
+  `ReagentCount3` int(10) unsigned NOT NULL DEFAULT '0',
+  `ReagentCount4` int(10) unsigned NOT NULL DEFAULT '0',
+  `ReagentCount5` int(10) unsigned NOT NULL DEFAULT '0',
+  `ReagentCount6` int(10) unsigned NOT NULL DEFAULT '0',
+  `ReagentCount7` int(10) unsigned NOT NULL DEFAULT '0',
+  `ReagentCount8` int(10) unsigned NOT NULL DEFAULT '0',
+  `CurrencyID` int(10) unsigned NOT NULL DEFAULT '0',
+  `CurrencyCount` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_rune_cost`
+--
+
+DROP TABLE IF EXISTS `spell_rune_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_rune_cost` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Blood` int(10) unsigned NOT NULL DEFAULT '0',
+  `Unholy` int(10) unsigned NOT NULL DEFAULT '0',
+  `Frost` int(10) unsigned NOT NULL DEFAULT '0',
+  `Chromatic` int(10) unsigned NOT NULL DEFAULT '0',
+  `RunicPower` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spell_totems`
+--
+
+DROP TABLE IF EXISTS `spell_totems`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_totems` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredTotemCategoryID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredTotemCategoryID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `Totem1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Totem2` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `taxi_nodes`
+--
+
+DROP TABLE IF EXISTS `taxi_nodes`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `taxi_nodes` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PosX` float NOT NULL DEFAULT '0',
+  `PosY` float NOT NULL DEFAULT '0',
+  `PosZ` float NOT NULL DEFAULT '0',
+  `Name` text,
+  `MountCreatureID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `MountCreatureID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `ConditionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `LearnableIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapOffsetX` float NOT NULL DEFAULT '0',
+  `MapOffsetY` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `taxi_nodes_locale`
+--
+
+DROP TABLE IF EXISTS `taxi_nodes_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `taxi_nodes_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `taxi_path`
+--
+
+DROP TABLE IF EXISTS `taxi_path`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `taxi_path` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `From` int(10) unsigned NOT NULL DEFAULT '0',
+  `To` int(10) unsigned NOT NULL DEFAULT '0',
+  `Cost` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `taxi_path_node`
+--
+
+DROP TABLE IF EXISTS `taxi_path_node`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `taxi_path_node` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `PathID` int(10) unsigned NOT NULL DEFAULT '0',
+  `NodeIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapID` int(10) unsigned NOT NULL DEFAULT '0',
+  `LocX` float NOT NULL DEFAULT '0',
+  `LocY` float NOT NULL DEFAULT '0',
+  `LocZ` float NOT NULL DEFAULT '0',
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `Delay` int(10) unsigned NOT NULL DEFAULT '0',
+  `ArrivalEventID` int(10) unsigned NOT NULL DEFAULT '0',
+  `DepartureEventID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `updates`
+--
+
+DROP TABLE IF EXISTS `updates`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `updates` (
+  `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.',
+  `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.',
+  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
+  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.',
+  `speed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.',
+  PRIMARY KEY (`name`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of all applied updates in this database.';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `updates_include`
+--
+
+DROP TABLE IF EXISTS `updates_include`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `updates_include` (
+  `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
+  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
+  PRIMARY KEY (`path`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of directories where we want to include sql updates.';
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2015-03-21 16:07:14