diff options
Diffstat (limited to 'misc')
| -rw-r--r-- | misc/database-layout.dump | 6 |
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` |