Adding unique constraint for activity ap_id. Fixes #1878 (#1935)

[lemmy.git] / migrations / 2021-11-22-135324_add_activity_ap_id_index / down.sql

alter table activity alter column ap_id drop not null;

create unique index idx_activity_unique_apid on activity ((data ->> 'id'::text));

drop index idx_activity_ap_id;