diff options
| author | Roger Braun <roger@rogerbraun.net> | 2017-06-20 16:25:28 +0200 |
|---|---|---|
| committer | Roger Braun <roger@rogerbraun.net> | 2017-06-20 16:25:28 +0200 |
| commit | 07cee92cd4a28d4863dab6c8ccfd4cbfdd49b42a (patch) | |
| tree | 63d1ec9795a30acbbe586f90ecdfc2ead6cd3c73 | |
| parent | 9cf38d679671181cf539883981f92e6777beb951 (diff) | |
| download | pleroma-07cee92cd4a28d4863dab6c8ccfd4cbfdd49b42a.tar.gz | |
Add correct index.
| -rw-r--r-- | priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs b/priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs new file mode 100644 index 000000000..705a05f82 --- /dev/null +++ b/priv/repo/migrations/20170620142420_add_object_activity_index_part_two.exs @@ -0,0 +1,8 @@ +defmodule Pleroma.Repo.Migrations.AddObjectActivityIndexPartTwo do + use Ecto.Migration + + def change do + drop index(:objects, ["(data->'object'->>'id')", "(data->>'type')"], name: :activities_create_objects_index) + create index(:activities, ["(data->'object'->>'id')", "(data->>'type')"], name: :activities_create_objects_index) + end +end |