20190213185503_change_apps_scopes_to_varchar_array.exs
No OneTemporary
Actions

Size

667 B

Referenced Files

None

Subscribers

None

20190213185503_change_apps_scopes_to_varchar_array.exs
View Options

	defmodule Pleroma.Repo.Migrations.ChangeAppsScopesToVarcharArray do
	use Ecto.Migration

	@alter_apps_scopes "ALTER TABLE apps ALTER COLUMN scopes"

	def up do
	execute(
	"#{@alter_apps_scopes} TYPE varchar(255)[] USING string_to_array(scopes, ',')::varchar(255)[];"
	)

	execute("#{@alter_apps_scopes} SET DEFAULT ARRAY[]::character varying[];")
	execute("#{@alter_apps_scopes} SET NOT NULL;")
	end

	def down do
	execute("#{@alter_apps_scopes} DROP NOT NULL;")
	execute("#{@alter_apps_scopes} DROP DEFAULT;")

	execute(
	"#{@alter_apps_scopes} TYPE varchar(255) USING array_to_string(scopes, ',')::varchar(255);"
	)
	end
	end

Mime Type: text/x-ruby
Expires: Sun, Feb 15, 4:35 AM (1 d, 17 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1084593
Default Alt Text: 20190213185503_change_apps_scopes_to_varchar_array.exs (667 B)