aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorOvah <dreadkiller@gmx.de>2022-04-16 18:21:04 +0200
committerGitHub <noreply@github.com>2022-04-16 18:21:04 +0200
commit4747515872775553de35cc3267e1ccd5e0076ca4 (patch)
tree1e69388797223e9322f8912bc8ebe0772fdd9160 /sql
parentc0a120669dafe0688e6b7fc1e487e3dfd6220087 (diff)
Core/Movement: Allow waypoints to use 0 as valid facing value (#26655)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2022_04_16_00_world.sql5
1 files changed, 5 insertions, 0 deletions
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;