diff options
author | Meji <alvaro.megias@outlook.com> | 2025-01-23 21:06:44 +0100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2025-01-23 21:06:44 +0100 |
commit | c9456ce8266b775208584244bd9893051f587e04 (patch) | |
tree | 2901e6a79e747f5f45f148e890855c7e46e96708 /sql | |
parent | ee5383615f7cf079e68781e8dfa3444f53c712cd (diff) |
Core/Spells: Added AttributesEx15 for serverside spells (#30632)
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2025_01_23_00_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_01_23_00_world.sql b/sql/updates/world/master/2025_01_23_00_world.sql new file mode 100644 index 00000000000..6728b966a65 --- /dev/null +++ b/sql/updates/world/master/2025_01_23_00_world.sql @@ -0,0 +1,14 @@ +DELIMITER ;; +CREATE PROCEDURE serverside_spell_2025_01_23_00() BEGIN + IF NOT EXISTS (SELECT * FROM `information_schema`.`columns` WHERE `table_schema`=SCHEMA() AND `table_name`='serverside_spell' AND `column_name`='AttributesEx15') THEN + + ALTER TABLE `serverside_spell` + ADD COLUMN `AttributesEx15` int unsigned NOT NULL DEFAULT '0' AFTER `AttributesEx14`; + + END IF; +END;; + +DELIMITER ; +CALL serverside_spell_2025_01_23_00(); + +DROP PROCEDURE IF EXISTS serverside_spell_2025_01_23_00; |