From 4e708195f1ccb3c2abad5cc6335b4b5d7dd17ffa Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Sun, 22 Apr 2018 17:10:33 +0200 Subject: bin/db-update,bin/return-assignment: update `binary_packages`.`last_moved` --- bin/db-update | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'bin/db-update') diff --git a/bin/db-update b/bin/db-update index 54d2f87..98bc884 100755 --- a/bin/db-update +++ b/bin/db-update @@ -392,7 +392,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 -- cgit v1.2.3