1 # Pleroma: A lightweight social networking server
2 # Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
3 # SPDX-License-Identifier: AGPL-3.0-only
5 defmodule Pleroma.Repo.Migrations.AddCorrectDMIndex do
7 @disable_ddl_transaction true
11 index(:activities, ["activity_visibility(actor, recipients, data)"],
12 name: :activities_visibility_index
17 index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC NULLS LAST"],
18 name: :activities_visibility_index,
20 where: "data->>'type' = 'Create'"
27 index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC"],
28 name: :activities_visibility_index,
30 where: "data->>'type' = 'Create'"