diff options
Diffstat (limited to 'rust/migrations/2019-05-09-051834_v0.3/down.sql')
-rw-r--r-- | rust/migrations/2019-05-09-051834_v0.3/down.sql | 22 |
1 files changed, 22 insertions, 0 deletions
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; |