From 561657a4472da1e5ab71319a8fca2067d77f54b5 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 11 Sep 2018 14:07:22 +0200 Subject: i486 new in the database --- misc/database-layout.dump | 42 ++++++++++++++++++++++++++++++++++-------- 1 file changed, 34 insertions(+), 8 deletions(-) (limited to 'misc/database-layout.dump') 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'), -- cgit v1.2.3-54-g00ecf