migrations/2023/01/Version20230117200351.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. final class Version20230117200351 extends AbstractMigration
  11. {
  12.     public function up(Schema $schema): void
  13.     {
  14.         $this->addSql('ALTER TABLE app_form_contact ADD campaign_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:marketing_campaign_id)\'');
  15.         $this->addSql('ALTER TABLE app_form_contact ADD CONSTRAINT FK_BF809C82F639F774 FOREIGN KEY (campaign_id) REFERENCES app_marketing_campaign (id)');
  16.         $this->addSql('CREATE INDEX IDX_BF809C82F639F774 ON app_form_contact (campaign_id)');
  17.         $this->addSql('ALTER TABLE app_form_contact_company_for_sale ADD campaign_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:marketing_campaign_id)\'');
  18.         $this->addSql('ALTER TABLE app_form_contact_company_for_sale ADD CONSTRAINT FK_C45675DFF639F774 FOREIGN KEY (campaign_id) REFERENCES app_marketing_campaign (id)');
  19.         $this->addSql('CREATE INDEX IDX_C45675DFF639F774 ON app_form_contact_company_for_sale (campaign_id)');
  20.         $this->addSql('ALTER TABLE app_form_contact_establish_company ADD campaign_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:marketing_campaign_id)\'');
  21.         $this->addSql('ALTER TABLE app_form_contact_establish_company ADD CONSTRAINT FK_3C0C2E3CF639F774 FOREIGN KEY (campaign_id) REFERENCES app_marketing_campaign (id)');
  22.         $this->addSql('CREATE INDEX IDX_3C0C2E3CF639F774 ON app_form_contact_establish_company (campaign_id)');
  23.         $this->addSql('ALTER TABLE app_form_contact_hse_card ADD campaign_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:marketing_campaign_id)\'');
  24.         $this->addSql('ALTER TABLE app_form_contact_hse_card ADD CONSTRAINT FK_1340A8A8F639F774 FOREIGN KEY (campaign_id) REFERENCES app_marketing_campaign (id)');
  25.         $this->addSql('CREATE INDEX IDX_1340A8A8F639F774 ON app_form_contact_hse_card (campaign_id)');
  26.         $this->addSql('ALTER TABLE app_form_contact_sell_company ADD campaign_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:marketing_campaign_id)\'');
  27.         $this->addSql('ALTER TABLE app_form_contact_sell_company ADD CONSTRAINT FK_DD7FD647F639F774 FOREIGN KEY (campaign_id) REFERENCES app_marketing_campaign (id)');
  28.         $this->addSql('CREATE INDEX IDX_DD7FD647F639F774 ON app_form_contact_sell_company (campaign_id)');
  29.         $this->addSql('ALTER TABLE app_form_contact_service ADD campaign_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:marketing_campaign_id)\'');
  30.         $this->addSql('ALTER TABLE app_form_contact_service ADD CONSTRAINT FK_20846E5DF639F774 FOREIGN KEY (campaign_id) REFERENCES app_marketing_campaign (id)');
  31.         $this->addSql('CREATE INDEX IDX_20846E5DF639F774 ON app_form_contact_service (campaign_id)');
  32.     }
  34.     public function down(Schema $schema): void
  35.     {
  36.         $this->addSql('ALTER TABLE app_form_contact DROP FOREIGN KEY FK_BF809C82F639F774');
  37.         $this->addSql('DROP INDEX IDX_BF809C82F639F774 ON app_form_contact');
  38.         $this->addSql('ALTER TABLE app_form_contact DROP campaign_id');
  39.         $this->addSql('ALTER TABLE app_form_contact_company_for_sale DROP FOREIGN KEY FK_C45675DFF639F774');
  40.         $this->addSql('DROP INDEX IDX_C45675DFF639F774 ON app_form_contact_company_for_sale');
  41.         $this->addSql('ALTER TABLE app_form_contact_company_for_sale DROP campaign_id');
  42.         $this->addSql('ALTER TABLE app_form_contact_establish_company DROP FOREIGN KEY FK_3C0C2E3CF639F774');
  43.         $this->addSql('DROP INDEX IDX_3C0C2E3CF639F774 ON app_form_contact_establish_company');
  44.         $this->addSql('ALTER TABLE app_form_contact_establish_company DROP campaign_id');
  45.         $this->addSql('ALTER TABLE app_form_contact_hse_card DROP FOREIGN KEY FK_1340A8A8F639F774');
  46.         $this->addSql('DROP INDEX IDX_1340A8A8F639F774 ON app_form_contact_hse_card');
  47.         $this->addSql('ALTER TABLE app_form_contact_hse_card DROP campaign_id');
  48.         $this->addSql('ALTER TABLE app_form_contact_sell_company DROP FOREIGN KEY FK_DD7FD647F639F774');
  49.         $this->addSql('DROP INDEX IDX_DD7FD647F639F774 ON app_form_contact_sell_company');
  50.         $this->addSql('ALTER TABLE app_form_contact_sell_company DROP campaign_id');
  51.         $this->addSql('ALTER TABLE app_form_contact_service DROP FOREIGN KEY FK_20846E5DF639F774');
  52.         $this->addSql('DROP INDEX IDX_20846E5DF639F774 ON app_form_contact_service');
  53.         $this->addSql('ALTER TABLE app_form_contact_service DROP campaign_id');
  54.     }
  55. }