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.dump14
1 files changed, 14 insertions, 0 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 0cd7493..e4afcba 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -333,6 +333,16 @@ allowed_email_actions CREATE TABLE `allowed_email_actions` (
CONSTRAINT `allowed_email_actions_ibfk_1` FOREIGN KEY (`action`) REFERENCES `email_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `allowed_email_actions_ibfk_2` FOREIGN KEY (`gpg_key`) REFERENCES `gpg_keys` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+architecture_compatibilities CREATE TABLE `architecture_compatibilities` (
+ `id` mediumint(9) NOT NULL AUTO_INCREMENT,
+ `built_for` smallint(6) NOT NULL,
+ `runs_on` smallint(6) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `content` (`built_for`,`runs_on`),
+ KEY `architecture_compatibilities_ibfk_2` (`runs_on`),
+ CONSTRAINT `architecture_compatibilities_ibfk_1` FOREIGN KEY (`built_for`) REFERENCES `architectures` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+ CONSTRAINT `architecture_compatibilities_ibfk_2` FOREIGN KEY (`runs_on`) REFERENCES `architectures` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
architectures CREATE TABLE `architectures` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
@@ -638,6 +648,10 @@ upstream_repositories CREATE TABLE `upstream_repositories` (
INSERT INTO `architectures` VALUES
(1,'any'),
(2,'i686');
+INSERT INTO `architecture_compatibilities` VALUES
+ (1,1,1),
+ (3,1,2),
+ (2,2,2);
INSERT INTO `dependency_types` VALUES
(2,'run','1','1'),
(3,'check','\0','\0'),