diff options
Diffstat (limited to 'priv/repo/migrations/20200831115854_add_unread_index_to_conversation_participation.exs')
-rw-r--r-- | priv/repo/migrations/20200831115854_add_unread_index_to_conversation_participation.exs | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/priv/repo/migrations/20200831115854_add_unread_index_to_conversation_participation.exs b/priv/repo/migrations/20200831115854_add_unread_index_to_conversation_participation.exs new file mode 100644 index 000000000..68771c655 --- /dev/null +++ b/priv/repo/migrations/20200831115854_add_unread_index_to_conversation_participation.exs @@ -0,0 +1,12 @@ +defmodule Pleroma.Repo.Migrations.AddUnreadIndexToConversationParticipation do + use Ecto.Migration + + def change do + create( + index(:conversation_participations, [:user_id], + where: "read = false", + name: "unread_conversation_participation_count_index" + ) + ) + end +end |