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