<?php

use yii\db\Migration;

class m210805_093052_change_fields_in_review extends Migration
{
    public function up()
    {
        $this->addColumn('{{%review}}', 'ratingAirport', $this->integer()->notNull());
        $this->addColumn('{{%review}}', 'ratingClean', $this->integer()->notNull());
        $this->addColumn('{{%review}}', 'ratingEat', $this->integer()->notNull());
        $this->addColumn('{{%review}}', 'ratingZodiak', $this->integer()->notNull());
        $this->renameColumn('{{%review}}', 'ratingSealife', 'ratingEquipment');
        $this->addColumn('{{%review}}', 'ratingPrice', $this->integer()->notNull());
        $this->addColumn('{{%review}}', 'ratingHost', $this->integer()->notNull());
        $this->addColumn('{{%review}}', 'hash', $this->string());
        $this->alterColumn('{{%review}}', 'title', $this->string());
    }

    public function down()
    {
        $this->dropColumn('{{%review}}', 'ratingAirport');
        $this->dropColumn('{{%review}}', 'ratingClean');
        $this->dropColumn('{{%review}}', 'ratingEat');
        $this->dropColumn('{{%review}}', 'ratingZodiak');
        $this->dropColumn('{{%review}}', 'ratingPrice');
        $this->dropColumn('{{%review}}', 'ratingHost');
        $this->dropColumn('{{%review}}', 'hash');
        $this->renameColumn('{{%review}}', 'ratingEquipment', 'ratingSealife');
        $this->alterColumn('{{%review}}', 'title', $this->string()->notNull());
    }
}