summaryrefslogtreecommitdiff
path: root/bin/bootstrap-mysql
diff options
context:
space:
mode:
Diffstat (limited to 'bin/bootstrap-mysql')
-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`)'