aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2020-03-05 21:45:10 -0800
committerBryan Newbold <bnewbold@archive.org>2020-03-05 21:45:10 -0800
commita53699e21f434adb06263763c0743ca4413eef91 (patch)
treeb3c0a26fea0a993fbe5791d8d46c12a492f60378 /sql
parent6f329d030ab2ee89461bbc3fd9cdbd25b58b4021 (diff)
downloadsandcrawler-a53699e21f434adb06263763c0743ca4413eef91.tar.gz
sandcrawler-a53699e21f434adb06263763c0743ca4413eef91.zip
sandcrawler schema: add MD5 index
Diffstat (limited to 'sql')
-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 a27796b..688487f 100644
--- a/sql/migrations/2019-12-19-060141_init/up.sql
+++ b/sql/migrations/2019-12-19-060141_init/up.sql
@@ -37,6 +37,7 @@ CREATE TABLE IF NOT EXISTS file_meta (
size_bytes BIGINT,
mimetype TEXT CHECK (octet_length(mimetype) >= 1)
);
+CREATE INDEX file_meta_md5hex_idx ON file_meta(md5hex);
CREATE TABLE IF NOT EXISTS fatcat_file (
sha1hex TEXT PRIMARY KEY CHECK (octet_length(sha1hex) = 40),