WordPress

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20190906150824 extends AbstractMigration
{
    public function getDescription() : string
    {
        return '';
    }

    public function up(Schema $schema) : void
    {
        // 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 right_managed_pricing (id INT AUTO_INCREMENT NOT NULL, sub_region_price INT DEFAULT NULL, region_price INT NOT NULL, usage_advertising INT DEFAULT NULL, usage_editorial INT DEFAULT NULL, usage_internal_company_use INT DEFAULT NULL, media_advertising_print INT DEFAULT NULL, media_advertising_commercial INT DEFAULT NULL, media_advertising_digital INT DEFAULT NULL, media_editorial_print INT DEFAULT NULL, media_editorial_commercial INT DEFAULT NULL, media_editorial_digital INT DEFAULT NULL, media_internal_company_use_print INT DEFAULT NULL, media_internal_company_use_digital VARCHAR(255) DEFAULT NULL, details_advertising_print_newspaper INT DEFAULT NULL, details_advertising_print_magazine INT DEFAULT NULL, details_advertising_print_outdoor INT DEFAULT NULL, details_advertising_print_pos INT DEFAULT NULL, details_advertising_print_all INT DEFAULT NULL, details_editorial_print_newspaper INT DEFAULT NULL, details_editorial_print_magazine INT DEFAULT NULL, details_editorial_print_book INT DEFAULT NULL, details_editorial_print_collateral INT DEFAULT NULL, details_advertising_commercial_tv INT DEFAULT NULL, details_editorial_commercial_program INT DEFAULT NULL, details_editorial_commercial_film INT DEFAULT NULL, details_advertising_digital_website INT DEFAULT NULL, details_advertising_digital_mobile INT DEFAULT NULL, details_advertising_digital_social INT DEFAULT NULL, details_advertising_digital_all INT DEFAULT NULL, details_editorial_digital_website INT DEFAULT NULL, details_editorial_digital_mobile INT DEFAULT NULL, details_editorial_digital_social INT DEFAULT NULL, details_editorial_digital_all INT DEFAULT NULL, details_internal_company_use_digital_website INT DEFAULT NULL, details_internal_company_use_digital_presentation INT DEFAULT NULL, duration_advertising_one_day INT DEFAULT NULL, duration_advertising_one_month INT DEFAULT NULL, duration_advertising_three_months INT DEFAULT NULL, duration_advertising_six_months INT DEFAULT NULL, duration_advertising_one_year INT DEFAULT NULL, duration_advertising_two_years INT DEFAULT NULL, duration_advertising_one_week INT DEFAULT NULL, duration_editorial_one_day INT DEFAULT NULL, duration_editorial_one_week INT DEFAULT NULL, duration_editorial_one_month INT DEFAULT NULL, duration_editorial_three_months INT DEFAULT NULL, duration_editorial_six_months INT DEFAULT NULL, duration_editorial_one_year INT DEFAULT NULL, duration_editorial_two_years INT DEFAULT NULL, duration_internal_use_one_day INT DEFAULT NULL, duration_internal_use_one_week INT DEFAULT NULL, duration_internal_use_one_month INT DEFAULT NULL, duration_internal_use_three_months INT DEFAULT NULL, duration_internal_use_six_months INT DEFAULT NULL, duration_internal_use_one_year INT DEFAULT NULL, duration_internal_use_two_years INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        $this->addSql('DROP TABLE test');
        $this->addSql('ALTER TABLE stock ADD licence_type VARCHAR(255) DEFAULT NULL');
        $this->addSql('ALTER TABLE cart_item ADD size VARCHAR(255) NOT NULL, ADD is_exclusive TINYINT(1) NOT NULL');
        $this->addSql('ALTER TABLE invoice_items ADD invoice_id INT NOT NULL');
        $this->addSql('ALTER TABLE invoice_items ADD CONSTRAINT FK_DCC4B9F82989F1FD FOREIGN KEY (invoice_id) REFERENCES invoice (id)');
        $this->addSql('CREATE INDEX IDX_DCC4B9F82989F1FD ON invoice_items (invoice_id)');
    }

    public function down(Schema $schema) : void
    {
        // 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 test (id INT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB COMMENT = \'\' ');
        $this->addSql('DROP TABLE right_managed_pricing');
        $this->addSql('ALTER TABLE cart_item DROP size, DROP is_exclusive');
        $this->addSql('ALTER TABLE invoice_items DROP FOREIGN KEY FK_DCC4B9F82989F1FD');
        $this->addSql('DROP INDEX IDX_DCC4B9F82989F1FD ON invoice_items');
        $this->addSql('ALTER TABLE invoice_items DROP invoice_id');
        $this->addSql('ALTER TABLE stock DROP licence_type');
    }
}