From 42fa2a4d01d31922de2a61881860840f2bfa80f5 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Sun, 19 Aug 2018 18:27:48 -0700 Subject: add index on release_rev_abstract SHA1 column --- rust/migrations/2018-05-12-001226_init/up.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql index a1de656d..024273a7 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -212,6 +212,7 @@ CREATE TABLE release_rev_abstract ( ); CREATE INDEX release_rev_abstract_rev_idx ON release_rev_abstract(release_rev); +CREATE INDEX release_rev_abstract_sha1_idx ON release_rev_abstract(abstract_sha1); CREATE TABLE release_ident ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), -- cgit v1.2.3