diff options
| 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) | |
| download | builder-a3cfcc18ebd248e9f2f16cd0d5166da5de222d3d.tar.xz | |
misc/database-layout.dump: new column in database: `repositories`.`architecture`
| -rw-r--r-- | misc/database-layout.dump | 5 |
1 files changed, 4 insertions, 1 deletions
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, |