From 8aa917a3e45b006c16cbe58cf6323d400417a687 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Sun, 19 Nov 2023 17:53:01 +0100 Subject: Core/Players: restore secondary talent specialization support and implement SPELL_EFFECT_TALENT_SPEC_COUNT --- sql/updates/characters/3.4.x/2023_11_19_00_characters.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/characters/3.4.x/2023_11_19_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/3.4.x/2023_11_19_00_characters.sql b/sql/updates/characters/3.4.x/2023_11_19_00_characters.sql new file mode 100644 index 00000000000..c20683eff7f --- /dev/null +++ b/sql/updates/characters/3.4.x/2023_11_19_00_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `characters_10x`.`characters` + DROP COLUMN `activeTalentGroup`, + CHANGE `primarySpecialization` `activeTalentGroup` TINYINT UNSIGNED DEFAULT 0 NOT NULL, + ADD COLUMN `bonusTalentGroups` TINYINT UNSIGNED DEFAULT 0 NOT NULL AFTER `activeTalentGroup`; -- cgit v1.2.3