CakePHP 3 migration missing enum

Question

I have a question;

Has anyone experienced to migrate a table using CakePHP 3 Migration Tool that when a specific field is an ENUM data type, the migration script automatically converts it into string or text.

How can I avoid it and how can I maintain the data type from ENUM?

Thanks

Answer 1

It depends on the driver in use, since enum is not supported by all database systems. For the MySQL driver, using the enum type will result in the appropriate DDL.

Migration class:

public function up()
{
    $table = $this->table('testenum');
    $table
        ->addColumn('enum_column', 'enum', [
            'values' => ['one', 'two']
        ])
        ->create();
}

DDL:

CREATE TABLE `testenum` (
  `enum_column` enum('one','two') NOT NULL,
  PRIMARY KEY (`id`)
) 

In the Phinx package, enum is present only in the MysqlAdapter.