From 01335bc18a01a7f956558fad26bf842eb3671674 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Thu, 23 May 2019 10:57:52 -0700 Subject: minor cleanups to SQL migration --- rust/migrations/2019-05-09-051834_v0.3/up.sql | 12 +----------- 1 file changed, 1 insertion(+), 11 deletions(-) (limited to 'rust/migrations') diff --git a/rust/migrations/2019-05-09-051834_v0.3/up.sql b/rust/migrations/2019-05-09-051834_v0.3/up.sql index 6b8fc2e2..06dd1d7c 100644 --- a/rust/migrations/2019-05-09-051834_v0.3/up.sql +++ b/rust/migrations/2019-05-09-051834_v0.3/up.sql @@ -18,7 +18,7 @@ ALTER TABLE release_rev ADD COLUMN number TEXT CHECK (octet_length(number) >= 1), ADD COLUMN version TEXT CHECK (octet_length(version) >= 1), ADD COLUMN subtitle TEXT CHECK (octet_length(subtitle) >= 1), -ADD COLUMN withdrawn_status TEXT, -- TODO: enum? +ADD COLUMN withdrawn_status TEXT, -- TODO: enum? ADD COLUMN withdrawn_date DATE, ADD COLUMN withdrawn_year BIGINT; @@ -58,16 +58,6 @@ CREATE INDEX IF NOT EXISTS webcapture_edit_ident_idx ON webcapture_edit(ident_id CREATE INDEX IF NOT EXISTS release_edit_ident_idx ON release_edit(ident_id); CREATE INDEX IF NOT EXISTS work_edit_ident_idx ON work_edit(ident_id); --- TODO: not needed? --- CREATE INDEX IF NOT EXISTS creator_edit_editgroup_idx ON creator_edit(editgroup_id); --- CREATE INDEX IF NOT EXISTS container_edit_editgroup_idx ON container_edit(editgroup_id); --- CREATE INDEX IF NOT EXISTS file_edit_editgroup_idx ON file_edit(editgroup_id); --- CREATE INDEX IF NOT EXISTS fileset_edit_editgroup_idx ON fileset_edit(editgroup_id); --- CREATE INDEX IF NOT EXISTS webcapture_edit_editgroup_idx ON webcapture_edit(editgroup_id); --- CREATE INDEX IF NOT EXISTS release_edit_editgroup_idx ON release_edit(editgroup_id); --- CREATE INDEX IF NOT EXISTS work_edit_editgroup_idx ON work_edit(editgroup_id); - - -------------------- Update Test Revs -------------------------------------- -- IMPORTANT: don't create new entities here, only mutate existing -- cgit v1.2.3