From 4747515872775553de35cc3267e1ccd5e0076ca4 Mon Sep 17 00:00:00 2001 From: Ovah Date: Sat, 16 Apr 2022 18:21:04 +0200 Subject: Core/Movement: Allow waypoints to use 0 as valid facing value (#26655) --- sql/updates/world/3.3.5/2022_04_16_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/3.3.5/2022_04_16_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2022_04_16_00_world.sql b/sql/updates/world/3.3.5/2022_04_16_00_world.sql new file mode 100644 index 00000000000..6330c80461d --- /dev/null +++ b/sql/updates/world/3.3.5/2022_04_16_00_world.sql @@ -0,0 +1,5 @@ +ALTER TABLE `waypoint_data` CHANGE `orientation` `orientation` FLOAT DEFAULT NULL NULL; +UPDATE `waypoint_data` SET `orientation`= NULL WHERE `orientation`= 0; + +ALTER TABLE `waypoints` CHANGE `orientation` `orientation` FLOAT DEFAULT NULL NULL; +UPDATE `waypoints` SET `orientation`= NULL WHERE `orientation`= 0; -- cgit v1.2.3