diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/hotfixes/2015_02_22_00_hotfixes.sql | 1162 |
1 files changed, 1162 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2015_02_22_00_hotfixes.sql b/sql/updates/hotfixes/2015_02_22_00_hotfixes.sql new file mode 100644 index 00000000000..f39dda765e2 --- /dev/null +++ b/sql/updates/hotfixes/2015_02_22_00_hotfixes.sql @@ -0,0 +1,1162 @@ +ALTER TABLE `broadcast_text` + CHANGE `ID` `ID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `Language` `Language` int(11) NOT NULL DEFAULT '0', + CHANGE `MaleText` `MaleText` text, + CHANGE `FemaleText` `FemaleText` text, + CHANGE `EmoteID0` `EmoteID1` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `EmoteID1` `EmoteID2` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `EmoteID2` `EmoteID3` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `EmoteDelay0` `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `EmoteDelay1` `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `EmoteDelay2` `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `SoundID` `SoundID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `UnkMoP1` `UnkEmoteID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `UnkMoP2` `Type` int(10) unsigned NOT NULL DEFAULT '0'; + +-- +-- 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 */; + +-- +-- Dumping data for table `broadcast_text_locale` +-- + +INSERT INTO `broadcast_text_locale` SELECT `ID`,'koKR',`MaleText_loc1`,`FemaleText_loc1`,`VerifiedBuild` FROM `locales_broadcast_text`; +INSERT INTO `broadcast_text_locale` SELECT `ID`,'frFR',`MaleText_loc2`,`FemaleText_loc2`,`VerifiedBuild` FROM `locales_broadcast_text`; +INSERT INTO `broadcast_text_locale` SELECT `ID`,'deDE',`MaleText_loc3`,`FemaleText_loc3`,`VerifiedBuild` FROM `locales_broadcast_text`; +INSERT INTO `broadcast_text_locale` SELECT `ID`,'zhCN',`MaleText_loc4`,`FemaleText_loc4`,`VerifiedBuild` FROM `locales_broadcast_text`; +INSERT INTO `broadcast_text_locale` SELECT `ID`,'zhTW',`MaleText_loc5`,`FemaleText_loc5`,`VerifiedBuild` FROM `locales_broadcast_text`; +INSERT INTO `broadcast_text_locale` SELECT `ID`,'esES',`MaleText_loc6`,`FemaleText_loc6`,`VerifiedBuild` FROM `locales_broadcast_text`; +INSERT INTO `broadcast_text_locale` SELECT `ID`,'esMX',`MaleText_loc7`,`FemaleText_loc7`,`VerifiedBuild` FROM `locales_broadcast_text`; +INSERT INTO `broadcast_text_locale` SELECT `ID`,'ruRU',`MaleText_loc8`,`FemaleText_loc8`,`VerifiedBuild` FROM `locales_broadcast_text`; +DROP TABLE IF EXISTS `locales_broadcast_text`; + +-- +-- 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 */; + +-- +-- Dumping data for table `curve_point` +-- + +LOCK TABLES `curve_point` WRITE; +/*!40000 ALTER TABLE `curve_point` DISABLE KEYS */; +/*!40000 ALTER TABLE `curve_point` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `holidays` +-- + +LOCK TABLES `holidays` WRITE; +/*!40000 ALTER TABLE `holidays` DISABLE KEYS */; +/*!40000 ALTER TABLE `holidays` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `holidays_locale` +-- + +LOCK TABLES `holidays_locale` WRITE; +/*!40000 ALTER TABLE `holidays_locale` DISABLE KEYS */; +/*!40000 ALTER TABLE `holidays_locale` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_appearance` +-- + +LOCK TABLES `item_appearance` WRITE; +/*!40000 ALTER TABLE `item_appearance` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_appearance` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_bonus` +-- + +LOCK TABLES `item_bonus` WRITE; +/*!40000 ALTER TABLE `item_bonus` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_bonus` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_bonus_tree_node` +-- + +LOCK TABLES `item_bonus_tree_node` WRITE; +/*!40000 ALTER TABLE `item_bonus_tree_node` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_bonus_tree_node` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_currency_cost` +-- + +LOCK TABLES `item_currency_cost` WRITE; +/*!40000 ALTER TABLE `item_currency_cost` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_currency_cost` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_effect` +-- + +LOCK TABLES `item_effect` WRITE; +/*!40000 ALTER TABLE `item_effect` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_effect` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item` +-- + +LOCK TABLES `item` WRITE; +/*!40000 ALTER TABLE `item` DISABLE KEYS */; +/*!40000 ALTER TABLE `item` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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', + `RequiredHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredArenaPoints` 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', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `item_extended_cost` +-- + +LOCK TABLES `item_extended_cost` WRITE; +/*!40000 ALTER TABLE `item_extended_cost` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_extended_cost` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_modified_appearance` +-- + +LOCK TABLES `item_modified_appearance` WRITE; +/*!40000 ALTER TABLE `item_modified_appearance` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_modified_appearance` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_sparse` +-- + +LOCK TABLES `item_sparse` WRITE; +/*!40000 ALTER TABLE `item_sparse` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_sparse` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_sparse_locale` +-- + +LOCK TABLES `item_sparse_locale` WRITE; +/*!40000 ALTER TABLE `item_sparse_locale` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_sparse_locale` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `item_x_bonus_tree` +-- + +LOCK TABLES `item_x_bonus_tree` WRITE; +/*!40000 ALTER TABLE `item_x_bonus_tree` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_x_bonus_tree` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `key_chain` +-- + +LOCK TABLES `key_chain` WRITE; +/*!40000 ALTER TABLE `key_chain` DISABLE KEYS */; +/*!40000 ALTER TABLE `key_chain` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `mount` +-- + +LOCK TABLES `mount` WRITE; +/*!40000 ALTER TABLE `mount` DISABLE KEYS */; +/*!40000 ALTER TABLE `mount` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `mount_locale` +-- + +LOCK TABLES `mount_locale` WRITE; +/*!40000 ALTER TABLE `mount_locale` DISABLE KEYS */; +/*!40000 ALTER TABLE `mount_locale` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `override_spell_data` +-- + +LOCK TABLES `override_spell_data` WRITE; +/*!40000 ALTER TABLE `override_spell_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `override_spell_data` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `phase_group` +-- + +LOCK TABLES `phase_group` WRITE; +/*!40000 ALTER TABLE `phase_group` DISABLE KEYS */; +/*!40000 ALTER TABLE `phase_group` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_aura_restrictions` +-- + +LOCK TABLES `spell_aura_restrictions` WRITE; +/*!40000 ALTER TABLE `spell_aura_restrictions` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_aura_restrictions` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_casting_requirements` +-- + +LOCK TABLES `spell_casting_requirements` WRITE; +/*!40000 ALTER TABLE `spell_casting_requirements` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_casting_requirements` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_class_options` +-- + +LOCK TABLES `spell_class_options` WRITE; +/*!40000 ALTER TABLE `spell_class_options` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_class_options` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_learn_spell` +-- + +LOCK TABLES `spell_learn_spell` WRITE; +/*!40000 ALTER TABLE `spell_learn_spell` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_learn_spell` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_misc` +-- + +LOCK TABLES `spell_misc` WRITE; +/*!40000 ALTER TABLE `spell_misc` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_misc` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_power` +-- + +LOCK TABLES `spell_power` WRITE; +/*!40000 ALTER TABLE `spell_power` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_power` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_reagents` +-- + +LOCK TABLES `spell_reagents` WRITE; +/*!40000 ALTER TABLE `spell_reagents` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_reagents` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_rune_cost` +-- + +LOCK TABLES `spell_rune_cost` WRITE; +/*!40000 ALTER TABLE `spell_rune_cost` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_rune_cost` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `spell_totems` +-- + +LOCK TABLES `spell_totems` WRITE; +/*!40000 ALTER TABLE `spell_totems` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_totems` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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', + `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 */; + +-- +-- Dumping data for table `taxi_nodes` +-- + +LOCK TABLES `taxi_nodes` WRITE; +/*!40000 ALTER TABLE `taxi_nodes` DISABLE KEYS */; +/*!40000 ALTER TABLE `taxi_nodes` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `taxi_nodes_locale` +-- + +LOCK TABLES `taxi_nodes_locale` WRITE; +/*!40000 ALTER TABLE `taxi_nodes_locale` DISABLE KEYS */; +/*!40000 ALTER TABLE `taxi_nodes_locale` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- 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 */; + +-- +-- Dumping data for table `taxi_path` +-- + +LOCK TABLES `taxi_path` WRITE; +/*!40000 ALTER TABLE `taxi_path` DISABLE KEYS */; +/*!40000 ALTER TABLE `taxi_path` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `taxi_path_node` +-- + +ALTER TABLE `taxi_path_node` + CHANGE `ID` `ID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `PathNode` `PathID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `NodeIndex` `NodeIndex` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `MapID` `MapID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `PositionX` `LocX` float NOT NULL DEFAULT '0', + CHANGE `PositionY` `LocY` float NOT NULL DEFAULT '0', + CHANGE `PositionZ` `LocZ` float NOT NULL DEFAULT '0', + CHANGE `ActionFlags` `Flags` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `Delay` `Delay` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `ArrivalEventID` `ArrivalEventID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `DepartureEventID` `DepartureEventID` int(10) unsigned NOT NULL DEFAULT '0', + CHANGE `VerifiedBuild` `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0'; + +ALTER TABLE `hotfix_data` ADD `Deleted` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `Timestamp`; |