vendor/plna-penezenka/pp-sdk-bundle/migrations/Version20220306123711_ProductCampaignModelUpdate.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace PPSDKDoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20220306123711_ProductCampaignModelUpdate extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  23.         $this->addSql('ALTER TABLE product_campaigns 
  24.             ADD default_promoted_shop_subtitle VARCHAR(255) DEFAULT \'\' NOT NULL, 
  25.             ADD default_article_link_title VARCHAR(255) DEFAULT \'\' NOT NULL, 
  26.             ADD image_under_menu_url VARCHAR(255) NOT NULL, 
  27.             ADD image_under_menu_storage_path VARCHAR(255) NOT NULL, 
  28.             ADD image_under_menu_file_size INT NOT NULL, 
  29.             ADD image_under_menu_width INT NOT NULL, 
  30.             ADD image_under_menu_height INT NOT NULL, 
  31.             ADD image_under_menu_alt VARCHAR(255) DEFAULT \'\' NOT NULL, 
  32.             DROP hero_product_headline, 
  33.             DROP hero_product_subtitle, 
  34.             DROP hero_image_url, 
  35.             DROP hero_image_storage_path, 
  36.             DROP hero_image_file_size, 
  37.             DROP hero_image_width, 
  38.             DROP hero_image_height, 
  39.             CHANGE other_extra_cashback_shops_headline other_extra_cashback_shops_headline VARCHAR(255) DEFAULT \'\' NOT NULL, 
  40.             CHANGE tutorial_headline tutorial_headline VARCHAR(255) DEFAULT \'\' NOT NULL, 
  41.             CHANGE tutorial_info tutorial_info VARCHAR(255) DEFAULT \'\' NOT NULL, 
  42.             CHANGE share_text share_text VARCHAR(255) DEFAULT \'\' NOT NULL, 
  43.             CHANGE partner_shops_headline partner_shops_headline VARCHAR(255) DEFAULT \'\' NOT NULL, 
  44.             CHANGE recommendation_extra_info recommendation_extra_info VARCHAR(255) DEFAULT \'\' NOT NULL, 
  45.             CHANGE hero_image_alt default_promoted_shop_headline VARCHAR(255) DEFAULT \'\' NOT NULL, 
  46.             CHANGE hero_image_attached image_under_menu_attached TINYINT(1) NOT NULL, 
  47.             CHANGE hero_image_attached_when image_under_menu_attached_when DATETIME DEFAULT NULL, 
  48.             CHANGE hero_image_mime_type image_under_menu_mime_type VARCHAR(40) NOT NULL
  49.         ');
  50.         $this->addSql('ALTER TABLE product_campaigns_days DROP FOREIGN KEY FK_DBC353737BA39F43');
  51.         $this->addSql('DROP INDEX IDX_DBC353737BA39F43 ON product_campaigns_days');
  52.         $this->addSql('ALTER TABLE product_campaigns_days 
  53.             ADD promoted_shop_article_id INT DEFAULT NULL, 
  54.             ADD promoted_shop_headline VARCHAR(255) DEFAULT \'\' NOT NULL, 
  55.             ADD promoted_shop_subtitle VARCHAR(255) DEFAULT \'\' NOT NULL, 
  56.             ADD promote_shop_article_link_title VARCHAR(50) DEFAULT \'\' NOT NULL, 
  57.             ADD promoted_shop_image_attached TINYINT(1) NOT NULL, 
  58.             ADD promoted_shop_image_attached_when DATETIME DEFAULT NULL, 
  59.             ADD promoted_shop_image_url VARCHAR(255) NOT NULL, 
  60.             ADD promoted_shop_image_storage_path VARCHAR(255) NOT NULL, 
  61.             ADD promoted_shop_image_file_size INT NOT NULL, 
  62.             ADD promoted_shop_image_mime_type VARCHAR(40) NOT NULL, 
  63.             ADD promoted_shop_image_width INT NOT NULL, 
  64.             ADD promoted_shop_image_height INT NOT NULL, 
  65.             ADD promoted_shop_image_alt VARCHAR(255) DEFAULT \'\' NOT NULL, 
  66.             ADD promoted_shop_id INT DEFAULT NULL,
  67.             DROP promoted_product_id');
  68.         $this->addSql('ALTER TABLE product_campaigns_days ADD CONSTRAINT FK_DBC35373709125D3 FOREIGN KEY (promoted_shop_id) REFERENCES shops (id)');
  69.         $this->addSql('ALTER TABLE product_campaigns_days ADD CONSTRAINT FK_DBC35373E2BE8C7C FOREIGN KEY (promoted_shop_article_id) REFERENCES articles (id)');
  70.         $this->addSql('CREATE INDEX IDX_DBC35373709125D3 ON product_campaigns_days (promoted_shop_id)');
  71.         $this->addSql('CREATE INDEX IDX_DBC35373E2BE8C7C ON product_campaigns_days (promoted_shop_article_id)');
  72.         $this->addSql('ALTER TABLE product_campaigns_products DROP FOREIGN KEY FK_FA4565633E2E969B');
  73.         $this->addSql('DROP INDEX IDX_FA4565633E2E969B ON product_campaigns_products');
  74.         $this->addSql('ALTER TABLE product_campaigns_products 
  75.             CHANGE review_id related_article_id INT DEFAULT NULL, 
  76.             CHANGE review_link_title related_article_link_title VARCHAR(50) DEFAULT \'\' NOT NULL');
  77.         $this->addSql('ALTER TABLE product_campaigns_products ADD CONSTRAINT FK_FA456563F8598E2C FOREIGN KEY (related_article_id) REFERENCES articles (id)');
  78.         $this->addSql('CREATE INDEX IDX_FA456563F8598E2C ON product_campaigns_products (related_article_id)');
  79.     }
  81.     public function down(Schema $schema): void
  82.     {
  83.         // this down() migration is auto-generated, please modify it to your needs
  84.         $this->addSql('ALTER TABLE product_campaigns 
  85.             ADD hero_product_headline VARCHAR(255) NOT NULL, 
  86.             ADD hero_product_subtitle VARCHAR(255) NOT NULL, 
  87.             ADD hero_image_url VARCHAR(255) NOT NULL, 
  88.             ADD hero_image_storage_path VARCHAR(255) NOT NULL, 
  89.             ADD hero_image_file_size INT NOT NULL, 
  90.             ADD hero_image_width INT NOT NULL, 
  91.             ADD hero_image_height INT NOT NULL, 
  92.             ADD hero_image_alt VARCHAR(255) DEFAULT \'\' NOT NULL, 
  93.             DROP default_promoted_shop_headline, 
  94.             DROP default_promoted_shop_subtitle, 
  95.             DROP default_article_link_title, 
  96.             DROP image_under_menu_url, 
  97.             DROP image_under_menu_storage_path, 
  98.             DROP image_under_menu_file_size, 
  99.             DROP image_under_menu_width, 
  100.             DROP image_under_menu_height, 
  101.             DROP image_under_menu_alt, 
  102.             CHANGE other_extra_cashback_shops_headline other_extra_cashback_shops_headline VARCHAR(255) NOT NULL, 
  103.             CHANGE tutorial_headline tutorial_headline VARCHAR(255) NOT NULL, 
  104.             CHANGE tutorial_info tutorial_info VARCHAR(255) NOT NULL, 
  105.             CHANGE share_text share_text VARCHAR(255) NOT NULL, 
  106.             CHANGE partner_shops_headline partner_shops_headline VARCHAR(255) NOT NULL, 
  107.             CHANGE recommendation_extra_info recommendation_extra_info VARCHAR(255) NOT NULL, 
  108.             CHANGE image_under_menu_attached hero_image_attached TINYINT(1) NOT NULL, 
  109.             CHANGE image_under_menu_attached_when hero_image_attached_when DATETIME DEFAULT NULL, 
  110.             CHANGE image_under_menu_mime_type hero_image_mime_type VARCHAR(40) NOT NULL');
  111.         $this->addSql('ALTER TABLE product_campaigns_days DROP FOREIGN KEY FK_DBC35373709125D3');
  112.         $this->addSql('ALTER TABLE product_campaigns_days DROP FOREIGN KEY FK_DBC35373E2BE8C7C');
  113.         $this->addSql('DROP INDEX IDX_DBC35373709125D3 ON product_campaigns_days');
  114.         $this->addSql('DROP INDEX IDX_DBC35373E2BE8C7C ON product_campaigns_days');
  115.         $this->addSql('ALTER TABLE product_campaigns_days 
  116.             ADD promoted_product_id INT DEFAULT NULL, 
  117.             DROP promoted_shop_id, 
  118.             DROP promoted_shop_article_id, 
  119.             DROP promoted_shop_headline, 
  120.             DROP promoted_shop_subtitle, 
  121.             DROP promote_shop_article_link_title, 
  122.             DROP promoted_shop_image_attached, 
  123.             DROP promoted_shop_image_attached_when, 
  124.             DROP promoted_shop_image_url, 
  125.             DROP promoted_shop_image_storage_path, 
  126.             DROP promoted_shop_image_file_size, 
  127.             DROP promoted_shop_image_mime_type, 
  128.             DROP promoted_shop_image_width, 
  129.             DROP promoted_shop_image_height, 
  130.             DROP promoted_shop_image_alt');
  131.         $this->addSql('ALTER TABLE product_campaigns_days ADD CONSTRAINT FK_DBC353737BA39F43 FOREIGN KEY (promoted_product_id) REFERENCES product_campaigns_products (id) ON UPDATE NO ACTION ON DELETE NO ACTION');
  132.         $this->addSql('CREATE INDEX IDX_DBC353737BA39F43 ON product_campaigns_days (promoted_product_id)');
  133.         $this->addSql('ALTER TABLE product_campaigns_products DROP FOREIGN KEY FK_FA456563F8598E2C');
  134.         $this->addSql('DROP INDEX IDX_FA456563F8598E2C ON product_campaigns_products');
  135.         $this->addSql('ALTER TABLE product_campaigns_products 
  136.             CHANGE related_article_id review_id INT DEFAULT NULL, 
  137.             CHANGE related_article_link_title review_link_title VARCHAR(50) DEFAULT \'\' NOT NULL');
  138.         $this->addSql('ALTER TABLE product_campaigns_products ADD CONSTRAINT FK_FA4565633E2E969B FOREIGN KEY (review_id) REFERENCES articles (id) ON UPDATE NO ACTION ON DELETE NO ACTION');
  139.         $this->addSql('CREATE INDEX IDX_FA4565633E2E969B ON product_campaigns_products (review_id)');
  140.     }
  141. }