From 8cac4808a87e1d85e9d6d39d9f5fbac8134b9b42 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 30 May 2018 13:55:26 +0200 Subject: bin/db-update: do not write `binary_packages`.`repository` --- 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 327e29f..9dc13b4 100755 --- a/bin/db-update +++ b/bin/db-update @@ -413,8 +413,7 @@ for source_stability in 'testing' 'staging'; do printf 'UPDATE `binary_packages`' 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`.`repository`=`moved_binary_packages`.`new_repository`,' - printf '`binary_packages_in_repositories`.`repository`=`moved_binary_packages`.`new_repository`,' + printf ' SET `binary_packages_in_repositories`.`repository`=`moved_binary_packages`.`new_repository`,' printf '`binary_packages`.`last_moved`=NOW()' printf ' WHERE `binary_packages_in_repositories`.`repository`!=`moved_binary_packages`.`new_repository`;\n' } | \ -- cgit v1.2.3