migrations/2020/08/Version20200824122721.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 Version20200824122721 extends AbstractMigration
  11. {
  12.     public function up(Schema $schema): void
  13.     {
  14.         $this->addSql('RENAME TABLE contact_client_relationship TO contact_relationship_customer_supplier');
  15.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier DROP FOREIGN KEY FK_CC9305C419EB6921');
  16.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier DROP FOREIGN KEY FK_CC9305C42ADD6D8C');
  17.         $this->addSql('DROP INDEX contact_client_relationship_unique ON contact_relationship_customer_supplier');
  18.         $this->addSql('DROP INDEX IDX_CC9305C419EB6921 ON contact_relationship_customer_supplier');
  19.         $this->addSql('DROP INDEX IDX_CC9305C42ADD6D8C ON contact_relationship_customer_supplier');
  20.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier CHANGE client_id customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  21.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier ADD CONSTRAINT FK_F27238549395C3F3 FOREIGN KEY (customer_id) REFERENCES contact (id)');
  22.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier ADD CONSTRAINT FK_F27238542ADD6D8C FOREIGN KEY (supplier_id) REFERENCES contact (id)');
  23.         $this->addSql('CREATE INDEX IDX_F27238549395C3F3 ON contact_relationship_customer_supplier (customer_id)');
  24.         $this->addSql('CREATE INDEX IDX_F27238542ADD6D8C ON contact_relationship_customer_supplier (supplier_id)');
  25.         $this->addSql('CREATE UNIQUE INDEX UNIQ_F27238542ADD6D8C9395C3F3 ON contact_relationship_customer_supplier (supplier_id, customer_id)');
  26.     }
  28.     public function down(Schema $schema): void
  29.     {
  30.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier DROP FOREIGN KEY FK_F27238549395C3F3');
  31.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier DROP FOREIGN KEY FK_F27238542ADD6D8C');
  32.         $this->addSql('DROP INDEX UNIQ_F27238542ADD6D8C9395C3F3 ON contact_relationship_customer_supplier');
  33.         $this->addSql('DROP INDEX IDX_F27238549395C3F3 ON contact_relationship_customer_supplier');
  34.         $this->addSql('DROP INDEX IDX_F27238542ADD6D8C ON contact_relationship_customer_supplier');
  35.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier CHANGE customer_id client_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  36.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier ADD CONSTRAINT FK_CC9305C419EB6921 FOREIGN KEY (client_id) REFERENCES contact (id)');
  37.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier ADD CONSTRAINT FK_CC9305C42ADD6D8C FOREIGN KEY (supplier_id) REFERENCES contact (id)');
  38.         $this->addSql('CREATE INDEX IDX_CC9305C419EB6921 ON contact_relationship_customer_supplier (client_id)');
  39.         $this->addSql('CREATE INDEX IDX_CC9305C42ADD6D8C ON contact_relationship_customer_supplier (supplier_id)');
  40.         $this->addSql('CREATE UNIQUE INDEX contact_client_relationship_unique ON contact_relationship_customer_supplier (supplier_id, client_id)');
  41.         $this->addSql('RENAME TABLE contact_relationship_customer_supplier TO contact_client_relationship');
  42.     }
  43. }