Core/AreaTriggers: Move SpellForVisuals override from AT spawn to properties (#29982)

1 files changed, 17 insertions, 0 deletions

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;