migrations/Version20260325123610.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  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 Version20260325123610 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
  24. $this->addSql('RENAME TABLE channel_crm_prospects TO contacts');
  26. $this->addSql('ALTER TABLE contacts DROP FOREIGN KEY FK_D584129F896DBBDE');
  27. $this->addSql('ALTER TABLE contacts DROP FOREIGN KEY FK_D584129FB03A8386');
  28. $this->addSql('ALTER TABLE contacts DROP FOREIGN KEY FK_D584129F72F5A1AA');
  30. $this->addSql('ALTER TABLE contacts ADD CONSTRAINT FK_44F066DA72F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id) ON DELETE CASCADE');
  31. $this->addSql('ALTER TABLE contacts ADD CONSTRAINT FK_44F066DAB03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  32. $this->addSql('ALTER TABLE contacts ADD CONSTRAINT FK_44F066DA896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  34. $this->addSql('ALTER TABLE contacts DROP INDEX IDX_D584129FE7927C74, ADD FULLTEXT INDEX IDX_33401573E7927C74 (email)');
  35. $this->addSql('ALTER TABLE contacts DROP INDEX IDX_D584129FA9D1C132, ADD FULLTEXT INDEX IDX_33401573A9D1C132 (first_name)');
  36. $this->addSql('ALTER TABLE contacts DROP INDEX IDX_D584129FC808BA5A, ADD FULLTEXT INDEX IDX_33401573C808BA5A (last_name)');
  37. $this->addSql('ALTER TABLE contacts DROP INDEX IDX_D584129F72F5A1AA, ADD INDEX IDX_3340157372F5A1AA (channel_id)');
  38. $this->addSql('ALTER TABLE contacts DROP INDEX IDX_D584129FB03A8386, ADD INDEX IDX_33401573B03A8386 (created_by_id)');
  39. $this->addSql('ALTER TABLE contacts DROP INDEX IDX_D584129F896DBBDE, ADD INDEX IDX_33401573896DBBDE (updated_by_id)');
  40. $this->addSql('ALTER TABLE contacts DROP INDEX UNIQ_D584129F72F5A1AAE7927C74, ADD UNIQUE INDEX UNIQ_3340157372F5A1AAE7927C74 (channel_id, email)');
  42. $this->addSql('ALTER TABLE channel_positioning_test_attempts DROP FOREIGN KEY FK_AEEA1A75D182060A');
  43. $this->addSql('ALTER TABLE channel_positioning_test_attempts ADD CONSTRAINT FK_AEEA1A75D182060A FOREIGN KEY (prospect_id) REFERENCES contacts (id) ON DELETE CASCADE');
  44. }
  46. public function down(Schema $schema): void
  47. {
  48. // this down() migration is auto-generated, please modify it to your needs
  50. $this->addSql('RENAME TABLE contacts TO channel_crm_prospects');
  52. $this->addSql('ALTER TABLE channel_crm_prospects DROP FOREIGN KEY FK_44F066DA72F5A1AA');
  53. $this->addSql('ALTER TABLE channel_crm_prospects DROP FOREIGN KEY FK_44F066DAB03A8386');
  54. $this->addSql('ALTER TABLE channel_crm_prospects DROP FOREIGN KEY FK_44F066DA896DBBDE');
  56. $this->addSql('ALTER TABLE channel_crm_prospects ADD CONSTRAINT FK_D584129F896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  57. $this->addSql('ALTER TABLE channel_crm_prospects ADD CONSTRAINT FK_D584129FB03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  58. $this->addSql('ALTER TABLE channel_crm_prospects ADD CONSTRAINT FK_D584129F72F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id) ON DELETE CASCADE');
  60. $this->addSql('ALTER TABLE channel_crm_prospects DROP INDEX IDX_33401573E7927C74, ADD FULLTEXT INDEX IDX_D584129FE7927C74 (email)');
  61. $this->addSql('ALTER TABLE channel_crm_prospects DROP INDEX IDX_33401573A9D1C132, ADD FULLTEXT INDEX IDX_D584129FA9D1C132 (first_name)');
  62. $this->addSql('ALTER TABLE channel_crm_prospects DROP INDEX IDX_33401573C808BA5A, ADD FULLTEXT INDEX IDX_D584129FC808BA5A (last_name)');
  63. $this->addSql('ALTER TABLE channel_crm_prospects DROP INDEX IDX_3340157372F5A1AA, ADD INDEX IDX_D584129F72F5A1AA (channel_id)');
  64. $this->addSql('ALTER TABLE channel_crm_prospects DROP INDEX IDX_33401573B03A8386, ADD INDEX IDX_D584129FB03A8386 (created_by_id)');
  65. $this->addSql('ALTER TABLE channel_crm_prospects DROP INDEX IDX_33401573896DBBDE, ADD INDEX IDX_D584129F896DBBDE (updated_by_id)');
  66. $this->addSql('ALTER TABLE channel_crm_prospects DROP INDEX UNIQ_3340157372F5A1AAE7927C74, ADD UNIQUE INDEX UNIQ_D584129F72F5A1AAE7927C74 (channel_id, email)');
  68. $this->addSql('ALTER TABLE channel_positioning_test_attempts DROP FOREIGN KEY FK_AEEA1A75D182060A');
  69. $this->addSql('ALTER TABLE channel_positioning_test_attempts ADD CONSTRAINT FK_AEEA1A75D182060A FOREIGN KEY (prospect_id) REFERENCES channel_crm_prospects (id) ON DELETE CASCADE');
  70. }
  71. }