Missing support for not nullable and default value using ENUM type for MySQL database

[batopa]

#910 partially restored the ability to set column as enum for MySQL.

We have many enum columns defined as NOT NULLABLE and with a default value, for example

$this->table('objects')
    ->addColumn('status', 'enum', [
            'comment' => 'object status: on, draft, off, deleted',
            'default' => 'draft', // not working anymore
            'values' => ['on', 'off', 'draft'],
            'null' => false, // not working anymore
    ]);

adds an enum column NULLABLE with default NULL. Moreover (less important) the comment is missing.

[dereuromark]

Small note:

When you use

'comment' => '[enum] on, draft, off, deleted'

it will also auto bake the PHP enum from it.

At least it should, based on what the behavior is for "normal" enums using varchar etc.

[batopa]

Ohhh, very interesting. Then how can I access those baked enums?

[dereuromark]

Check out
https://www.dereuromark.de/2024/01/30/enums-in-cakephp-reloaded/