1 defmodule Pleroma.Repo.Migrations.MigrateSeenToUnreadInChatMessageReferences do
6 index(:chat_message_references, [:chat_id],
8 name: "unseen_messages_count_index"
12 alter table(:chat_message_references) do
13 add(:unread, :boolean, default: true)
16 execute("update chat_message_references set unread = not seen")
18 alter table(:chat_message_references) do
19 modify(:unread, :boolean, default: true, null: false)
20 remove(:seen, :boolean, default: false, null: false)
24 index(:chat_message_references, [:chat_id],
25 where: "unread = true",
26 name: "unread_messages_count_index"