diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2021-10-12 16:46:54 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2021-10-13 16:21:30 -0700 |
| commit | 31c96eb15af54c90e4d048dfe82cc580a0679a13 (patch) | |
| tree | 57db7fc4634f7bd20ffa8e760d775ac0c59f7e59 /rust/migrations/2021-10-12-215817_v0.4/down.sql | |
| parent | d4351119368184a32f07bb197d923a87bab4552b (diff) | |
| download | fatcat-31c96eb15af54c90e4d048dfe82cc580a0679a13.tar.gz fatcat-31c96eb15af54c90e4d048dfe82cc580a0679a13.zip | |
sql: v0.4 schema implementation (as diesel migration)
Diffstat (limited to 'rust/migrations/2021-10-12-215817_v0.4/down.sql')
| -rw-r--r-- | rust/migrations/2021-10-12-215817_v0.4/down.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/rust/migrations/2021-10-12-215817_v0.4/down.sql b/rust/migrations/2021-10-12-215817_v0.4/down.sql new file mode 100644 index 00000000..d4d35681 --- /dev/null +++ b/rust/migrations/2021-10-12-215817_v0.4/down.sql @@ -0,0 +1,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'; |