From c83676e8af52dc50156db67f027361fab5255a39 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 25 Dec 2018 13:14:40 +0100 Subject: misc/database-layout.dump: updated (do not ignore versions of dependencies) --- misc/database-layout.dump | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'misc') 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` -- cgit v1.2.3-54-g00ecf