1 defmodule Pleroma.Repo.Migrations.ChangeAppsScopesToVarcharArray do
4 @alter_apps_scopes "ALTER TABLE apps ALTER COLUMN scopes"
7 execute "#{@alter_apps_scopes} TYPE varchar(255)[] USING string_to_array(scopes, ',')::varchar(255)[];"
8 execute "#{@alter_apps_scopes} SET DEFAULT ARRAY[]::character varying[];"
9 execute "#{@alter_apps_scopes} SET NOT NULL;"
13 execute "#{@alter_apps_scopes} DROP NOT NULL;"
14 execute "#{@alter_apps_scopes} DROP DEFAULT;"
15 execute "#{@alter_apps_scopes} TYPE varchar(255) USING array_to_string(scopes, ',')::varchar(255);"