lemmy/migrations/2021-11-22-135324_add_activ.../down.sql

8 lines
175 B
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;