summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-07-23 13:43:09 +0200
committerErich Eckner <git@eckner.net>2018-07-23 13:43:09 +0200
commite7b67c492c8b654057a817c5159b1b3afd9f2439 (patch)
tree03a49b079f7418571a5436bd9dcb346ee5a5cc8f /misc
parenteb1553deacd8c8912354825faa7b3c4a3c85c60b (diff)
downloadbuilder-e7b67c492c8b654057a817c5159b1b3afd9f2439.tar.xz
misc/database-layout.dump: deletion-list now arch dependent
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dump5
1 files changed, 3 insertions, 2 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index d41e704..90255b4 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -620,7 +620,7 @@ repositories CREATE TABLE `repositories` (
`is_on_master_mirror` bit(1) NOT NULL,
`architecture` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
+ UNIQUE KEY `name_arch` (`name`,`architecture`),
KEY `stability` (`stability`),
KEY `architecture` (`architecture`),
CONSTRAINT `repositories_ibfk_1` FOREIGN KEY (`stability`) REFERENCES `repository_stabilities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
@@ -763,7 +763,8 @@ INSERT INTO `repositories` VALUES
(10,'deletion-list',6,'\0',1),
(11,'to-be-decided',7,'\0',1),
(12,'gnome-unstable',8,'1',2),
- (13,'kde-unstable',8,'1',2);
+ (13,'kde-unstable',8,'1',2),
+ (14,'deletion-list',6,'\0',2);
INSERT INTO `repository_moves` VALUES
(1,6,3,3),
(2,6,3,4),