diff options
-rwxr-xr-x | bin/bootstrap-mysql | 4 |
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`)' |