From e0c167a65916bf995add39aec94f5f524af834e4 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 1 Jun 2018 11:06:41 +0200 Subject: make `binary_packages`.`is_to_be_deleted` and `binary_packages`.`last_moved` obsolete; cleanup some queries --- bin/db-update | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'bin/db-update') diff --git a/bin/db-update b/bin/db-update index 4834a1d..2140880 100755 --- a/bin/db-update +++ b/bin/db-update @@ -201,7 +201,7 @@ for source_stability in 'testing' 'staging'; do mysql_join_dependencies_dependency_types printf ' AND `dependency_types`.`relevant_for_binary_packages`' printf ' WHERE NOT EXISTS (' - printf 'SELECT * FROM `install_target_providers`' + printf 'SELECT 1 FROM `install_target_providers`' printf ' WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on`' printf ');\n' @@ -411,7 +411,6 @@ for source_stability in 'testing' 'staging'; do printf ' JOIN `moved_binary_packages` ON `binary_packages`.`id`=`moved_binary_packages`.`id`' mysql_join_binary_packages_binary_packages_in_repositories printf ' SET `binary_packages_in_repositories`.`repository`=`moved_binary_packages`.`new_repository`,' - printf '`binary_packages`.`last_moved`=NOW(),' printf '`binary_packages_in_repositories`.`last_moved`=NOW()' printf ' WHERE `binary_packages_in_repositories`.`repository`!=`moved_binary_packages`.`new_repository`;\n' } | \ -- cgit v1.2.3-54-g00ecf