From c562d0c13a0508437b815594763a07e8a848d7b1 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Wed, 15 Nov 2023 17:15:21 +0100 Subject: Core/DataStores: load TalentTab.db2 --- .../hotfixes/3.4.x/2023_11_15_01_hotfixes.sql | 65 ++++++++++++++++++++++ 1 file changed, 65 insertions(+) create mode 100644 sql/updates/hotfixes/3.4.x/2023_11_15_01_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/3.4.x/2023_11_15_01_hotfixes.sql b/sql/updates/hotfixes/3.4.x/2023_11_15_01_hotfixes.sql new file mode 100644 index 00000000000..777c4d6e86d --- /dev/null +++ b/sql/updates/hotfixes/3.4.x/2023_11_15_01_hotfixes.sql @@ -0,0 +1,65 @@ +-- +-- Table structure for table `talent_tab` +-- + +DROP TABLE IF EXISTS `talent_tab`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `talent_tab` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `BackgroundFile` text, + `OrderIndex` int(11) NOT NULL DEFAULT '0', + `RaceMask` int(11) NOT NULL DEFAULT '0', + `ClassMask` int(11) NOT NULL DEFAULT '0', + `PetTalentMask` int(11) NOT NULL DEFAULT '0', + `SpellIconID` int(11) 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 */; + +-- +-- Dumping data for table `talent_tab` +-- + +LOCK TABLES `talent_tab` WRITE; +/*!40000 ALTER TABLE `talent_tab` DISABLE KEYS */; +/*!40000 ALTER TABLE `talent_tab` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `talent_tab_locale` +-- + +DROP TABLE IF EXISTS `talent_tab_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `talent_tab_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_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, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `talent_tab_locale` +-- + +LOCK TABLES `talent_tab_locale` WRITE; +/*!40000 ALTER TABLE `talent_tab_locale` DISABLE KEYS */; +/*!40000 ALTER TABLE `talent_tab_locale` ENABLE KEYS */; +UNLOCK TABLES; -- cgit v1.2.3