DB/misc: Missing sql rename

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`;