bin/return-assignment: keep binary_packages_in_repositories.repository up-to-date

1 files changed, 9 insertions, 1 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index bf5d6ab..f8f5546 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -572,8 +572,16 @@ trigger_mirror_refreshs
 
   # remove from build-list
   printf 'UPDATE `binary_packages`'
+  printf ' LEFT'
+  mysql_join_binary_packages_binary_packages_in_repositories
   printf ' SET'
-  printf ' `binary_packages`.`repository`=from_base64("%s"),' \
+  printf ' `binary_packages%s`.`repository`=from_base64("%s"),' \
+    '' \
+    "$(
+      printf '%s' "${destination_id}" | \
+        base64 -w0
+    )" \
+    '_in_repositories' \
     "$(
       printf '%s' "${destination_id}" | \
         base64 -w0