Files F41646435

20190213185503_change_apps_scopes_to_varchar_array.exs
No OneTemporary
Actions

Size

635 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

File Metadata

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

Event Timeline