From f8e8b08fa4c5dcdd97bb13a1f272965f9041b6ce Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 17 Jan 2019 15:27:21 +0100 Subject: misc/database-layout.dump: update to new package_blobs-generation --- misc/database-layout.dump | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'misc') 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` -- cgit v1.2.3-70-g09d2