From 1f47da1679460296c05b5054b4c2865759236d79 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 15 Jan 2019 10:48:58 +0100 Subject: bin/db-update: add some comments --- bin/db-update | 2 ++ 1 file changed, 2 insertions(+) (limited to 'bin/db-update') diff --git a/bin/db-update b/bin/db-update index 4f7cfd3..ae79135 100755 --- a/bin/db-update +++ b/bin/db-update @@ -225,6 +225,7 @@ for source_stability in \ printf 'CREATE TEMPORARY TABLE `replaced_bpir` (`id` BIGINT, `replaced_by` BIGINT, UNIQUE KEY (`id`));\n' printf 'CREATE TEMPORARY TABLE `moveable_bpir` (`id` BIGINT, `to_repository` MEDIUMINT, UNIQUE KEY (`id`));\n' + # packages that replace broken packages printf 'INSERT IGNORE INTO `replaced_bpir` (`id`,`replaced_by`)' printf ' SELECT `old_bpir`.`id`,`new_bpir`.`id`' printf ' FROM `binary_packages_in_repositories` AS `new_bpir`' @@ -263,6 +264,7 @@ for source_stability in \ printf ' JOIN `binary_packages_in_repositories` ON `binary_packages_in_repositories`.`id`=`replaced_bpir`.`id`' printf ';\n' + # packages which replace nothing printf 'INSERT IGNORE INTO `moveable_bpir` (`id`,`to_repository`)' printf ' SELECT `binary_packages_in_repositories`.`id`,`repository_moves`.`to_repository`' printf ' FROM `binary_packages_in_repositories`' -- cgit v1.2.3-70-g09d2