summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-07-03 09:21:34 +0200
committerErich Eckner <git@eckner.net>2019-07-03 09:21:34 +0200
commitd8c2af7de1293bd64beee95928724302ff2eb6bf (patch)
tree6c98cbb71af16a195186dfa7e7c649d70507b692
parentba5f2280a29cccb04454eb0d467f604b37fbb899 (diff)
downloadbuilder-d8c2af7de1293bd64beee95928724302ff2eb6bf.tar.xz
bin/bootstrap-mysql: add keys to temporary blacklist tables (accellerates queries?)
-rwxr-xr-xbin/bootstrap-mysql4
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`)'