Skip to content

1164 - Migration Plan

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

maml
{
  schema_version: "9.19.5"
  database: "mysql"

  migrations: [
    {
      id: "1774747430"
      name: "create_password_table"
      applied: true
    }

    {
      id: "1774833830"
      name: "alter_name_index"
      applied: true
    }

    {
      id: "1774920230"
      name: "drop_createdAt_column"
      applied: true
    }

    {
      id: "1775006630"
      name: "add_email_index"
      applied: false
    }

    {
      id: "1775093030"
      name: "drop_password_index"
      applied: false
    }

    {
      id: "1775179430"
      name: "drop_email_table"
      applied: false
    }
  ]

  environments: {
    dev: {
      host: "dev-db.nippy-traffic.com"
      port: 5432
      ssl: false
    }

    staging: {
      host: "staging-db.esteemed-feather.org"
      port: 5432
      ssl: true
    }

    prod: {
      host: "prod-db.sardonic-casket.net"
      port: 5432
      ssl: true
    }
  }
}

See Also