summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-12-25 13:14:40 +0100
committerErich Eckner <git@eckner.net>2018-12-25 13:14:40 +0100
commitc83676e8af52dc50156db67f027361fab5255a39 (patch)
tree775154fb3a6d0d00e7adcbd884ef609e5f4eb13f
parentf5ff9af94026d3ca23e0bd2676282dcf2dd9803f (diff)
downloadbuilder-c83676e8af52dc50156db67f027361fab5255a39.tar.xz
misc/database-layout.dump: updated (do not ignore versions of dependencies)
-rw-r--r--misc/database-layout.dump6
1 files changed, 5 insertions, 1 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index f9fbde3..311aabf 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -283,7 +283,11 @@ DELETE `replaced_bpir`,`moveable_bpir`
JOIN `repositories` AS `repl_r`
ON `repl_bpir`.`repository`=`repl_r`.`id`
JOIN `dependencies`
- ON `install_target_providers`.`install_target`=`dependencies`.`depending_on` AND NOT EXISTS (
+ ON `install_target_providers`.`install_target`=`dependencies`.`depending_on`
+ JOIN `versions` AS `install_target_providers_versions`
+ ON `install_target_providers`.`version`=`install_target_providers_versions`.`id`
+ JOIN `versions` AS `dependencies_versions`
+ ON `dependencies`.`version`=`dependencies_versions`.`id` AND ((`dependencies`.`version_relation`="<" AND `install_target_providers_versions`.`order`<`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="<=" AND `install_target_providers_versions`.`order`<=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">" AND `install_target_providers_versions`.`order`>`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`=">=" AND `install_target_providers_versions`.`order`>=`dependencies_versions`.`order`) OR (`dependencies`.`version_relation`="=" AND `install_target_providers_versions`.`order`=`dependencies_versions`.`order`)) AND NOT EXISTS (
SELECT 1
FROM `replaced_bpir_copy`
JOIN `binary_packages_in_repositories` AS `repl_bpir_copy`