1 defmodule Pleroma.Repo.Migrations.AddCorrectDMIndex do
3 @disable_ddl_transaction true
7 index(:activities, ["activity_visibility(actor, recipients, data)"],
8 name: :activities_visibility_index
13 index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC NULLS LAST"],
14 name: :activities_visibility_index,
16 where: "data->>'type' = 'Create'"
23 index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC"],
24 name: :activities_visibility_index,
26 where: "data->>'type' = 'Create'"