From c2ac37125b566cb4d9b659bc8ae2d381f60bc6db Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 28 Mar 2024 21:11:59 +0100 Subject: Core/Players: Use CharBaseInfo.db2 data to determine appropriate race for mercenary mode transforms --- sql/updates/hotfixes/master/2024_03_28_00_hotfixes.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/hotfixes/master/2024_03_28_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2024_03_28_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_03_28_00_hotfixes.sql new file mode 100644 index 00000000000..e0e8a296116 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_03_28_00_hotfixes.sql @@ -0,0 +1,12 @@ +-- +-- Table structure for table `char_base_info` +-- +DROP TABLE IF EXISTS `char_base_info`; +CREATE TABLE `char_base_info` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `RaceID` tinyint NOT NULL DEFAULT '0', + `ClassID` tinyint NOT NULL DEFAULT '0', + `OtherFactionRaceID` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- cgit v1.2.3