aboutsummaryrefslogtreecommitdiffstats
path: root/sql/migrations
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2022-04-04 15:52:02 -0700
committerBryan Newbold <bnewbold@archive.org>2022-04-04 15:52:02 -0700
commitdadb26935c4d255c5a662f1e758bcf53864f7f95 (patch)
treef29f7c689a2f7d288cc2d07cec040b8edf8c1380 /sql/migrations
parentc4caeaedc63c2bb2f9bb9f6be6826480aefc9caf (diff)
downloadsandcrawler-dadb26935c4d255c5a662f1e758bcf53864f7f95.tar.gz
sandcrawler-dadb26935c4d255c5a662f1e758bcf53864f7f95.zip
sql: add source/created index on ingest_request table
Diffstat (limited to 'sql/migrations')
-rw-r--r--sql/migrations/2019-12-19-060141_init/up.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/migrations/2019-12-19-060141_init/up.sql b/sql/migrations/2019-12-19-060141_init/up.sql
index 23a935e..33dba66 100644
--- a/sql/migrations/2019-12-19-060141_init/up.sql
+++ b/sql/migrations/2019-12-19-060141_init/up.sql
@@ -149,6 +149,7 @@ CREATE TABLE IF NOT EXISTS ingest_request (
PRIMARY KEY (link_source, link_source_id, ingest_type, base_url)
);
CREATE INDEX ingest_request_base_url_idx ON ingest_request(base_url, ingest_type);
+CREATE INDEX ingest_request_source_created_idx ON ingest_request(ingest_request_source, created);
CREATE TABLE IF NOT EXISTS ingest_file_result (
ingest_type TEXT NOT NULL CHECK (octet_length(ingest_type) >= 1),