Git of dcc - anni/blob - priv/repo/migrations/20190204200237_add_correct_dm_index.exs

   1 # Pleroma: A lightweight social networking server
   2 # Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
   3 # SPDX-License-Identifier: AGPL-3.0-only
   4
   5 defmodule Pleroma.Repo.Migrations.AddCorrectDMIndex do
   6   use Ecto.Migration
   7   @disable_ddl_transaction true
   8
   9   def up do
  10     drop_if_exists(
  11       index(:activities, ["activity_visibility(actor, recipients, data)"],
  12         name: :activities_visibility_index
  13       )
  14     )
  15
  16     create(
  17       index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC NULLS LAST"],
  18         name: :activities_visibility_index,
  19         concurrently: true,
  20         where: "data->>'type' = 'Create'"
  21       )
  22     )
  23   end
  24
  25   def down do
  26     drop_if_exists(
  27       index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC"],
  28         name: :activities_visibility_index,
  29         concurrently: true,
  30         where: "data->>'type' = 'Create'"
  31       )
  32     )
  33   end
  34 end