Current section

Files

Jump to
rivet_ident lib ident access migrations base.exs
Raw

lib/ident/access/migrations/base.exs

defmodule Rivet.Ident.Access.Migrations.Base do
@moduledoc false
use Ecto.Migration
def change do
create table(:ident_accesses) do
add(:user_id, references(:users, on_delete: :delete_all, type: :uuid))
add(:role_id, references(:ident_roles, on_delete: :delete_all))
add(:domain, :integer, default: 0)
add(:ref_id, :binary_id, default: nil)
end
create(index(:ident_accesses, [:domain, :ref_id]))
create(
unique_index(:ident_accesses, [:user_id, :role_id, :domain, :ref_id],
name: :accesses_unique_index
)
)
end
end