Stu\Migrations\Version20240705092745_StarSystem

Complexity

Total Complexity

3

Size/Duplication

Total Lines	19
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	5	1
A	up()	0	5	1
A	getDescription()	0	3	1

<?php

declare(strict_types=1);

namespace Stu\Migrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

final class Version20240705092745_StarSystem extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Removes the following obsolete fields from stu_systems: cx, cy';
    }

    public function up(Schema $schema): void
    {
        $this->addSql('DROP INDEX coordinate_idx;');
        $this->addSql('ALTER TABLE stu_systems DROP cx;');
        $this->addSql('ALTER TABLE stu_systems DROP cy;');
    }

    public function down(Schema $schema): void
    {
        $this->addSql('ALTER TABLE stu_systems ADD cx SMALLINT DEFAULT NULL;');
        $this->addSql('ALTER TABLE stu_systems ADD cy SMALLINT DEFAULT NULL;');
        $this->addSql('CREATE INDEX coordinate_idx ON stu_systems (cx, cy);');
    }
}