From: Nathan Wagner <nw@hydaspes.if.org>
Date: Mon, 3 Dec 2018 06:53:55 +0000 (+0000)
Subject: add index on configuration files
X-Git-Tag: v0.3.3~6
X-Git-Url: https://pd.if.org/git/?p=zpackage;a=commitdiff_plain;h=d230fdf22ba4e063b616f2e7a00c36ffa040d754

add index on configuration files
---

diff --git a/db.sql b/db.sql
index a4a0651..42eeb06 100644
--- a/db.sql
+++ b/db.sql
@@ -171,6 +171,7 @@ without rowid
 create index packagefile_package_index on packagefiles (package);
 create index packagefile_path_index on packagefiles (path);
 create index packagefile_hash_index on packagefiles (hash);
+create index pkgfile_configuration on packagefiles (configuration) where configuration = 1;
 
 create view packagefiles_pkgid as
 select printf('%s-%s-%s', package, version, release) as pkgid, *,