<?php

use yii\db\Migration;

class m161125_085617_dic_relation_fix extends Migration
{
    public function up()
    {
        $this->dropForeignKey('FK_entity_boat_navigation_entity', '{{%entity_boat_navigation_link}}');
        $this->addForeignKey('FK_entity_boat_navigation_entity', '{{%entity_boat_navigation_link}}', 'entityId', '{{%entity_boat}}', 'id', 'CASCADE', 'CASCADE');

        $this->dropForeignKey('FK_entity_boat_food_entity', '{{%entity_boat_food_link}}');
        $this->addForeignKey('FK_entity_boat_food_entity', '{{%entity_boat_food_link}}', 'entityId', '{{%entity_boat}}', 'id', 'CASCADE', 'CASCADE');

        $this->dropForeignKey('FK_entity_boat_service_entity', '{{%entity_boat_service_link}}');
        $this->addForeignKey('FK_entity_boat_service_entity', '{{%entity_boat_service_link}}', 'entityId', '{{%entity_boat}}', 'id', 'CASCADE', 'CASCADE');

        $this->dropForeignKey('FK_entity_boat_diving_entity', '{{%entity_boat_diving_link}}');
        $this->addForeignKey('FK_entity_boat_diving_entity', '{{%entity_boat_diving_link}}', 'entityId', '{{%entity_boat}}', 'id', 'CASCADE', 'CASCADE');
    }

    public function down()
    {
        $this->dropForeignKey('FK_entity_boat_navigation_entity', '{{%entity_boat_navigation_link}}');
        $this->addForeignKey('FK_entity_boat_navigation_entity', '{{%entity_boat_navigation_link}}', 'entityId', '{{%entity}}', 'id', 'CASCADE', 'CASCADE');

        $this->dropForeignKey('FK_entity_boat_food_entity', '{{%entity_boat_food_link}}');
        $this->addForeignKey('FK_entity_boat_food_entity', '{{%entity_boat_food_link}}', 'entityId', '{{%entity}}', 'id', 'CASCADE', 'CASCADE');

        $this->dropForeignKey('FK_entity_boat_service_entity', '{{%entity_boat_service_link}}');
        $this->addForeignKey('FK_entity_boat_service_entity', '{{%entity_boat_service_link}}', 'entityId', '{{%entity}}', 'id', 'CASCADE', 'CASCADE');

        $this->dropForeignKey('FK_entity_boat_diving_entity', '{{%entity_boat_diving_link}}');
        $this->addForeignKey('FK_entity_boat_diving_entity', '{{%entity_boat_diving_link}}', 'entityId', '{{%entity}}', 'id', 'CASCADE', 'CASCADE');
    }

    /*
    // Use safeUp/safeDown to run migration code within a transaction
    public function safeUp()
    {
    }

    public function safeDown()
    {
    }
    */
}