Passed
Pull Request — master (#6835)
by Angel Fernando Quiroz
10:09
created

Version20250927180003   A

Complexity

Total Complexity 2

Size/Duplication

Total Lines 24
Duplicated Lines 0 %

Importance

Changes 3
Bugs 0 Features 0
Metric Value
eloc 16
dl 0
loc 24
rs 10
c 3
b 0
f 0
wmc 2

2 Methods

Rating   Name   Duplication   Size   Complexity  
A getDescription() 0 3 1
A up() 0 17 1
1
<?php
2
3
/* For licensing terms, see /license.txt */
4
5
declare(strict_types=1);
6
7
namespace Chamilo\CoreBundle\Migrations\Schema\V200;
8
9
use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
10
use Chamilo\CoreBundle\Repository\Node\PortfolioRepository;
11
use Chamilo\CoreBundle\Repository\Node\UserRepository;
12
use Chamilo\CoreBundle\Repository\ResourceRepository;
13
use Doctrine\DBAL\Schema\Schema;
14
15
class Version20250927180003 extends AbstractMigrationChamilo
16
{
17
    public function getDescription(): string
18
    {
19
        return 'Migrate portfolio comments to resource nodes';
20
    }
21
22
    public function up(Schema $schema): void
23
    {
24
        $this->addSql("ALTER TABLE portfolio DROP FOREIGN KEY FK_A9ED106291D79BD3");
25
        $this->addSql("ALTER TABLE portfolio DROP FOREIGN KEY FK_A9ED1062A76ED395");
26
        $this->addSql("ALTER TABLE portfolio DROP FOREIGN KEY FK_A9ED1062613FECDF");
27
        $this->addSql("DROP INDEX course ON portfolio");
28
        $this->addSql("DROP INDEX session ON portfolio");
29
        $this->addSql("DROP INDEX user ON portfolio");
30
        $this->addSql("ALTER TABLE portfolio DROP user_id, DROP c_id, DROP session_id, DROP creation_date, DROP update_date");
31
32
        $this->addSql("ALTER TABLE portfolio_comment DROP FOREIGN KEY FK_C2C17DA2A977936C");
33
        $this->addSql("ALTER TABLE portfolio_comment DROP FOREIGN KEY FK_C2C17DA2F675F31B");
34
        $this->addSql("ALTER TABLE portfolio_comment DROP FOREIGN KEY FK_C2C17DA2727ACA70");
35
        $this->addSql("DROP INDEX IDX_C2C17DA2A977936C ON portfolio_comment");
36
        $this->addSql("DROP INDEX IDX_C2C17DA2727ACA70 ON portfolio_comment");
37
        $this->addSql("DROP INDEX IDX_C2C17DA2F675F31B ON portfolio_comment");
38
        $this->addSql("ALTER TABLE portfolio_comment DROP author_id, DROP tree_root, DROP parent_id, DROP lft, DROP lvl, DROP rgt");
39
    }
40
}