summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2019-01-01-000000_init
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2019-01-09 13:06:11 -0800
committerBryan Newbold <bnewbold@robocracy.org>2019-01-09 13:06:11 -0800
commitad58e900247ca9be2b29ea8f926c4120e1c9501a (patch)
tree68b0f59daf1a1b66b1bd4061ef13c076f106a81e /rust/migrations/2019-01-01-000000_init
parentcbf615dda68367600c47c6867d27737c0113ca39 (diff)
downloadfatcat-ad58e900247ca9be2b29ea8f926c4120e1c9501a.tar.gz
fatcat-ad58e900247ca9be2b29ea8f926c4120e1c9501a.zip
start removing active editgroup code
Diffstat (limited to 'rust/migrations/2019-01-01-000000_init')
-rw-r--r--rust/migrations/2019-01-01-000000_init/up.sql8
1 files changed, 2 insertions, 6 deletions
diff --git a/rust/migrations/2019-01-01-000000_init/up.sql b/rust/migrations/2019-01-01-000000_init/up.sql
index ddaa60b3..a3dd13a5 100644
--- a/rust/migrations/2019-01-01-000000_init/up.sql
+++ b/rust/migrations/2019-01-01-000000_init/up.sql
@@ -23,13 +23,11 @@ CREATE TABLE editor (
is_active BOOLEAN NOT NULL DEFAULT true,
registered TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL,
auth_epoch TIMESTAMP WITH TIME ZONE DEFAULT now() NOT NULL,
- wrangler_id UUID REFERENCES editor(id),
- active_editgroup_id UUID -- REFERENCES( editgroup(id) via ALTER below
+ wrangler_id UUID REFERENCES editor(id)
);
-- case-insensitive UNIQ index on username
CREATE UNIQUE INDEX editor_username_uniq_idx on editor(lower(username));
-CREATE INDEX active_editgroup_idx ON editor(active_editgroup_id);
CREATE INDEX editor_username_idx ON editor(username);
CREATE TABLE auth_oidc (
@@ -51,9 +49,7 @@ CREATE TABLE editgroup (
description TEXT
);
-ALTER TABLE editor
- ADD CONSTRAINT editor_editgroupid_fkey FOREIGN KEY (active_editgroup_id)
- REFERENCES editgroup(id);
+CREATE INDEX editgroup_created_idx ON editgroup(created);
CREATE TABLE changelog (
id BIGSERIAL PRIMARY KEY,