diff options
| author | Shauren <shauren.trinity@gmail.com> | 2024-05-26 22:29:57 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-06-20 01:07:34 +0200 |
| commit | 0608cf31c22c5ba88db539076e95d0220d1a9706 (patch) | |
| tree | cfd5273c034450db8a9e7ff20fbbb7cb303cdb08 /sql | |
| parent | 889abca362de2949ab2fbda28741f8275e6f173b (diff) | |
Core/AreaTriggers: Implement height check for polygon db2 areatriggers
(cherry picked from commit 1c3268155d0165e150d239c3a808d5a8dddeae18)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/cata_classic/2024_06_20_00_hotfixes_2024_05_27_00_hotfixes.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/cata_classic/2024_06_20_00_hotfixes_2024_05_27_00_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2024_06_20_00_hotfixes_2024_05_27_00_hotfixes.sql index dae069efc75..de982063b1a 100644 --- a/sql/updates/hotfixes/cata_classic/2024_06_20_00_hotfixes_2024_05_27_00_hotfixes.sql +++ b/sql/updates/hotfixes/cata_classic/2024_06_20_00_hotfixes_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; |
