diff options
| -rw-r--r-- | sql/updates/world/master/2023_04_09_02_world.sql | 13 | ||||
| -rw-r--r-- | sql/updates/world/master/9999_99_99_99_world.sql | 1 |
2 files changed, 13 insertions, 1 deletions
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`; |