bin/bootstrap-mysql: add all packages to package_blobs, so we move split packages together, too

1 files changed, 10 insertions, 0 deletions

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index c73b1e5..75043e6 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -100,6 +100,16 @@ fi
   printf ' AND NOT `binary_packages`.`has_issues`'
   printf ';\n'
 
+  # add all considered packages, so we move split packages together, too
+  printf 'INSERT IGNORE INTO `package_blobs` (`ps_a`,`ps_b`)'
+  printf ' SELECT `package_sourcess`.`id`,`package_sources`.`id`'
+  printf ' FROM `package_sources`'
+  mysql_join_package_sources_build_assignments
+  mysql_join_build_assignments_binary_packages
+  mysql_join_binary_packages_binary_packages_in_repositories
+  mysql_join_binary_packages_in_repositories_repositories
+  printf ' WHERE `repositories`.`stability`=`from_stability`;\n'
+
   # these packages are considered for being replaced:
   # for each moved package
   printf 'INSERT IGNORE INTO `replaced_bpir` (`id`,`replaced_by`)'