diff options
| author | Erich Eckner <git@eckner.net> | 2018-12-25 13:14:40 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-12-25 13:14:40 +0100 |
| commit | c83676e8af52dc50156db67f027361fab5255a39 (patch) | |
| tree | 775154fb3a6d0d00e7adcbd884ef609e5f4eb13f | |
| parent | f5ff9af94026d3ca23e0bd2676282dcf2dd9803f (diff) | |
| download | builder-c83676e8af52dc50156db67f027361fab5255a39.tar.xz | |
misc/database-layout.dump: updated (do not ignore versions of dependencies)
| -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` |