summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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`