<?php

use yii\db\Migration;

class m161125_124255_country_new_fields extends Migration
{
    public function up()
    {
        $this->addColumn('{{%country}}', 'reason5', $this->text()->after('reason4'));
        $this->addColumn('{{%country}}', 'descrBoat', $this->text());
        $this->addColumn('{{%country}}', 'descrResort', $this->text());
        $this->addColumn('{{%country}}', 'descrInterest', $this->text());
        $this->addColumn('{{%country}}', 'seasonTextRight', $this->text()->after('seasonText'));
        $this->addColumn('{{%country}}', 'm1', $this->integer(2));
        $this->addColumn('{{%country}}', 'm2', $this->integer(2));
        $this->addColumn('{{%country}}', 'm3', $this->integer(2));
        $this->addColumn('{{%country}}', 'm4', $this->integer(2));
        $this->addColumn('{{%country}}', 'm5', $this->integer(2));
        $this->addColumn('{{%country}}', 'm6', $this->integer(2));
        $this->addColumn('{{%country}}', 'm7', $this->integer(2));
        $this->addColumn('{{%country}}', 'm8', $this->integer(2));
        $this->addColumn('{{%country}}', 'm9', $this->integer(2));
        $this->addColumn('{{%country}}', 'm10', $this->integer(2));
        $this->addColumn('{{%country}}', 'm11', $this->integer(2));
        $this->addColumn('{{%country}}', 'm12', $this->integer(2));
        $this->dropColumn('{{%country}}', 'seasonLogo');
    }

    public function down()
    {
        $this->dropColumn('{{%country}}', 'reason5');
        $this->dropColumn('{{%country}}', 'descrBoat');
        $this->dropColumn('{{%country}}', 'descrResort');
        $this->dropColumn('{{%country}}', 'descrInterest');
        $this->dropColumn('{{%country}}', 'seasonTextRight');
        $this->dropColumn('{{%country}}', 'm1');
        $this->dropColumn('{{%country}}', 'm2');
        $this->dropColumn('{{%country}}', 'm3');
        $this->dropColumn('{{%country}}', 'm4');
        $this->dropColumn('{{%country}}', 'm5');
        $this->dropColumn('{{%country}}', 'm6');
        $this->dropColumn('{{%country}}', 'm7');
        $this->dropColumn('{{%country}}', 'm8');
        $this->dropColumn('{{%country}}', 'm9');
        $this->dropColumn('{{%country}}', 'm10');
        $this->dropColumn('{{%country}}', 'm11');
        $this->dropColumn('{{%country}}', 'm12');
        $this->addColumn('{{%country}}', 'seasonLogo', $this->string());
    }
}