From dd8de0e6238cb9ab6f48d727b4646d163e0ec961 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 7 Jun 2018 16:00:30 +0200 Subject: new table `architecture_compatibilities` --- misc/database-layout.dump | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'misc/database-layout.dump') 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'), -- cgit v1.2.3-54-g00ecf