? ??????? ??? ??? ?? ??????? ??? ??????? ???? ?? ??????. ? ?????? ?????? ???? ??, ??? ? ???? ?? ?????. ??? ???? ?? ? ??? ?? ??? ?? ????? ??? ??????? ?????? ??? ??? ?? ? ??? ?????.

Phinx? ???? ?????? ?????? ? ?????? ??? ?? PHP ????????. ?? ?? PHP ?????? ThinkPHP6? ?? ??? ???? ? ?? Phinx ?? ??? ?????.

? ????? ThinkPHP6 ??????? Phinx? ???? ??????? ???????? ??? ?????.

1. Phinx ??

?? Composer? ???? ???? ????? Phinx? ?????.

composer require robmorgan/phinx

2. Phinx ??

ThinkPHP6?? Phinx ??? config/phinx.php ??? ????. ?? ?? ??? ??? ??? ?? ??? ? ????:

vendor/bin/phinx init

?? ? phinx.php ??? config ????? ?????. ?????? ?? ??? ???? ?? ? ?? ??? ???? ???.

?? ?? ?????? ?? ?? ??:

return [
    'paths' => [
        'migrations' => '%%PHINX_CONFIG_DIR%%/db/migrations',
        'seeds' => '%%PHINX_CONFIG_DIR%%/db/seeds'
    ],
    'environments' => [
        'default_database' => 'development',
        'development' => [
            'adapter' => 'mysql',
            'host' => '127.0.0.1',
            'name' => 'thinkphp6',
            'user' => 'root',
            'pass' => '123456',
            'charset' => 'utf8',
        ]
    ]
];

3. Create ?????? ??????

ThinkPHP6?? Phinx ?????? ??????? ??????/?????? ????? ?????. ?? ??? ???? ? ??????? ??? ? ????:

vendor/bin/phinx create MyNewMigration

? ??? ???? ??????/?????? ????? ? ?????? ??? ?????.

Phinx??? ??????? ??????? ??? ? ?? ???? ????. ???????? ??????? ?? ?? ??? ????, ??? ??????? ??? ?????.

?? ??, ??? ???? ???? ???:

use PhinxMigrationAbstractMigration;

class CreateUsersTable extends AbstractMigration
{
    /**
     * Change Method.
     *
     * More information on this method is available here:
     * http://docs.phinx.org/en/latest/migrations.html#the-change-method
     */
    public function change()
    {
        $table = $this->table('users');
        $table->addColumn('username', 'string', ['limit' => 50])
              ->addColumn('email', 'string', ['limit' => 100])
              ->addColumn('password', 'string', ['limit' => 255])
              ->addColumn('created_at', 'datetime')
              ->addColumn('updated_at', 'datetime')
              ->create();
    }
}

change() ????? $table ??? ???? ??? ??? ???? addColumn() ???? ???? ??? ?? ?? ??? ?? ? ?? ??? ?????. . ????? create() ???? ???? ??????? ??? ??? ?????.

4. ?????? ?????? ??

?? ??? ???? ??????? ??? ? ????.

vendor/bin/phinx migrate

Phinx? ??????? ??? ???? ?? ??? ?????. ?? ??????? ????? ???? Phinx? ??????? phinxlog?? ???? ???? ?????? ??? ?????.

??: ??????? ???? ??????? ?????. ??? ???? ?? ???? ????? ???? ?????.

5. ?????? ?????? ??

??? ????? ?? ??? ???? ?? ?? ?? ??? ???? ??? ??????? ??? ? ????.

vendor/bin/phinx rollback

Phinx? ????? ????? ??? ??????(???? ??)? ?????. . Phinx? ??????? ??? ? phinxlog ???? ??? ?????.

6. ??

?? ThinkPHP6?? Phinx? ??? ?????? ?????? ?????. Phinx? ???? ?? ??? SQL? ???? ??? ???? ?????? ?????? ????? ?? ?? ?? ??????.

?????? ???? ?? ??? ???, ??? ??, ?? ?????? ??? ?? Phinx? ?? ??? ??? ? ????. ??? ??? ?????? ?? ???? ??? ?? ???? ? ????.

?? ????? ??? ??? ???? ???? ???? ?? ? ??? ???? ?????? ?????? ? ??? ?????.

? ??? ThinkPHP6?? ?????? ??????? ?? Phinx? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!