summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-11 21:52:47 +0200
committerErich Eckner <git@eckner.net>2018-06-11 21:52:47 +0200
commitf6ecdd3ed41ff847a1cfdbfd6e3ad6c4f2d8af29 (patch)
treee0289dc7a785832790881f4e1a890d423348ae55
parent24e1fd05ead6daf0acda29ba30d22441a6915955 (diff)
downloadbuilder-f6ecdd3ed41ff847a1cfdbfd6e3ad6c4f2d8af29.tar.xz
bin/db-update: fix table names in query
-rwxr-xr-xbin/db-update4
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