summaryrefslogtreecommitdiff
path: root/misc/database-layout.dump
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-01-11 14:04:51 +0100
committerErich Eckner <git@eckner.net>2019-01-11 14:04:51 +0100
commitbb8a2d1cd8b6aced244c9b48590c4d60f9205848 (patch)
treea342bd2f5df140bc5c3c3a52ea4062e689d01cee /misc/database-layout.dump
parentfa44e6ac5b94bcbf2ac6ca82258386d275298715 (diff)
downloadbuilder-bb8a2d1cd8b6aced244c9b48590c4d60f9205848.tar.xz
misc/database-layout.dump: update in calculate_maximal_moveable_set
Diffstat (limited to 'misc/database-layout.dump')
-rw-r--r--misc/database-layout.dump2
1 files changed, 1 insertions, 1 deletions
diff --git a/misc/database-layout.dump b/misc/database-layout.dump
index 311aabf..66aed36 100644
--- a/misc/database-layout.dump
+++ b/misc/database-layout.dump
@@ -117,7 +117,7 @@ INSERT IGNORE INTO `package_blobs` (`ps_a`,`ps_b`)
SELECT `a_ps`.`id`,`b_ps`.`id`
FROM `package_sources` AS `a_ps`
JOIN `package_sources` AS `b_ps`
- ON UNIX_TIMESTAMP(`a_ps`.`commit_time`) - UNIX_TIMESTAMP(`b_ps`.`commit_time`) BETWEEN -10 AND 10
+ ON UNIX_TIMESTAMP(`a_ps`.`commit_time`) - UNIX_TIMESTAMP(`b_ps`.`commit_time`) BETWEEN -10 AND 10 AND `a_ps`.`commit_time`!="0000-00-00 00:00:00" AND `b_ps`.`commit_time`!="0000-00-00 00:00:00"
JOIN `build_assignments` AS `a_ba`
ON `a_ps`.`id`=`a_ba`.`package_source`
JOIN `build_assignments` AS `b_ba`