From dea6c0b122c8f4b97cb7b3833b41d9bef5c0d911 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 7 Jul 2015 12:13:14 +0200 Subject: Core/DataStores: Updated dbc/db2 structures to 6.2.0 --- sql/updates/hotfixes/2015_07_05_00_hotfixes.sql | 1025 +++++++++++++++++++++++ 1 file changed, 1025 insertions(+) create mode 100644 sql/updates/hotfixes/2015_07_05_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/2015_07_05_00_hotfixes.sql b/sql/updates/hotfixes/2015_07_05_00_hotfixes.sql new file mode 100644 index 00000000000..6308d4b1eb0 --- /dev/null +++ b/sql/updates/hotfixes/2015_07_05_00_hotfixes.sql @@ -0,0 +1,1025 @@ +-- +-- Table structure for table `auction_house` +-- + +DROP TABLE IF EXISTS `auction_house`; +CREATE TABLE `auction_house` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `FactionID` int(10) unsigned NOT NULL DEFAULT '0', + `DepositRate` int(10) unsigned NOT NULL DEFAULT '0', + `ConsignmentRate` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `auction_house_locale` +-- + +DROP TABLE IF EXISTS `auction_house_locale`; +CREATE TABLE `auction_house_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; + +-- +-- Table structure for table `barber_shop_style` +-- + +DROP TABLE IF EXISTS `barber_shop_style`; +CREATE TABLE `barber_shop_style` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Type` int(10) unsigned NOT NULL DEFAULT '0', + `DisplayName` text, + `Description` text, + `CostModifier` float NOT NULL DEFAULT '0', + `Race` int(10) unsigned NOT NULL DEFAULT '0', + `Sex` int(10) unsigned NOT NULL DEFAULT '0', + `Data` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `barber_shop_style_locale` +-- + +DROP TABLE IF EXISTS `barber_shop_style_locale`; +CREATE TABLE `barber_shop_style_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `DisplayName_lang` text, + `Description_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `char_start_outfit` +-- + +DROP TABLE IF EXISTS `char_start_outfit`; +CREATE TABLE `char_start_outfit` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `RaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GenderID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OutfitID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemID1` int(11) NOT NULL DEFAULT '0', + `ItemID2` int(11) NOT NULL DEFAULT '0', + `ItemID3` int(11) NOT NULL DEFAULT '0', + `ItemID4` int(11) NOT NULL DEFAULT '0', + `ItemID5` int(11) NOT NULL DEFAULT '0', + `ItemID6` int(11) NOT NULL DEFAULT '0', + `ItemID7` int(11) NOT NULL DEFAULT '0', + `ItemID8` int(11) NOT NULL DEFAULT '0', + `ItemID9` int(11) NOT NULL DEFAULT '0', + `ItemID10` int(11) NOT NULL DEFAULT '0', + `ItemID11` int(11) NOT NULL DEFAULT '0', + `ItemID12` int(11) NOT NULL DEFAULT '0', + `ItemID13` int(11) NOT NULL DEFAULT '0', + `ItemID14` int(11) NOT NULL DEFAULT '0', + `ItemID15` int(11) NOT NULL DEFAULT '0', + `ItemID16` int(11) NOT NULL DEFAULT '0', + `ItemID17` int(11) NOT NULL DEFAULT '0', + `ItemID18` int(11) NOT NULL DEFAULT '0', + `ItemID19` int(11) NOT NULL DEFAULT '0', + `ItemID20` int(11) NOT NULL DEFAULT '0', + `ItemID21` int(11) NOT NULL DEFAULT '0', + `ItemID22` int(11) NOT NULL DEFAULT '0', + `ItemID23` int(11) NOT NULL DEFAULT '0', + `ItemID24` int(11) NOT NULL DEFAULT '0', + `PetDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `PetFamilyID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `chr_classes_x_power_types` +-- + +DROP TABLE IF EXISTS `chr_classes_x_power_types`; +CREATE TABLE `chr_classes_x_power_types` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ClassID` int(10) unsigned NOT NULL DEFAULT '0', + `PowerType` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `cinematic_sequences` +-- + +DROP TABLE IF EXISTS `cinematic_sequences`; +CREATE TABLE `cinematic_sequences` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SoundID` int(10) unsigned NOT NULL DEFAULT '0', + `Camera1` int(10) unsigned NOT NULL DEFAULT '0', + `Camera2` int(10) unsigned NOT NULL DEFAULT '0', + `Camera3` int(10) unsigned NOT NULL DEFAULT '0', + `Camera4` int(10) unsigned NOT NULL DEFAULT '0', + `Camera5` int(10) unsigned NOT NULL DEFAULT '0', + `Camera6` int(10) unsigned NOT NULL DEFAULT '0', + `Camera7` int(10) unsigned NOT NULL DEFAULT '0', + `Camera8` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `creature_display_info` +-- + +DROP TABLE IF EXISTS `creature_display_info`; +CREATE TABLE `creature_display_info` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ModelID` int(10) unsigned NOT NULL DEFAULT '0', + `SoundID` int(10) unsigned NOT NULL DEFAULT '0', + `ExtendedDisplayInfoID` int(10) unsigned NOT NULL DEFAULT '0', + `CreatureModelScale` float NOT NULL DEFAULT '0', + `Unknown620` float NOT NULL DEFAULT '0', + `CreatureModelAlpha` int(10) unsigned NOT NULL DEFAULT '0', + `TextureVariation1` text, + `TextureVariation2` text, + `TextureVariation3` text, + `PortraitTextureName` text, + `PortraitCreatureDisplayInfoID` int(10) unsigned NOT NULL DEFAULT '0', + `SizeClass` int(10) unsigned NOT NULL DEFAULT '0', + `BloodID` int(10) unsigned NOT NULL DEFAULT '0', + `NPCSoundID` int(10) unsigned NOT NULL DEFAULT '0', + `ParticleColorID` int(10) unsigned NOT NULL DEFAULT '0', + `CreatureGeosetData` int(10) unsigned NOT NULL DEFAULT '0', + `ObjectEffectPackageID` int(10) unsigned NOT NULL DEFAULT '0', + `AnimReplacementSetID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Gender` int(11) NOT NULL DEFAULT '0', + `StateSpellVisualKitID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `creature_display_info_locale` +-- + +DROP TABLE IF EXISTS `creature_display_info_locale`; +CREATE TABLE `creature_display_info_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `TextureVariation_lang1` text, + `TextureVariation_lang2` text, + `TextureVariation_lang3` text, + `PortraitTextureName_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `creature_type` +-- + +DROP TABLE IF EXISTS `creature_type`; +CREATE TABLE `creature_type` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `creature_type_locale` +-- + +DROP TABLE IF EXISTS `creature_type_locale`; +CREATE TABLE `creature_type_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; + +-- +-- Table structure for table `destructible_model_data` +-- + +DROP TABLE IF EXISTS `destructible_model_data`; +CREATE TABLE `destructible_model_data` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `StateDamagedDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `StateDamagedImpactEffectDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateDamagedAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateDamagedNameSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateDestroyedDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `StateDestroyedDestructionDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateDestroyedImpactEffectDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateDestroyedAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateDestroyedNameSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateRebuildingDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `StateRebuildingDestructionDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateRebuildingImpactEffectDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateRebuildingAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateRebuildingNameSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateSmokeDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `StateSmokeInitDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateSmokeAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', + `StateSmokeNameSet` int(10) unsigned NOT NULL DEFAULT '0', + `EjectDirection` int(10) unsigned NOT NULL DEFAULT '0', + `RepairGroundFx` int(10) unsigned NOT NULL DEFAULT '0', + `DoNotHighlight` int(10) unsigned NOT NULL DEFAULT '0', + `HealEffect` int(10) unsigned NOT NULL DEFAULT '0', + `HealEffectSpeed` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `durability_quality` +-- + +DROP TABLE IF EXISTS `durability_quality`; +CREATE TABLE `durability_quality` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `QualityMod` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `glyph_slot` +-- + +DROP TABLE IF EXISTS `glyph_slot`; +CREATE TABLE `glyph_slot` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Type` int(10) unsigned NOT NULL DEFAULT '0', + `Tooltip` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `guild_perk_spells` +-- + +DROP TABLE IF EXISTS `guild_perk_spells`; +CREATE TABLE `guild_perk_spells` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GuildLevel` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `import_price_armor` +-- + +DROP TABLE IF EXISTS `import_price_armor`; +CREATE TABLE `import_price_armor` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ClothFactor` float NOT NULL DEFAULT '0', + `LeatherFactor` float NOT NULL DEFAULT '0', + `MailFactor` float NOT NULL DEFAULT '0', + `PlateFactor` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `import_price_quality` +-- + +DROP TABLE IF EXISTS `import_price_quality`; +CREATE TABLE `import_price_quality` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Factor` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `import_price_shield` +-- + +DROP TABLE IF EXISTS `import_price_shield`; +CREATE TABLE `import_price_shield` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Factor` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `import_price_weapon` +-- + +DROP TABLE IF EXISTS `import_price_weapon`; +CREATE TABLE `import_price_weapon` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Factor` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_class` +-- + +DROP TABLE IF EXISTS `item_class`; +CREATE TABLE `item_class` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `PriceMod` float NOT NULL DEFAULT '0', + `Name` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_class_locale` +-- + +DROP TABLE IF EXISTS `item_class_locale`; +CREATE TABLE `item_class_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; + +-- +-- Table structure for table `item_disenchant_loot` +-- + +DROP TABLE IF EXISTS `item_disenchant_loot`; +CREATE TABLE `item_disenchant_loot` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemClass` int(10) unsigned NOT NULL DEFAULT '0', + `ItemSubClass` int(11) NOT NULL DEFAULT '0', + `ItemQuality` int(10) unsigned NOT NULL DEFAULT '0', + `MinItemLevel` int(10) unsigned NOT NULL DEFAULT '0', + `MaxItemLevel` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredDisenchantSkill` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_limit_category` +-- + +DROP TABLE IF EXISTS `item_limit_category`; +CREATE TABLE `item_limit_category` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Quantity` 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; + +-- +-- Table structure for table `item_limit_category_locale` +-- + +DROP TABLE IF EXISTS `item_limit_category_locale`; +CREATE TABLE `item_limit_category_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; + +-- +-- Table structure for table `item_price_base` +-- + +DROP TABLE IF EXISTS `item_price_base`; +CREATE TABLE `item_price_base` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevel` int(10) unsigned NOT NULL DEFAULT '0', + `ArmorFactor` float NOT NULL DEFAULT '0', + `WeaponFactor` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_random_properties` +-- + +DROP TABLE IF EXISTS `item_random_properties`; +CREATE TABLE `item_random_properties` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `InternalName` text, + `Enchantment1` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment2` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment3` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment4` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment5` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_random_properties_locale` +-- + +DROP TABLE IF EXISTS `item_random_properties_locale`; +CREATE TABLE `item_random_properties_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `InternalName_lang` text, + `Name_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_random_suffix` +-- + +DROP TABLE IF EXISTS `item_random_suffix`; +CREATE TABLE `item_random_suffix` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `InternalName` text, + `Enchantment1` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment2` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment3` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment4` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment5` int(10) unsigned NOT NULL DEFAULT '0', + `AllocationPct1` int(10) unsigned NOT NULL DEFAULT '0', + `AllocationPct2` int(10) unsigned NOT NULL DEFAULT '0', + `AllocationPct3` int(10) unsigned NOT NULL DEFAULT '0', + `AllocationPct4` int(10) unsigned NOT NULL DEFAULT '0', + `AllocationPct5` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_random_suffix_locale` +-- + +DROP TABLE IF EXISTS `item_random_suffix_locale`; +CREATE TABLE `item_random_suffix_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `InternalName_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_spec` +-- + +DROP TABLE IF EXISTS `item_spec`; +CREATE TABLE `item_spec` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MinLevel` int(10) unsigned NOT NULL DEFAULT '0', + `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', + `ItemType` int(10) unsigned NOT NULL DEFAULT '0', + `PrimaryStat` int(10) unsigned NOT NULL DEFAULT '0', + `SecondaryStat` int(10) unsigned NOT NULL DEFAULT '0', + `SpecID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `item_spec_override` +-- + +DROP TABLE IF EXISTS `item_spec_override`; +CREATE TABLE `item_spec_override` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemID` int(10) unsigned NOT NULL DEFAULT '0', + `SpecID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `mail_template` +-- + +DROP TABLE IF EXISTS `mail_template`; +CREATE TABLE `mail_template` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Body` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `mail_template_locale` +-- + +DROP TABLE IF EXISTS `mail_template_locale`; +CREATE TABLE `mail_template_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Body_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `mount_capability` +-- + +DROP TABLE IF EXISTS `mount_capability`; +CREATE TABLE `mount_capability` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredRidingSkill` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredArea` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredAura` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredSpell` int(10) unsigned NOT NULL DEFAULT '0', + `SpeedModSpell` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredMap` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `mount_type` +-- + +DROP TABLE IF EXISTS `mount_type_x_capability`; +CREATE TABLE `mount_type_x_capability` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MountTypeID` int(10) unsigned NOT NULL DEFAULT '0', + `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0', + `MountCapabilityID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `name_gen` +-- + +DROP TABLE IF EXISTS `name_gen`; +CREATE TABLE `name_gen` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Race` int(10) unsigned NOT NULL DEFAULT '0', + `Sex` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `name_gen_locale` +-- + +DROP TABLE IF EXISTS `name_gen_locale`; +CREATE TABLE `name_gen_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; + +-- +-- Table structure for table `quest_money_reward` +-- + +DROP TABLE IF EXISTS `quest_money_reward`; +CREATE TABLE `quest_money_reward` ( + `Level` int(10) unsigned NOT NULL DEFAULT '0', + `Money1` int(10) unsigned NOT NULL DEFAULT '0', + `Money2` int(10) unsigned NOT NULL DEFAULT '0', + `Money3` int(10) unsigned NOT NULL DEFAULT '0', + `Money4` int(10) unsigned NOT NULL DEFAULT '0', + `Money5` int(10) unsigned NOT NULL DEFAULT '0', + `Money6` int(10) unsigned NOT NULL DEFAULT '0', + `Money7` int(10) unsigned NOT NULL DEFAULT '0', + `Money8` int(10) unsigned NOT NULL DEFAULT '0', + `Money9` int(10) unsigned NOT NULL DEFAULT '0', + `Money10` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`Level`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `quest_sort` +-- + +DROP TABLE IF EXISTS `quest_sort`; +CREATE TABLE `quest_sort` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SortName` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `quest_sort_locale` +-- + +DROP TABLE IF EXISTS `quest_sort_locale`; +CREATE TABLE `quest_sort_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `SortName_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `quest_v2` +-- + +DROP TABLE IF EXISTS `quest_v2`; +CREATE TABLE `quest_v2` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `UniqueBitFlag` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `quest_v2` +-- + +LOCK TABLES `quest_v2` WRITE; +/*!40000 ALTER TABLE `quest_v2` DISABLE KEYS */; +/*!40000 ALTER TABLE `quest_v2` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `quest_xp` +-- + +DROP TABLE IF EXISTS `quest_xp`; +CREATE TABLE `quest_xp` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Exp1` int(10) unsigned NOT NULL DEFAULT '0', + `Exp2` int(10) unsigned NOT NULL DEFAULT '0', + `Exp3` int(10) unsigned NOT NULL DEFAULT '0', + `Exp4` int(10) unsigned NOT NULL DEFAULT '0', + `Exp5` int(10) unsigned NOT NULL DEFAULT '0', + `Exp6` int(10) unsigned NOT NULL DEFAULT '0', + `Exp7` int(10) unsigned NOT NULL DEFAULT '0', + `Exp8` int(10) unsigned NOT NULL DEFAULT '0', + `Exp9` int(10) unsigned NOT NULL DEFAULT '0', + `Exp10` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `scaling_stat_distribution` +-- + +DROP TABLE IF EXISTS `scaling_stat_distribution`; +CREATE TABLE `scaling_stat_distribution` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MinLevel` int(10) unsigned NOT NULL DEFAULT '0', + `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevelCurveID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `specialization_spells` +-- + +DROP TABLE IF EXISTS `specialization_spells`; +CREATE TABLE `specialization_spells` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpecID` int(10) unsigned NOT NULL DEFAULT '0', + `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `OverridesSpellID` int(10) unsigned NOT NULL DEFAULT '0', + `Description` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `specialization_spells_locale` +-- + +DROP TABLE IF EXISTS `specialization_spells_locale`; +CREATE TABLE `specialization_spells_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Description_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spell_cast_times` +-- + +DROP TABLE IF EXISTS `spell_cast_times`; +CREATE TABLE `spell_cast_times` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `CastTime` int(11) NOT NULL DEFAULT '0', + `CastTimePerLevel` int(11) NOT NULL DEFAULT '0', + `MinCastTime` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spell_duration` +-- + +DROP TABLE IF EXISTS `spell_duration`; +CREATE TABLE `spell_duration` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Duration1` int(11) NOT NULL DEFAULT '0', + `Duration2` int(11) NOT NULL DEFAULT '0', + `Duration3` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spell_item_enchantment_condition` +-- + +DROP TABLE IF EXISTS `spell_item_enchantment_condition`; +CREATE TABLE `spell_item_enchantment_condition` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `LTOperandType1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LTOperandType2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LTOperandType3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LTOperandType4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LTOperandType5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LTOperand1` int(10) unsigned NOT NULL DEFAULT '0', + `LTOperand2` int(10) unsigned NOT NULL DEFAULT '0', + `LTOperand3` int(10) unsigned NOT NULL DEFAULT '0', + `LTOperand4` int(10) unsigned NOT NULL DEFAULT '0', + `LTOperand5` int(10) unsigned NOT NULL DEFAULT '0', + `Operator1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Operator2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Operator3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Operator4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Operator5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RTOperandType1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RTOperandType2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RTOperandType3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RTOperandType4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RTOperandType5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RTOperand1` int(10) unsigned NOT NULL DEFAULT '0', + `RTOperand2` int(10) unsigned NOT NULL DEFAULT '0', + `RTOperand3` int(10) unsigned NOT NULL DEFAULT '0', + `RTOperand4` int(10) unsigned NOT NULL DEFAULT '0', + `RTOperand5` int(10) unsigned NOT NULL DEFAULT '0', + `Logic1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Logic2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Logic3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Logic4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Logic5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- +-- Table structure for table `spell_radius` +-- + +DROP TABLE IF EXISTS `spell_radius`; +CREATE TABLE `spell_radius` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Radius` float NOT NULL DEFAULT '0', + `RadiusPerLevel` float NOT NULL DEFAULT '0', + `RadiusMin` float NOT NULL DEFAULT '0', + `RadiusMax` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spell_range` +-- + +DROP TABLE IF EXISTS `spell_range`; +CREATE TABLE `spell_range` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MinRangeHostile` float NOT NULL DEFAULT '0', + `MinRangeFriend` float NOT NULL DEFAULT '0', + `MaxRangeHostile` float NOT NULL DEFAULT '0', + `MaxRangeFriend` float NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `DisplayName` text, + `DisplayNameShort` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spell_range_locale` +-- + +DROP TABLE IF EXISTS `spell_range_locale`; +CREATE TABLE `spell_range_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `DisplayName_lang` text, + `DisplayNameShort_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spell_x_spell_visual` +-- + +DROP TABLE IF EXISTS `spell_x_spell_visual`; +CREATE TABLE `spell_x_spell_visual` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `DifficultyID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellVisualID1` int(10) unsigned NOT NULL DEFAULT '0', + `SpellVisualID2` int(10) unsigned NOT NULL DEFAULT '0', + `Unk620` float NOT NULL DEFAULT '0', + `PlayerConditionID` 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; + +-- +-- Table structure for table `totem_category` +-- + +DROP TABLE IF EXISTS `totem_category`; +CREATE TABLE `totem_category` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `CategoryType` int(10) unsigned NOT NULL DEFAULT '0', + `CategoryMask` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `totem_category_locale` +-- + +DROP TABLE IF EXISTS `totem_category_locale`; +CREATE TABLE `totem_category_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; + +-- +-- Table structure for table `transport_animation` +-- + +DROP TABLE IF EXISTS `transport_animation`; +CREATE TABLE `transport_animation` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `TransportID` int(10) unsigned NOT NULL DEFAULT '0', + `TimeIndex` 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', + `SequenceID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `transport_rotation` +-- + +DROP TABLE IF EXISTS `transport_rotation`; +CREATE TABLE `transport_rotation` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `TransportID` int(10) unsigned NOT NULL DEFAULT '0', + `TimeIndex` int(10) unsigned NOT NULL DEFAULT '0', + `X` float NOT NULL DEFAULT '0', + `Y` float NOT NULL DEFAULT '0', + `Z` float NOT NULL DEFAULT '0', + `W` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `unit_power_bar` +-- + +DROP TABLE IF EXISTS `unit_power_bar`; +CREATE TABLE `unit_power_bar` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MinPower` int(10) unsigned NOT NULL DEFAULT '0', + `MaxPower` int(10) unsigned NOT NULL DEFAULT '0', + `StartPower` int(10) unsigned NOT NULL DEFAULT '0', + `CenterPower` int(10) unsigned NOT NULL DEFAULT '0', + `RegenerationPeace` float NOT NULL DEFAULT '0', + `RegenerationCombat` float NOT NULL DEFAULT '0', + `BarType` int(10) unsigned NOT NULL DEFAULT '0', + `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', + `Color1` int(10) unsigned NOT NULL DEFAULT '0', + `Color2` int(10) unsigned NOT NULL DEFAULT '0', + `Color3` int(10) unsigned NOT NULL DEFAULT '0', + `Color4` int(10) unsigned NOT NULL DEFAULT '0', + `Color5` int(10) unsigned NOT NULL DEFAULT '0', + `Color6` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Cost` text, + `OutOfError` text, + `ToolTip` text, + `StartInset` float NOT NULL DEFAULT '0', + `EndInset` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `unit_power_bar_locale` +-- + +DROP TABLE IF EXISTS `unit_power_bar_locale`; +CREATE TABLE `unit_power_bar_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `Cost_lang` text, + `OutOfError_lang` text, + `ToolTip_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `world_map_overlay` +-- + +DROP TABLE IF EXISTS `world_map_overlay`; +CREATE TABLE `world_map_overlay` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MapAreaID` int(10) unsigned NOT NULL DEFAULT '0', + `AreaID1` int(10) unsigned NOT NULL DEFAULT '0', + `AreaID2` int(10) unsigned NOT NULL DEFAULT '0', + `AreaID3` int(10) unsigned NOT NULL DEFAULT '0', + `AreaID4` int(10) unsigned NOT NULL DEFAULT '0', + `TextureName` text, + `TextureWidth` int(10) unsigned NOT NULL DEFAULT '0', + `TextureHeight` int(10) unsigned NOT NULL DEFAULT '0', + `OffsetX` int(10) unsigned NOT NULL DEFAULT '0', + `OffsetY` int(10) unsigned NOT NULL DEFAULT '0', + `HitRectTop` int(10) unsigned NOT NULL DEFAULT '0', + `HitRectLeft` int(10) unsigned NOT NULL DEFAULT '0', + `HitRectBottom` int(10) unsigned NOT NULL DEFAULT '0', + `HitRectRight` 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; + +-- +-- Table structure for table `world_map_overlay_locale` +-- + +DROP TABLE IF EXISTS `world_map_overlay_locale`; +CREATE TABLE `world_map_overlay_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `TextureName_lang` text, + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +ALTER TABLE `garr_ability` ADD `FollowerTypeID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `GarrAbilityCategoryID`; +ALTER TABLE `garr_follower` + ADD `FollowerTypeID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `ID`, + ADD `HordeListPortraitTextureKitID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AlliancePortraitIconID`, + ADD `AllianceListPortraitTextureKitID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `HordeListPortraitTextureKitID`; +ALTER TABLE `item_effect` ADD `ChrSpecializationID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `CategoryCooldown`; +ALTER TABLE `spell_misc` DROP `SpellVisualID1`. DROP `SpellVisualID2`; -- cgit v1.2.3