misc/database-layout.dump: update to new package_blobs-generation

1 files changed, 12 insertions, 0 deletions

diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 66aed36..6610971 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -153,6 +153,18 @@ INSERT IGNORE INTO `moveable_bpir` (`id`,`to_repository`)
 	JOIN `repository_moves`
 	ON `upstream_repositories`.`id`=`repository_moves`.`upstream_package_repository` AND `repository_moves`.`from_repository`=`binary_packages_in_repositories`.`repository`
 	WHERE `repository_stabilities`.`id`=`from_stability` AND (`repository_stabilities`.`name`="staging" OR `binary_packages`.`is_tested`) AND NOT `binary_packages`.`has_issues`;
+INSERT IGNORE INTO `package_blobs` (`ps_a`,`ps_b`)
+	SELECT `package_sourcess`.`id`,`package_sources`.`id`
+	FROM `package_sources`
+	JOIN `build_assignments`
+	ON `package_sources`.`id`=`build_assignments`.`package_source`
+	JOIN `binary_packages`
+	ON `build_assignments`.`id`=`binary_packages`.`build_assignment`
+	JOIN `binary_packages_in_repositories`
+	ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`
+	JOIN `repositories`
+	ON `binary_packages_in_repositories`.`repository`=`repositories`.`id`
+	WHERE `repositories`.`stability`=`from_stability`;
 INSERT IGNORE INTO `replaced_bpir` (`id`,`replaced_by`)
 	SELECT `r_bpir`.`id`,`m_bpir`.`id`
 	FROM `moveable_bpir`