From 3262bc827dbce8d659c249e23cd585b4c86f00b3 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Sun, 14 Jul 2019 15:21:32 +0200
Subject: Core/DataStores: Updated db2 structures to 8.2

---
 .../hotfixes/master/2019_07_14_00_hotfixes.sql     | 74 ++++++++++++++++++++++
 1 file changed, 74 insertions(+)
 create mode 100644 sql/updates/hotfixes/master/2019_07_14_00_hotfixes.sql

(limited to 'sql')

diff --git a/sql/updates/hotfixes/master/2019_07_14_00_hotfixes.sql b/sql/updates/hotfixes/master/2019_07_14_00_hotfixes.sql
new file mode 100644
index 00000000000..ac39fc76248
--- /dev/null
+++ b/sql/updates/hotfixes/master/2019_07_14_00_hotfixes.sql
@@ -0,0 +1,74 @@
+--
+-- Table structure for table `cfg_regions`
+--
+ALTER TABLE `cfg_regions`
+  DROP `ChallengeTimeOffset1`,
+  DROP `ChallengeTimeOffset2`;
+
+--
+-- Table structure for table `content_tuning`
+--
+ALTER TABLE `content_tuning`
+  ADD `ExpansionID` int(11) NOT NULL DEFAULT '0' AFTER `Flags`,
+  DROP `ExpectedStatModID`,
+  DROP `DifficultyESMID`;
+
+--
+-- Table structure for table `content_tuning_x_expected`
+--
+DROP TABLE IF EXISTS `content_tuning_x_expected`;
+CREATE TABLE `content_tuning_x_expected` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ExpectedStatModID` int(11) NOT NULL DEFAULT '0',
+  `ContentTuningID` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `creature_model_data`
+--
+ALTER TABLE `creature_model_data`
+  ADD `Unknown820_1` tinyint(4) NOT NULL DEFAULT '0' AFTER `TamedPetBaseScale`,
+  ADD `Unknown820_2` float NOT NULL DEFAULT '0' AFTER `Unknown820_1`,
+  ADD `Unknown820_31` float NOT NULL DEFAULT '0' AFTER `Unknown820_2`,
+  ADD `Unknown820_32` float NOT NULL DEFAULT '0' AFTER `Unknown820_31`;
+
+--
+-- Table structure for table `garr_follower`
+--
+ALTER TABLE `garr_follower` MODIFY `HordeGarrClassSpecID` int(11) NOT NULL DEFAULT '0' AFTER `AllianceGarrFollRaceID`;
+ALTER TABLE `garr_follower` MODIFY `AllianceGarrClassSpecID` int(11) NOT NULL DEFAULT '0' AFTER `HordeGarrClassSpecID`;
+
+--
+-- Table structure for table `glyph_properties`
+--
+ALTER TABLE `glyph_properties` ADD `SpellIconFileDataID` int(11) NOT NULL DEFAULT '0' AFTER `GlyphExclusiveCategoryID`;
+ALTER TABLE `glyph_properties` DROP `SpellIconID`;
+
+--
+-- Table structure for table `modifier_tree`
+--
+ALTER TABLE `modifier_tree` MODIFY `Type` int(11) NOT NULL DEFAULT '0' AFTER `Amount`;
+
+--
+-- Table structure for table `mount_capability`
+--
+ALTER TABLE `mount_capability` ADD `PlayerConditionID` int(11) NOT NULL DEFAULT '0' AFTER `ReqMapID`;
+
+--
+-- Table structure for table `rand_prop_points`
+--
+ALTER TABLE `rand_prop_points` ADD `DamageSecondary` int(11) NOT NULL DEFAULT '0' AFTER `DamageReplaceStat`;
+
+--
+-- Table structure for table `spell_misc`
+--
+ALTER TABLE `spell_misc` ADD `ContentTuningID` int(11) NOT NULL DEFAULT '0' AFTER `ActiveIconFileDataID`;
+
+--
+-- Table structure for table `ui_map_link`
+--
+ALTER TABLE `ui_map_link`
+  ADD `OverrideHighlightFileDataID` int(11) NOT NULL DEFAULT '0' AFTER `ChildUiMapID`,
+  ADD `OverrideHighlightAtlasID` int(11) NOT NULL DEFAULT '0' AFTER `OverrideHighlightFileDataID`;
-- 
cgit v1.2.3