]> Untitled Git - lemmy.git/blob - migrations/2021-11-22-135324_add_activity_ap_id_index/down.sql
Revert "Attempt to fix CI building wrong commits (#3830)"
[lemmy.git] / migrations / 2021-11-22-135324_add_activity_ap_id_index / down.sql
1 ALTER TABLE activity
2     ALTER COLUMN ap_id DROP NOT NULL;
3
4 CREATE UNIQUE INDEX idx_activity_unique_apid ON activity ((data ->> 'id'::text));
5
6 DROP INDEX idx_activity_ap_id;
7