git.squeep.com Git - akkoma/blob - priv/repo/migrations/20180221210540_make_following_postgres_array.exs

   1 defmodule Pleroma.Repo.Migrations.MakeFollowingPostgresArray do
   2   use Ecto.Migration
   3
   4   def up do
   5     alter table(:users) do
   6       add :following_temp, {:array, :string}
   7     end
   8
   9     execute """
  10     update users set following_temp = array(select jsonb_array_elements_text(following));
  11     """
  12
  13     alter table(:users) do
  14       remove :following
  15     end
  16     rename table(:users), :following_temp, to: :following
  17   end
  18
  19   def down, do: :ok
  20 end