bin/bootstrap-mysql: add keys to temporary blacklist tables (accellerates queries?)

1 files changed, 3 insertions, 1 deletions

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index 820d689..54d9da6 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -678,7 +678,9 @@ fi
       "${suffix}"
       printf '`arch` SMALLINT,'
       printf '`pkgbase` VARCHAR(64),'
-      printf 'UNIQUE KEY `content`(`arch`,`pkgbase`)'
+      printf 'UNIQUE KEY `content`(`arch`,`pkgbase`),'
+      printf 'KEY (`arch`),'
+      printf 'KEY (`pkgbase`)'
     printf ');\n'
   done
   printf 'INSERT IGNORE INTO `bl`(`arch`,`pkgbase`)'