Passed
Push — dev ( 5ebfc2...850c22 )
by Janko
12:27
created

Version20240822091021_LotteryWinnerBuildplan::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 6
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 4
nc 1
nop 1
dl 0
loc 6
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 Override;
0 ignored issues
show
Bug introduced by
The type Override was not found. Maybe you did not declare it correctly or list all dependencies?

The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:

filter:
    dependency_paths: ["lib/*"]

For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths

Loading history...
8
use Doctrine\DBAL\Schema\Schema;
9
use Doctrine\Migrations\AbstractMigration;
10
11
final class Version20240822091021_LotteryWinnerBuildplan extends AbstractMigration
12
{
13
    #[Override]
14
    public function getDescription(): string
15
    {
16
        return 'Adds new entity for ship buildplans that lottery winners get.';
17
    }
18
19
    #[Override]
20
    public function up(Schema $schema): void
21
    {
22
        $this->addSql('CREATE TABLE stu_lottery_buildplan (id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, buildplan_id INT NOT NULL, chance INT NOT NULL, PRIMARY KEY(id))');
23
        $this->addSql('CREATE INDEX IDX_E8141D9B8638E4E7 ON stu_lottery_buildplan (buildplan_id)');
24
        $this->addSql('ALTER TABLE stu_lottery_buildplan ADD CONSTRAINT FK_E8141D9B8638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplans (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
25
    }
26
27
    #[Override]
28
    public function down(Schema $schema): void
29
    {
30
        $this->addSql('ALTER TABLE stu_lottery_buildplan DROP CONSTRAINT FK_E8141D9B8638E4E7');
31
        $this->addSql('DROP TABLE stu_lottery_buildplan');
32
    }
33
}
34