From ec95f600da094af1ea02231045c38e9d46f4f2f8 Mon Sep 17 00:00:00 2001 From: Meji Date: Sat, 18 May 2024 08:56:26 +0200 Subject: Core/AreaTriggers: Move SpellForVisuals override from AT spawn to properties (#29982) (cherry picked from commit 2ad7c7829b17bb9e6e951632e8e0e68f68b9aa44) # Conflicts: # src/server/game/Entities/AreaTrigger/AreaTrigger.cpp --- sql/updates/world/master/2024_05_18_01_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/master/2024_05_18_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2024_05_18_01_world.sql b/sql/updates/world/master/2024_05_18_01_world.sql new file mode 100644 index 00000000000..726c4bcbbb8 --- /dev/null +++ b/sql/updates/world/master/2024_05_18_01_world.sql @@ -0,0 +1,17 @@ +DELIMITER ;; +CREATE PROCEDURE 2024_05_18_01_areatrigger_spellvisual() BEGIN + IF NOT EXISTS (SELECT * FROM `information_schema`.`columns` WHERE `table_schema`=SCHEMA() AND `table_name`='areatrigger_create_properties' AND `column_name`='SpellsForVisuals') THEN + + ALTER TABLE `areatrigger` + DROP COLUMN `SpellForVisuals`; + + ALTER TABLE `areatrigger_create_properties` + ADD COLUMN `SpellForVisuals` INT AFTER `DecalPropertiesId`; + + END IF; +END;; + +DELIMITER ; +CALL 2024_05_18_01_areatrigger_spellvisual(); + +DROP PROCEDURE IF EXISTS 2024_05_18_01_areatrigger_spellvisual; -- cgit v1.2.3