blob: c015afbe1da2da89c2886ce8d2309fa53e342622 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
defmodule Pleroma.Repo.Migrations.AddObjectActivityIndexPartTwo do
use Ecto.Migration
def change do
drop_if_exists(
index(:objects, ["(data->'object'->>'id')", "(data->>'type')"],
name: :activities_create_objects_index
)
)
create_if_not_exists(
index(:activities, ["(data->'object'->>'id')", "(data->>'type')"],
name: :activities_create_objects_index
)
)
end
end
|