Current section

Files

Jump to
rivet_ident priv rivet migrations handle base.exs
Raw

priv/rivet/migrations/handle/base.exs

defmodule Rivet.Ident.Handle.Migrations.Base do
@moduledoc false
use Ecto.Migration
def change do
############################################################################
# separate username so it can be left blank and not have unique constraint problems
create table(:user_handles, primary_key: false) do
add(:id, :uuid, primary_key: true)
add(:user_id, references(:users, on_delete: :delete_all, type: :uuid), null: false)
add(:handle, :citext, null: false)
timestamps()
end
create(unique_index(:user_handles, [:handle]))
create(index(:user_handles, [:user_id]))
end
end