From d1ffe61727f53505a3e2b94cae32f2ce3d28b07b Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 10 Aug 2024 12:01:47 +0200 Subject: Core/Players: Implemented hero talents --- .../hotfixes/master/2024_08_10_00_hotfixes.sql | 37 ++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 sql/updates/hotfixes/master/2024_08_10_00_hotfixes.sql (limited to 'sql/updates') diff --git a/sql/updates/hotfixes/master/2024_08_10_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_08_10_00_hotfixes.sql new file mode 100644 index 00000000000..297325106f0 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_08_10_00_hotfixes.sql @@ -0,0 +1,37 @@ +-- +-- Table structure for table `trait_sub_tree` +-- +DROP TABLE IF EXISTS `trait_sub_tree`; +CREATE TABLE `trait_sub_tree` ( + `Name` text, + `Description` text, + `ID` int unsigned NOT NULL DEFAULT '0', + `UiTextureAtlasElementID` int NOT NULL DEFAULT '0', + `TraitTreeID` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `trait_sub_tree_locale` +-- +DROP TABLE IF EXISTS `trait_sub_tree_locale`; +CREATE TABLE `trait_sub_tree_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `Description_lang` text, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +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); -- cgit v1.2.3