aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorGiacomo Pozzoni <giacomopoz@gmail.com>2020-09-19 23:33:29 +0200
committerShauren <shauren.trinity@gmail.com>2022-02-27 20:08:41 +0100
commita65b3493a7823ba543070c514d54f3c07c417bc1 (patch)
tree5c66df602c726f67fa446eef7a73b8fd3f1f68dd /sql/updates
parent60519e947f634f12aa93a1871d53e012ed9e57d2 (diff)
Core/SAI: Add orientation and delay columns to waypoints table (#25472)
* Core/SAI: Add orientation and delay columns to waypoints table * Rename 2020_99_99_99_world.sql to 2020_09_19_00_world.sql (cherry picked from commit 4b7d19c91bde2cabb8498809dee935c7efb2660a)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2022_02_27_05_world_2020_09_19_00_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_27_05_world_2020_09_19_00_world.sql b/sql/updates/world/master/2022_02_27_05_world_2020_09_19_00_world.sql
new file mode 100644
index 00000000000..30aadb03701
--- /dev/null
+++ b/sql/updates/world/master/2022_02_27_05_world_2020_09_19_00_world.sql
@@ -0,0 +1,2 @@
+--
+ALTER TABLE `waypoints` ADD COLUMN `orientation` FLOAT DEFAULT 0 NOT NULL AFTER `position_z`, ADD COLUMN `delay` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `orientation`;