[FIXED] How can i add default value when i want to create new table via console

Issue

I have shell command like this. Tell me please, how can i add default value to this query ?

bin/cake bake migration CreateProducts name:string description:text created modified

Solution

You can't, it's not supported, the column definition syntax is:

fieldName:fieldType?[length]:indexType:indexName

If you want to specify a default, then you need to add that to the migration file manually using the default option of the addColumn() method, like:

$table->addColumn('name', 'string', [
    'default' => 'default value',
    // ...
]);

See also

• Cookbook > Migrations > Columns Definition
• Cookbook > Migrations > Creating a table

Answered By - ndm

Answer Checked By - Marie Seifert (PHPFixing Admin)