diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2019-05-10 15:03:46 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2019-05-10 15:03:50 -0700 |
| commit | b07f92545eaf112db735903dac8f7809fe62440a (patch) | |
| tree | 81c43ea0e2260ba330284f8fc2d5cec7aa3a07f3 /rust/migrations/2019-05-09-051834_v0.3/down.sql | |
| parent | 8e3038e55282088825a1243a34f2d9f7d25e5533 (diff) | |
| download | fatcat-b07f92545eaf112db735903dac8f7809fe62440a.tar.gz fatcat-b07f92545eaf112db735903dac8f7809fe62440a.zip | |
schema: move release ext_ids to their own table and sub-entity
Some identifiers are kept on the main release_rev table to minimize
impact to the existing database.
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 | 7 |
1 files changed, 4 insertions, 3 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 index 65e818bf..612cdbcc 100644 --- a/rust/migrations/2019-05-09-051834_v0.3/down.sql +++ b/rust/migrations/2019-05-09-051834_v0.3/down.sql @@ -13,9 +13,10 @@ DROP COLUMN version, DROP COLUMN subtitle, DROP COLUMN withdrawn_status, DROP COLUMN withdrawn_date, -DROP COLUMN withdrawn_year, -DROP COLUMN mag_id, -DROP COLUMN ark_id; +DROP COLUMN withdrawn_year; + +DROP INDEX IF EXISTS release_rev_extid_type_value_idx; +DROP TABLE release_rev_extid; ALTER TABLE webcapture_rev_cdx DROP COLUMN size_bytes; |