diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2019-05-08 23:39:34 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2019-05-08 23:39:34 -0700 |
| commit | 89b04e5f716ac486f42ea8c55976ce7231ef692e (patch) | |
| tree | 7ee38537d3de3f4b7f3fdf5aa766cf9238481307 /rust/migrations/2019-05-09-051834_v0.3/down.sql | |
| parent | 92b43d6537f1d406f25f807798e706c17d5daa18 (diff) | |
| download | fatcat-89b04e5f716ac486f42ea8c55976ce7231ef692e.tar.gz fatcat-89b04e5f716ac486f42ea8c55976ce7231ef692e.zip | |
first draft of SQL schema changes
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; |