<?php

use yii\db\Migration;

class m161031_085215_review_fix extends Migration
{
    public function up()
    {
        $this->addColumn('{{%review}}', 'status', $this->integer());
        $this->dropForeignKey('FK_review_user', '{{%review}}');
        $this->renameColumn('{{%review}}', 'userId', 'user');
        $this->alterColumn('{{%review}}', 'user', $this->string());
        $this->alterColumn('{{%review}}', 'date', $this->date());
    }

    public function down()
    {
        $this->dropColumn('{{%review}}', 'status');
        $this->renameColumn('{{%review}}', 'user', 'userId');
        $this->alterColumn('{{%review}}', 'userId', $this->integer());
        $this->addForeignKey('FK_review_user', '{{%review}}', 'userId', '{{%user}}', 'id', 'CASCADE', 'CASCADE');
        $this->alterColumn('{{%review}}', 'date', $this->dateTime());
    }
}