Code Duplication - pamil/Sylius - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 18-24 lines in 39 locations

app/migrations/Version20140620085516.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20140620085516 extends AbstractMigration
{
    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('CREATE INDEX sku ON sylius_product_variant (sku)');
    }

    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('DROP INDEX sku ON sylius_product_variant');
    }
}


app/migrations/Version20140724192706.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20140724192706 extends AbstractMigration
{
    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('ALTER TABLE sylius_order ADD email VARCHAR(255) DEFAULT NULL');
        $this->addSql('UPDATE sylius_order o SET email = (SELECT email FROM sylius_user u WHERE u.id = o.user_id) WHERE user_id IS NOT NULL');
    }

    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('ALTER TABLE sylius_order DROP email');
    }
}


app/migrations/Version20140904095124.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20140904095124 extends AbstractMigration
{
    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('ALTER TABLE sylius_address ADD phone_number VARCHAR(255) DEFAULT NULL');
    }

    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('ALTER TABLE sylius_address DROP phone_number');
    }
}


app/migrations/Version20140930184010.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20140930184010 extends AbstractMigration
{
    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('ALTER TABLE sylius_order_item ADD is_immutable TINYINT(1) NOT NULL');
    }

    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('ALTER TABLE sylius_order_item DROP is_immutable');
    }
}


app/migrations/Version20141001095847.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141001095847 extends AbstractMigration
{
    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('ALTER TABLE sylius_adjustment ADD is_locked TINYINT(1) NOT NULL');
    }

    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('ALTER TABLE sylius_adjustment DROP is_locked');
    }
}


app/migrations/Version20141225005106.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141225005106 extends AbstractMigration
{
    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('CREATE TABLE sylius_order_identity (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, name VARCHAR(255) NOT NULL, value VARCHAR(255) DEFAULT NULL, INDEX IDX_5757A18E8D9F6D38 (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE sylius_order_identity ADD CONSTRAINT FK_5757A18E8D9F6D38 FOREIGN KEY (order_id) REFERENCES sylius_order (id)');
    }

    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('DROP TABLE sylius_order_identity');
    }
}


app/migrations/Version20141226173325.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20141226173325 extends AbstractMigration
{
    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('ALTER TABLE sylius_promotion_coupon ADD created_at DATETIME NOT NULL, ADD updated_at DATETIME DEFAULT NULL, ADD deleted_at DATETIME DEFAULT NULL');
    }

    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('ALTER TABLE sylius_promotion_coupon DROP created_at, DROP updated_at, DROP deleted_at');
    }
}


app/migrations/Version20150102104334.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150102104334 extends AbstractMigration
{
    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('ALTER TABLE sylius_promotion ADD deleted_at DATETIME DEFAULT NULL');
    }

    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('ALTER TABLE sylius_promotion DROP deleted_at');
    }
}


app/migrations/Version20150102133831.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150102133831 extends AbstractMigration
{
    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('ALTER TABLE sylius_product_archetype ADD code VARCHAR(255) NOT NULL');
    }

    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('ALTER TABLE sylius_product_archetype DROP code');
    }
}


app/migrations/Version20150102191232.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150102191232 extends AbstractMigration
{
    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('CREATE UNIQUE INDEX UNIQ_A4001B5277153098 ON sylius_product_archetype (code)');
    }

    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('DROP INDEX UNIQ_A4001B5277153098 ON sylius_product_archetype');
    }
}


app/migrations/Version20150128131714.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150128131714 extends AbstractMigration
{
    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('CREATE TABLE sylius_email (id INT AUTO_INCREMENT NOT NULL, code VARCHAR(12) NOT NULL, enabled TINYINT(1) NOT NULL, subject VARCHAR(255) NOT NULL, sender_name VARCHAR(255) DEFAULT NULL, sender_address VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    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('DROP TABLE sylius_email');
    }
}


app/migrations/Version20150629123648.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150629123648 extends AbstractMigration
{
    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('ALTER TABLE sylius_payment_method ADD fee_calculator VARCHAR(255) DEFAULT NULL, ADD fee_calculator_configuration VARCHAR(255) DEFAULT NULL');
    }

    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('ALTER TABLE sylius_payment_method DROP COLUMN fee_calculator, DROP COLUMN fee_calculator_configuration');
    }
}


app/migrations/Version20150630213802.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150630213802 extends AbstractMigration
{
    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('ALTER TABLE sylius_payment_method CHANGE fee_calculator_configuration fee_calculator_configuration LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\'');
    }

    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('ALTER TABLE sylius_payment_method CHANGE fee_calculator_configuration fee_calculator_configuration VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20150722115433.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150722115433 extends AbstractMigration
{
    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 sylius_country_translation');
    }

    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 sylius_country_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT NOT NULL, name VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, locale VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, UNIQUE INDEX sylius_country_translation_uniq_trans (translatable_id, locale), INDEX IDX_B8BD1DDC2C2AC5D3 (translatable_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE sylius_country_translation ADD CONSTRAINT FK_B8BD1DDC2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES sylius_country (id) ON DELETE CASCADE');
    }
}


app/migrations/Version20150722152840.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150722152840 extends AbstractMigration
{
    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('ALTER TABLE sylius_country ADD enabled TINYINT(1) NOT NULL');
    }

    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('ALTER TABLE sylius_country DROP enabled');
    }
}


app/migrations/Version20150817113941.php 1 location


/**
 * @author Kamil Kokot <[email protected]>
 */
class Version20150817113941 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('CREATE TABLE sylius_metadata (id INT AUTO_INCREMENT NOT NULL, `key` VARCHAR(255) NOT NULL, metadata LONGTEXT NOT NULL COMMENT \'(DC2Type:object)\', UNIQUE INDEX UNIQ_B0AF6FFB4E645A7E (`key`), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
    }

    /**
     * @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('DROP TABLE sylius_metadata');
    }
}


app/migrations/Version20150901104436.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150901104436 extends AbstractMigration
{
    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('ALTER TABLE sylius_payment ADD deleted_at DATETIME DEFAULT NULL');
    }

    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('ALTER TABLE sylius_payment DROP deleted_at');
    }
}


app/migrations/Version20150901113105.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150901113105 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('ALTER TABLE sylius_product_translation CHANGE short_description short_description LONGTEXT DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_product_translation CHANGE short_description short_description VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20151019160305.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20151019160305 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('ALTER TABLE sylius_adjustment CHANGE label type VARCHAR(255) NOT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_adjustment CHANGE type label VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20151118223453.php 1 location


/**
 * @author Paweł Jędrzejewski <[email protected]>
 */
class Version20151118223453 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE sylius_payment_method_translation CHANGE description description LONGTEXT DEFAULT NULL');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE sylius_payment_method_translation CHANGE description description VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20160104133517.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160104133517 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('ALTER TABLE sylius_product ADD enabled TINYINT(1) NOT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_product DROP enabled');
    }
}


app/migrations/Version20160112125003.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160112125003 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('ALTER TABLE sylius_order ADD additional_information VARCHAR(1000) DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_order DROP additional_information');
    }
}


app/migrations/Version20160112145643.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160112145643 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('ALTER TABLE sylius_currency ADD base TINYINT(1) NOT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_currency DROP base');
    }
}


app/migrations/Version20160114113257.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160114113257 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('ALTER TABLE sylius_adjustment CHANGE description `label` VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_adjustment CHANGE `label` description VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20160118140609.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160118140609 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('ALTER TABLE sylius_order ADD exchange_rate NUMERIC(10, 5) NOT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_order DROP exchange_rate');
    }
}


app/migrations/Version20160118174656.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160118174656 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('ALTER TABLE sylius_payment_method DROP fee_calculator, DROP fee_calculator_configuration');
    }

    /**
     * @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('ALTER TABLE sylius_payment_method ADD fee_calculator VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci, ADD fee_calculator_configuration LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci COMMENT \'(DC2Type:array)\'');
    }
}


app/migrations/Version20160122143514.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160122143514 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('ALTER TABLE sylius_province ADD abbreviation VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_province DROP abbreviation');
    }
}


app/migrations/Version20160205134111.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160205134111 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('ALTER TABLE sylius_channel CHANGE url hostname VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_channel CHANGE hostname url VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20160212150554.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160212150554 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('ALTER TABLE sylius_product_translation CHANGE description description LONGTEXT DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_product_translation CHANGE description description LONGTEXT NOT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20160220110242.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160220110242 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('ALTER TABLE sylius_product_option DROP name');
    }

    /**
     * @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('ALTER TABLE sylius_product_option ADD name VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20160226092329.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160226092329 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('ALTER TABLE sylius_payment DROP deleted_at');
    }

    /**
     * @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('ALTER TABLE sylius_payment ADD deleted_at DATETIME DEFAULT NULL');
    }
}


app/migrations/Version20160229091707.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160229091707 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('ALTER TABLE sylius_customer ADD phone_number VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_customer DROP phone_number');
    }
}


app/migrations/Version20160229145014.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160229145014 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('ALTER TABLE sylius_product_variant DROP deleted_at');
    }

    /**
     * @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('ALTER TABLE sylius_product_variant ADD deleted_at DATETIME DEFAULT NULL');
    }
}


app/migrations/Version20160305114253.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160305114253 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('ALTER TABLE sylius_promotion DROP deleted_at');
    }

    /**
     * @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('ALTER TABLE sylius_promotion ADD deleted_at DATETIME DEFAULT NULL');
    }
}


app/migrations/Version20160309144959.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160309144959 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('ALTER TABLE sylius_product DROP deleted_at');
    }

    /**
     * @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('ALTER TABLE sylius_product ADD deleted_at DATETIME DEFAULT NULL');
    }
}


app/migrations/Version20160310181749.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160310181749 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('ALTER TABLE sylius_order DROP INDEX UNIQ_6196A1F917B24436, ADD INDEX IDX_6196A1F917B24436 (promotion_coupon_id)');
    }

    /**
     * @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('ALTER TABLE sylius_order DROP INDEX IDX_6196A1F917B24436, ADD UNIQUE INDEX UNIQ_6196A1F917B24436 (promotion_coupon_id)');
    }
}


app/migrations/Version20160425094419.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160425094419 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('ALTER TABLE sylius_product_variant DROP is_master');
    }

    /**
     * @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('ALTER TABLE sylius_product_variant ADD is_master TINYINT(1) NOT NULL');
    }
}


app/migrations/Version20160621211112.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160621211112 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('ALTER TABLE sylius_product_variant CHANGE presentation name VARCHAR(255) DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_product_variant CHANGE name presentation VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
    }
}


app/migrations/Version20160622114217.php 1 location


/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160622114217 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('ALTER TABLE sylius_order DROP additional_information, CHANGE notes notes VARCHAR(1000) DEFAULT NULL');
    }

    /**
     * @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('ALTER TABLE sylius_order ADD additional_information VARCHAR(1000) DEFAULT NULL COLLATE utf8_unicode_ci, CHANGE notes notes VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
    }
}


		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20140620085516 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', "Migration can only be executed safely on 'mysql'.");
26
27		$this->addSql('CREATE INDEX sku ON sylius_product_variant (sku)');
28		}
29
30		public function down(Schema $schema)
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('DROP INDEX sku ON sylius_product_variant');
36		}
37		}
38

		@@ 20-38 (lines=19) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20140724192706 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', "Migration can only be executed safely on 'mysql'.");
26
27		$this->addSql('ALTER TABLE sylius_order ADD email VARCHAR(255) DEFAULT NULL');
28		$this->addSql('UPDATE sylius_order o SET email = (SELECT email FROM sylius_user u WHERE u.id = o.user_id) WHERE user_id IS NOT NULL');
29		}
30
31		public function down(Schema $schema)
32		{
33		// this down() migration is auto-generated, please modify it to your needs
34		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', "Migration can only be executed safely on 'mysql'.");
35
36		$this->addSql('ALTER TABLE sylius_order DROP email');
37		}
38		}
39

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20140904095124 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_address ADD phone_number VARCHAR(255) DEFAULT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_address DROP phone_number');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20140930184010 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_order_item ADD is_immutable TINYINT(1) NOT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_order_item DROP is_immutable');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20141001095847 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_adjustment ADD is_locked TINYINT(1) NOT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_adjustment DROP is_locked');
36		}
37		}
38

		@@ 20-38 (lines=19) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20141225005106 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('CREATE TABLE sylius_order_identity (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, name VARCHAR(255) NOT NULL, value VARCHAR(255) DEFAULT NULL, INDEX IDX_5757A18E8D9F6D38 (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
28		$this->addSql('ALTER TABLE sylius_order_identity ADD CONSTRAINT FK_5757A18E8D9F6D38 FOREIGN KEY (order_id) REFERENCES sylius_order (id)');
29		}
30
31		public function down(Schema $schema)
32		{
33		// this down() migration is auto-generated, please modify it to your needs
34		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
35
36		$this->addSql('DROP TABLE sylius_order_identity');
37		}
38		}
39

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20141226173325 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_promotion_coupon ADD created_at DATETIME NOT NULL, ADD updated_at DATETIME DEFAULT NULL, ADD deleted_at DATETIME DEFAULT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_promotion_coupon DROP created_at, DROP updated_at, DROP deleted_at');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150102104334 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_promotion ADD deleted_at DATETIME DEFAULT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_promotion DROP deleted_at');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150102133831 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_product_archetype ADD code VARCHAR(255) NOT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_product_archetype DROP code');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150102191232 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('CREATE UNIQUE INDEX UNIQ_A4001B5277153098 ON sylius_product_archetype (code)');
28		}
29
30		public function down(Schema $schema)
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('DROP INDEX UNIQ_A4001B5277153098 ON sylius_product_archetype');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150128131714 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('CREATE TABLE sylius_email (id INT AUTO_INCREMENT NOT NULL, code VARCHAR(12) NOT NULL, enabled TINYINT(1) NOT NULL, subject VARCHAR(255) NOT NULL, sender_name VARCHAR(255) DEFAULT NULL, sender_address VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
28		}
29
30		public function down(Schema $schema)
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('DROP TABLE sylius_email');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150629123648 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_payment_method ADD fee_calculator VARCHAR(255) DEFAULT NULL, ADD fee_calculator_configuration VARCHAR(255) DEFAULT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_payment_method DROP COLUMN fee_calculator, DROP COLUMN fee_calculator_configuration');
36		}
37		}
38

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150630213802 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_payment_method CHANGE fee_calculator_configuration fee_calculator_configuration LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\'');
28		}
29
30		public function down(Schema $schema)
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 sylius_payment_method CHANGE fee_calculator_configuration fee_calculator_configuration VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
36		}
37		}
38

		@@ 20-38 (lines=19) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150722115433 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('DROP TABLE sylius_country_translation');
28		}
29
30		public function down(Schema $schema)
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('CREATE TABLE sylius_country_translation (id INT AUTO_INCREMENT NOT NULL, translatable_id INT NOT NULL, name VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, locale VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, UNIQUE INDEX sylius_country_translation_uniq_trans (translatable_id, locale), INDEX IDX_B8BD1DDC2C2AC5D3 (translatable_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
36		$this->addSql('ALTER TABLE sylius_country_translation ADD CONSTRAINT FK_B8BD1DDC2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES sylius_country (id) ON DELETE CASCADE');
37		}
38		}
39

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150722152840 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_country ADD enabled TINYINT(1) NOT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_country DROP enabled');
36		}
37		}
38

		@@ 20-43 (lines=24) @@
17		/**
18		* @author Kamil Kokot <[email protected]>
19		*/
20		class Version20150817113941 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('CREATE TABLE sylius_metadata (id INT AUTO_INCREMENT NOT NULL, `key` VARCHAR(255) NOT NULL, metadata LONGTEXT NOT NULL COMMENT \'(DC2Type:object)\', UNIQUE INDEX UNIQ_B0AF6FFB4E645A7E (`key`), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('DROP TABLE sylius_metadata');
42		}
43		}
44

		@@ 20-37 (lines=18) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150901104436 extends AbstractMigration
21		{
22		public function up(Schema $schema)
23		{
24		// this up() migration is auto-generated, please modify it to your needs
25		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
26
27		$this->addSql('ALTER TABLE sylius_payment ADD deleted_at DATETIME DEFAULT NULL');
28		}
29
30		public function down(Schema $schema)
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 sylius_payment DROP deleted_at');
36		}
37		}
38

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20150901113105 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', "Migration can only be executed safely on 'mysql'.");
29
30		$this->addSql('ALTER TABLE sylius_product_translation CHANGE short_description short_description LONGTEXT DEFAULT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', "Migration can only be executed safely on 'mysql'.");
40
41		$this->addSql('ALTER TABLE sylius_product_translation CHANGE short_description short_description VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20151019160305 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_adjustment CHANGE label type VARCHAR(255) NOT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_adjustment CHANGE type label VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
42		}
43		}
44

		@@ 20-41 (lines=22) @@
17		/**
18		* @author Paweł Jędrzejewski <[email protected]>
19		*/
20		class Version20151118223453 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
28
29		$this->addSql('ALTER TABLE sylius_payment_method_translation CHANGE description description LONGTEXT DEFAULT NULL');
30		}
31
32		/**
33		* @param Schema $schema
34		*/
35		public function down(Schema $schema)
36		{
37		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
38
39		$this->addSql('ALTER TABLE sylius_payment_method_translation CHANGE description description VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
40		}
41		}
42

pamil / Sylius

Code Duplication Length = 18-24 lines in 39 locations

app/migrations/Version20140620085516.php 1 location

app/migrations/Version20140724192706.php 1 location

app/migrations/Version20140904095124.php 1 location

app/migrations/Version20140930184010.php 1 location

app/migrations/Version20141001095847.php 1 location

app/migrations/Version20141225005106.php 1 location

app/migrations/Version20141226173325.php 1 location

app/migrations/Version20150102104334.php 1 location

app/migrations/Version20150102133831.php 1 location

app/migrations/Version20150102191232.php 1 location

app/migrations/Version20150128131714.php 1 location

app/migrations/Version20150629123648.php 1 location

app/migrations/Version20150630213802.php 1 location

app/migrations/Version20150722115433.php 1 location

app/migrations/Version20150722152840.php 1 location

app/migrations/Version20150817113941.php 1 location

app/migrations/Version20150901104436.php 1 location

app/migrations/Version20150901113105.php 1 location

app/migrations/Version20151019160305.php 1 location

app/migrations/Version20151118223453.php 1 location

app/migrations/Version20160104133517.php 1 location

app/migrations/Version20160112125003.php 1 location

app/migrations/Version20160112145643.php 1 location

app/migrations/Version20160114113257.php 1 location

app/migrations/Version20160118140609.php 1 location

app/migrations/Version20160118174656.php 1 location

app/migrations/Version20160122143514.php 1 location

app/migrations/Version20160205134111.php 1 location

app/migrations/Version20160212150554.php 1 location

app/migrations/Version20160220110242.php 1 location

app/migrations/Version20160226092329.php 1 location

app/migrations/Version20160229091707.php 1 location

app/migrations/Version20160229145014.php 1 location

app/migrations/Version20160305114253.php 1 location

app/migrations/Version20160309144959.php 1 location

app/migrations/Version20160310181749.php 1 location

app/migrations/Version20160425094419.php 1 location

app/migrations/Version20160621211112.php 1 location

app/migrations/Version20160622114217.php 1 location

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160104133517 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_product ADD enabled TINYINT(1) NOT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_product DROP enabled');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160112125003 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_order ADD additional_information VARCHAR(1000) DEFAULT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_order DROP additional_information');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160112145643 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_currency ADD base TINYINT(1) NOT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_currency DROP base');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160114113257 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_adjustment CHANGE description `label` VARCHAR(255) DEFAULT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_adjustment CHANGE `label` description VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160118140609 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_order ADD exchange_rate NUMERIC(10, 5) NOT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_order DROP exchange_rate');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160118174656 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_payment_method DROP fee_calculator, DROP fee_calculator_configuration');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_payment_method ADD fee_calculator VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci, ADD fee_calculator_configuration LONGTEXT DEFAULT NULL COLLATE utf8_unicode_ci COMMENT \'(DC2Type:array)\'');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160122143514 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_province ADD abbreviation VARCHAR(255) DEFAULT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_province DROP abbreviation');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160205134111 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_channel CHANGE url hostname VARCHAR(255) DEFAULT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_channel CHANGE hostname url VARCHAR(255) DEFAULT NULL COLLATE utf8_unicode_ci');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160212150554 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_product_translation CHANGE description description LONGTEXT DEFAULT NULL');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_product_translation CHANGE description description LONGTEXT NOT NULL COLLATE utf8_unicode_ci');
42		}
43		}
44

		@@ 20-43 (lines=24) @@
17		/**
18		* Auto-generated Migration: Please modify to your needs!
19		*/
20		class Version20160220110242 extends AbstractMigration
21		{
22		/**
23		* @param Schema $schema
24		*/
25		public function up(Schema $schema)
26		{
27		// this up() migration is auto-generated, please modify it to your needs
28		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30		$this->addSql('ALTER TABLE sylius_product_option DROP name');
31		}
32
33		/**
34		* @param Schema $schema
35		*/
36		public function down(Schema $schema)
37		{
38		// this down() migration is auto-generated, please modify it to your needs
39		$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
40
41		$this->addSql('ALTER TABLE sylius_product_option ADD name VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
42		}
43		}
44