User, Migration: Change `accepts_chat_messages` to be nullable

This is to model the ambiguous state of most users.

1 files changed, 9 insertions, 4 deletions

diff --git a/priv/repo/migrations/20200703101031_add_chat_acceptance_to_users.exs b/priv/repo/migrations/20200703101031_add_chat_acceptance_to_users.exs
index 4ae3c4201..8dfda89f1 100644
--- a/priv/repo/migrations/20200703101031_add_chat_acceptance_to_users.exs
+++ b/priv/repo/migrations/20200703101031_add_chat_acceptance_to_users.exs
@@ -1,12 +1,17 @@
 defmodule Pleroma.Repo.Migrations.AddChatAcceptanceToUsers do
   use Ecto.Migration
 
-  def change do
+  def up do
     alter table(:users) do
-      add(:accepts_chat_messages, :boolean, nullable: false, default: false)
+      add(:accepts_chat_messages, :boolean, nullable: true)
     end
 
-    # Looks stupid but makes the update much faster
-    execute("update users set accepts_chat_messages = local where local = true")
+    execute("update users set accepts_chat_messages = true where local = true")
+  end
+
+  def down do
+    alter table(:users) do
+      remove(:accepts_chat_messages)
+    end
   end
 end