diff options
Diffstat (limited to 'bin/db-update')
-rwxr-xr-x | bin/db-update | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/bin/db-update b/bin/db-update index 6f4096c..f09db2d 100755 --- a/bin/db-update +++ b/bin/db-update @@ -186,6 +186,8 @@ for source_stability in \ printf ' FROM `binary_packages_in_repositories` AS `new_bpir`' mysql_join_binary_packages_in_repositories_binary_packages 'new_bpir' 'new_bp' mysql_join_binary_packages_in_repositories_repositories 'new_bpir' 'from_r' + printf ' AND `from_r`.`stability`=%s' \ + "${source_stability}" printf ' AND `from_r`.`is_on_master_mirror`' mysql_join_binary_packages_build_assignments 'new_bp' mysql_join_build_assignments_package_sources @@ -194,14 +196,11 @@ for source_stability in \ printf ' AND `repository_moves`.`from_repository`=`from_r`.`id`' printf ' JOIN `repositories` AS `to_r`' printf ' ON `repository_moves`.`to_repository`=`to_r`.`id`' - printf ' AND `to_r`.`stability`=%s' \ - "${source_stability}" printf ' JOIN `binary_packages` AS `old_bp`' printf ' ON `new_bp`.`pkgname`=`old_bp`.`pkgname`' mysql_join_binary_packages_binary_packages_in_repositories 'old_bp' 'old_bpir' mysql_join_binary_packages_in_repositories_repositories 'old_bpir' 'old_r' - printf ' AND `old_r`.`stability`=%s' \ - "${source_stability}" + printf ' AND `old_r`.`stability`=`to_r`.`stability`' printf ' AND `old_r`.`architecture`=`to_r`.`architecture`' mysql_join_binary_packages_dependencies 'old_bp' mysql_join_dependencies_dependency_types |