| index : builder | |
| Archlinux32 build system | gitolite user |
| summaryrefslogtreecommitdiff |
| -rw-r--r-- | misc/database-layout.dump | 12 |
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` |