From f6ecdd3ed41ff847a1cfdbfd6e3ad6c4f2d8af29 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 11 Jun 2018 21:52:47 +0200 Subject: bin/db-update: fix table names in query --- bin/db-update | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'bin/db-update') diff --git a/bin/db-update b/bin/db-update index ea0f2e9..1b72805 100755 --- a/bin/db-update +++ b/bin/db-update @@ -162,7 +162,7 @@ for source_stability in \ mysql_join_package_sources_upstream_repositories mysql_join_upstream_repositories_repository_moves printf ' AND `repository_moves`.`from_repository`=`binary_packages_in_repositories`.`repository`' - printf ' SET `moveable_binary_packages`.`to_repository`=`repository_moves`.`to_repository`;\n' + printf ' SET `moveable_bpir`.`to_repository`=`repository_moves`.`to_repository`;\n' printf 'DELETE FROM `moveable_bpir` WHERE `moveable_bpir`.`to_repository` IS NULL;\n' printf 'INSERT IGNORE INTO `replaced_bpir` (`id`,`replaced_by`)' printf ' SELECT `binary_packages_in_repositories`.`id`,`moveable_bpir`.`id`' @@ -172,7 +172,7 @@ for source_stability in \ printf ' JOIN `binary_packages` ON `binary_packages`.`pkgname`=`subst_bp`.`pkgname`' mysql_join_binary_packages_binary_packages_in_repositories mysql_join_binary_packages_in_repositories_repositories - printf ' JOIN `repositories` AS `m_to_r` ON `moveable_binary_packages`.`to_repository`=`m_to_r`.`id`' + printf ' JOIN `repositories` AS `m_to_r` ON `moveable_bpir`.`to_repository`=`m_to_r`.`id`' printf ' AND `repositories`.`stability`=`m_to_r`.`stability`' printf ' AND `repositories`.`architecture`=`m_to_r`.`architecture`;\n' elif ${progressive}; then -- cgit v1.2.3