git.squeep.com Git - akkoma/blob - priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs

   1 defmodule Pleroma.Repo.Migrations.AddObjectActivityIndexPartTwo do
   2   use Ecto.Migration
   3
   4   def change do
   5     drop_if_exists(
   6       index(:objects, ["(data->'object'->>'id')", "(data->>'type')"],
   7         name: :activities_create_objects_index
   8       )
   9     )
  10
  11     create_if_not_exists(
  12       index(:activities, ["(data->'object'->>'id')", "(data->>'type')"],
  13         name: :activities_create_objects_index
  14       )
  15     )
  16   end
  17 end