Version20180620075122::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 8
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 0
Metric Value
cc 1
eloc 4
nc 1
nop 1
dl 0
loc 8
ccs 0
cts 6
cp 0
crap 2
rs 9.4285
c 0
b 0
f 0
1
<?php declare(strict_types=1);
2
3
namespace App\Migrations;
4
5
use Doctrine\DBAL\Schema\Schema;
6
use Doctrine\Migrations\AbstractMigration;
7
8
/**
9
 * Auto-generated Migration: Please modify to your needs!
10
 */
11
final class Version20180620075122 extends AbstractMigration
12
{
13
    public function up(Schema $schema) : void
14
    {
15
        // this up() migration is auto-generated, please modify it to your needs
16
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
17
18
        $this->addSql('ALTER TABLE project__projects ADD approval_poll_id INT DEFAULT NULL');
19
        $this->addSql('ALTER TABLE project__projects ADD CONSTRAINT FK_636FB313A8D4C349 FOREIGN KEY (approval_poll_id) REFERENCES project__polls (id)');
20
        $this->addSql('CREATE UNIQUE INDEX UNIQ_636FB313A8D4C349 ON project__projects (approval_poll_id)');
21
    }
22
23
    public function down(Schema $schema) : void
24
    {
25
        // this down() migration is auto-generated, please modify it to your needs
26
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
27
28
        $this->addSql('ALTER TABLE project__projects DROP FOREIGN KEY FK_636FB313A8D4C349');
29
        $this->addSql('DROP INDEX UNIQ_636FB313A8D4C349 ON project__projects');
30
        $this->addSql('ALTER TABLE project__projects DROP approval_poll_id');
31
    }
32
}
33