<?php

use yii\db\Migration;

class m170206_122644_tour_instructor extends Migration
{
    public function up()
    {
        $this->addColumn('{{%tour}}', 'isInstructor', $this->integer()->defaultValue(0));
        $this->createIndex('IDX_tour_isInstructor', '{{%tour}}', 'isInstructor');

        $this->addColumn('{{%product}}', 'notice', $this->text());
        $this->addColumn('{{%entity}}', 'notice', $this->text());
    }

    public function down()
    {
        $this->dropIndex('IDX_tour_isInstructor', '{{%tour}}');
        $this->dropColumn('{{%tour}}', 'isInstructor');

        $this->dropColumn('{{%product}}', 'notice');
        $this->dropColumn('{{%entity}}', 'notice');
    }
}