From f48bc5c3e1507c485d0515a4800e2123f848705f Mon Sep 17 00:00:00 2001 From: lain Date: Wed, 21 Feb 2018 22:20:29 +0100 Subject: Make User.following a postgres array. --- .../20180221210540_make_following_postgres_array.exs | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 priv/repo/migrations/20180221210540_make_following_postgres_array.exs (limited to 'priv/repo/migrations/20180221210540_make_following_postgres_array.exs') diff --git a/priv/repo/migrations/20180221210540_make_following_postgres_array.exs b/priv/repo/migrations/20180221210540_make_following_postgres_array.exs new file mode 100644 index 000000000..98ca7d9d7 --- /dev/null +++ b/priv/repo/migrations/20180221210540_make_following_postgres_array.exs @@ -0,0 +1,18 @@ +defmodule Pleroma.Repo.Migrations.MakeFollowingPostgresArray do + use Ecto.Migration + + def change do + alter table(:users) do + add :following_temp, {:array, :string} + end + + execute """ + update users set following_temp = array(select jsonb_array_elements_text(following)); + """ + + alter table(:users) do + remove :following + end + rename table(:users), :following_temp, to: :following + end +end -- cgit v1.2.3