diff options
| -rw-r--r-- | priv/repo/migrations/20201115114437_change_object_index_on_create_activities.exs | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/priv/repo/migrations/20201115114437_change_object_index_on_create_activities.exs b/priv/repo/migrations/20201115114437_change_object_index_on_create_activities.exs new file mode 100644 index 000000000..e2137063f --- /dev/null +++ b/priv/repo/migrations/20201115114437_change_object_index_on_create_activities.exs @@ -0,0 +1,22 @@ +defmodule Pleroma.Repo.Migrations.ChangeObjectIndexOnCreateActivities do + use Ecto.Migration + + @disable_ddl_transaction true + @disable_migration_lock true + + def change do + drop_if_exists( + index(:activities, ["(coalesce(data->'object'->>'id', data->>'object'))"], + name: :activities_create_objects_index + ) + ) + + create( + index(:activities, ["(coalesce(data->'object'->>'id', data->>'object'))"], + name: :activities_create_objects_index, + concurrently: true, + where: "data->>'type' = 'Create'" + ) + ) + end +end |