Completed
Push — master ( 19732d...076741 )
by Paweł
11:47
created

Version20180608134715::down()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 9

Duplication

Lines 9
Ratio 100 %

Importance

Changes 0
Metric Value
dl 9
loc 9
rs 9.9666
c 0
b 0
f 0
cc 1
nc 1
nop 1
1
<?php
2
3
declare(strict_types=1);
4
5
namespace SWP\Migrations;
6
7
use Doctrine\DBAL\Migrations\AbstractMigration;
8
use Doctrine\DBAL\Schema\Schema;
9
10
/**
11
 * Auto-generated Migration: Please modify to your needs!
12
 */
13 View Code Duplication
final class Version20180608134715 extends AbstractMigration
0 ignored issues
show
Deprecated Code introduced by
The class Doctrine\DBAL\Migrations\AbstractMigration has been deprecated with message: Please use Doctrine\Migrations\AbstractMigration

This class, trait or interface has been deprecated. The supplier of the file has supplied an explanatory message.

The explanatory message should give you some clue as to whether and when the type will be removed from the class and what other constant to use instead.

Loading history...
Duplication introduced by
This class seems to be duplicated in your project.

Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.

You can also find more detailed suggestions in the “Code” section of your repository.

Loading history...
14
{
15
    public function up(Schema $schema): void
16
    {
17
        // this up() migration is auto-generated, please modify it to your needs
18
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
19
20
        $this->addSql('ALTER TABLE swp_route DROP CONSTRAINT fk_5ce4ce5a79066886');
21
        $this->addSql('DROP INDEX idx_5ce4ce5a79066886');
22
        $this->addSql('ALTER TABLE swp_route DROP root_id');
23
    }
24
25
    public function down(Schema $schema): void
26
    {
27
        // this down() migration is auto-generated, please modify it to your needs
28
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
29
30
        $this->addSql('ALTER TABLE swp_route ADD root_id INT DEFAULT NULL');
31
        $this->addSql('ALTER TABLE swp_route ADD CONSTRAINT fk_5ce4ce5a79066886 FOREIGN KEY (root_id) REFERENCES swp_route (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
32
        $this->addSql('CREATE INDEX idx_5ce4ce5a79066886 ON swp_route (root_id)');
33
    }
34
}
35