diff options
| author | Erich Eckner <git@eckner.net> | 2019-01-17 15:27:21 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2019-01-17 15:27:21 +0100 |
| commit | f8e8b08fa4c5dcdd97bb13a1f272965f9041b6ce (patch) | |
| tree | fba86b9572f29e8e288bfa1811e954bacb1b5ff3 /misc | |
| parent | c9f55c95cb382e22c41a310c1005e3de43379ae9 (diff) | |
| download | builder-f8e8b08fa4c5dcdd97bb13a1f272965f9041b6ce.tar.xz | |
misc/database-layout.dump: update to new package_blobs-generation
Diffstat (limited to 'misc')
| -rw-r--r-- | misc/database-layout.dump | 12 |
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` |