migrations/Version20230321233139.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 Version20230321233139 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('CREATE TABLE collaborator (id INT NOT NULL, code VARCHAR(255) NOT NULL, identifiant VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE customer_delivery_compliment (cus_id INT NOT NULL, com_id INT NOT NULL, INDEX IDX_1F7192BDEE1AA0B8 (cus_id), INDEX IDX_1F7192BD748C0F37 (com_id), PRIMARY KEY(cus_id, com_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE deliveryman_delivery_compliment (del_id INT NOT NULL, com_id INT NOT NULL, INDEX IDX_405DEBB9B85404B (del_id), INDEX IDX_405DEBB748C0F37 (com_id), PRIMARY KEY(del_id, com_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE customer_delivery_remarque (cus_id INT NOT NULL, com_id INT NOT NULL, INDEX IDX_CC0406DAEE1AA0B8 (cus_id), INDEX IDX_CC0406DA748C0F37 (com_id), PRIMARY KEY(cus_id, com_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE deliveryman_delivery_remarque (del_id INT NOT NULL, com_id INT NOT NULL, INDEX IDX_4FDACF189B85404B (del_id), INDEX IDX_4FDACF18748C0F37 (com_id), PRIMARY KEY(del_id, com_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE delivery_compliment (id INT AUTO_INCREMENT NOT NULL, delivery_id INT DEFAULT NULL, compliment_id INT DEFAULT NULL, INDEX IDX_2311641112136921 (delivery_id), INDEX IDX_231164111776C5E5 (compliment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('CREATE TABLE suspension (id INT AUTO_INCREMENT NOT NULL, delivery_man_id INT NOT NULL, duration VARCHAR(255) NOT NULL, comments LONGTEXT DEFAULT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_82AF0500FD128646 (delivery_man_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  30. $this->addSql('CREATE TABLE suspension_reason (suspension_id INT NOT NULL, reason_id INT NOT NULL, INDEX IDX_276188CB5D5F8F8E (suspension_id), INDEX IDX_276188CB59BB1592 (reason_id), PRIMARY KEY(suspension_id, reason_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  31. $this->addSql('ALTER TABLE collaborator ADD CONSTRAINT FK_606D487CBF396750 FOREIGN KEY (id) REFERENCES `user` (id) ON DELETE CASCADE');
  32. $this->addSql('ALTER TABLE customer_delivery_compliment ADD CONSTRAINT FK_1F7192BDEE1AA0B8 FOREIGN KEY (cus_id) REFERENCES delivery (id)');
  33. $this->addSql('ALTER TABLE customer_delivery_compliment ADD CONSTRAINT FK_1F7192BD748C0F37 FOREIGN KEY (com_id) REFERENCES compliment (id)');
  34. $this->addSql('ALTER TABLE deliveryman_delivery_compliment ADD CONSTRAINT FK_405DEBB9B85404B FOREIGN KEY (del_id) REFERENCES delivery (id)');
  35. $this->addSql('ALTER TABLE deliveryman_delivery_compliment ADD CONSTRAINT FK_405DEBB748C0F37 FOREIGN KEY (com_id) REFERENCES compliment (id)');
  36. $this->addSql('ALTER TABLE customer_delivery_remarque ADD CONSTRAINT FK_CC0406DAEE1AA0B8 FOREIGN KEY (cus_id) REFERENCES delivery (id)');
  37. $this->addSql('ALTER TABLE customer_delivery_remarque ADD CONSTRAINT FK_CC0406DA748C0F37 FOREIGN KEY (com_id) REFERENCES compliment (id)');
  38. $this->addSql('ALTER TABLE deliveryman_delivery_remarque ADD CONSTRAINT FK_4FDACF189B85404B FOREIGN KEY (del_id) REFERENCES delivery (id)');
  39. $this->addSql('ALTER TABLE deliveryman_delivery_remarque ADD CONSTRAINT FK_4FDACF18748C0F37 FOREIGN KEY (com_id) REFERENCES compliment (id)');
  40. $this->addSql('ALTER TABLE delivery_compliment ADD CONSTRAINT FK_2311641112136921 FOREIGN KEY (delivery_id) REFERENCES delivery (id)');
  41. $this->addSql('ALTER TABLE delivery_compliment ADD CONSTRAINT FK_231164111776C5E5 FOREIGN KEY (compliment_id) REFERENCES compliment (id)');
  42. $this->addSql('ALTER TABLE suspension ADD CONSTRAINT FK_82AF0500FD128646 FOREIGN KEY (delivery_man_id) REFERENCES delivery_man (id)');
  43. $this->addSql('ALTER TABLE suspension_reason ADD CONSTRAINT FK_276188CB5D5F8F8E FOREIGN KEY (suspension_id) REFERENCES suspension (id) ON DELETE CASCADE');
  44. $this->addSql('ALTER TABLE suspension_reason ADD CONSTRAINT FK_276188CB59BB1592 FOREIGN KEY (reason_id) REFERENCES reason (id) ON DELETE CASCADE');
  45. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC10E20974CC');
  46. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC107313B5E6');
  47. $this->addSql('DROP INDEX IDX_3781EC107313B5E6 ON delivery');
  48. $this->addSql('DROP INDEX IDX_3781EC10E20974CC ON delivery');
  49. $this->addSql('ALTER TABLE delivery DROP customer_compliment_id, DROP delivery_man_compliment_id');
  50. $this->addSql('ALTER TABLE document ADD document_status_id INT DEFAULT NULL');
  51. $this->addSql('ALTER TABLE document ADD CONSTRAINT FK_D8698A7679CF281C FOREIGN KEY (document_status_id) REFERENCES deliverer_document_status (id)');
  52. $this->addSql('CREATE INDEX IDX_D8698A7679CF281C ON document (document_status_id)');
  53. }
  55. public function down(Schema $schema): void
  56. {
  57. // this down() migration is auto-generated, please modify it to your needs
  58. $this->addSql('ALTER TABLE collaborator DROP FOREIGN KEY FK_606D487CBF396750');
  59. $this->addSql('ALTER TABLE customer_delivery_compliment DROP FOREIGN KEY FK_1F7192BDEE1AA0B8');
  60. $this->addSql('ALTER TABLE customer_delivery_compliment DROP FOREIGN KEY FK_1F7192BD748C0F37');
  61. $this->addSql('ALTER TABLE deliveryman_delivery_compliment DROP FOREIGN KEY FK_405DEBB9B85404B');
  62. $this->addSql('ALTER TABLE deliveryman_delivery_compliment DROP FOREIGN KEY FK_405DEBB748C0F37');
  63. $this->addSql('ALTER TABLE customer_delivery_remarque DROP FOREIGN KEY FK_CC0406DAEE1AA0B8');
  64. $this->addSql('ALTER TABLE customer_delivery_remarque DROP FOREIGN KEY FK_CC0406DA748C0F37');
  65. $this->addSql('ALTER TABLE deliveryman_delivery_remarque DROP FOREIGN KEY FK_4FDACF189B85404B');
  66. $this->addSql('ALTER TABLE deliveryman_delivery_remarque DROP FOREIGN KEY FK_4FDACF18748C0F37');
  67. $this->addSql('ALTER TABLE delivery_compliment DROP FOREIGN KEY FK_2311641112136921');
  68. $this->addSql('ALTER TABLE delivery_compliment DROP FOREIGN KEY FK_231164111776C5E5');
  69. $this->addSql('ALTER TABLE suspension DROP FOREIGN KEY FK_82AF0500FD128646');
  70. $this->addSql('ALTER TABLE suspension_reason DROP FOREIGN KEY FK_276188CB5D5F8F8E');
  71. $this->addSql('ALTER TABLE suspension_reason DROP FOREIGN KEY FK_276188CB59BB1592');
  72. $this->addSql('DROP TABLE collaborator');
  73. $this->addSql('DROP TABLE customer_delivery_compliment');
  74. $this->addSql('DROP TABLE deliveryman_delivery_compliment');
  75. $this->addSql('DROP TABLE customer_delivery_remarque');
  76. $this->addSql('DROP TABLE deliveryman_delivery_remarque');
  77. $this->addSql('DROP TABLE delivery_compliment');
  78. $this->addSql('DROP TABLE suspension');
  79. $this->addSql('DROP TABLE suspension_reason');
  80. $this->addSql('ALTER TABLE delivery ADD customer_compliment_id INT DEFAULT NULL, ADD delivery_man_compliment_id INT DEFAULT NULL');
  81. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10E20974CC FOREIGN KEY (delivery_man_compliment_id) REFERENCES compliment (id) ON UPDATE NO ACTION ON DELETE NO ACTION');
  82. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC107313B5E6 FOREIGN KEY (customer_compliment_id) REFERENCES compliment (id) ON UPDATE NO ACTION ON DELETE NO ACTION');
  83. $this->addSql('CREATE INDEX IDX_3781EC107313B5E6 ON delivery (customer_compliment_id)');
  84. $this->addSql('CREATE INDEX IDX_3781EC10E20974CC ON delivery (delivery_man_compliment_id)');
  85. $this->addSql('ALTER TABLE document DROP FOREIGN KEY FK_D8698A7679CF281C');
  86. $this->addSql('DROP INDEX IDX_D8698A7679CF281C ON document');
  87. $this->addSql('ALTER TABLE document DROP document_status_id');
  88. }
  89. }