diff options
| author | Erich Eckner <git@eckner.net> | 2019-07-03 09:21:34 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2019-07-03 09:21:34 +0200 |
| commit | d8c2af7de1293bd64beee95928724302ff2eb6bf (patch) | |
| tree | 6c98cbb71af16a195186dfa7e7c649d70507b692 | |
| parent | ba5f2280a29cccb04454eb0d467f604b37fbb899 (diff) | |
| download | builder-d8c2af7de1293bd64beee95928724302ff2eb6bf.tar.xz | |
bin/bootstrap-mysql: add keys to temporary blacklist tables (accellerates queries?)
| -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`)' |