path: root/migrations/2018-04-05-190159_add_data_indexes/up.sql

-- note: pgcrypto extension must exist for this database

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