Chamilo\CoreBundle\Migrations\Schema\V200\Version20230116184632::up()

Complexity

Conditions	3
Paths	2

Size

Total Lines	25
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public function up(Schema $schema): void
    {
        $table = $schema->getTable('c_quiz_question_rel_category');
        $cQuizQuestionTable = $schema->getTable('c_quiz_question');
        $cQuizQuestionCategoryTable = $schema->getTable('c_quiz_question_category');

        $fks = $table->getForeignKeys();

        if (!empty($fks)) {
            foreach ($fks as $fk) {
                $table->removeForeignKey($fk->getName());
            }
        }

        $table->addForeignKeyConstraint(
            $cQuizQuestionTable,
            ['question_id'],
            ['iid'],
            ['onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'],
        );
        $table->addForeignKeyConstraint(
            $cQuizQuestionCategoryTable,
            ['category_id'],
            ['iid'],
            ['onUpdate' => 'CASCADE', 'onDelete' => 'CASCADE'],
        );