Просмотр файла database/upgrades/20180120222958_change_gender_in_users.php

<?php

use Phinx\Migration\AbstractMigration;

class ChangeGenderInUsers extends AbstractMigration
{
    /**
     * Migrate Up.
     */
    public function up()
    {
        $table = $this->table('users');
        $table
            ->changeColumn('gender', 'string')
            ->save();

        $this->execute('UPDATE users SET gender="male" WHERE gender = "1";');
        $this->execute('UPDATE users SET gender="female" WHERE gender = "2";');

        $table
            ->changeColumn('gender', 'enum', ['values' => ['male', 'female']])
            ->save();
    }

    /**
     * Migrate Down.
     */
    public function down()
    {
        $table = $this->table('users');
        $table
            ->changeColumn('gender', 'string')
            ->save();

        $this->execute('UPDATE users SET gender="1" WHERE gender = "male";');
        $this->execute('UPDATE users SET gender="2" WHERE gender = "female";');

        $table
            ->changeColumn('gender', 'boolean', ['default' => false])
            ->save();
    }
}