From e8f7d4153622aea70ac74fb73e134d51cdac821d Mon Sep 17 00:00:00 2001 From: ModoX Date: Tue, 2 Apr 2024 04:12:52 +0200 Subject: Core/Movement: Added Velocity field to waypoint_path table (#29837) --- sql/updates/world/master/2024_04_02_00_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/master/2024_04_02_00_world.sql (limited to 'sql') 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); -- cgit v1.2.3