diff options
Diffstat (limited to 'sql/base/dev')
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 1713 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 779 |
2 files changed, 2000 insertions, 492 deletions
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 1dcaf45bdab..310573098ef 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -92,6 +92,100 @@ CREATE TABLE `area_poi_state` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `auction_house` +-- + +DROP TABLE IF EXISTS `auction_house`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `auction_house_locale` +-- + +DROP TABLE IF EXISTS `auction_house_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `barber_shop_style` +-- + +DROP TABLE IF EXISTS `barber_shop_style`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `barber_shop_style_locale` +-- + +DROP TABLE IF EXISTS `barber_shop_style_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `battle_pet_species` +-- + +DROP TABLE IF EXISTS `battle_pet_species`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `battle_pet_species` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `CreatureID` int(10) unsigned NOT NULL DEFAULT '0', + `IconFileID` int(10) unsigned NOT NULL DEFAULT '0', + `SummonSpellID` int(10) unsigned NOT NULL DEFAULT '0', + `PetType` int(11) NOT NULL DEFAULT '0', + `Source` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `SourceText` text, + `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 `broadcast_text` -- @@ -135,6 +229,138 @@ CREATE TABLE `broadcast_text_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `char_start_outfit` +-- + +DROP TABLE IF EXISTS `char_start_outfit`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `chr_classes_x_power_types` +-- + +DROP TABLE IF EXISTS `chr_classes_x_power_types`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `chr_upgrade_bucket` +-- + +DROP TABLE IF EXISTS `chr_upgrade_bucket`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_upgrade_bucket` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `TierID` int(10) unsigned NOT NULL DEFAULT '0', + `SpecializationID` 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 `chr_upgrade_bucket_spell` +-- + +DROP TABLE IF EXISTS `chr_upgrade_bucket_spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_upgrade_bucket_spell` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `BucketID` 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `chr_upgrade_tier` +-- + +DROP TABLE IF EXISTS `chr_upgrade_tier`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_upgrade_tier` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `TierIndex` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `TalentTier` 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 `cinematic_sequences` +-- + +DROP TABLE IF EXISTS `cinematic_sequences`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `creature` -- @@ -192,6 +418,92 @@ CREATE TABLE `creature_difficulty` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `creature_display_info` +-- + +DROP TABLE IF EXISTS `creature_display_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_display_info_locale` +-- + +DROP TABLE IF EXISTS `creature_display_info_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_type` +-- + +DROP TABLE IF EXISTS `creature_type`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_type_locale` +-- + +DROP TABLE IF EXISTS `creature_type_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `currency_types` -- @@ -254,6 +566,91 @@ CREATE TABLE `curve_point` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `destructible_model_data` +-- + +DROP TABLE IF EXISTS `destructible_model_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `durability_quality` +-- + +DROP TABLE IF EXISTS `durability_quality`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_tables` +-- + +DROP TABLE IF EXISTS `game_tables`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_tables` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text NOT NULL, + `NumRows` int(10) unsigned NOT NULL DEFAULT '0', + `NumColumns` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) NOT NULL, + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_tables_locale` +-- + +DROP TABLE IF EXISTS `game_tables_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_tables_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text NOT NULL, + `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 `gameobjects` -- @@ -276,14 +673,14 @@ CREATE TABLE `gameobjects` ( `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', + `Data0` int(10) NOT NULL DEFAULT '0', + `Data1` int(10) NOT NULL DEFAULT '0', + `Data2` int(10) NOT NULL DEFAULT '0', + `Data3` int(10) NOT NULL DEFAULT '0', + `Data4` int(10) NOT NULL DEFAULT '0', + `Data5` int(10) NOT NULL DEFAULT '0', + `Data6` int(10) NOT NULL DEFAULT '0', + `Data7` int(10) NOT NULL DEFAULT '0', `Name` text NOT NULL, `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) @@ -291,6 +688,404 @@ CREATE TABLE `gameobjects` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `gameobjects_locale` +-- + +DROP TABLE IF EXISTS `gameobjects_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobjects_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 `garr_ability` +-- + +DROP TABLE IF EXISTS `garr_ability`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_ability` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Description` text, + `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `OtherFactionGarrAbilityID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrAbilityCategoryID` int(10) unsigned NOT NULL DEFAULT '0', + `FollowerTypeID` 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 `garr_ability_locale` +-- + +DROP TABLE IF EXISTS `garr_ability_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_ability_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_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 `garr_building` +-- + +DROP TABLE IF EXISTS `garr_building`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_building` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeGameObjectID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceGameObjectID` int(10) unsigned NOT NULL DEFAULT '0', + `Unknown` int(10) unsigned NOT NULL DEFAULT '0', + `Type` int(10) unsigned NOT NULL DEFAULT '0', + `Level` int(10) unsigned NOT NULL DEFAULT '0', + `NameAlliance` text, + `NameHorde` text, + `Description` text, + `Tooltip` text, + `BuildDuration` int(10) unsigned NOT NULL DEFAULT '0', + `CostCurrencyID` int(10) unsigned NOT NULL DEFAULT '0', + `CostCurrencyAmount` int(11) NOT NULL DEFAULT '0', + `HordeTexPrefixKitID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceTexPrefixKitID` int(10) unsigned NOT NULL DEFAULT '0', + `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `BonusAmount` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceActivationScenePackageID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeActivationScenePackageID` int(10) unsigned NOT NULL DEFAULT '0', + `MaxShipments` int(10) unsigned NOT NULL DEFAULT '0', + `FollowerRequiredGarrAbilityID` int(10) unsigned NOT NULL DEFAULT '0', + `FollowerGarrAbilityEffectID` int(10) unsigned NOT NULL DEFAULT '0', + `CostMoney` 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 `garr_building_locale` +-- + +DROP TABLE IF EXISTS `garr_building_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_building_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `NameAlliance_lang` text, + `NameHorde_lang` text, + `Description_lang` text, + `Tooltip_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 `garr_building_plot_inst` +-- + +DROP TABLE IF EXISTS `garr_building_plot_inst`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_building_plot_inst` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrBuildingID` int(10) unsigned NOT NULL DEFAULT '0', + `UiTextureAtlasMemberID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrSiteLevelPlotInstID` int(10) unsigned NOT NULL DEFAULT '0', + `LandmarkOffsetX` float NOT NULL DEFAULT '0', + `LandmarkOffsetY` 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 `garr_class_spec` +-- + +DROP TABLE IF EXISTS `garr_class_spec`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_class_spec` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `NameMale` text, + `NameFemale` text, + `NameGenderless` text, + `ClassAtlasID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrFollItemSetID` 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 `garr_class_spec_locale` +-- + +DROP TABLE IF EXISTS `garr_class_spec_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_class_spec_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `NameMale_lang` text, + `NameFemale_lang` text, + `NameGenderless_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 `garr_follower` +-- + +DROP TABLE IF EXISTS `garr_follower`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_follower` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `FollowerTypeID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeCreatureID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceCreatureID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeUiAnimRaceInfoID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceUiAnimRaceInfoID` int(10) unsigned NOT NULL DEFAULT '0', + `Quality` int(10) unsigned NOT NULL DEFAULT '0', + `HordeGarrClassSpecID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceGarrClassSpecID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeGarrFollItemSetID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceGarrFollItemSetID` int(10) unsigned NOT NULL DEFAULT '0', + `Level` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevelWeapon` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevelArmor` int(10) unsigned NOT NULL DEFAULT '0', + `Unknown1` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `HordeSourceText` text, + `AllianceSourceText` text, + `Unknown2` int(11) NOT NULL DEFAULT '0', + `Unknown3` int(11) NOT NULL DEFAULT '0', + `HordePortraitIconID` int(10) unsigned NOT NULL DEFAULT '0', + `AlliancePortraitIconID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeListPortraitTextureKitID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceListPortraitTextureKitID` 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 `garr_follower_locale` +-- + +DROP TABLE IF EXISTS `garr_follower_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_follower_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `HordeSourceText_lang` text, + `AllianceSourceText_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 `garr_follower_x_ability` +-- + +DROP TABLE IF EXISTS `garr_follower_x_ability`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_follower_x_ability` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrFollowerID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrAbilityID` int(10) unsigned NOT NULL DEFAULT '0', + `FactionIndex` 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 `garr_plot` +-- + +DROP TABLE IF EXISTS `garr_plot`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_plot` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrPlotUICategoryID` int(10) unsigned NOT NULL DEFAULT '0', + `PlotType` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `MinCount` int(10) unsigned NOT NULL DEFAULT '0', + `MaxCount` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceConstructionGameObjectID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeConstructionGameObjectID` 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 `garr_plot_building` +-- + +DROP TABLE IF EXISTS `garr_plot_building`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_plot_building` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrPlotID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrBuildingID` 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 `garr_plot_instance` +-- + +DROP TABLE IF EXISTS `garr_plot_instance`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_plot_instance` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrPlotID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` 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 `garr_plot_instance_locale` +-- + +DROP TABLE IF EXISTS `garr_plot_instance_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_plot_instance_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 `garr_plot_locale` +-- + +DROP TABLE IF EXISTS `garr_plot_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_plot_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 `garr_site_level` +-- + +DROP TABLE IF EXISTS `garr_site_level`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_site_level` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Level` int(10) unsigned NOT NULL DEFAULT '0', + `MapID` int(10) unsigned NOT NULL DEFAULT '0', + `SiteID` int(10) unsigned NOT NULL DEFAULT '0', + `UITextureKitID` int(10) unsigned NOT NULL DEFAULT '0', + `TownHallX` float NOT NULL DEFAULT '0', + `TownHallY` float NOT NULL DEFAULT '0', + `MovieID` int(10) unsigned NOT NULL DEFAULT '0', + `Level2` int(10) unsigned NOT NULL DEFAULT '0', + `UpgradeResourceCost` int(10) unsigned NOT NULL DEFAULT '0', + `UpgradeMoneyCost` 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 `garr_site_level_plot_inst` +-- + +DROP TABLE IF EXISTS `garr_site_level_plot_inst`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garr_site_level_plot_inst` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrSiteLevelID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrPlotInstanceID` int(10) unsigned NOT NULL DEFAULT '0', + `LandmarkX` float NOT NULL DEFAULT '0', + `LandmarkY` float NOT NULL DEFAULT '0', + `Unknown` 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 `glyph_slot` +-- + +DROP TABLE IF EXISTS `glyph_slot`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `guild_perk_spells` +-- + +DROP TABLE IF EXISTS `guild_perk_spells`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `holidays` -- @@ -381,6 +1176,69 @@ CREATE TABLE `hotfix_data` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `import_price_armor` +-- + +DROP TABLE IF EXISTS `import_price_armor`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `import_price_quality` +-- + +DROP TABLE IF EXISTS `import_price_quality`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `import_price_shield` +-- + +DROP TABLE IF EXISTS `import_price_shield`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `import_price_weapon` +-- + +DROP TABLE IF EXISTS `import_price_weapon`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item` -- @@ -456,6 +1314,39 @@ CREATE TABLE `item_bonus_tree_node` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_class` +-- + +DROP TABLE IF EXISTS `item_class`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_class_locale` +-- + +DROP TABLE IF EXISTS `item_class_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_currency_cost` -- @@ -472,6 +1363,26 @@ CREATE TABLE `item_currency_cost` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_disenchant_loot` +-- + +DROP TABLE IF EXISTS `item_disenchant_loot`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_effect` -- @@ -488,6 +1399,7 @@ CREATE TABLE `item_effect` ( `Cooldown` int(11) NOT NULL DEFAULT '0', `Category` int(10) unsigned NOT NULL DEFAULT '0', `CategoryCooldown` int(11) NOT NULL DEFAULT '0', + `ChrSpecializationID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -536,6 +1448,39 @@ CREATE TABLE `item_extended_cost` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_limit_category` +-- + +DROP TABLE IF EXISTS `item_limit_category`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_limit_category_locale` +-- + +DROP TABLE IF EXISTS `item_limit_category_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_modified_appearance` -- @@ -555,6 +1500,104 @@ CREATE TABLE `item_modified_appearance` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_price_base` +-- + +DROP TABLE IF EXISTS `item_price_base`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_properties` +-- + +DROP TABLE IF EXISTS `item_random_properties`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_properties_locale` +-- + +DROP TABLE IF EXISTS `item_random_properties_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_suffix` +-- + +DROP TABLE IF EXISTS `item_random_suffix`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_suffix_locale` +-- + +DROP TABLE IF EXISTS `item_random_suffix_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_sparse` -- @@ -690,6 +1733,42 @@ CREATE TABLE `item_sparse_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_spec` +-- + +DROP TABLE IF EXISTS `item_spec`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_spec_override` +-- + +DROP TABLE IF EXISTS `item_spec_override`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_x_bonus_tree` -- @@ -752,6 +1831,37 @@ CREATE TABLE `key_chain` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `mail_template` +-- + +DROP TABLE IF EXISTS `mail_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `mail_template_locale` +-- + +DROP TABLE IF EXISTS `mail_template_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `mount` -- @@ -775,6 +1885,27 @@ CREATE TABLE `mount` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `mount_capability` +-- + +DROP TABLE IF EXISTS `mount_capability`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `mount_locale` -- @@ -793,6 +1924,56 @@ CREATE TABLE `mount_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `mount_type_x_capability` +-- + +DROP TABLE IF EXISTS `mount_type_x_capability`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `name_gen` +-- + +DROP TABLE IF EXISTS `name_gen`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `name_gen_locale` +-- + +DROP TABLE IF EXISTS `name_gen_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `override_spell_data` -- @@ -835,6 +2016,135 @@ CREATE TABLE `phase_group` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `quest_money_reward` +-- + +DROP TABLE IF EXISTS `quest_money_reward`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_package_item` +-- + +DROP TABLE IF EXISTS `quest_package_item`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_package_item` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `QuestPackageID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemCount` int(10) unsigned NOT NULL DEFAULT '0', + `FilterType` 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 `quest_sort` +-- + +DROP TABLE IF EXISTS `quest_sort`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_sort_locale` +-- + +DROP TABLE IF EXISTS `quest_sort_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_v2` +-- + +DROP TABLE IF EXISTS `quest_v2`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_xp` +-- + +DROP TABLE IF EXISTS `quest_xp`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `scaling_stat_distribution` +-- + +DROP TABLE IF EXISTS `scaling_stat_distribution`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `sound_entries` -- @@ -920,6 +2230,41 @@ CREATE TABLE `sound_entries_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `specialization_spells` +-- + +DROP TABLE IF EXISTS `specialization_spells`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `specialization_spells_locale` +-- + +DROP TABLE IF EXISTS `specialization_spells_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `spell_aura_restrictions` -- @@ -942,6 +2287,23 @@ CREATE TABLE `spell_aura_restrictions` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `spell_cast_times` +-- + +DROP TABLE IF EXISTS `spell_cast_times`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `spell_casting_requirements` -- @@ -982,6 +2344,83 @@ CREATE TABLE `spell_class_options` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `spell_duration` +-- + +DROP TABLE IF EXISTS `spell_duration`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_effect_group_size` +-- + +DROP TABLE IF EXISTS `spell_effect_group_size`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_effect_group_size` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellEffectID` int(10) unsigned NOT NULL DEFAULT '0', + `Size` 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_item_enchantment_condition` +-- + +DROP TABLE IF EXISTS `spell_item_enchantment_condition`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `spell_learn_spell` -- @@ -1025,8 +2464,6 @@ CREATE TABLE `spell_misc` ( `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', @@ -1080,6 +2517,62 @@ CREATE TABLE `spell_power_difficulty` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `spell_radius` +-- + +DROP TABLE IF EXISTS `spell_radius`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_range` +-- + +DROP TABLE IF EXISTS `spell_range`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_range_locale` +-- + +DROP TABLE IF EXISTS `spell_range_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `spell_reagents` -- @@ -1149,6 +2642,27 @@ CREATE TABLE `spell_totems` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `spell_x_spell_visual` +-- + +DROP TABLE IF EXISTS `spell_x_spell_visual`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `taxi_nodes` -- @@ -1232,6 +2746,138 @@ CREATE TABLE `taxi_path_node` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `totem_category` +-- + +DROP TABLE IF EXISTS `totem_category`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `totem_category_locale` +-- + +DROP TABLE IF EXISTS `totem_category_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `transport_animation` +-- + +DROP TABLE IF EXISTS `transport_animation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `transport_rotation` +-- + +DROP TABLE IF EXISTS `transport_rotation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `unit_power_bar` +-- + +DROP TABLE IF EXISTS `unit_power_bar`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `unit_power_bar_locale` +-- + +DROP TABLE IF EXISTS `unit_power_bar_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `updates` -- @@ -1261,6 +2907,51 @@ CREATE TABLE `updates_include` ( 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 */; + +-- +-- Table structure for table `world_map_overlay` +-- + +DROP TABLE IF EXISTS `world_map_overlay`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `world_map_overlay_locale` +-- + +DROP TABLE IF EXISTS `world_map_overlay_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; @@ -1271,4 +2962,4 @@ CREATE TABLE `updates_include` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2015-03-21 16:07:14 +-- Dump completed on 2015-07-13 23:52:10 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 76a07e6a56d..15a7c457122 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -160,20 +160,18 @@ DROP TABLE IF EXISTS `battleground_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battleground_template` ( - `id` mediumint(8) unsigned NOT NULL, + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', `MinPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0', `MaxPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0', `MinLvl` tinyint(3) unsigned NOT NULL DEFAULT '0', `MaxLvl` tinyint(3) unsigned NOT NULL DEFAULT '0', `AllianceStartLoc` mediumint(8) unsigned NOT NULL, - `AllianceStartO` float NOT NULL, `HordeStartLoc` mediumint(8) unsigned NOT NULL, - `HordeStartO` float NOT NULL, `StartMaxDist` float NOT NULL DEFAULT '0', `Weight` tinyint(3) unsigned NOT NULL DEFAULT '1', `ScriptName` char(64) NOT NULL DEFAULT '', `Comment` char(32) NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -235,9 +233,9 @@ CREATE TABLE `conditions` ( `ElseGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', `ConditionTypeOrReference` mediumint(8) NOT NULL DEFAULT '0', `ConditionTarget` tinyint(3) unsigned NOT NULL DEFAULT '0', - `ConditionValue1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ConditionValue2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `ConditionValue3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ConditionValue1` int(10) unsigned NOT NULL DEFAULT '0', + `ConditionValue2` int(10) unsigned NOT NULL DEFAULT '0', + `ConditionValue3` int(10) unsigned NOT NULL DEFAULT '0', `NegativeCondition` tinyint(3) unsigned NOT NULL DEFAULT '0', `ErrorType` mediumint(8) unsigned NOT NULL DEFAULT '0', `ErrorTextId` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -261,7 +259,6 @@ CREATE TABLE `creature` ( `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', `areaId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier', `spawnMask` int(10) unsigned NOT NULL DEFAULT '1', - `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', `PhaseId` int(10) DEFAULT '0', `PhaseGroup` int(10) DEFAULT '0', `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -276,7 +273,7 @@ CREATE TABLE `creature` ( `curhealth` int(10) unsigned NOT NULL DEFAULT '1', `curmana` int(10) unsigned NOT NULL DEFAULT '0', `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', - `npcflag` int(10) unsigned NOT NULL DEFAULT '0', + `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0', `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', @@ -338,13 +335,13 @@ DROP TABLE IF EXISTS `creature_equip_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_equip_template` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `id` tinyint(3) unsigned NOT NULL DEFAULT '0', - `itemEntry1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `itemEntry2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `itemEntry3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ID` tinyint(3) unsigned NOT NULL DEFAULT '1', + `ItemID1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ItemID2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ItemID3` mediumint(8) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`entry`,`id`) + PRIMARY KEY (`CreatureID`,`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -442,6 +439,22 @@ CREATE TABLE `creature_questender` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `creature_questitem` +-- + +DROP TABLE IF EXISTS `creature_questitem`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_questitem` ( + `CreatureEntry` int(10) unsigned NOT NULL DEFAULT '0', + `Idx` int(10) unsigned NOT NULL DEFAULT '0', + `ItemId` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', + PRIMARY KEY (`CreatureEntry`,`Idx`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `creature_queststarter` -- @@ -504,7 +517,7 @@ CREATE TABLE `creature_template` ( `exp` smallint(6) NOT NULL DEFAULT '0', `exp_unk` smallint(2) NOT NULL DEFAULT '0', `faction` smallint(5) unsigned NOT NULL DEFAULT '0', - `npcflag` int(10) unsigned NOT NULL DEFAULT '0', + `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0', `speed_walk` float NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value', `speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value', `scale` float NOT NULL DEFAULT '1', @@ -542,7 +555,6 @@ CREATE TABLE `creature_template` ( `spell6` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell7` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell8` mediumint(8) unsigned NOT NULL DEFAULT '0', - `PetSpellDataId` mediumint(8) unsigned NOT NULL DEFAULT '0', `VehicleId` mediumint(8) unsigned NOT NULL DEFAULT '0', `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0', `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -558,12 +570,6 @@ CREATE TABLE `creature_template` ( `DamageModifier` float NOT NULL DEFAULT '1', `ExperienceModifier` float NOT NULL DEFAULT '1', `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0', - `questItem1` int(10) unsigned NOT NULL DEFAULT '0', - `questItem2` int(10) unsigned NOT NULL DEFAULT '0', - `questItem3` int(10) unsigned NOT NULL DEFAULT '0', - `questItem4` int(10) unsigned NOT NULL DEFAULT '0', - `questItem5` int(10) unsigned NOT NULL DEFAULT '0', - `questItem6` int(10) unsigned NOT NULL DEFAULT '0', `movementId` int(11) unsigned NOT NULL DEFAULT '0', `RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1', `mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0', @@ -888,7 +894,7 @@ DROP TABLE IF EXISTS `game_event_npcflag`; CREATE TABLE `game_event_npcflag` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `npcflag` int(10) unsigned NOT NULL DEFAULT '0', + `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1011,7 +1017,6 @@ CREATE TABLE `gameobject` ( `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', `areaId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier', `spawnMask` int(10) unsigned NOT NULL DEFAULT '1', - `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', `PhaseId` int(10) DEFAULT '0', `PhaseGroup` int(10) DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', @@ -1031,6 +1036,21 @@ CREATE TABLE `gameobject` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `gameobject_addon` +-- + +DROP TABLE IF EXISTS `gameobject_addon`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject_addon` ( + `guid` bigint(20) unsigned NOT NULL DEFAULT '0', + `invisibilityType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `invisibilityValue` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `gameobject_loot_template` -- @@ -1067,6 +1087,22 @@ CREATE TABLE `gameobject_questender` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `gameobject_questitem` +-- + +DROP TABLE IF EXISTS `gameobject_questitem`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject_questitem` ( + `GameObjectEntry` int(10) unsigned NOT NULL DEFAULT '0', + `Idx` int(10) unsigned NOT NULL DEFAULT '0', + `ItemId` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', + PRIMARY KEY (`GameObjectEntry`,`Idx`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `gameobject_queststarter` -- @@ -1098,12 +1134,6 @@ CREATE TABLE `gameobject_template` ( `faction` smallint(5) unsigned NOT NULL DEFAULT '0', `flags` int(10) unsigned NOT NULL DEFAULT '0', `size` float NOT NULL DEFAULT '1', - `questItem1` int(11) unsigned NOT NULL DEFAULT '0', - `questItem2` int(11) unsigned NOT NULL DEFAULT '0', - `questItem3` int(11) unsigned NOT NULL DEFAULT '0', - `questItem4` int(11) unsigned NOT NULL DEFAULT '0', - `questItem5` int(11) unsigned NOT NULL DEFAULT '0', - `questItem6` int(11) unsigned NOT NULL DEFAULT '0', `Data0` int(10) NOT NULL DEFAULT '0', `Data1` int(10) NOT NULL DEFAULT '0', `Data2` int(10) NOT NULL DEFAULT '0', @@ -1147,6 +1177,45 @@ CREATE TABLE `gameobject_template` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `garrison_follower_class_spec_abilities` +-- + +DROP TABLE IF EXISTS `garrison_follower_class_spec_abilities`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garrison_follower_class_spec_abilities` ( + `classSpecId` int(10) unsigned NOT NULL DEFAULT '0', + `abilityId` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`classSpecId`,`abilityId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `garrison_plot_finalize_info` +-- + +DROP TABLE IF EXISTS `garrison_plot_finalize_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `garrison_plot_finalize_info` ( + `garrPlotInstanceId` int(10) unsigned NOT NULL, + `hordeGameObjectId` int(10) unsigned NOT NULL DEFAULT '0', + `hordeX` float NOT NULL DEFAULT '0', + `hordeY` float NOT NULL DEFAULT '0', + `hordeZ` float NOT NULL DEFAULT '0', + `hordeO` float NOT NULL DEFAULT '0', + `hordeAnimKitId` smallint(5) unsigned NOT NULL DEFAULT '0', + `allianceGameObjectId` int(10) unsigned NOT NULL DEFAULT '0', + `allianceX` float NOT NULL DEFAULT '0', + `allianceY` float NOT NULL DEFAULT '0', + `allianceZ` float NOT NULL DEFAULT '0', + `allianceO` float NOT NULL DEFAULT '0', + `allianceAnimKitId` smallint(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`garrPlotInstanceId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `gossip_menu` -- @@ -1174,7 +1243,7 @@ CREATE TABLE `gossip_menu_option` ( `option_text` text, `OptionBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', `option_id` tinyint(3) unsigned NOT NULL DEFAULT '0', - `npc_option_npcflag` int(10) unsigned NOT NULL DEFAULT '0', + `npc_option_npcflag` bigint(20) unsigned NOT NULL DEFAULT '0', `action_menu_id` int(10) unsigned NOT NULL DEFAULT '0', `action_poi_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `box_coded` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -1535,323 +1604,6 @@ CREATE TABLE `locales_gossip_menu_option` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `locales_npc_text` --- - -DROP TABLE IF EXISTS `locales_npc_text`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_npc_text` ( - `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Text0_0_loc1` longtext, - `Text0_0_loc2` longtext, - `Text0_0_loc3` longtext, - `Text0_0_loc4` longtext, - `Text0_0_loc5` longtext, - `Text0_0_loc6` longtext, - `Text0_0_loc7` longtext, - `Text0_0_loc8` longtext, - `Text0_1_loc1` longtext, - `Text0_1_loc2` longtext, - `Text0_1_loc3` longtext, - `Text0_1_loc4` longtext, - `Text0_1_loc5` longtext, - `Text0_1_loc6` longtext, - `Text0_1_loc7` longtext, - `Text0_1_loc8` longtext, - `Text1_0_loc1` longtext, - `Text1_0_loc2` longtext, - `Text1_0_loc3` longtext, - `Text1_0_loc4` longtext, - `Text1_0_loc5` longtext, - `Text1_0_loc6` longtext, - `Text1_0_loc7` longtext, - `Text1_0_loc8` longtext, - `Text1_1_loc1` longtext, - `Text1_1_loc2` longtext, - `Text1_1_loc3` longtext, - `Text1_1_loc4` longtext, - `Text1_1_loc5` longtext, - `Text1_1_loc6` longtext, - `Text1_1_loc7` longtext, - `Text1_1_loc8` longtext, - `Text2_0_loc1` longtext, - `Text2_0_loc2` longtext, - `Text2_0_loc3` longtext, - `Text2_0_loc4` longtext, - `Text2_0_loc5` longtext, - `Text2_0_loc6` longtext, - `Text2_0_loc7` longtext, - `Text2_0_loc8` longtext, - `Text2_1_loc1` longtext, - `Text2_1_loc2` longtext, - `Text2_1_loc3` longtext, - `Text2_1_loc4` longtext, - `Text2_1_loc5` longtext, - `Text2_1_loc6` longtext, - `Text2_1_loc7` longtext, - `Text2_1_loc8` longtext, - `Text3_0_loc1` longtext, - `Text3_0_loc2` longtext, - `Text3_0_loc3` longtext, - `Text3_0_loc4` longtext, - `Text3_0_loc5` longtext, - `Text3_0_loc6` longtext, - `Text3_0_loc7` longtext, - `Text3_0_loc8` longtext, - `Text3_1_loc1` longtext, - `Text3_1_loc2` longtext, - `Text3_1_loc3` longtext, - `Text3_1_loc4` longtext, - `Text3_1_loc5` longtext, - `Text3_1_loc6` longtext, - `Text3_1_loc7` longtext, - `Text3_1_loc8` longtext, - `Text4_0_loc1` longtext, - `Text4_0_loc2` longtext, - `Text4_0_loc3` longtext, - `Text4_0_loc4` longtext, - `Text4_0_loc5` longtext, - `Text4_0_loc6` longtext, - `Text4_0_loc7` longtext, - `Text4_0_loc8` longtext, - `Text4_1_loc1` longtext, - `Text4_1_loc2` longtext, - `Text4_1_loc3` longtext, - `Text4_1_loc4` longtext, - `Text4_1_loc5` longtext, - `Text4_1_loc6` longtext, - `Text4_1_loc7` longtext, - `Text4_1_loc8` longtext, - `Text5_0_loc1` longtext, - `Text5_0_loc2` longtext, - `Text5_0_loc3` longtext, - `Text5_0_loc4` longtext, - `Text5_0_loc5` longtext, - `Text5_0_loc6` longtext, - `Text5_0_loc7` longtext, - `Text5_0_loc8` longtext, - `Text5_1_loc1` longtext, - `Text5_1_loc2` longtext, - `Text5_1_loc3` longtext, - `Text5_1_loc4` longtext, - `Text5_1_loc5` longtext, - `Text5_1_loc6` longtext, - `Text5_1_loc7` longtext, - `Text5_1_loc8` longtext, - `Text6_0_loc1` longtext, - `Text6_0_loc2` longtext, - `Text6_0_loc3` longtext, - `Text6_0_loc4` longtext, - `Text6_0_loc5` longtext, - `Text6_0_loc6` longtext, - `Text6_0_loc7` longtext, - `Text6_0_loc8` longtext, - `Text6_1_loc1` longtext, - `Text6_1_loc2` longtext, - `Text6_1_loc3` longtext, - `Text6_1_loc4` longtext, - `Text6_1_loc5` longtext, - `Text6_1_loc6` longtext, - `Text6_1_loc7` longtext, - `Text6_1_loc8` longtext, - `Text7_0_loc1` longtext, - `Text7_0_loc2` longtext, - `Text7_0_loc3` longtext, - `Text7_0_loc4` longtext, - `Text7_0_loc5` longtext, - `Text7_0_loc6` longtext, - `Text7_0_loc7` longtext, - `Text7_0_loc8` longtext, - `Text7_1_loc1` longtext, - `Text7_1_loc2` longtext, - `Text7_1_loc3` longtext, - `Text7_1_loc4` longtext, - `Text7_1_loc5` longtext, - `Text7_1_loc6` longtext, - `Text7_1_loc7` longtext, - `Text7_1_loc8` longtext, - PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_page_text` --- - -DROP TABLE IF EXISTS `locales_page_text`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_page_text` ( - `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Text_loc1` longtext, - `Text_loc2` longtext, - `Text_loc3` longtext, - `Text_loc4` longtext, - `Text_loc5` longtext, - `Text_loc6` longtext, - `Text_loc7` longtext, - `Text_loc8` longtext, - PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_points_of_interest` --- - -DROP TABLE IF EXISTS `locales_points_of_interest`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_points_of_interest` ( - `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Name_loc1` text, - `Name_loc2` text, - `Name_loc3` text, - `Name_loc4` text, - `Name_loc5` text, - `Name_loc6` text, - `Name_loc7` text, - `Name_loc8` text, - PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `locales_quest` --- - -DROP TABLE IF EXISTS `locales_quest`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `locales_quest` ( - `Id` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Title_loc1` text, - `Title_loc2` text, - `Title_loc3` text, - `Title_loc4` text, - `Title_loc5` text, - `Title_loc6` text, - `Title_loc7` text, - `Title_loc8` text, - `Details_loc1` text, - `Details_loc2` text, - `Details_loc3` text, - `Details_loc4` text, - `Details_loc5` text, - `Details_loc6` text, - `Details_loc7` text, - `Details_loc8` text, - `Objectives_loc1` text, - `Objectives_loc2` text, - `Objectives_loc3` text, - `Objectives_loc4` text, - `Objectives_loc5` text, - `Objectives_loc6` text, - `Objectives_loc7` text, - `Objectives_loc8` text, - `OfferRewardText_loc1` text, - `OfferRewardText_loc2` text, - `OfferRewardText_loc3` text, - `OfferRewardText_loc4` text, - `OfferRewardText_loc5` text, - `OfferRewardText_loc6` text, - `OfferRewardText_loc7` text, - `OfferRewardText_loc8` text, - `RequestItemsText_loc1` text, - `RequestItemsText_loc2` text, - `RequestItemsText_loc3` text, - `RequestItemsText_loc4` text, - `RequestItemsText_loc5` text, - `RequestItemsText_loc6` text, - `RequestItemsText_loc7` text, - `RequestItemsText_loc8` text, - `EndText_loc1` text, - `EndText_loc2` text, - `EndText_loc3` text, - `EndText_loc4` text, - `EndText_loc5` text, - `EndText_loc6` text, - `EndText_loc7` text, - `EndText_loc8` text, - `CompletedText_loc1` text, - `CompletedText_loc2` text, - `CompletedText_loc3` text, - `CompletedText_loc4` text, - `CompletedText_loc5` text, - `CompletedText_loc6` text, - `CompletedText_loc7` text, - `CompletedText_loc8` text, - `ObjectiveText1_loc1` text, - `ObjectiveText1_loc2` text, - `ObjectiveText1_loc3` text, - `ObjectiveText1_loc4` text, - `ObjectiveText1_loc5` text, - `ObjectiveText1_loc6` text, - `ObjectiveText1_loc7` text, - `ObjectiveText1_loc8` text, - `ObjectiveText2_loc1` text, - `ObjectiveText2_loc2` text, - `ObjectiveText2_loc3` text, - `ObjectiveText2_loc4` text, - `ObjectiveText2_loc5` text, - `ObjectiveText2_loc6` text, - `ObjectiveText2_loc7` text, - `ObjectiveText2_loc8` text, - `ObjectiveText3_loc1` text, - `ObjectiveText3_loc2` text, - `ObjectiveText3_loc3` text, - `ObjectiveText3_loc4` text, - `ObjectiveText3_loc5` text, - `ObjectiveText3_loc6` text, - `ObjectiveText3_loc7` text, - `ObjectiveText3_loc8` text, - `ObjectiveText4_loc1` text, - `ObjectiveText4_loc2` text, - `ObjectiveText4_loc3` text, - `ObjectiveText4_loc4` text, - `ObjectiveText4_loc5` text, - `ObjectiveText4_loc6` text, - `ObjectiveText4_loc7` text, - `ObjectiveText4_loc8` text, - `QuestGiverTextWindow_loc1` text, - `QuestGiverTextWindow_loc2` text, - `QuestGiverTextWindow_loc3` text, - `QuestGiverTextWindow_loc4` text, - `QuestGiverTextWindow_loc5` text, - `QuestGiverTextWindow_loc6` text, - `QuestGiverTextWindow_loc7` text, - `QuestGiverTextWindow_loc8` text, - `QuestGiverTargetName_loc1` text, - `QuestGiverTargetName_loc2` text, - `QuestGiverTargetName_loc3` text, - `QuestGiverTargetName_loc4` text, - `QuestGiverTargetName_loc5` text, - `QuestGiverTargetName_loc6` text, - `QuestGiverTargetName_loc7` text, - `QuestGiverTargetName_loc8` text, - `QuestTurnTextWindow_loc1` text, - `QuestTurnTextWindow_loc2` text, - `QuestTurnTextWindow_loc3` text, - `QuestTurnTextWindow_loc4` text, - `QuestTurnTextWindow_loc5` text, - `QuestTurnTextWindow_loc6` text, - `QuestTurnTextWindow_loc7` text, - `QuestTurnTextWindow_loc8` text, - `QuestTurnTargetName_loc1` text, - `QuestTurnTargetName_loc2` text, - `QuestTurnTargetName_loc3` text, - `QuestTurnTargetName_loc4` text, - `QuestTurnTargetName_loc5` text, - `QuestTurnTargetName_loc6` text, - `QuestTurnTargetName_loc7` text, - `QuestTurnTargetName_loc8` text, - `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- -- Table structure for table `mail_level_reward` -- @@ -1936,94 +1688,22 @@ DROP TABLE IF EXISTS `npc_text`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_text` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `text0_0` longtext, - `text0_1` longtext, - `BroadcastTextID0` mediumint(6) NOT NULL DEFAULT '0', - `lang0` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob0` float NOT NULL DEFAULT '0', - `em0_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em0_5` smallint(5) unsigned NOT NULL DEFAULT '0', - `text1_0` longtext, - `text1_1` longtext, - `BroadcastTextID1` mediumint(6) NOT NULL DEFAULT '0', - `lang1` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob1` float NOT NULL DEFAULT '0', - `em1_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em1_5` smallint(5) unsigned NOT NULL DEFAULT '0', - `text2_0` longtext, - `text2_1` longtext, - `BroadcastTextID2` mediumint(6) NOT NULL DEFAULT '0', - `lang2` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob2` float NOT NULL DEFAULT '0', - `em2_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em2_5` smallint(5) unsigned NOT NULL DEFAULT '0', - `text3_0` longtext, - `text3_1` longtext, - `BroadcastTextID3` mediumint(6) NOT NULL DEFAULT '0', - `lang3` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob3` float NOT NULL DEFAULT '0', - `em3_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em3_5` smallint(5) unsigned NOT NULL DEFAULT '0', - `text4_0` longtext, - `text4_1` longtext, - `BroadcastTextID4` mediumint(6) NOT NULL DEFAULT '0', - `lang4` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob4` float NOT NULL DEFAULT '0', - `em4_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em4_5` smallint(5) unsigned NOT NULL DEFAULT '0', - `text5_0` longtext, - `text5_1` longtext, - `BroadcastTextID5` mediumint(6) NOT NULL DEFAULT '0', - `lang5` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob5` float NOT NULL DEFAULT '0', - `em5_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em5_5` smallint(5) unsigned NOT NULL DEFAULT '0', - `text6_0` longtext, - `text6_1` longtext, - `BroadcastTextID6` mediumint(6) NOT NULL DEFAULT '0', - `lang6` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob6` float NOT NULL DEFAULT '0', - `em6_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em6_5` smallint(5) unsigned NOT NULL DEFAULT '0', - `text7_0` longtext, - `text7_1` longtext, - `BroadcastTextID7` mediumint(6) NOT NULL DEFAULT '0', - `lang7` tinyint(3) unsigned NOT NULL DEFAULT '0', - `prob7` float NOT NULL DEFAULT '0', - `em7_0` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_1` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_2` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_3` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_4` smallint(5) unsigned NOT NULL DEFAULT '0', - `em7_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `Probability0` float NOT NULL DEFAULT '0', + `Probability1` float NOT NULL DEFAULT '0', + `Probability2` float NOT NULL DEFAULT '0', + `Probability3` float NOT NULL DEFAULT '0', + `Probability4` float NOT NULL DEFAULT '0', + `Probability5` float NOT NULL DEFAULT '0', + `Probability6` float NOT NULL DEFAULT '0', + `Probability7` float NOT NULL DEFAULT '0', + `BroadcastTextID0` mediumint(6) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID1` mediumint(6) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID2` mediumint(6) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID3` mediumint(6) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID4` mediumint(6) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID5` mediumint(6) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID6` mediumint(6) unsigned NOT NULL DEFAULT '0', + `BroadcastTextID7` mediumint(6) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2100,6 +1780,22 @@ CREATE TABLE `page_text` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `page_text_locale` +-- + +DROP TABLE IF EXISTS `page_text_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `page_text_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Text` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `pet_levelstats` -- @@ -2138,35 +1834,17 @@ CREATE TABLE `pet_name_generation` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `phase_definitions` +-- Table structure for table `phase_area` -- -DROP TABLE IF EXISTS `phase_definitions`; +DROP TABLE IF EXISTS `phase_area`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `phase_definitions` ( - `zoneId` int(10) unsigned NOT NULL DEFAULT '0', - `entry` int(10) unsigned NOT NULL AUTO_INCREMENT, - `phaseId` int(10) unsigned NOT NULL DEFAULT '0', - `phaseGroup` int(10) NOT NULL DEFAULT '0', - `comment` text, - PRIMARY KEY (`zoneId`,`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Table structure for table `phase_info` --- - -DROP TABLE IF EXISTS `phase_info`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `phase_info` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `worldmapareaswap` int(10) unsigned NOT NULL DEFAULT '0', - `terrainswapmap` int(10) unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) DEFAULT NULL, - PRIMARY KEY (`id`) +CREATE TABLE `phase_area` ( + `AreaId` int(10) unsigned NOT NULL, + `PhaseId` int(10) unsigned NOT NULL, + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`AreaId`,`PhaseId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2423,6 +2101,22 @@ CREATE TABLE `points_of_interest` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `points_of_interest_locale` +-- + +DROP TABLE IF EXISTS `points_of_interest_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `points_of_interest_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `pool_creature` -- @@ -2588,6 +2282,24 @@ CREATE TABLE `quest_objectives` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `quest_objectives_locale` +-- + +DROP TABLE IF EXISTS `quest_objectives_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_objectives_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `QuestId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `StorageIndex` tinyint(3) NOT NULL DEFAULT '0', + `Description` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `quest_offer_reward` -- @@ -2618,16 +2330,23 @@ DROP TABLE IF EXISTS `quest_poi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_poi` ( - `questId` int(10) unsigned NOT NULL DEFAULT '0', - `id` int(10) unsigned NOT NULL DEFAULT '0', - `objIndex` int(11) NOT NULL DEFAULT '0', - `mapid` int(10) unsigned NOT NULL DEFAULT '0', - `WorldMapAreaId` int(10) unsigned NOT NULL DEFAULT '0', - `FloorId` int(10) unsigned NOT NULL DEFAULT '0', - `unk3` int(10) unsigned NOT NULL DEFAULT '0', - `unk4` int(10) unsigned NOT NULL DEFAULT '0', + `QuestID` int(11) NOT NULL DEFAULT '0', + `BlobIndex` int(11) NOT NULL DEFAULT '0', + `Idx1` int(11) NOT NULL DEFAULT '0', + `ObjectiveIndex` int(11) NOT NULL DEFAULT '0', + `QuestObjectiveID` int(11) NOT NULL DEFAULT '0', + `QuestObjectID` int(11) NOT NULL DEFAULT '0', + `MapID` int(11) NOT NULL DEFAULT '0', + `WorldMapAreaId` int(11) NOT NULL DEFAULT '0', + `Floor` int(11) NOT NULL DEFAULT '0', + `Priority` int(11) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `WorldEffectID` int(11) NOT NULL DEFAULT '0', + `PlayerConditionID` int(11) NOT NULL DEFAULT '0', + `WoDUnk1` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`questId`,`id`) + PRIMARY KEY (`QuestID`,`BlobIndex`,`Idx1`), + KEY `idx` (`QuestID`,`BlobIndex`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2639,14 +2358,14 @@ DROP TABLE IF EXISTS `quest_poi_points`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_poi_points` ( - `questId` int(10) unsigned NOT NULL DEFAULT '0', - `id` int(10) unsigned NOT NULL DEFAULT '0', - `idx` int(10) unsigned NOT NULL DEFAULT '0', - `x` int(11) NOT NULL DEFAULT '0', - `y` int(11) NOT NULL DEFAULT '0', + `QuestID` int(11) NOT NULL DEFAULT '0', + `Idx1` int(11) NOT NULL DEFAULT '0', + `Idx2` int(11) NOT NULL DEFAULT '0', + `X` int(11) NOT NULL DEFAULT '0', + `Y` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', - PRIMARY KEY (`questId`,`id`,`idx`), - KEY `questId_id` (`questId`,`id`) + PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`), + KEY `questId_id` (`QuestID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2687,10 +2406,10 @@ CREATE TABLE `quest_template` ( `SuggestedGroupNum` tinyint(3) unsigned NOT NULL DEFAULT '0', `RewardNextQuest` int(10) unsigned NOT NULL DEFAULT '0', `RewardXPDifficulty` int(10) unsigned NOT NULL DEFAULT '0', - `Float10` float NOT NULL DEFAULT '1', + `RewardXPMultiplier` float NOT NULL DEFAULT '1', `RewardMoney` int(11) NOT NULL DEFAULT '0', `RewardMoneyDifficulty` int(10) unsigned NOT NULL DEFAULT '0', - `Float13` float NOT NULL DEFAULT '1', + `RewardMoneyMultiplier` float NOT NULL DEFAULT '1', `RewardBonusMoney` int(10) unsigned NOT NULL DEFAULT '0', `RewardDisplaySpell` int(10) unsigned NOT NULL DEFAULT '0', `RewardSpell` int(10) unsigned NOT NULL DEFAULT '0', @@ -2817,6 +2536,30 @@ CREATE TABLE `quest_template_addon` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `quest_template_locale` +-- + +DROP TABLE IF EXISTS `quest_template_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_template_locale` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `LogTitle` text, + `LogDescription` text, + `QuestDescription` text, + `AreaDescription` text, + `PortraitGiverText` text, + `PortraitGiverName` text, + `PortraitTurnInText` text, + `PortraitTurnInName` text, + `QuestCompletionLog` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`,`locale`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `quest_visual_effect` -- @@ -2982,6 +2725,35 @@ CREATE TABLE `skill_fishing_base_level` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `skill_tiers` +-- + +DROP TABLE IF EXISTS `skill_tiers`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `skill_tiers` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Value1` int(10) unsigned NOT NULL DEFAULT '0', + `Value2` int(10) unsigned NOT NULL DEFAULT '0', + `Value3` int(10) unsigned NOT NULL DEFAULT '0', + `Value4` int(10) unsigned NOT NULL DEFAULT '0', + `Value5` int(10) unsigned NOT NULL DEFAULT '0', + `Value6` int(10) unsigned NOT NULL DEFAULT '0', + `Value7` int(10) unsigned NOT NULL DEFAULT '0', + `Value8` int(10) unsigned NOT NULL DEFAULT '0', + `Value9` int(10) unsigned NOT NULL DEFAULT '0', + `Value10` int(10) unsigned NOT NULL DEFAULT '0', + `Value11` int(10) unsigned NOT NULL DEFAULT '0', + `Value12` int(10) unsigned NOT NULL DEFAULT '0', + `Value13` int(10) unsigned NOT NULL DEFAULT '0', + `Value14` int(10) unsigned NOT NULL DEFAULT '0', + `Value15` int(10) unsigned NOT NULL DEFAULT '0', + `Value16` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `skinning_loot_template` -- @@ -3420,6 +3192,51 @@ CREATE TABLE `spelleffect_dbc` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `terrain_phase_info` +-- + +DROP TABLE IF EXISTS `terrain_phase_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `terrain_phase_info` ( + `Id` int(10) unsigned NOT NULL, + `TerrainSwapMap` int(10) unsigned NOT NULL, + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`Id`,`TerrainSwapMap`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `terrain_swap_defaults` +-- + +DROP TABLE IF EXISTS `terrain_swap_defaults`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `terrain_swap_defaults` ( + `MapId` int(10) unsigned NOT NULL, + `TerrainSwapMap` int(10) unsigned NOT NULL, + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`MapId`,`TerrainSwapMap`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `terrain_worldmap` +-- + +DROP TABLE IF EXISTS `terrain_worldmap`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `terrain_worldmap` ( + `TerrainSwapMap` int(10) unsigned NOT NULL, + `WorldMapArea` int(10) unsigned NOT NULL, + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`TerrainSwapMap`,`WorldMapArea`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `transports` -- @@ -3638,4 +3455,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2015-03-21 16:07:24 +-- Dump completed on 2015-07-13 23:52:04 |