index : builder | |
Archlinux32 build system | gitolite user |
summaryrefslogtreecommitdiff |
author | Erich Eckner <git@eckner.net> | 2018-05-03 13:57:00 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-05-03 13:57:00 +0200 |
commit | a3cfcc18ebd248e9f2f16cd0d5166da5de222d3d (patch) | |
tree | 3b45cacf277b8cc8266713d4bde0ea7a81fe1aa2 | |
parent | 4814b1e2732cca03f4b557a9aa7a796c5e690e1f (diff) |
-rw-r--r-- | misc/database-layout.dump | 5 |
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, |