Completed
Push — master ( 05bb5a...5289b8 )
by Rafał
34:32 queued 04:15
created

Version20190208103320::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 10

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 10
rs 9.9332
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\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
/**
11
 * Auto-generated Migration: Please modify to your needs!
12
 */
13
final class Version20190208103320 extends AbstractMigration
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('DROP SEQUENCE request_metrics_id_seq CASCADE');
21
        $this->addSql('DROP TABLE request_metrics');
22
        $this->addSql('ALTER TABLE swp_publish_destination ADD content_lists TEXT DEFAULT NULL');
23
        $this->addSql('COMMENT ON COLUMN swp_publish_destination.content_lists IS \'(DC2Type:array)\'');
24
    }
25
26
    public function down(Schema $schema): void
27
    {
28
        // this down() migration is auto-generated, please modify it to your needs
29
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');
30
31
        $this->addSql('CREATE SEQUENCE request_metrics_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
32
        $this->addSql('CREATE TABLE request_metrics (
33
          id INT NOT NULL, 
34
          uri TEXT NOT NULL, 
35
          route VARCHAR(255) NOT NULL, 
36
          duration INT NOT NULL, 
37
          created TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, 
38
          PRIMARY KEY(id)
39
        )');
40
        $this->addSql('ALTER TABLE swp_publish_destination DROP content_lists');
41
    }
42
}
43