Core/DataStores: Updated dbc/db2 to 7.0.1.20994

1 files changed, 280 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_03.sql b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_03.sql
new file mode 100644
index 00000000000..959b3275e9d
--- /dev/null
+++ b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_03.sql
@@ -0,0 +1,280 @@
+--
+-- Table structure for table `area_table`
+--
+DROP TABLE IF EXISTS `area_table`;
+CREATE TABLE `area_table` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags1` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags2` int(10) unsigned NOT NULL DEFAULT '0',
+  `ZoneName` text,
+  `AmbientMultiplier` float NOT NULL DEFAULT '0',
+  `AreaName` text,
+  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `ParentAreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `AreaBit` smallint(6) NOT NULL DEFAULT '0',
+  `AmbienceID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `ZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `IntroSound` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `LiquidTypeID1` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `LiquidTypeID2` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `LiquidTypeID3` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `LiquidTypeID4` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `UWZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `UWAmbience` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `PvPCombastWorldStateID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `SoundProviderPref` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `SoundProviderPrefUnderwater` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ExplorationLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `FactionGroupMask` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `MountFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `UWIntroMusic` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `WildBattlePetLevelMin` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `WildBattlePetLevelMax` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `WindSettingsID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `area_table_locale`
+--
+DROP TABLE IF EXISTS `area_table_locale`;
+CREATE TABLE `area_table_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `AreaName_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `area_trigger`
+--
+DROP TABLE IF EXISTS `area_trigger`;
+CREATE TABLE `area_trigger` (
+  `ID` 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',
+  `Radius` float NOT NULL DEFAULT '0',
+  `BoxLength` float NOT NULL DEFAULT '0',
+  `BoxWidth` float NOT NULL DEFAULT '0',
+  `BoxHeight` float NOT NULL DEFAULT '0',
+  `BoxYaw` float NOT NULL DEFAULT '0',
+  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `PhaseID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `PhaseGroupID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `ShapeID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `AreaTriggerActionSetID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ShapeType` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `char_titles`
+--
+DROP TABLE IF EXISTS `char_titles`;
+CREATE TABLE `char_titles` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `NameMale` text,
+  `NameFemale` text,
+  `ConditionID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `MaskID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `char_titles_locale`
+--
+DROP TABLE IF EXISTS `char_titles_locale`;
+CREATE TABLE `char_titles_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `NameMale_lang` text,
+  `NameFemale_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `creature_family`
+--
+DROP TABLE IF EXISTS `creature_family`;
+CREATE TABLE `creature_family` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `MinScale` float NOT NULL DEFAULT '0',
+  `MaxScale` float NOT NULL DEFAULT '0',
+  `Name` text,
+  `IconFile` text,
+  `SkillLine1` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `SkillLine2` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `PetFoodMask` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `MinScaleLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `MaxScaleLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `PetTalentType` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `CategoryEnumID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `creature_family_locale`
+--
+DROP TABLE IF EXISTS `creature_family_locale`;
+CREATE TABLE `creature_family_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `difficulty`
+--
+DROP TABLE IF EXISTS `difficulty`;
+CREATE TABLE `difficulty` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `FallbackDifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `InstanceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `MinPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `MaxPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `OldEnumValue` tinyint(4) NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ToggleDifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GroupSizeHealthCurveID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GroupSizeDmgCurveID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GroupSizeSpellPointsCurveID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ItemBonusTreeModID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `difficulty_locale`
+--
+DROP TABLE IF EXISTS `difficulty_locale`;
+CREATE TABLE `difficulty_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `dungeon_encounter`
+--
+DROP TABLE IF EXISTS `dungeon_encounter`;
+CREATE TABLE `dungeon_encounter` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `CreatureDisplayID` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `OrderIndex` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `SpellIconID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Bit` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `dungeon_encounter_locale`
+--
+DROP TABLE IF EXISTS `dungeon_encounter_locale`;
+CREATE TABLE `dungeon_encounter_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `emotes_text`
+--
+DROP TABLE IF EXISTS `emotes_text`;
+CREATE TABLE `emotes_text` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text,
+  `EmoteID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `emotes_text_locale`
+--
+DROP TABLE IF EXISTS `emotes_text_locale`;
+CREATE TABLE `emotes_text_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `Name_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `map`
+--
+DROP TABLE IF EXISTS `map`;
+CREATE TABLE `map` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Directory` text,
+  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapType` int(10) unsigned NOT NULL DEFAULT '0',
+  `MinimapIconScale` float NOT NULL DEFAULT '0',
+  `CorpsePosX` float NOT NULL DEFAULT '0',
+  `CorpsePosY` float NOT NULL DEFAULT '0',
+  `RaidOffset` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapName` text,
+  `MapDescription0` text,
+  `MapDescription1` text,
+  `AreaTableID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `LoadingScreenID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `CorpseMapID` smallint(6) NOT NULL DEFAULT '0',
+  `TimeOfDayOverride` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `ParentMapID` smallint(6) NOT NULL DEFAULT '0',
+  `CosmeticParentMapID` smallint(6) NOT NULL DEFAULT '0',
+  `InstanceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `unk5` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ExpansionID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `MaxPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `TimeOffset` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `map_locale`
+--
+DROP TABLE IF EXISTS `map_locale`;
+CREATE TABLE `map_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) NOT NULL,
+  `MapName_lang` text,
+  `MapDescription0_lang` text,
+  `MapDescription1_lang` text,
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `phase`
+--
+DROP TABLE IF EXISTS `phase`;
+CREATE TABLE `phase` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;