misc/database-layout.dump: updated (do not ignore versions of dependencies)

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`