diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/9999_99_99_99_world_SPLINECHAINS.sql | 21 |
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`) +); |