priv/repo/migrations/20190213185600_data_migration_populate_o_auth_scopes.exs


1
2
3
4
5
6
7
8
9
10
11

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

  def up do
    for t <- [:oauth_authorizations, :oauth_tokens] do
      execute("UPDATE #{t} SET scopes = apps.scopes FROM apps WHERE #{t}.app_id = apps.id;")
    end
  end

  def down, do: :noop
end