From 89b04e5f716ac486f42ea8c55976ce7231ef692e Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 8 May 2019 23:39:34 -0700 Subject: first draft of SQL schema changes --- rust/migrations/2019-05-09-051834_v0.3/down.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 rust/migrations/2019-05-09-051834_v0.3/down.sql (limited to 'rust/migrations/2019-05-09-051834_v0.3/down.sql') diff --git a/rust/migrations/2019-05-09-051834_v0.3/down.sql b/rust/migrations/2019-05-09-051834_v0.3/down.sql new file mode 100644 index 00000000..bd060a69 --- /dev/null +++ b/rust/migrations/2019-05-09-051834_v0.3/down.sql @@ -0,0 +1,22 @@ +-- This file should undo anything in `up.sql` + +ALTER TABLE release_contrib +DROP COLUMN given_name, +DROP COLUMN surname; + +ALTER TABLE release_rev +RENAME COLUMN release_stage TO release_status; + +ALTER TABLE release_rev +DROP COLUMN number, +DROP COLUMN version, +DROP COLUMN subtitle, +DROP COLUMN withdrawn_state, +DROP COLUMN withdrawn_date, +DROP COLUMN withdrawn_year, +DROP COLUMN mag_id, +DROP COLUMN ark_id; + +ALTER TABLE webcapture_rev_cdx +DROP COLUMN size_bytes, +DROP COLUMN extra_json; -- cgit v1.2.3