From b070e63fa867f7f25e73e9ef3aafbe18902a50e9 Mon Sep 17 00:00:00 2001 From: Meji Date: Sat, 4 May 2024 13:20:13 +0200 Subject: Core/AreaTriggers: Fix triggering of client areatriggers for some shapes --- .../hotfixes/master/2024_05_27_00_hotfixes.sql | 45 ++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql new file mode 100644 index 00000000000..dae069efc75 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql @@ -0,0 +1,45 @@ +-- +-- Table structure for table `location` +-- +DROP TABLE IF EXISTS `location`; +CREATE TABLE `location` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PosX` float NOT NULL DEFAULT '0', + `PosY` float NOT NULL DEFAULT '0', + `PosZ` float NOT NULL DEFAULT '0', + `Rot1` float NOT NULL DEFAULT '0', + `Rot2` float NOT NULL DEFAULT '0', + `Rot3` float NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `path` +-- +DROP TABLE IF EXISTS `path`; +CREATE TABLE `path` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Type` tinyint unsigned NOT NULL DEFAULT '0', + `SplineType` tinyint unsigned NOT NULL DEFAULT '0', + `Red` tinyint unsigned NOT NULL DEFAULT '0', + `Green` tinyint unsigned NOT NULL DEFAULT '0', + `Blue` tinyint unsigned NOT NULL DEFAULT '0', + `Alpha` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `path_node` +-- +DROP TABLE IF EXISTS `path_node`; +CREATE TABLE `path_node` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PathID` smallint unsigned NOT NULL DEFAULT '0', + `Sequence` smallint NOT NULL DEFAULT '0', + `LocationID` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- cgit v1.2.3