aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRoger Braun <rbraun@Bobble.local>2017-11-09 15:16:10 +0100
committerRoger Braun <rbraun@Bobble.local>2017-11-09 15:16:10 +0100
commitccde03285debe8def5d89d49b9afdcc48a76d7a6 (patch)
treee4ddc0c98ca476771be8381e5475abb994aa7d3d
parent9e60de695db74bbe66c2be411ec85420b0ff54a7 (diff)
downloadpleroma-ccde03285debe8def5d89d49b9afdcc48a76d7a6.tar.gz
add sort index for activities
-rw-r--r--priv/repo/migrations/20171109141309_add_sort_index_to_activities.exs8
1 files changed, 8 insertions, 0 deletions
diff --git a/priv/repo/migrations/20171109141309_add_sort_index_to_activities.exs b/priv/repo/migrations/20171109141309_add_sort_index_to_activities.exs
new file mode 100644
index 000000000..2d21c56ca
--- /dev/null
+++ b/priv/repo/migrations/20171109141309_add_sort_index_to_activities.exs
@@ -0,0 +1,8 @@
+defmodule Pleroma.Repo.Migrations.AddSortIndexToActivities do
+ use Ecto.Migration
+ @disable_ddl_transaction true
+
+ def change do
+ create index(:activities, ["id desc nulls last"], concurrently: true)
+ end
+end