Merge branch 'master' into fixes

1 files changed, 5 insertions, 1 deletions

diff --git a/bin/db-update b/bin/db-update
index 54d2f87..28e9861 100755
--- a/bin/db-update
+++ b/bin/db-update
@@ -12,6 +12,8 @@
 # TODO: we should delete more packages than just the ones in repositories
 # where we move to (think of [extra] -> [community])
 
+# TODO: enable separate repositories for each architecture
+
 # shellcheck disable=SC2039
 # shellcheck source=../conf/default.conf
 . "${0%/*}/../conf/default.conf"
@@ -392,7 +394,9 @@ 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 ' SET `binary_packages`.`repository`=`moved_binary_packages`.`new_repository`;\n'
+    printf ' SET `binary_packages`.`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
 done