From 01335bc18a01a7f956558fad26bf842eb3671674 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
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/2019-05-09-051834_v0.3/up.sql')

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

