Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump7
1 files changed, 7 insertions, 0 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index cf75f18..8954513 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -197,6 +197,13 @@ DELETE `replaced_bpir`,`moveable_bpir`
ON `replaced_bpir`.`replaced_by`=`moveable_bpir`.`id`
JOIN `binary_packages_in_repositories` AS `repl_bpir`
ON `repl_bpir`.`id`=`replaced_bpir`.`id` AND NOT `repl_bpir`.`is_to_be_deleted`
+ JOIN `binary_packages` AS `repl_bp`
+ ON `repl_bpir`.`package`=`repl_bp`.`id`
+ JOIN `build_assignments` AS `repl_ba`
+ ON `repl_bp`.`build_assignment`=`repl_ba`.`id` AND NOT EXISTS (
+SELECT 1
+ FROM `failed_builds`
+ WHERE `failed_builds`.`date`<=ADDTIME(NOW(),"-1 00:00:00") AND `failed_builds`.`build_assignment`=`repl_ba`.`id`)
JOIN `install_target_providers`
ON `repl_bpir`.`package`=`install_target_providers`.`package`
JOIN `repositories` AS `repl_r`