Core/AdventureJournal: Fix broken hotfix database structure from 3addbe7dd418259149c39fc3b9423f7809de696a

1 files changed, 24 insertions, 24 deletions

diff --git a/sql/updates/hotfixes/master/2021_03_14_00_hotfixes.sql b/sql/updates/hotfixes/master/2021_03_14_00_hotfixes.sql
index 7dfb91bbe06..1bf231c7ea5 100644
--- a/sql/updates/hotfixes/master/2021_03_14_00_hotfixes.sql
+++ b/sql/updates/hotfixes/master/2021_03_14_00_hotfixes.sql
@@ -6,32 +6,32 @@ DROP TABLE IF EXISTS `adventure_journal`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `adventure_journal` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
-  `Name` text DEFAULT NULL,
-  `Description` text DEFAULT NULL,
-  `ButtonText` text DEFAULT NULL,
-  `RewardDescription` text DEFAULT NULL,
-  `ContinueDescription` text DEFAULT NULL,
+  `Name` text,
+  `Description` text,
+  `ButtonText` text,
+  `RewardDescription` text,
+  `ContinueDescription` text,
   `Type` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `PlayerConditionId` int(10) unsigned NOT NULL DEFAULT '0',
+  `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
   `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `ButtonActionType` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `TextureFileDataId` int(11) NOT NULL DEFAULT '0',
-  `LfgDungeonId` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `QuestId` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `BattleMasterListId` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `TextureFileDataID` int(11) NOT NULL DEFAULT '0',
+  `LfgDungeonID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `QuestID` int(11) NOT NULL DEFAULT '0',
+  `BattleMasterListID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `PriorityMin` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `PriorityMax` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `ItemId` int(11) NOT NULL DEFAULT '0',
+  `ItemID` int(11) NOT NULL DEFAULT '0',
   `ItemQuantity` int(10) unsigned NOT NULL DEFAULT '0',
   `CurrencyType` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `CurrencyQuantity` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `UiMapId` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `BonusPlayerConditionId1` int(11) NOT NULL DEFAULT '0',
-  `BonusPlayerConditionId2` int(11) NOT NULL DEFAULT '0',
+  `CurrencyQuantity` int(10) unsigned NOT NULL DEFAULT '0',
+  `UiMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `BonusPlayerConditionID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `BonusPlayerConditionID2` int(10) unsigned NOT NULL DEFAULT '0',
   `BonusValue1` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `BonusValue2` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`ID`)
+  `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -44,13 +44,13 @@ DROP TABLE IF EXISTS `adventure_journal_locale`;
 CREATE TABLE `adventure_journal_locale` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
   `locale` varchar(4) NOT NULL,
-  `Name_lang` text DEFAULT NULL,
-  `Description_lang` text DEFAULT NULL,
-  `ButtonText_lang` text DEFAULT NULL,
-  `RewardDescription_lang` text DEFAULT NULL,
-  `ContinueDescription_lang` text DEFAULT NULL,
-  `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`ID`,`locale`)
+  `Name_lang` text,
+  `Description_lang` text,
+  `ButtonText_lang` text,
+  `RewardDescription_lang` text,
+  `ContinueDescription_lang` text,
+  `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 /*!50500 PARTITION BY LIST  COLUMNS(locale)
 (PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,