akkoma/priv/repo/migrations/20171024121413_add_object_actor_index.exs

defmodule Pleroma.Repo.Migrations.AddObjectActorIndex do
  use Ecto.Migration

  def change do
    create(index(:objects, ["(data->>'actor')", "(data->>'type')"], name: :objects_actor_type))
  end
end
Use more efficient user note count update query. 2017-10-24 06:16:17 -06:00			`defmodule Pleroma.Repo.Migrations.AddObjectActorIndex do`
			`use Ecto.Migration`

			`def change do`
cosmetic: fix concurrent index creation warnings Since those old migrations will now most likely only run during db init, there’s not much point in running them in the background concurrently anyway, so just drop the cncurrent setting rather than disabling migration locks. 2024-06-18 18:05:38 -06:00			`create(index(:objects, ["(data->>'actor')", "(data->>'type')"], name: :objects_actor_type))`
Use more efficient user note count update query. 2017-10-24 06:16:17 -06:00			`end`
			`end`