phinx.php

<?php declare(strict_types=1);

require __DIR__ . '/bootstrap/app.php';

return
    [
        'paths'         => [
            'migrations' => 'database/migrations',
            'seeds'      => 'database/seeds'
        ],
        'environments'  => [
            'default_migration_table' => 'phinxlog',
            'default_environment'     => 'development',
            // 'production' => [
            //     'adapter' => 'mysql',
            //     'host' => 'localhost',
            //     'name' => 'production_db',
            //     'user' => 'root',
            //     'pass' => '',
            //     'port' => '3306',
            //     'charset' => 'utf8',
            // ],
            'development'             => [
                'adapter'           => $_ENV['DB_CONNECTION'],
                'host'              => $_ENV['DB_HOST'],
                'name'              => $_ENV['DB_NAME'],
                'user'              => $_ENV['DB_USERNAME'],
                'pass'              => $_ENV['DB_PASSWORD'],
                'port'              => $_ENV['DB_PORT'],
                'charset'           => $_ENV['DB_CHARSET'],
                'additionalOptions' => [
                    PDO::MYSQL_ATTR_SSL_KEY => null,
                ]
            ],
            // 'testing' => [
            //     'adapter' => 'mysql',
            //     'host' => 'localhost',
            //     'name' => 'testing_db',
            //     'user' => 'root',
            //     'pass' => '',
            //     'port' => '3306',
            //     'charset' => 'utf8',
            // ]
        ],
        'version_order' => 'creation'
    ];