summaryrefslogtreecommitdiffstats
path: root/rust/migrations
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2019-05-23 10:57:52 -0700
committerBryan Newbold <bnewbold@robocracy.org>2019-05-23 10:57:52 -0700
commit01335bc18a01a7f956558fad26bf842eb3671674 (patch)
tree9310b20bb51b8832140da8605a888b3e67b68fb0 /rust/migrations
parentbbc4ff2e2dbaf024251fe642cd1cca91f921f5b6 (diff)
downloadfatcat-01335bc18a01a7f956558fad26bf842eb3671674.tar.gz
fatcat-01335bc18a01a7f956558fad26bf842eb3671674.zip
minor cleanups to SQL migration
Diffstat (limited to 'rust/migrations')
-rw-r--r--rust/migrations/2019-05-09-051834_v0.3/up.sql12
1 files changed, 1 insertions, 11 deletions
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