From 336b9090a03cbc6df2bab12da70b4f7b19064132 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 24 Feb 2020 11:44:02 +0100 Subject: misc/database-layout: new column `binary_packages`.`signing_key` referencing `gpg_keys`.`id` --- misc/database-layout.dump | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'misc/database-layout.dump') diff --git a/misc/database-layout.dump b/misc/database-layout.dump index afbd087..be12666 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -504,6 +504,7 @@ binary_packages CREATE TABLE `binary_packages` ( `sha512sum` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sub_pkgrel_omitted` bit(1) NOT NULL DEFAULT b'0', `compression` smallint(6) DEFAULT NULL, + `signing_key` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `file_name` (`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`,`sub_pkgrel_omitted`), UNIQUE KEY `content` (`build_assignment`,`sub_pkgrel`,`pkgname`,`architecture`,`sub_pkgrel_omitted`), @@ -512,9 +513,11 @@ binary_packages CREATE TABLE `binary_packages` ( KEY `pkgver` (`pkgver`), KEY `pkgname` (`pkgname`), KEY `compression` (`compression`), + KEY `signing_key` (`signing_key`), CONSTRAINT `binary_packages_ibfk_1` FOREIGN KEY (`architecture`) REFERENCES `architectures` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `binary_packages_ibfk_2` FOREIGN KEY (`build_assignment`) REFERENCES `build_assignments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `binary_packages_ibfk_3` FOREIGN KEY (`compression`) REFERENCES `compressions` (`id`) ON DELETE SET NULL + CONSTRAINT `binary_packages_ibfk_3` FOREIGN KEY (`compression`) REFERENCES `compressions` (`id`) ON DELETE SET NULL, + CONSTRAINT `binary_packages_ibfk_4` FOREIGN KEY (`signing_key`) REFERENCES `gpg_keys` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci binary_packages_in_repositories CREATE TABLE `binary_packages_in_repositories` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, -- cgit v1.2.3-54-g00ecf