Completed
Push — master ( 2055e6...14d075 )
by Paweł
17s queued 10s
created

Version20190513085321::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 6
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 3
nc 1
nop 1
dl 0
loc 6
rs 10
c 0
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Migrations;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
final class Version20190513085321 extends AbstractMigration
11
{
12
    public function getDescription(): string
13
    {
14
        return 'Add missing timestampable columns to attachment';
15
    }
16
17
    public function up(Schema $schema): void
18
    {
19
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
20
21
        $this->addSql('ALTER TABLE npd_attachment ADD created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL');
22
        $this->addSql('ALTER TABLE npd_attachment ADD updated TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL');
23
    }
24
25
    public function down(Schema $schema): void
26
    {
27
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
28
29
        $this->addSql('ALTER TABLE npd_attachment DROP created');
30
        $this->addSql('ALTER TABLE npd_attachment DROP updated');
31
    }
32
}
33