Version20190318110040::up() - Code Metrics - Inspection of "Merge pull request #483 from metalslave/39548-reff..." - stfalcon/fwdays - Measure and Improve Code Quality continuously with Scrutinizer

Test Setup Failed

Push — master ( 14e042...222fdb )

by Artem

created 2019-03-20 15:23 UTC

Version20190318110040::up() A

↳ Parent: Version20190318110040

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	3
dl	0
loc	7
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	1

<?php

namespace Application\Migrations;

use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20190318110040 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE sponsor_translations');
        $this->addSql('ALTER TABLE sponsors DROP slug, DROP about, DROP on_main');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE sponsor_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL COLLATE utf8_unicode_ci, field VARCHAR(32) NOT NULL COLLATE utf8_unicode_ci, content LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, UNIQUE INDEX sponsor_lookup_unique_idx (locale, object_id, field), INDEX IDX_4C84E738232D562B (object_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE sponsor_translations ADD CONSTRAINT FK_4C84E738232D562B FOREIGN KEY (object_id) REFERENCES sponsors (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE sponsors ADD slug VARCHAR(255) NOT NULL COLLATE utf8_general_ci, ADD about LONGTEXT DEFAULT NULL COLLATE utf8_general_ci, ADD on_main TINYINT(1) NOT NULL');
    }
}


1			<?php
2
3			namespace Application\Migrations;
4
5			use Doctrine\DBAL\Migrations\AbstractMigration;
6			use Doctrine\DBAL\Schema\Schema;
7
8			/**
9			* Auto-generated Migration: Please modify to your needs!
10			*/
11			class Version20190318110040 extends AbstractMigration
12			{
13			/**
14			* @param Schema $schema
15			*/
16			public function up(Schema $schema)
17			{
18			// this up() migration is auto-generated, please modify it to your needs
19			$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
20
21			$this->addSql('DROP TABLE sponsor_translations');
22			$this->addSql('ALTER TABLE sponsors DROP slug, DROP about, DROP on_main');
23			}
24
25			/**
26			* @param Schema $schema
27			*/
28			public function down(Schema $schema)
29			{
30			// this down() migration is auto-generated, please modify it to your needs
31			$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
32
33			$this->addSql('CREATE TABLE sponsor_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL COLLATE utf8_unicode_ci, field VARCHAR(32) NOT NULL COLLATE utf8_unicode_ci, content LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci, UNIQUE INDEX sponsor_lookup_unique_idx (locale, object_id, field), INDEX IDX_4C84E738232D562B (object_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
34			$this->addSql('ALTER TABLE sponsor_translations ADD CONSTRAINT FK_4C84E738232D562B FOREIGN KEY (object_id) REFERENCES sponsors (id) ON DELETE CASCADE');
35			$this->addSql('ALTER TABLE sponsors ADD slug VARCHAR(255) NOT NULL COLLATE utf8_general_ci, ADD about LONGTEXT DEFAULT NULL COLLATE utf8_general_ci, ADD on_main TINYINT(1) NOT NULL');
36			}
37			}
38

stfalcon / fwdays

Push — master ( 14e042...222fdb )

Version20190318110040::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like