summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2019-05-09-051834_v0.3/down.sql
diff options
context:
space:
mode:
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.sql22
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;