From 00ec890ca7e2aaf5fc1c8c48eefe2ac3b1327493 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 3 Sep 2018 09:47:48 +0200 Subject: misc/database-layout.dump, misc/database-layout.dmf: new table `versions` - not yet in FOREIGN KEYs --- misc/database-layout.dump | 22 +++++++++++++++++----- 1 file changed, 17 insertions(+), 5 deletions(-) (limited to 'misc/database-layout.dump') diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 61c78be..c8fedbb 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -675,10 +675,12 @@ dependencies CREATE TABLE `dependencies` ( `dependent` bigint(20) NOT NULL, `depending_on` bigint(20) NOT NULL, `dependency_type` smallint(6) NOT NULL, + `version` bigint(20) DEFAULT NULL, + `version_relation` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), - UNIQUE KEY `content` (`dependent`,`depending_on`,`dependency_type`), - KEY `depending_on` (`depending_on`), - KEY `dependency_type` (`dependency_type`), + UNIQUE KEY `content` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`), + KEY `dependencies_ibfk_2` (`depending_on`), + KEY `dependencies_ibfk_3` (`dependency_type`), 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 @@ -759,9 +761,10 @@ install_target_providers CREATE TABLE `install_target_providers` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `package` bigint(20) NOT NULL, `install_target` bigint(20) NOT NULL, + `version` bigint(20) NOT NULL, PRIMARY KEY (`id`), - UNIQUE KEY `content` (`package`,`install_target`), - KEY `install_target` (`install_target`), + UNIQUE KEY `content` (`package`,`install_target`,`version`), + KEY `install_target_providers_ibfk_2` (`install_target`), 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -912,6 +915,15 @@ upstream_repositories CREATE TABLE `upstream_repositories` ( KEY `git_repository` (`git_repository`), CONSTRAINT `upstream_repositories_ibfk_1` FOREIGN KEY (`git_repository`) REFERENCES `git_repositories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +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, + PRIMARY KEY (`id`), + UNIQUE KEY `content` (`epoch`,`version`), + KEY `order` (`order`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci INSERT INTO `architectures` VALUES (1,'any'), (2,'i686'); -- cgit v1.2.3-54-g00ecf