yii2 - how to add new column with default value via schema

Question

how to add new column with default value via schema? I make as this:

$this->addColumn('users', 'email_notification', Schema::TYPE_SMALLINT . ' AFTER auth_key DEFAULT 0  ');

but it's not working..

Thanks

Answer 1

Try this, type parameter accepts ColumnSchemaBuilder as well.

$this->addColumn('users', 'email_notification', $this->smallInteger()->defaultValue(0));

Answer 2

Make sure you 'use' the yii\db\Schema

use yii\db\Schema;
use yii\db\Migration;