aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorlambda <lain@soykaf.club>2019-06-03 19:03:35 +0000
committerlambda <lain@soykaf.club>2019-06-03 19:03:35 +0000
commit662e95e9484a46bfc72c2edc305aefae99ff68b0 (patch)
tree920ebdda1969f890e60dc3626a16157c40a02e4c
parent9789e000b05621435dc0c03833f564481e0b80e6 (diff)
parentcfc3c62b2ffde1a2fbc7764ad1cbc292e7f20f74 (diff)
downloadpleroma-662e95e9484a46bfc72c2edc305aefae99ff68b0.tar.gz
Merge branch 'fix/tag-timeline-missing-index' into 'develop'
Add missing tag index on objects Closes #867 See merge request pleroma/pleroma!1241
-rw-r--r--priv/repo/migrations/20190603173419_add_tag_index_to_objects.exs8
1 files 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
new file mode 100644
index 000000000..c915a0213
--- /dev/null
+++ 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