Current section

Files

Jump to
blossom lib blossom migrations postgres v19.ex
Raw

lib/blossom/migrations/postgres/v19.ex

defmodule Blossom.Migrations.Postgres.V19 do
use Ecto.Migration
def up(_opts) do
create table(:clients, primary_key: false) do
add(:id, :uuid,
primary_key: true,
default: fragment("uuid_generate_v4()")
)
add(:name, :text, null: false)
add(:secret, :text, null: false)
add(:slug, :text, null: false)
add(:token_expiration, :integer, null: false)
add(
:cask,
references(:casks, type: :uuid, on_delete: :delete_all),
null: false
)
add(:inserted_at, :naive_datetime,
null: false,
default: fragment("now()")
)
add(:updated_at, :naive_datetime, null: false, default: fragment("now()"))
end
create(unique_index(:clients, [:cask, :slug]))
end
def down(_opts) do
drop(index(:clients, [:cask, :slug]))
drop(table(:clients))
end
end