From a53699e21f434adb06263763c0743ca4413eef91 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@archive.org>
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

