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

Complexity

Conditions	7
Paths	64

Size

Total Lines	27
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	0

<?php
    public function up(Schema $schema): void
    {
        $tblResourceFile = $schema->getTable('resource_file');
        $tblResourceNode = $schema->getTable('resource_node');

        if (!$tblResourceFile->hasColumn('resource_node_id')) {
            $this->addSql('ALTER TABLE resource_file ADD resource_node_id INT DEFAULT NULL');
        }

        if (!$tblResourceFile->hasForeignKey('FK_83BF96AA1BAD783F')) {
            $this->addSql('ALTER TABLE resource_file ADD CONSTRAINT FK_83BF96AA1BAD783F FOREIGN KEY (resource_node_id) REFERENCES resource_node (id)');
        }

        if (!$tblResourceFile->hasIndex('IDX_83BF96AA1BAD783F')) {
            $this->addSql('CREATE INDEX IDX_83BF96AA1BAD783F ON resource_file (resource_node_id)');
        }

        if ($tblResourceNode->hasForeignKey('FK_8A5F48FFCE6B9E84')) {
            $this->addSql('ALTER TABLE resource_node DROP FOREIGN KEY FK_8A5F48FFCE6B9E84');
        }

        if ($tblResourceNode->hasIndex('UNIQ_8A5F48FFCE6B9E84')) {
            $this->addSql('DROP INDEX UNIQ_8A5F48FFCE6B9E84 ON resource_node');
        }

        if ($tblResourceNode->hasColumn('resource_file_id')) {
            $this->addSql('ALTER TABLE resource_node DROP resource_file_id');
        }