Dorokhov.codes

Migrations in Yii2

Adding a column:

$this->addColumn('job', 'score', $this->integer()->after('starred'));

Removing a column:

$this->dropColumn('job', 'score');

We can name it like idx-TABLE_NAME-FIELD_NAME.

Add index:

$this->createIndex(
    'idx-post-category_id',
    'post',
    'category_id'
);

Delete index:

$this->dropIndex(
    'idx-post-category_id',
    'post'
);