summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2021-10-12-215817_v0.4/down.sql
blob: d4d35681c16f881e0af53170b0f4e33422d67aa7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- This file should undo anything in `up.sql`

DROP INDEX IF EXISTS container_rev_issne_idx;
DROP INDEX IF EXISTS container_rev_issnp_idx;

ALTER TABLE container_rev
DROP COLUMN issne,
DROP COLUMN issnp,
DROP COLUMN publication_status;

ALTER TABLE fileset_rev_file 
DROP COLUMN mimetype;

DELETE FROM release_rev_extid WHERE extid_type = 'hdl';