bin/db-update: keep binary_packages_in_repositories up to date

1 files changed, 4 insertions, 1 deletions

diff --git a/bin/db-update b/bin/db-update
index 7d261e1..a2555fe 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -398,8 +398,11 @@ for source_stability in 'testing' 'staging'; do
     printf ' JOIN `replaced_binary_packages` ON `binary_packages`.`id`=`replaced_binary_packages`.`id`;\n'
     printf 'UPDATE `binary_packages`'
     printf ' JOIN `moved_binary_packages` ON `binary_packages`.`id`=`moved_binary_packages`.`id`'
+    printf ' LEFT'
+    mysql_join_binary_packages_binary_packages_in_repositories
     printf ' SET `binary_packages`.`repository`=`moved_binary_packages`.`new_repository`,'
-    printf ' `binary_packages`.`last_moved`=NOW()'
+    printf '`binary_packages_in_repositories`.`repository`=`moved_binary_packages`.`new_repository`,'
+    printf '`binary_packages`.`last_moved`=NOW()'
     printf ' WHERE `binary_packages`.`repository`!=`moved_binary_packages`.`new_repository`;\n'
   } | \
     mysql_run_query