X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;ds=sidebyside;f=priv%2Frepo%2Fmigrations%2F20170620142420_add_object_activity_index_part_two.exs;h=c015afbe1da2da89c2886ce8d2309fa53e342622;hb=refs%2Fheads%2Fdevelop;hp=705a05f822a152a28667f40cbdf434cd54a7cb1e;hpb=07cee92cd4a28d4863dab6c8ccfd4cbfdd49b42a;p=akkoma diff --git a/priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs b/priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs index 705a05f82..c015afbe1 100644 --- a/priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs +++ b/priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs @@ -2,7 +2,16 @@ defmodule Pleroma.Repo.Migrations.AddObjectActivityIndexPartTwo do use Ecto.Migration def change do - drop index(:objects, ["(data->'object'->>'id')", "(data->>'type')"], name: :activities_create_objects_index) - create index(:activities, ["(data->'object'->>'id')", "(data->>'type')"], name: :activities_create_objects_index) + drop_if_exists( + index(:objects, ["(data->'object'->>'id')", "(data->>'type')"], + name: :activities_create_objects_index + ) + ) + + create_if_not_exists( + index(:activities, ["(data->'object'->>'id')", "(data->>'type')"], + name: :activities_create_objects_index + ) + ) end end