From 1c3268155d0165e150d239c3a808d5a8dddeae18 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 26 May 2024 22:29:57 +0200 Subject: Core/AreaTriggers: Implement height check for polygon db2 areatriggers --- sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) (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 index dae069efc75..de982063b1a 100644 --- a/sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql +++ b/sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql @@ -43,3 +43,16 @@ CREATE TABLE `path_node` ( `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `path_property` +-- +DROP TABLE IF EXISTS `path_property`; +CREATE TABLE `path_property` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PathID` smallint unsigned NOT NULL DEFAULT '0', + `PropertyIndex` tinyint unsigned NOT NULL DEFAULT '0', + `Value` 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