From a3cfcc18ebd248e9f2f16cd0d5166da5de222d3d Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 3 May 2018 13:57:00 +0200 Subject: misc/database-layout.dump: new column in database: `repositories`.`architecture` --- 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 8ff5049..620326c 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -492,10 +492,13 @@ repositories CREATE TABLE `repositories` ( `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `stability` mediumint(9) NOT NULL, `is_on_master_mirror` bit(1) NOT NULL, + `architecture` smallint(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `stability` (`stability`), - CONSTRAINT `repositories_ibfk_1` FOREIGN KEY (`stability`) REFERENCES `repository_stabilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE + KEY `architecture` (`architecture`), + CONSTRAINT `repositories_ibfk_1` FOREIGN KEY (`stability`) REFERENCES `repository_stabilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `repositories_ibfk_2` FOREIGN KEY (`architecture`) REFERENCES `architectures` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci repository_moves CREATE TABLE `repository_moves` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, -- cgit v1.2.3