Current section

Files

Jump to
blossom lib blossom migrations postgres v21.ex
Raw

lib/blossom/migrations/postgres/v21.ex

defmodule Blossom.Migrations.Postgres.V21 do
use Ecto.Migration
def up(_opts) do
create table(:roles_definitions, primary_key: false) do
add(:id, :uuid,
primary_key: true,
default: fragment("uuid_generate_v4()")
)
add(:permissions, {:array, :string})
add(:name, :text, null: false)
add(:slug, :text, null: false)
add(
:realm,
references(:realms, type: :uuid, on_delete: :delete_all),
null: false
)
add(:inserted_at, :utc_datetime,
null: false,
default: fragment("now()")
)
add(:updated_at, :utc_datetime, null: false, default: fragment("now()"))
end
create(unique_index(:roles_definitions, [:realm, :slug]))
end
def down(_opts) do
drop(table(:roles_definitions))
end
end