Failed Conditions
Push — master ( 0b3886...ea22ef )
by Adrien
04:31
created

Version20251110085941::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 27
Code Lines 27

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 27
dl 0
loc 27
ccs 0
cts 18
cp 0
rs 9.488
c 1
b 0
f 0
cc 1
nc 1
nop 1
crap 2
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Application\Migration;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
class Version20251110085941 extends AbstractMigration
11
{
12
    public function up(Schema $schema): void
13
    {
14
        $this->addSql(<<<'SQL'
15
                ALTER TABLE expense_claim DROP FOREIGN KEY FK_461791D7E3C61F9
16
            SQL);
17
        $this->addSql(<<<'SQL'
18
                ALTER TABLE expense_claim CHANGE owner_id owner_id INT DEFAULT NULL
19
            SQL);
20
        $this->addSql(<<<'SQL'
21
                ALTER TABLE expense_claim ADD CONSTRAINT FK_461791D7E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id) ON DELETE SET NULL
22
            SQL);
23
        $this->addSql(<<<'SQL'
24
                ALTER TABLE log DROP FOREIGN KEY FK_8F3F68C561220EA6
25
            SQL);
26
        $this->addSql(<<<'SQL'
27
                ALTER TABLE log DROP FOREIGN KEY FK_8F3F68C57E3C61F9
28
            SQL);
29
        $this->addSql(<<<'SQL'
30
                ALTER TABLE log ADD CONSTRAINT FK_8F3F68C561220EA6 FOREIGN KEY (creator_id) REFERENCES user (id) ON DELETE CASCADE
31
            SQL);
32
        $this->addSql(<<<'SQL'
33
                ALTER TABLE log ADD CONSTRAINT FK_8F3F68C57E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id) ON DELETE CASCADE
34
            SQL);
35
        $this->addSql(<<<'SQL'
36
                ALTER TABLE message DROP FOREIGN KEY FK_B6BD307F7E3C61F9
37
            SQL);
38
        $this->addSql(<<<'SQL'
39
                ALTER TABLE message ADD CONSTRAINT FK_B6BD307F7E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id) ON DELETE CASCADE
40
            SQL);
41
    }
42
}
43