git.squeep.com Git - akkoma/blob - priv/repo/migrations/20201012173004_refactor_deactivated_user_field.exs

   1 defmodule Pleroma.Repo.Migrations.RefactorDeactivatedUserField do
   2   use Ecto.Migration
   3
   4   def up do
   5     # Flip the values before we change the meaning of the column
   6     execute("UPDATE users SET deactivated = NOT deactivated;")
   7     execute("ALTER TABLE users RENAME COLUMN deactivated TO is_active;")
   8     execute("ALTER TABLE users ALTER COLUMN is_active SET DEFAULT true;")
   9     execute("ALTER INDEX users_deactivated_index RENAME TO users_is_active_index;")
  10   end
  11
  12   def down do
  13     execute("UPDATE users SET is_active = NOT is_active;")
  14     execute("ALTER TABLE users RENAME COLUMN is_active TO deactivated;")
  15     execute("ALTER TABLE users ALTER COLUMN deactivated SET DEFAULT false;")
  16     execute("ALTER INDEX users_is_active_index RENAME TO users_deactivated_index;")
  17   end
  18 end