diff options
| author | Christopher Baines <mail@cbaines.net> | 2024-06-12 09:37:09 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2024-06-12 17:37:28 +0100 |
| commit | cba2a28017c3da02c18a7992a83830c7c91042ba (patch) | |
| tree | 1486e4cdeac30697697d44496fafe4630090bd94 | |
| parent | 43ceba0f59bf53e2097789a0005c3104a0ab0796 (diff) | |
| download | nar-herder-cba2a28017c3da02c18a7992a83830c7c91042ba.tar nar-herder-cba2a28017c3da02c18a7992a83830c7c91042ba.tar.gz | |
Index narinfo_files (url)
As this is needed by database-select-narinfo-for-file.
| -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)) |