aboutsummaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-08-14 20:13:31 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-08-14 20:13:31 -0700
commit03db89544ee1589300e497bd5064b72f357d0c80 (patch)
treec72330e4d3b5c9ecc3da22d1095eb30618db4d84 /rust/migrations/2018-05-12-001226_init
parent612d5c406a5a7e0d4fc7a697577ae908233ee275 (diff)
downloadfatcat-03db89544ee1589300e497bd5064b72f357d0c80.tar.gz
fatcat-03db89544ee1589300e497bd5064b72f357d0c80.zip
cockroach: create active_editgroup_id index on editor table
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init')
-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 a8318f30..18139d30 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 gen_random_uuid(),
editor_id UUID REFERENCES editor(id) NOT NULL,