aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-05-26 22:29:57 +0200
committerShauren <shauren.trinity@gmail.com>2024-05-27 18:53:47 +0200
commit1c3268155d0165e150d239c3a808d5a8dddeae18 (patch)
tree764d238d71e7349d6001edd21dec25cefaf7d4a6 /sql
parentb070e63fa867f7f25e73e9ef3aafbe18902a50e9 (diff)
Core/AreaTriggers: Implement height check for polygon db2 areatriggers
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql13
1 files changed, 13 insertions, 0 deletions
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;