Ecto migrations for questions, dashboards, and the audit log.

defmodule MyApp.Repo.Migrations.AddPhoenixLens do
  use Ecto.Migration

  def up, do: PhoenixLens.Migrations.up()
  def down, do: PhoenixLens.Migrations.down()
end

Upgrading an existing 0.1.x database: add another migration and call up/0 again. It is idempotent. Missing columns are added only when information_schema says they are absent, so a database that already has them does not take ACCESS EXCLUSIVE.

defmodule MyApp.Repo.Migrations.UpgradePhoenixLens do
  use Ecto.Migration

  def up, do: PhoenixLens.Migrations.up()
  def down, do: :ok
end