From bed06d8726a063e177ccd8a40554a799e0fdb1f1 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
Date: Sun, 19 Aug 2018 16:45:51 -0700
Subject: add index on file_rev_url file_rev

---
 rust/migrations/2018-05-12-001226_init/up.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'rust/migrations/2018-05-12-001226_init/up.sql')

diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql
index 960623a3..a1de656d 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -145,6 +145,8 @@ CREATE TABLE file_rev_url (
     url                 TEXT NOT NULL
 );
 
+CREATE INDEX file_rev_url_rev_idx ON file_rev_url(file_rev);
+
 CREATE TABLE file_ident (
     id                  UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
     is_live             BOOL NOT NULL DEFAULT false,
-- 
cgit v1.2.3

