From 31da896eb2ea9a18dae7c2fa45c188ebadfc9e3e Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 2 Nov 2023 20:05:29 +0100 Subject: Core/Spells: Prevent duplicating trait configs for Generic type --- sql/updates/characters/master/2023_11_02_00_characters.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/characters/master/2023_11_02_00_characters.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/master/2023_11_02_00_characters.sql b/sql/updates/characters/master/2023_11_02_00_characters.sql new file mode 100644 index 00000000000..1c06a0785a4 --- /dev/null +++ b/sql/updates/characters/master/2023_11_02_00_characters.sql @@ -0,0 +1 @@ +DELETE ctc, cte FROM `character_trait_config` ctc LEFT JOIN `character_trait_entry` cte ON ctc.`guid` = cte.`guid` AND ctc.`traitConfigId` = cte.`traitConfigId` WHERE ctc.`type` = 3; -- cgit v1.2.3