Core/Players: Use CharBaseInfo.db2 data to determine appropriate race for mercenary mode transforms

1 files changed, 12 insertions, 0 deletions

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;