X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Fmigrations%2F20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs;h=f5e5cd269809e708198d22db35c502831f8c78c8;hb=e4e3fd7e5552db274655d58bbbec1e4faabf7ccd;hp=12eea136923b23924d34a5548e1fb34fc3b9fd78;hpb=b403ea4d2b69cef4434ad68babdfb402d8227847;p=akkoma diff --git a/priv/repo/migrations/20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs b/priv/repo/migrations/20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs index 12eea1369..f5e5cd269 100644 --- a/priv/repo/migrations/20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs +++ b/priv/repo/migrations/20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs @@ -1,10 +1,12 @@ defmodule Pleroma.Repo.Migrations.AddIdContraintsToActivitiesAndObjectsPartTwo do use Ecto.Migration - def change do - drop index(:objects, ["(data->>\"id\")"], name: :objects_unique_apid_index) - drop index(:activities, ["(data->>\"id\")"], name: :activities_unique_apid_index) - create unique_index(:objects, ["(data->>'id')"], name: :objects_unique_apid_index) - create unique_index(:activities, ["(data->>'id')"], name: :activities_unique_apid_index) + def up do + drop_if_exists index(:objects, ["(data->>\"id\")"], name: :objects_unique_apid_index) + drop_if_exists index(:activities, ["(data->>\"id\")"], name: :activities_unique_apid_index) + create_if_not_exists unique_index(:objects, ["(data->>'id')"], name: :objects_unique_apid_index) + create_if_not_exists unique_index(:activities, ["(data->>'id')"], name: :activities_unique_apid_index) end + + def down, do: :ok end