Packages

boruta

3.0.0-beta.2
3.0.0-beta.4 3.0.0-beta.3 3.0.0-beta.2 3.0.0-beta.1 2.3.6 2.3.5 2.3.4 2.3.3 2.3.2 2.3.1 2.3.0 2.2.2 2.2.1 2.2.0 2.1.5 2.1.4 2.1.3 2.1.2 2.1.1 2.1.0 2.0.1 2.0.0 2.0.0-rc.1 2.0.0-rc.0 1.2.1 1.2.0 1.1.0 1.0.3 1.0.2 1.0.1 1.0.0 1.0.0-rc.3 1.0.0-rc.2 1.0.0-rc.1 1.0.0-rc.0 0.2.1 0.2.0 0.1.1 0.1.0 0.1.0-rc.5 0.1.0-rc.4 0.1.0-rc.3 0.1.0-rc.2 0.1.0-rc.1

Core of an OAuth/OpenID Connect provider enabling authorization in your applications.

HexDocs

Current section

Files

Jump to
Readme
44 Versions
14 Dependencies
Dependants
Files
Activity
boruta priv boruta migrations 20210824001622_create_boruta.ex
Raw

priv/boruta/migrations/20210824001622_create_boruta.ex 

defmodule Boruta.Migrations.CreateBoruta do

  @moduledoc false



  defmacro __using__(_args) do

    quote do

      def change do

        create table(:clients, primary_key: false) do

          add(:id, :uuid, primary_key: true)

          add(:name, :string, default: "", null: false)

          add(:secret, :string, null: false)

          add(:redirect_uris, {:array, :string}, default: [], null: false)

          add(:scope, :string)

          add(:authorize_scope, :boolean, default: false, null: false)

          add(:supported_grant_types, {:array, :string}, default: [], null: false)

          add(:authorization_code_ttl, :integer, null: false)

          add(:access_token_ttl, :integer, null: false)

          add(:pkce, :boolean, default: false, null: false)

          add(:public_key, :text, null: false)

          add(:private_key, :text, null: false)



          timestamps()

        end



        create table(:tokens, primary_key: false) do

          add(:id, :uuid, primary_key: true)

          add(:type, :string)

          add(:value, :string)

          add(:refresh_token, :string)

          add(:expires_at, :integer)

          add(:redirect_uri, :string)

          add(:state, :string)

          add(:scope, :string)

          add(:revoked_at, :utc_datetime_usec)

          add(:code_challenge_hash, :string)

          add(:code_challenge_method, :string)



          add(:client_id, references(:clients, type: :uuid, on_delete: :nilify_all))

          add(:sub, :string)



          timestamps(type: :utc_datetime_usec)

        end



        create table(:scopes, primary_key: false) do

          add(:id, :binary_id, primary_key: true)

          add(:label, :string)

          add(:name, :string)

          add(:public, :boolean, default: false, null: false)



          timestamps()

        end



        create table(:clients_scopes) do

          add(:client_id, references(:clients, type: :uuid, on_delete: :delete_all))

          add(:scope_id, references(:scopes, type: :uuid, on_delete: :delete_all))

        end



        create(unique_index(:clients, [:id, :secret]))

        create(index("tokens", [:value]))

        create(unique_index("tokens", [:client_id, :value]))

        create(unique_index("tokens", [:client_id, :refresh_token]))

        create(unique_index("scopes", [:name]))

      end

    end

  end

end