Core/Movement: Add new SplineChainMovementGenerator that allows accurate replication of sniffed waypoints in static sequences, along with DB facilities that allow loading of waypoints from DB.

1 files changed, 21 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/9999_99_99_99_world_SPLINECHAINS.sql b/sql/updates/world/3.3.5/9999_99_99_99_world_SPLINECHAINS.sql
new file mode 100644
index 00000000000..ae2caf249f9
--- /dev/null
+++ b/sql/updates/world/3.3.5/9999_99_99_99_world_SPLINECHAINS.sql
@@ -0,0 +1,21 @@
+-- add tables for spline chain DB storage
+DROP TABLE IF EXISTS `script_spline_chain_meta`;
+CREATE TABLE `script_spline_chain_meta` (
+	`entry` INT UNSIGNED NOT NULL,
+	`chainId` TINYINT UNSIGNED NOT NULL,
+	`splineId` TINYINT UNSIGNED NOT NULL,
+	`expectedDuration` INT UNSIGNED NOT NULL,
+	`msUntilNext` INT UNSIGNED NOT NULL,
+	PRIMARY KEY USING BTREE (`entry`,`chainId`,`splineId`)
+);
+DROP TABLE IF EXISTS `script_spline_chain_waypoints`;
+CREATE TABLE `script_spline_chain_waypoints` (
+	`entry` INT UNSIGNED NOT NULL,
+	`chainId` TINYINT UNSIGNED NOT NULL,
+	`splineId` TINYINT UNSIGNED NOT NULL,
+	`wpId` TINYINT UNSIGNED NOT NULL,
+	`x` FLOAT NOT NULL,
+	`y` FLOAT NOT NULL,
+	`z` FLOAT NOT NULL,
+	PRIMARY KEY USING BTREE (`entry`,`chainId`,`splineId`,`wpId`)
+);