diff options
| -rw-r--r-- | nar-herder/database.scm | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/nar-herder/database.scm b/nar-herder/database.scm index ded7c2c..a8a043c 100644 --- a/nar-herder/database.scm +++ b/nar-herder/database.scm @@ -121,6 +121,7 @@ CREATE TABLE narinfo_files ( ); CREATE INDEX narinfo_files_narinfo_id ON narinfo_files (narinfo_id); +CREATE INDEX narinfo_files_url ON narinfo_files (url); CREATE TABLE narinfo_references ( narinfo_id INTEGER NOT NULL REFERENCES narinfos (id), @@ -257,7 +258,12 @@ CREATE TABLE scheduled_cached_narinfo_removal ( (sqlite-exec db "CREATE INDEX IF NOT EXISTS narinfo_files_narinfo_id - ON narinfo_files (narinfo_id);")) + ON narinfo_files (narinfo_id);") + + (sqlite-exec + db + "CREATE INDEX IF NOT EXISTS narinfo_files_url + ON narinfo_files (url);")) (define* (setup-database database-file metrics-registry #:key (reader-threads 1)) |