pleroma

commit: 22878cf84afd3f8b844c66e99f37022318c4c55e
parent 10dfa107d5d5d3b6fa7c13eb005c4cd5b6b94661
Author: Lain Soykaf <lain@lain.com>
Date:   Sun, 11 Jun 2023 16:22:16 +0400

B Migrations: Don't remove activity_visibility_index for now.

Diffstat:
M
priv/repo/migrations/20230422154018_drop_unused_indexes.exs
15
---------------

1 file 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
@@ -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