Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump5
1 files changed, 4 insertions, 1 deletions
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,