From a53699e21f434adb06263763c0743ca4413eef91 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Thu, 5 Mar 2020 21:45:10 -0800 Subject: sandcrawler schema: add MD5 index --- sql/migrations/2019-12-19-060141_init/up.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'sql/migrations/2019-12-19-060141_init/up.sql') 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), -- cgit v1.2.3