git.squeep.com Git - akkoma/blob - priv/repo/migrations/20200604150318_migrate_seen_to_unread_in_chat_message_references.exs

   1 defmodule Pleroma.Repo.Migrations.MigrateSeenToUnreadInChatMessageReferences do
   2   use Ecto.Migration
   3
   4   def change do
   5     drop(
   6       index(:chat_message_references, [:chat_id],
   7         where: "seen = false",
   8         name: "unseen_messages_count_index"
   9       )
  10     )
  11
  12     alter table(:chat_message_references) do
  13       add(:unread, :boolean, default: true)
  14     end
  15
  16     execute("update chat_message_references set unread = not seen")
  17
  18     alter table(:chat_message_references) do
  19       modify(:unread, :boolean, default: true, null: false)
  20       remove(:seen, :boolean, default: false, null: false)
  21     end
  22
  23     create(
  24       index(:chat_message_references, [:chat_id],
  25         where: "unread = true",
  26         name: "unread_messages_count_index"
  27       )
  28     )
  29   end
  30 end