<?php

use Phalcon\Mvc\Model\Migration;

/**
 * Class StranasNewMigration_302
 */
class StranasNewCascadeMigration_302 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            alter table jaga.str_target_activities
                drop constraint fk_str_activities,
                add constraint fk_str_activities
                    foreign key (id_master)
                    references jaga.str_target_master(id)
                    on delete cascade;
        '
        );

        self::$connection->execute('
            alter table jaga.str_target_log
                drop constraint fk_str_target_master,
                add constraint fk_str_target_master
                    foreign key (id_master)
                    references jaga.str_target_master(id)
                    on delete cascade;
        '
        );
        
        self::$connection->execute('
            alter table jaga.str_target_log_comment
                drop constraint fk_str_target_log,
                add constraint fk_str_target_log
                    foreign key (id_log)
                    references jaga.str_target_log(id)
                    on delete cascade;
        '
        );
    }

    public function down()
    {
        self::$connection->execute("");
    }
}