From ad58e900247ca9be2b29ea8f926c4120e1c9501a Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 9 Jan 2019 13:06:11 -0800 Subject: start removing active editgroup code --- rust/migrations/2019-01-01-000000_init/up.sql | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) (limited to 'rust/migrations') 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, -- cgit v1.2.3