Current section
Files
Jump to
Current section
Files
priv/rivet/migrations/user_ident/base.exs
defmodule Rivet.Ident.UserIdent.Migrations.Base do
@moduledoc false
use Ecto.Migration
def change do
create table(:user_idents, primary_key: false) do
add(:origin, :string, primary_key: true)
add(:ident, :binary, primary_key: true)
add(:user_id, references(:users, on_delete: :delete_all, type: :uuid))
timestamps()
end
create(index(:user_idents, [:user_id]))
# only one user per origin ID
create(unique_index(:user_idents, [:origin, :ident]))
end
end