Passed
Push — dev ( 00baf5...4e8c32 )
by Nico
17:36
created

Version20250604163346_LayerDescription::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 9
Code Lines 9

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 9
nc 1
nop 1
dl 0
loc 9
rs 9.9666
c 1
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Stu\Migrations\Pgsql;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
11
final class Version20250604163346_LayerDescription extends AbstractMigration
12
{
13
    public function getDescription(): string
14
    {
15
        return 'Add description, is_colonizable and is_noobzone to layer';
16
    }
17
18
    public function up(Schema $schema): void
19
    {
20
        $this->addSql(<<<'SQL'
21
            ALTER TABLE stu_layer ADD description TEXT DEFAULT NULL
22
        SQL);
23
        $this->addSql(<<<'SQL'
24
            ALTER TABLE stu_layer ADD is_colonizable BOOLEAN DEFAULT NULL
25
        SQL);
26
        $this->addSql(<<<'SQL'
27
            ALTER TABLE stu_layer ADD is_noobzone BOOLEAN DEFAULT NULL
28
        SQL);
29
    }
30
31
    public function down(Schema $schema): void
32
    {
33
        $this->addSql(<<<'SQL'
34
            ALTER TABLE stu_layer DROP description
35
        SQL);
36
        $this->addSql(<<<'SQL'
37
            ALTER TABLE stu_layer DROP is_colonizable
38
        SQL);
39
        $this->addSql(<<<'SQL'
40
            ALTER TABLE stu_layer DROP is_noobzone
41
        SQL);
42
    }
43
}
44