diff options
author | Erich Eckner <git@eckner.net> | 2018-06-11 21:52:47 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-06-11 21:52:47 +0200 |
commit | f6ecdd3ed41ff847a1cfdbfd6e3ad6c4f2d8af29 (patch) | |
tree | e0289dc7a785832790881f4e1a890d423348ae55 | |
parent | 24e1fd05ead6daf0acda29ba30d22441a6915955 (diff) | |
download | builder-f6ecdd3ed41ff847a1cfdbfd6e3ad6c4f2d8af29.tar.xz |
bin/db-update: fix table names in query
-rwxr-xr-x | bin/db-update | 4 |
1 files changed, 2 insertions, 2 deletions
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 |