Core/Player: initial work on implementing talents for Cataclysm

- use a new structure to hold talent group data which will eventually replace the old master branch implementation
- added support for unlocking dual talent specialization and switching specs
- added basic support for learning and resetting talents

2 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/characters/cata_classic/2024_07_27_00_characters.sql b/sql/updates/characters/cata_classic/2024_07_27_00_characters.sql
new file mode 100644
index 00000000000..3a01e0a7f8e
--- /dev/null
+++ b/sql/updates/characters/cata_classic/2024_07_27_00_characters.sql
@@ -0,0 +1,16 @@
+DROP TABLE IF EXISTS `character_talent`;
+CREATE TABLE `character_talent`  (
+  `guid` bigint UNSIGNED NOT NULL,
+  `talentGroup` tinyint UNSIGNED NOT NULL DEFAULT 0,
+  `talentId` int UNSIGNED NOT NULL,
+  `rank` tinyint UNSIGNED NOT NULL DEFAULT 0,
+  PRIMARY KEY (`guid`, `talentId`, `talentGroup`)
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
+
+DROP TABLE IF EXISTS `character_talent_group`;
+CREATE TABLE `character_talent_group`  (
+  `guid` bigint UNSIGNED NOT NULL DEFAULT 0,
+  `id` tinyint UNSIGNED NOT NULL DEFAULT 0,
+  `talentTabId` int UNSIGNED NOT NULL DEFAULT 0,
+  PRIMARY KEY (`guid`, `id`)
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
diff --git a/sql/updates/hotfixes/cata_classic/2024_07_27_00_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2024_07_27_00_hotfixes.sql
new file mode 100644
index 00000000000..270ff6af610
--- /dev/null
+++ b/sql/updates/hotfixes/cata_classic/2024_07_27_00_hotfixes.sql
@@ -0,0 +1,2 @@
+DROP TABLE IF EXISTS `specialization_spells`;
+DROP TABLE IF EXISTS `specialization_spells_locale`;