Test Setup Failed
Branch master (354693)
by Valery
09:34
created

Version20190825162141::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 8
Code Lines 4

Duplication

Lines 0
Ratio 0 %

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 8
rs 10
1
<?php
2
3
declare(strict_types=1);
4
5
namespace DoctrineMigrations;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
/**
11
 * Auto-generated Migration: Please modify to your needs!
12
 */
13
final class Version20190825162141 extends AbstractMigration
14
{
15
    public function getDescription() : string
16
    {
17
        return '';
18
    }
19
20
    public function up(Schema $schema) : void
21
    {
22
        // this up() migration is auto-generated, please modify it to your needs
23
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
24
25
        $this->addSql('ALTER TABLE property ADD area_id INT DEFAULT NULL');
26
        $this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDEBD0F409C FOREIGN KEY (area_id) REFERENCES area (id)');
27
        $this->addSql('CREATE INDEX IDX_8BF21CDEBD0F409C ON property (area_id)');
28
    }
29
30
    public function down(Schema $schema) : void
31
    {
32
        // this down() migration is auto-generated, please modify it to your needs
33
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
34
35
        $this->addSql('ALTER TABLE property DROP FOREIGN KEY FK_8BF21CDEBD0F409C');
36
        $this->addSql('DROP INDEX IDX_8BF21CDEBD0F409C ON property');
37
        $this->addSql('ALTER TABLE property DROP area_id');
38
    }
39
}
40