commit: 662e95e9484a46bfc72c2edc305aefae99ff68b0
parent: 9789e000b05621435dc0c03833f564481e0b80e6
Author: lambda <lain@soykaf.club>
Date: Mon, 3 Jun 2019 19:03:35 +0000
Merge branch 'fix/tag-timeline-missing-index' into 'develop'
Add missing tag index on objects
Closes #867
See merge request pleroma/pleroma!1241
Diffstat:
1 file changed, 8 insertions(+), 0 deletions(-)
diff --git a/priv/repo/migrations/20190603173419_add_tag_index_to_objects.exs b/priv/repo/migrations/20190603173419_add_tag_index_to_objects.exs
@@ -0,0 +1,8 @@
+defmodule Pleroma.Repo.Migrations.AddTagIndexToObjects do
+ use Ecto.Migration
+
+ def change do
+ drop_if_exists index(:activities, ["(data #> '{\"object\",\"tag\"}')"], using: :gin, name: :activities_tags)
+ create index(:objects, ["(data->'tag')"], using: :gin, name: :objects_tags)
+ end
+end