diff options
| author | Bryan Newbold <bnewbold@archive.org> | 2020-03-05 21:45:10 -0800 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@archive.org> | 2020-03-05 21:45:10 -0800 |
| commit | a53699e21f434adb06263763c0743ca4413eef91 (patch) | |
| tree | b3c0a26fea0a993fbe5791d8d46c12a492f60378 | |
| parent | 6f329d030ab2ee89461bbc3fd9cdbd25b58b4021 (diff) | |
| download | sandcrawler-a53699e21f434adb06263763c0743ca4413eef91.tar.gz sandcrawler-a53699e21f434adb06263763c0743ca4413eef91.zip | |
sandcrawler schema: add MD5 index
| -rw-r--r-- | sql/migrations/2019-12-19-060141_init/up.sql | 1 |
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), |