Test removed HTTP adapter

[akkoma] / priv / repo / migrations / 20221211234352_remove_unused_indices.exs

diff --git a/priv/repo/migrations/20221211234352_remove_unused_indices.exs b/priv/repo/migrations/20221211234352_remove_unused_indices.exs
new file mode 100644 (file)
index 0000000..facc85a
--- /dev/null
+++ b/priv/repo/migrations/20221211234352_remove_unused_indices.exs
@@ -0,0 +1,11 @@
+defmodule Pleroma.Repo.Migrations.RemoveUnusedIndices do
+  use Ecto.Migration
+
+  def change do
+    drop_if_exists(
+      index(:activities, ["(data->>'actor')", "inserted_at desc"], name: :activities_actor_index)
+    )
+
+    drop_if_exists(index(:objects, ["(data->'tag')"], using: :gin, name: :objects_tags))
+  end
+end