add index on configuration files

diff --git a/db.sql b/db.sql
index a4a065161f3c972dde677be7fd5d4f73c4e2af2f..42eeb067cc0a824de9204613bf74a520ba9ca0af 100644 (file)
--- 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, *,