From df9ca294a7fa249bade83928f811973c02d810c5 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 31 May 2018 11:18:00 +0200
Subject: lib/mysql-functions: deletion-list packages may have a checksum

---
 lib/mysql-functions | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/lib/mysql-functions b/lib/mysql-functions
index 0aad61a..7a6ba03 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -742,7 +742,12 @@ mysql_sanity_check() {
       printf '`architectures`.`name`'
       printf ' FROM `binary_packages`'
       mysql_join_binary_packages_architectures
-      printf ' WHERE `binary_packages`.`sha512sum` IS NOT NULL'
+      printf ' WHERE NOT EXISTS ('
+        printf 'SELECT 1 FROM `binary_packages_in_repositories`'
+        mysql_join_binary_packages_in_repositories_repositories
+        printf ' WHERE NOT `repositories`.`is_on_master_mirror`'
+        printf ' AND `binary_packages_in_repositories`.`package`=`binary_packages`.`id`'
+      printf ')'
     } | \
       mysql_run_query | \
       sed '
-- 
cgit v1.2.3-70-g09d2