Passed
Pull Request — master (#2138)
by Nico
25:02 queued 13:24
created

Version20250610094046::getDescription()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 1
nc 1
nop 0
dl 0
loc 3
rs 10
c 0
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
final class Version20250610094046 extends AbstractMigration
11
{
12
    public function getDescription(): string
13
    {
14
        return 'Fixed primary key field order.';
15
    }
16
17
    public function up(Schema $schema): void
18
    {
19
        $this->addSql(<<<'SQL'
20
            ALTER TABLE stu_user_map DROP CONSTRAINT stu_user_map_pkey
21
        SQL);
22
        $this->addSql(<<<'SQL'
23
            ALTER TABLE stu_user_map ADD PRIMARY KEY (cx, cy, user_id, layer_id)
24
        SQL);
25
    }
26
27
    public function down(Schema $schema): void
28
    {
29
        $this->addSql(<<<'SQL'
30
            DROP INDEX stu_user_map_pkey
31
        SQL);
32
        $this->addSql(<<<'SQL'
33
            ALTER TABLE stu_user_map ADD PRIMARY KEY (user_id, layer_id, cx, cy)
34
        SQL);
35
    }
36
}
37