Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/misc
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-01-17 15:27:21 +0100
committerErich Eckner <git@eckner.net>2019-01-17 15:27:21 +0100
commitf8e8b08fa4c5dcdd97bb13a1f272965f9041b6ce (patch)
treefba86b9572f29e8e288bfa1811e954bacb1b5ff3 /misc
parentc9f55c95cb382e22c41a310c1005e3de43379ae9 (diff)
misc/database-layout.dump: update to new package_blobs-generation
Diffstat (limited to 'misc')
-rw-r--r--misc/database-layout.dump12
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`