Skip to content

4177 - Migration Plan

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

maml
{
  schema_version: "0.12.8"
  database: "postgresql"

  migrations: [
    {
      id: "1777341396"
      name: "add_name_table"
      applied: true
    }

    {
      id: "1777427796"
      name: "drop_comment_index"
      applied: true
    }

    {
      id: "1777514196"
      name: "alter_status_column"
      applied: true
    }

    {
      id: "1777600596"
      name: "drop_status_column"
      applied: false
    }

    {
      id: "1777686996"
      name: "alter_status_column"
      applied: false
    }

    {
      id: "1777773396"
      name: "create_category_column"
      applied: false
    }
  ]

  environments: {
    dev: {
      host: "dev-db.extra-large-milestone.name"
      port: 5432
      ssl: false
    }

    staging: {
      host: "staging-db.better-morbidity.info"
      port: 5432
      ssl: true
    }

    prod: {
      host: "prod-db.wealthy-platter.name"
      port: 5432
      ssl: true
    }
  }
}

See Also