migrations/2018-04-06-223934_add_hash_to_data/down.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE UNIQUE INDEX audio_data on audio     (digest(data, 'sha1'));
CREATE UNIQUE INDEX image_data on images    (digest(data, 'sha1'));

DROP INDEX audio_hash;
DROP INDEX image_hash;

ALTER TABLE audio   DROP CONSTRAINT audio_hash_valid;
ALTER TABLE images  DROP CONSTRAINT image_hash_valid;

ALTER TABLE audio DROP COLUMN data_hash;
ALTER TABLE images DROP COLUMN data_hash;