Current section

Files

Jump to
blossom lib blossom migrations postgres v11.ex
Raw

lib/blossom/migrations/postgres/v11.ex

defmodule Blossom.Migrations.Postgres.V11 do
use Ecto.Migration
def up(_opts) do
create table(:realms, primary_key: false) do
add(:id, :uuid,
primary_key: true,
default: fragment("uuid_generate_v4()")
)
add(:name, :text, null: false)
add(:slug, :text, 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(:realms, [:name]))
create(unique_index(:realms, [:slug]))
end
def down(_opts) do
drop(table(:realms))
end
end