B Migrations: Don't remove activity_visibility_index for now.

1 files changed, 0 insertions, 15 deletions

diff --git a/priv/repo/migrations/20230422154018_drop_unused_indexes.exs b/priv/repo/migrations/20230422154018_drop_unused_indexes.exs
index f2ba6b8df..0d877a798 100644
--- a/priv/repo/migrations/20230422154018_drop_unused_indexes.exs
+++ b/priv/repo/migrations/20230422154018_drop_unused_indexes.exs
@@ -22,13 +22,6 @@ defmodule Pleroma.Repo.Migrations.DropUnusedIndexes do
     drop_if_exists(
       index(:activities, ["((data #> '{\"object\",\"likes\"}'))"], name: :activities_likes)
     )
-
-    drop_if_exists(
-      index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC NULLS LAST"],
-        name: :activities_visibility_index,
-        where: "data->>'type' = 'Create'"
-      )
-    )
   end
 
   def down do
@@ -76,13 +69,5 @@ defmodule Pleroma.Repo.Migrations.DropUnusedIndexes do
         concurrently: true
       )
     )
-
-    create_if_not_exists(
-      index(:activities, ["activity_visibility(actor, recipients, data)", "id DESC NULLS LAST"],
-        name: :activities_visibility_index,
-        where: "data->>'type' = 'Create'",
-        concurrently: true
-      )
-    )
   end
 end