aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2021-03-14 13:07:29 +0100
committerShauren <shauren.trinity@gmail.com>2021-03-14 13:07:29 +0100
commitd0246e5835ea184b22896e6b354fb28c28890810 (patch)
tree9631475374982307816ab5da5637168ef4975913 /sql
parentc15cf8b424be0cf60150fbc7ddaf4574f78d72fd (diff)
Core/AdventureJournal: Check if player can access adventure journal with ChrClassUIDisplay.db2
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/hotfixes/master/2021_03_14_01_hotfixes.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2021_03_14_01_hotfixes.sql b/sql/updates/hotfixes/master/2021_03_14_01_hotfixes.sql
new file mode 100644
index 00000000000..78636252fd6
--- /dev/null
+++ b/sql/updates/hotfixes/master/2021_03_14_01_hotfixes.sql
@@ -0,0 +1,15 @@
+--
+-- Table structure for table `chr_class_ui_display`
+--
+DROP TABLE IF EXISTS `chr_class_ui_display`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `chr_class_ui_display` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `ChrClassesID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `AdvGuidePlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
+ `SplashPlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
+ `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 */;