misc/database-layout.dump: foreign keys referencing `versions`

1 files changed, 7 insertions, 3 deletions

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index c8fedbb..7a2f775 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -681,9 +681,11 @@ dependencies	CREATE TABLE `dependencies` (
 	 UNIQUE KEY `content` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`),
 	 KEY `dependencies_ibfk_2` (`depending_on`),
 	 KEY `dependencies_ibfk_3` (`dependency_type`),
+	 KEY `version` (`version`),
 	 CONSTRAINT `dependencies_ibfk_1` FOREIGN KEY (`dependent`) REFERENCES `binary_packages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
 	 CONSTRAINT `dependencies_ibfk_2` FOREIGN KEY (`depending_on`) REFERENCES `install_targets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-	 CONSTRAINT `dependencies_ibfk_3` FOREIGN KEY (`dependency_type`) REFERENCES `dependency_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+	 CONSTRAINT `dependencies_ibfk_3` FOREIGN KEY (`dependency_type`) REFERENCES `dependency_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+	 CONSTRAINT `dependencies_ibfk_4` FOREIGN KEY (`version`) REFERENCES `versions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 dependency_types	CREATE TABLE `dependency_types` (
 	 `id` smallint(6) NOT NULL AUTO_INCREMENT,
@@ -765,8 +767,10 @@ install_target_providers	CREATE TABLE `install_target_providers` (
 	 PRIMARY KEY (`id`),
 	 UNIQUE KEY `content` (`package`,`install_target`,`version`),
 	 KEY `install_target_providers_ibfk_2` (`install_target`),
+	 KEY `version` (`version`),
 	 CONSTRAINT `install_target_providers_ibfk_1` FOREIGN KEY (`package`) REFERENCES `binary_packages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-	 CONSTRAINT `install_target_providers_ibfk_2` FOREIGN KEY (`install_target`) REFERENCES `install_targets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+	 CONSTRAINT `install_target_providers_ibfk_2` FOREIGN KEY (`install_target`) REFERENCES `install_targets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+	 CONSTRAINT `install_target_providers_ibfk_3` FOREIGN KEY (`version`) REFERENCES `versions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
 install_targets	CREATE TABLE `install_targets` (
 	 `id` bigint(20) NOT NULL AUTO_INCREMENT,
@@ -919,7 +923,7 @@ versions	CREATE TABLE `versions` (
 	 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 	 `order` bigint(20) DEFAULT NULL,
 	 `epoch` mediumint(9) NOT NULL,
-	 `version` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+	 `version` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
 	 PRIMARY KEY (`id`),
 	 UNIQUE KEY `content` (`epoch`,`version`),
 	 KEY `order` (`order`)