Core/Movement: Added Velocity field to waypoint_path table (#29837)

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_04_02_00_world.sql b/sql/updates/world/master/2024_04_02_00_world.sql
new file mode 100644
index 00000000000..a40494c0ea4
--- /dev/null
+++ b/sql/updates/world/master/2024_04_02_00_world.sql
@@ -0,0 +1,17 @@
+DELIMITER ;;
+CREATE PROCEDURE waypoint_path_velocity_2024_04_02_00() BEGIN
+    IF NOT EXISTS (SELECT * FROM `information_schema`.`columns` WHERE `table_schema`=SCHEMA() AND `table_name`='waypoint_path' AND `column_name`='Velocity') THEN
+
+    ALTER TABLE `waypoint_path` 
+       ADD COLUMN `Velocity` float NULL DEFAULT NULL AFTER `Flags`;
+
+    END IF;
+END;;
+
+DELIMITER ;
+CALL waypoint_path_velocity_2024_04_02_00();
+
+DROP PROCEDURE IF EXISTS waypoint_path_velocity_2024_04_02_00;
+
+UPDATE `waypoint_path` SET `Velocity`=4.0 WHERE `PathId`=9301100;
+UPDATE `waypoint_path` SET `Velocity`=35.0 WHERE `PathId` IN(11432300, 11432301, 11432302, 11432303, 11432304);