You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
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;