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:
authorErich Eckner <git@eckner.net>2018-05-03 13:57:00 +0200
committerErich Eckner <git@eckner.net>2018-05-03 13:57:00 +0200
commita3cfcc18ebd248e9f2f16cd0d5166da5de222d3d (patch)
tree3b45cacf277b8cc8266713d4bde0ea7a81fe1aa2 /misc/database-layout.dump
parent4814b1e2732cca03f4b557a9aa7a796c5e690e1f (diff)
misc/database-layout.dump: new column in database: `repositories`.`architecture`
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump5
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,