From 6d00d3f28380dd0811a18913450b1dc4f07fef48 Mon Sep 17 00:00:00 2001 From: treeston Date: Wed, 14 Sep 2016 23:53:37 +0200 Subject: 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. --- .../3.3.5/9999_99_99_99_world_SPLINECHAINS.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/3.3.5/9999_99_99_99_world_SPLINECHAINS.sql (limited to 'sql') 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`) +); -- cgit v1.2.3