From 347b77151f56c0737f61bb75c1aeb044329ad9d0 Mon Sep 17 00:00:00 2001 From: Meji Date: Sun, 9 Apr 2023 18:32:27 +0200 Subject: DB/misc: Missing sql rename --- sql/updates/world/master/2023_04_09_02_world.sql | 13 +++++++++++++ sql/updates/world/master/9999_99_99_99_world.sql | 1 - 2 files changed, 13 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/master/2023_04_09_02_world.sql delete mode 100644 sql/updates/world/master/9999_99_99_99_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2023_04_09_02_world.sql b/sql/updates/world/master/2023_04_09_02_world.sql new file mode 100644 index 00000000000..088aaee95e7 --- /dev/null +++ b/sql/updates/world/master/2023_04_09_02_world.sql @@ -0,0 +1,13 @@ +DROP PROCEDURE IF EXISTS apply_if_exists_2023_04_09_02_world; + +DELIMITER ;; +CREATE PROCEDURE apply_if_exists_2023_04_09_02_world() BEGIN + IF EXISTS (SELECT * FROM `information_schema`.`columns` WHERE `table_schema`=SCHEMA() AND `table_name`='creature_template' AND `column_name`='HoverHeight') THEN + ALTER TABLE `creature_template` DROP COLUMN `HoverHeight`; + END IF; +END;; + +DELIMITER ; +CALL apply_if_exists_2023_04_09_02_world(); + +DROP PROCEDURE IF EXISTS apply_if_exists_2023_04_09_02_world; diff --git a/sql/updates/world/master/9999_99_99_99_world.sql b/sql/updates/world/master/9999_99_99_99_world.sql deleted file mode 100644 index f9ed254f65d..00000000000 --- a/sql/updates/world/master/9999_99_99_99_world.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `creature_template` DROP COLUMN `HoverHeight`; -- cgit v1.2.3