summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWilliam Pitcock <nenolod@dereferenced.org>2019-01-27 15:15:33 +0000
committerWilliam Pitcock <nenolod@dereferenced.org>2019-01-27 15:15:33 +0000
commit15d12a69a4ac627d7c28226234645a23360279a5 (patch)
treee79042fdde4de8e8f73298930b9600a080098fef
parent5eb81d2c72c593d5b7dfb893827c0685467c21ca (diff)
downloadpleroma-15d12a69a4ac627d7c28226234645a23360279a5.tar.gz
pleroma-15d12a69a4ac627d7c28226234645a23360279a5.zip
add activities likes index, fixes favorites API call
-rw-r--r--priv/repo/migrations/20190127151220_add_activities_likes_index.exs8
1 files changed, 8 insertions, 0 deletions
diff --git a/priv/repo/migrations/20190127151220_add_activities_likes_index.exs b/priv/repo/migrations/20190127151220_add_activities_likes_index.exs
new file mode 100644
index 000000000..b1822d265
--- /dev/null
+++ b/priv/repo/migrations/20190127151220_add_activities_likes_index.exs
@@ -0,0 +1,8 @@
+defmodule Pleroma.Repo.Migrations.AddActivitiesLikesIndex do
+ use Ecto.Migration
+ @disable_ddl_transaction true
+
+ def change do
+ create index(:activities, ["((data #> '{\"object\",\"likes\"}'))"], concurrently: true, name: :activities_likes, using: :gin)
+ end
+end