From 89b04e5f716ac486f42ea8c55976ce7231ef692e Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
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

