<?php

use yii\db\Migration;

class m161220_114901_wifi_tech extends Migration
{
    public function up()
    {
        $this->addColumn('{{%entity}}', 'wifi', $this->integer(1));
        $this->addColumn('{{%entity}}', 'nitrox', $this->integer(1));
        $this->addColumn('{{%entity}}', 'techDiving', $this->integer(1));
        /*$this->execute('
            UPDATE {{%entity}} e
              JOIN {{%entity_boat}} eb ON eb.entityId = e.id 
              SET e.wifi = eb.wifi, e.nitrox = eb.nitrox 
              WHERE e.type = 1
            
            '
        );*/

        $this->dropColumn('{{%entity_boat}}', 'wifi');
        $this->dropColumn('{{%entity_boat}}', 'nitrox');

        $this->dropColumn('{{%entity_resort}}', 'wifi');
        $this->dropColumn('{{%entity_resort}}', 'nitrox');
        $this->dropColumn('{{%entity_resort}}', 'techDiving');

        $this->createIndex('IDX_entity_wifi', '{{%entity}}', 'wifi');
        $this->createIndex('IDX_entity_nitrox', '{{%entity}}', 'nitrox');
        $this->createIndex('IDX_entity_techDiving', '{{%entity}}', 'techDiving');
    }

    public function down()
    {
        $this->dropColumn('{{%entity}}', 'wifi');
        $this->dropColumn('{{%entity}}', 'nitrox');
        $this->dropColumn('{{%entity}}', 'techDiving');

        $this->addColumn('{{%entity_boat}}', 'wifi', $this->integer(1));
        $this->addColumn('{{%entity_boat}}', 'nitrox', $this->integer(1));

        $this->addColumn('{{%entity_resort}}', 'wifi', $this->integer(1));
        $this->addColumn('{{%entity_resort}}', 'nitrox', $this->integer(1));
        $this->addColumn('{{%entity_resort}}', 'techDiving', $this->integer(1));
    }
}