summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-09-11 14:07:22 +0200
committerErich Eckner <git@eckner.net>2018-09-11 14:07:22 +0200
commit561657a4472da1e5ab71319a8fca2067d77f54b5 (patch)
tree1837509410af7edcf3cbd5e247df13d8bbd9c1f4 /misc/database-layout.dump
parent60c87c316703b7e68e19b205782e0fad669deb73 (diff)
downloadbuilder-561657a4472da1e5ab71319a8fca2067d77f54b5.tar.xz
i486 new in the database
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump42
1 files changed, 34 insertions, 8 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 7a2f775..bd8411d 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -834,7 +834,7 @@ repository_moves CREATE TABLE `repository_moves` (
`to_repository` mediumint(9) NOT NULL,
`upstream_package_repository` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY `source` (`from_repository`,`upstream_package_repository`),
+ UNIQUE KEY `content` (`from_repository`,`to_repository`,`upstream_package_repository`),
KEY `to_repository` (`to_repository`),
KEY `upstream_package_repository` (`upstream_package_repository`),
CONSTRAINT `repository_moves_ibfk_1` FOREIGN KEY (`from_repository`) REFERENCES `repositories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
@@ -930,11 +930,14 @@ versions CREATE TABLE `versions` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
INSERT INTO `architectures` VALUES
(1,'any'),
+ (3,'i486'),
(2,'i686');
INSERT INTO `architecture_compatibilities` VALUES
(1,1,1,'1'),
(2,2,2,'1'),
- (3,1,2,'1');
+ (3,1,2,'1'),
+ (4,3,3,'1'),
+ (5,1,3,'1');
INSERT INTO `dependency_types` VALUES
(2,'run','1','1'),
(3,'check','\0','\0'),
@@ -979,20 +982,43 @@ INSERT INTO `repositories` VALUES
(11,'to-be-decided',7,'\0',1),
(12,'gnome-unstable',8,'1',2),
(13,'kde-unstable',8,'1',2),
- (14,'deletion-list',6,'\0',2);
+ (14,'deletion-list',6,'\0',2),
+ (15,'core',1,'1',3),
+ (16,'extra',1,'1',3),
+ (17,'community',1,'1',3),
+ (18,'build-support',4,'1',3),
+ (19,'testing',2,'1',3),
+ (20,'community-testing',2,'1',3),
+ (21,'staging',3,'1',3),
+ (22,'community-staging',3,'1',3),
+ (23,'gnome-unstable',8,'1',3),
+ (24,'kde-unstable',8,'1',3),
+ (25,'deletion-list',6,'\0',3);
INSERT INTO `repository_moves` VALUES
- (1,6,3,3),
- (2,6,3,4),
- (3,8,6,3),
- (4,8,6,4),
(5,5,1,1),
(6,5,2,2),
+ (1,6,3,3),
+ (2,6,3,4),
(8,7,5,1),
(9,7,5,2),
+ (3,8,6,3),
+ (4,8,6,4),
(10,9,7,1),
(11,9,7,2),
(12,9,8,3),
- (13,9,8,4);
+ (13,9,8,4),
+ (29,9,21,1),
+ (30,9,21,2),
+ (31,9,22,3),
+ (32,9,22,4),
+ (18,19,15,1),
+ (19,19,16,2),
+ (14,20,17,3),
+ (15,20,17,4),
+ (20,21,19,1),
+ (21,21,19,2),
+ (16,22,20,3),
+ (17,22,20,4);
INSERT INTO `repository_stabilities` VALUES
(1,'stable','Packages: Stable'),
(2,'testing','Packages: Testing'),