diff options
Diffstat (limited to 'sql/base/dev/hotfixes_database.sql')
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 1258 |
1 files changed, 1257 insertions, 1 deletions
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 0d5a5d2f23c..1dcaf45bdab 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -15,4 +15,1260 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- Dump completed on 2014-10-19 23:50:46 +-- +-- 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 |