From d8c2af7de1293bd64beee95928724302ff2eb6bf Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 3 Jul 2019 09:21:34 +0200 Subject: bin/bootstrap-mysql: add keys to temporary blacklist tables (accellerates queries?) --- bin/bootstrap-mysql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'bin/bootstrap-mysql') 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`)' -- cgit v1.2.3