Passed
Push — dev ( f3475b...4f3a03 )
by Nico
29:49
created

Version20240806141232::down()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 6
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 4
c 1
b 0
f 0
nc 1
nop 1
dl 0
loc 6
ccs 0
cts 5
cp 0
crap 2
rs 10
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Stu\Migrations;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
11
final class Version20240806141232 extends AbstractMigration
12
{
13
    public function getDescription(): string
14
    {
15
        return 'Add mining queue entity';
16
    }
17
18
    public function up(Schema $schema): void
19
    {
20
21
        $this->addSql('CREATE TABLE stu_mining_queue (id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, ship_id INT NOT NULL, location_mining_id INT NOT NULL, PRIMARY KEY(id))');
22
        $this->addSql('CREATE INDEX IDX_BBFEF8C427D56C25 ON stu_mining_queue (location_mining_id)');
23
        $this->addSql('CREATE UNIQUE INDEX UNIQ_BBFEF8C4C256317D ON stu_mining_queue (ship_id)');
24
        $this->addSql('ALTER TABLE stu_mining_queue ADD CONSTRAINT FK_BBFEF8C427D56C25 FOREIGN KEY (location_mining_id) REFERENCES stu_location_mining (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
25
        $this->addSql('ALTER TABLE stu_mining_queue ADD CONSTRAINT FK_BBFEF8C4C256317D FOREIGN KEY (ship_id) REFERENCES stu_ships (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
26
    }
27
28
    public function down(Schema $schema): void
29
    {
30
        $this->addSql('CREATE SCHEMA public');
31
        $this->addSql('ALTER TABLE stu_mining_queue DROP CONSTRAINT FK_BBFEF8C427D56C25');
32
        $this->addSql('ALTER TABLE stu_mining_queue DROP CONSTRAINT FK_BBFEF8C4C256317D');
33
        $this->addSql('DROP TABLE stu_mining_queue');
34
    }
35
}