<?php

use yii\db\Migration;

class m161028_111354_fix extends Migration
{
    public function up()
    {
        $this->renameTable('{{%product_tag}}', '{{%product_tag_link}}');
        $this->renameTable('{{%product_site}}', '{{%product_site_link}}');

        $this->dropForeignKey('FK_tour_open', '{{%tour_open}}');
        $this->renameColumn('{{%tour_open}}', 'productId', 'tourId');
        $this->addForeignKey('FK_tour_open', '{{%tour_open}}', 'tourId', '{{%tour}}', 'id', 'CASCADE', 'CASCADE');


        $this->alterColumn('{{%tour}}', 'productId', $this->integer());
        $this->addForeignKey('FK_tour_product', '{{%tour}}', 'productId', '{{%product}}', 'id', 'CASCADE', 'CASCADE');
    }

    public function down()
    {
        $this->renameTable('{{%product_tag_link}}', '{{%product_tag}}');
        $this->renameTable('{{%product_site_link}}', '{{%product_site}}');

        $this->dropForeignKey('FK_tour_open', '{{%tour_open}}');
        $this->renameColumn('{{%tour_open}}', 'tourId', 'productId');
        
        $this->addForeignKey('FK_tour_open', '{{%tour_open}}', 'productId', '{{%product}}', 'id', 'CASCADE', 'CASCADE');

        $this->dropForeignKey('FK_tour_product', '{{%tour}}');
        $this->alterColumn('{{%tour}}', 'productId', $this->string());
    }

}