From 3e1823a4ae0fee443996b10b9d82a9edabc621fa Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
Date: Mon, 10 Sep 2018 19:44:20 -0700
Subject: sql: add an index from cockroach branch

---
 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 c21e5b5e..9e0f471e 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -16,6 +16,8 @@ CREATE TABLE editor (
     active_editgroup_id UUID -- REFERENCES( editgroup(id) via ALTER below
 );
 
+CREATE INDEX active_editgroup_idx ON editor(active_editgroup_id);
+
 CREATE TABLE editgroup (
     id                  UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
     editor_id           UUID REFERENCES editor(id) NOT NULL,
-- 
cgit v1.2.3

