Adding a 'enum' MySQL field type with Phinx Migrate

Question

I'm trying to create a migration in Phinx (actually a rollback) which will create a enum type field in a MySQL DB. Having read the docs I was under the impression that this should be pretty simple but it just fails every time.

$table = $this->table('mytable');
$table->addColumn('warmth','enum', array('limit' => array('1', '2', '3', '4', '5', 'P', 'A', 'B', 'C', 'D', 'X', 'N')))
->save();

Unfortunately there's no easy way to have Phinx output the offending SQL query either.

hshhhhh.name · Accepted Answer · 2019-04-03T11:53:50.413

25

Use latest version from master (above 0.5.x-dev):

$this->table('my_table')
->addColumn('status', 'enum', ['values' => ['enabled', 'disabled']])
->save();

edited Apr 03 '19 at 11:53

answered Mar 03 '16 at 14:57

hshhhhh.name

366
3
4

1

For those who care, it's the same for `set` column type. – IMB Jan 09 '20 at 15:59

score 2 · Answer 2 · answered Nov 30 '19 at 21:26

Maybe for others it will be interesting that there is another way to add an ENUM column

use Phinx\Db\Adapter\MysqlAdapter;
use Phinx\Db\Table\Column;

$this->table('posts')
    ->addColumn(
        (new Column())
            ->setName('status')
            ->setType(MysqlAdapter::PHINX_TYPE_ENUM)
            ->setValues([
                'draft', 'publish', 'private', 'trash',
            ])
    )
    ->update();

Adding a 'enum' MySQL field type with Phinx Migrate

2 Answers2