summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-09-10 19:44:20 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-09-10 19:44:20 -0700
commit3e1823a4ae0fee443996b10b9d82a9edabc621fa (patch)
tree1692f4bf330fe4cc4b564513512840f2d7664805 /rust/migrations/2018-05-12-001226_init/up.sql
parent60b070103e80a83e062a57cefd0ba0a84fc3a4c0 (diff)
downloadfatcat-3e1823a4ae0fee443996b10b9d82a9edabc621fa.tar.gz
fatcat-3e1823a4ae0fee443996b10b9d82a9edabc621fa.zip
sql: add an index from cockroach branch
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init/up.sql')
-rw-r--r--rust/migrations/2018-05-12-001226_init/up.sql2
1 files changed, 2 insertions, 0 deletions
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,