Skip to content

171 - Migration Plan

Database migration plan across environments. This is an example of a MAML document.

maml
{
  schema_version: "1.2.5"
  database: "mysql"

  migrations: [
    {
      id: "1773882790"
      name: "drop_updatedAt_index"
      applied: true
    }

    {
      id: "1773969190"
      name: "drop_email_table"
      applied: true
    }

    {
      id: "1774055590"
      name: "create_name_table"
      applied: true
    }

    {
      id: "1774141990"
      name: "add_password_table"
      applied: false
    }

    {
      id: "1774228390"
      name: "alter_updatedAt_column"
      applied: false
    }

    {
      id: "1774314790"
      name: "alter_group_table"
      applied: false
    }
  ]

  environments: {
    dev: {
      host: "dev-db.indelible-hubris.org"
      port: 5432
      ssl: false
    }

    staging: {
      host: "staging-db.dismal-meal.biz"
      port: 5432
      ssl: true
    }

    prod: {
      host: "prod-db.idolized-importance.com"
      port: 5432
      ssl: true
    }
  }
}

See Also