Skip to content

468 - Migration Plan

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

maml
{
  schema_version: "4.17.20"
  database: "mysql"

  migrations: [
    {
      id: "1774142599"
      name: "drop_avatar_column"
      applied: true
    }

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

    {
      id: "1774315399"
      name: "drop_email_index"
      applied: true
    }

    {
      id: "1774401799"
      name: "alter_avatar_column"
      applied: false
    }

    {
      id: "1774488199"
      name: "add_phone_table"
      applied: false
    }

    {
      id: "1774574599"
      name: "alter_name_column"
      applied: false
    }
  ]

  environments: {
    dev: {
      host: "dev-db.obedient-independence.net"
      port: 5432
      ssl: false
    }

    staging: {
      host: "staging-db.genuine-flat.biz"
      port: 5432
      ssl: true
    }

    prod: {
      host: "prod-db.colorless-term.name"
      port: 5432
      ssl: true
    }
  }
}

See Also