diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/master/2024_05_27_00_hotfixes.sql | 13 |
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; |