Phinx sample configuration

phinx.yml.template

paths:
    migrations: %%PHINX_CONFIG_DIR%%/../migrations

environments:
    default_migration_table: _migrations
    default_database: test
    prod:
        adapter: pgsql
        host: "@@DB_SETTINGS_HOST@@"
        name: "@@DB_SETTINGS_DATABASE@@"
        user: "@@DB_SETTINGS_USERNAME@@"
        pass: "@@DB_SETTINGS_PASSWORD@@"
        charset: utf8

    dev:
        adapter: pgsql
        host: "@@DB_SETTINGS_HOST@@"
        name: "@@DB_SETTINGS_DATABASE@@"
        user: "@@DB_SETTINGS_USERNAME@@"
        pass: "@@DB_SETTINGS_PASSWORD@@"
        charset: utf8

    test:
        adapter: pgsql
        host: "@@DB_SETTINGS_TEST_HOST@@"
        name: "@@DB_SETTINGS_TEST_DATABASE@@"
        user: "@@DB_SETTINGS_TEST_USERNAME@@"
        pass: "@@DB_SETTINGS_TEST_PASSWORD@@"
        charset: utf8