migrations/Version20240304182927.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 Version20240304182927 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('DROP TABLE ch_cookieconsent_log');
  24. $this->addSql('ALTER TABLE majoration_transport ADD CONSTRAINT FK_23B85CC684CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id)');
  25. $this->addSql('ALTER TABLE majoration_transport ADD CONSTRAINT FK_23B85CC6F965414C FOREIGN KEY (saison_id) REFERENCES saison (id)');
  26. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10CD5044DA1 FOREIGN KEY (media_categorie_id) REFERENCES media_categorie (id)');
  27. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10C571A79FE FOREIGN KEY (media_parent_id) REFERENCES media (id)');
  28. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10C84CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id)');
  29. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10CB6121583 FOREIGN KEY (candidature_id) REFERENCES candidature (id)');
  30. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10CE7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
  31. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10C44F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  32. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10C5DAC5993 FOREIGN KEY (inscription_id) REFERENCES inscription (id)');
  33. $this->addSql('ALTER TABLE media ADD CONSTRAINT FK_6A2CA10CF965414C FOREIGN KEY (saison_id) REFERENCES saison (id)');
  34. $this->addSql('ALTER TABLE media_categorie ADD CONSTRAINT FK_6C1D65BA4CF5E510 FOREIGN KEY (interaction_template_id) REFERENCES interaction_template (id)');
  35. $this->addSql('ALTER TABLE message_directeur_aux_parents ADD CONSTRAINT FK_C649D49FE82E7EE8 FOREIGN KEY (directeur_id) REFERENCES contact (id)');
  36. $this->addSql('ALTER TABLE message_directeur_aux_parents ADD CONSTRAINT FK_C649D49F44F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  37. $this->addSql('ALTER TABLE message_parent ADD CONSTRAINT FK_AA9FD4044F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  38. $this->addSql('ALTER TABLE property ADD CONSTRAINT FK_8BF21CDE727ACA70 FOREIGN KEY (parent_id) REFERENCES property (id)');
  39. $this->addSql('ALTER TABLE reduction ADD CONSTRAINT FK_B1E75468A97D1AC3 FOREIGN KEY (enterprise_id) REFERENCES enterprise (id)');
  40. $this->addSql('ALTER TABLE reduction_item ADD CONSTRAINT FK_FE60A8A020C7E1C9 FOREIGN KEY (compta_type_id) REFERENCES compta_type (id)');
  41. $this->addSql('ALTER TABLE reduction_item ADD CONSTRAINT FK_FE60A8A0C03CB092 FOREIGN KEY (reduction_id) REFERENCES reduction (id)');
  42. $this->addSql('ALTER TABLE reduction_request ADD CONSTRAINT FK_BDAD12D6E7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
  43. $this->addSql('ALTER TABLE reduction_request ADD CONSTRAINT FK_BDAD12D6C03CB092 FOREIGN KEY (reduction_id) REFERENCES reduction (id)');
  44. $this->addSql('ALTER TABLE reduction_request ADD CONSTRAINT FK_BDAD12D682EA2E54 FOREIGN KEY (commande_id) REFERENCES commande (id)');
  45. $this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  46. $this->addSql('ALTER TABLE sejour ADD CONSTRAINT FK_96F5202864D218E FOREIGN KEY (location_id) REFERENCES location (id)');
  47. $this->addSql('ALTER TABLE sejour ADD CONSTRAINT FK_96F520286B75E559 FOREIGN KEY (tranche_age1_id) REFERENCES tranche_age (id)');
  48. $this->addSql('ALTER TABLE sejour ADD CONSTRAINT FK_96F5202879C04AB7 FOREIGN KEY (tranche_age2_id) REFERENCES tranche_age (id)');
  49. $this->addSql('ALTER TABLE sejour_theme ADD CONSTRAINT FK_7F55811C84CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id) ON DELETE CASCADE');
  50. $this->addSql('ALTER TABLE sejour_theme ADD CONSTRAINT FK_7F55811C59027487 FOREIGN KEY (theme_id) REFERENCES theme (id) ON DELETE CASCADE');
  51. $this->addSql('ALTER TABLE sejour_country ADD CONSTRAINT FK_D90C327E84CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id) ON DELETE CASCADE');
  52. $this->addSql('ALTER TABLE sejour_country ADD CONSTRAINT FK_D90C327EF92F3E70 FOREIGN KEY (country_id) REFERENCES country (id) ON DELETE CASCADE');
  53. $this->addSql('ALTER TABLE sejour_saison ADD CONSTRAINT FK_DAE2219D84CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id) ON DELETE CASCADE');
  54. $this->addSql('ALTER TABLE sejour_saison ADD CONSTRAINT FK_DAE2219DF965414C FOREIGN KEY (saison_id) REFERENCES saison (id) ON DELETE CASCADE');
  55. $this->addSql('ALTER TABLE sejour_property ADD CONSTRAINT FK_9814FB7384CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id) ON DELETE CASCADE');
  56. $this->addSql('ALTER TABLE sejour_property ADD CONSTRAINT FK_9814FB73549213EC FOREIGN KEY (property_id) REFERENCES property (id) ON DELETE CASCADE');
  57. $this->addSql('ALTER TABLE sejour_tranche_age ADD CONSTRAINT FK_127BFB3684CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id) ON DELETE CASCADE');
  58. $this->addSql('ALTER TABLE sejour_tranche_age ADD CONSTRAINT FK_127BFB36A43AD6F0 FOREIGN KEY (tranche_age_id) REFERENCES tranche_age (id) ON DELETE CASCADE');
  59. $this->addSql('ALTER TABLE sejour_equipier ADD CONSTRAINT FK_E1A51B0B84CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id)');
  60. $this->addSql('ALTER TABLE sejour_equipier ADD CONSTRAINT FK_E1A51B0BED16FA20 FOREIGN KEY (metier_id) REFERENCES metier (id)');
  61. $this->addSql('ALTER TABLE sejour_session ADD CONSTRAINT FK_5A3B2ECC84CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id)');
  62. $this->addSql('ALTER TABLE sejour_session_equipier ADD CONSTRAINT FK_69FDE3C744F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  63. $this->addSql('ALTER TABLE sejour_session_equipier ADD CONSTRAINT FK_69FDE3C7E7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
  64. $this->addSql('ALTER TABLE sejour_session_equipier ADD CONSTRAINT FK_69FDE3C7ED16FA20 FOREIGN KEY (metier_id) REFERENCES metier (id)');
  65. $this->addSql('ALTER TABLE sejour_session_equipier ADD CONSTRAINT FK_69FDE3C7A4502180 FOREIGN KEY (employee_contract_id) REFERENCES employee_contract (id)');
  66. $this->addSql('ALTER TABLE sejour_session_majoration_transport ADD CONSTRAINT FK_75BE2BC544F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  67. $this->addSql('ALTER TABLE sejour_session_majoration_transport ADD CONSTRAINT FK_75BE2BC520D70607 FOREIGN KEY (majoration_transport_id) REFERENCES majoration_transport (id)');
  68. $this->addSql('ALTER TABLE sejour_session_media_categorie ADD CONSTRAINT FK_76EA427544F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  69. $this->addSql('ALTER TABLE sejour_session_media_categorie ADD CONSTRAINT FK_76EA4275EA9FDD75 FOREIGN KEY (media_id) REFERENCES media (id)');
  70. $this->addSql('ALTER TABLE sejour_session_media_categorie ADD CONSTRAINT FK_76EA4275D5044DA1 FOREIGN KEY (media_categorie_id) REFERENCES media_categorie (id)');
  71. $this->addSql('ALTER TABLE sejour_session_picture ADD CONSTRAINT FK_CC069E4944F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  72. $this->addSql('ALTER TABLE sejour_session_picture ADD CONSTRAINT FK_CC069E494014244 FOREIGN KEY (user_valid_id) REFERENCES user (id)');
  73. $this->addSql('ALTER TABLE sejour_session_picture ADD CONSTRAINT FK_CC069E49F987D8A8 FOREIGN KEY (user_created_id) REFERENCES user (id)');
  74. $this->addSql('ALTER TABLE sejour_whitelist ADD CONSTRAINT FK_6372A1D6A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  75. $this->addSql('ALTER TABLE sejour_whitelist ADD CONSTRAINT FK_6372A1D684CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id)');
  76. $this->addSql('ALTER TABLE temoignage ADD CONSTRAINT FK_BDADBC4684CF0CF FOREIGN KEY (sejour_id) REFERENCES sejour (id)');
  77. $this->addSql('ALTER TABLE temoignage ADD CONSTRAINT FK_BDADBC4644F84A46 FOREIGN KEY (sejour_session_id) REFERENCES sejour_session (id)');
  78. $this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA33E136988 FOREIGN KEY (personne_associe_id) REFERENCES contact (id)');
  79. $this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA3B03A8386 FOREIGN KEY (created_by_id) REFERENCES user (id)');
  80. $this->addSql('ALTER TABLE ticket_comment ADD CONSTRAINT FK_98B80B3EA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  81. $this->addSql('ALTER TABLE ticket_comment ADD CONSTRAINT FK_98B80B3E700047D2 FOREIGN KEY (ticket_id) REFERENCES ticket (id)');
  82. $this->addSql('ALTER TABLE tiers_de_confiance ADD CONSTRAINT FK_EF8EBA24627EA78A FOREIGN KEY (main_id) REFERENCES contact (id)');
  83. $this->addSql('ALTER TABLE tiers_de_confiance ADD CONSTRAINT FK_EF8EBA245DAC5993 FOREIGN KEY (inscription_id) REFERENCES inscription (id)');
  84. $this->addSql('ALTER TABLE tiers_de_confiance ADD CONSTRAINT FK_EF8EBA2468B77723 FOREIGN KEY (tiers_id) REFERENCES contact (id)');
  85. $this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649E7A1254A FOREIGN KEY (contact_id) REFERENCES contact (id)');
  86. }
  88. public function down(Schema $schema): void
  89. {
  90. // this down() migration is auto-generated, please modify it to your needs
  91. $this->addSql('CREATE TABLE ch_cookieconsent_log (id INT AUTO_INCREMENT NOT NULL, ip_address VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, cookie_consent_key VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, cookie_name VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, cookie_value VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, timestamp DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
  92. $this->addSql('ALTER TABLE majoration_transport DROP FOREIGN KEY FK_23B85CC684CF0CF');
  93. $this->addSql('ALTER TABLE majoration_transport DROP FOREIGN KEY FK_23B85CC6F965414C');
  94. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10CD5044DA1');
  95. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10C571A79FE');
  96. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10C84CF0CF');
  97. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10CB6121583');
  98. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10CE7A1254A');
  99. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10C44F84A46');
  100. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10C5DAC5993');
  101. $this->addSql('ALTER TABLE media DROP FOREIGN KEY FK_6A2CA10CF965414C');
  102. $this->addSql('ALTER TABLE media_categorie DROP FOREIGN KEY FK_6C1D65BA4CF5E510');
  103. $this->addSql('ALTER TABLE message_directeur_aux_parents DROP FOREIGN KEY FK_C649D49FE82E7EE8');
  104. $this->addSql('ALTER TABLE message_directeur_aux_parents DROP FOREIGN KEY FK_C649D49F44F84A46');
  105. $this->addSql('ALTER TABLE message_parent DROP FOREIGN KEY FK_AA9FD4044F84A46');
  106. $this->addSql('ALTER TABLE property DROP FOREIGN KEY FK_8BF21CDE727ACA70');
  107. $this->addSql('ALTER TABLE reduction DROP FOREIGN KEY FK_B1E75468A97D1AC3');
  108. $this->addSql('ALTER TABLE reduction_item DROP FOREIGN KEY FK_FE60A8A020C7E1C9');
  109. $this->addSql('ALTER TABLE reduction_item DROP FOREIGN KEY FK_FE60A8A0C03CB092');
  110. $this->addSql('ALTER TABLE reduction_request DROP FOREIGN KEY FK_BDAD12D6E7A1254A');
  111. $this->addSql('ALTER TABLE reduction_request DROP FOREIGN KEY FK_BDAD12D6C03CB092');
  112. $this->addSql('ALTER TABLE reduction_request DROP FOREIGN KEY FK_BDAD12D682EA2E54');
  113. $this->addSql('ALTER TABLE reset_password_request DROP FOREIGN KEY FK_7CE748AA76ED395');
  114. $this->addSql('ALTER TABLE sejour DROP FOREIGN KEY FK_96F5202864D218E');
  115. $this->addSql('ALTER TABLE sejour DROP FOREIGN KEY FK_96F520286B75E559');
  116. $this->addSql('ALTER TABLE sejour DROP FOREIGN KEY FK_96F5202879C04AB7');
  117. $this->addSql('ALTER TABLE sejour_country DROP FOREIGN KEY FK_D90C327E84CF0CF');
  118. $this->addSql('ALTER TABLE sejour_country DROP FOREIGN KEY FK_D90C327EF92F3E70');
  119. $this->addSql('ALTER TABLE sejour_equipier DROP FOREIGN KEY FK_E1A51B0B84CF0CF');
  120. $this->addSql('ALTER TABLE sejour_equipier DROP FOREIGN KEY FK_E1A51B0BED16FA20');
  121. $this->addSql('ALTER TABLE sejour_property DROP FOREIGN KEY FK_9814FB7384CF0CF');
  122. $this->addSql('ALTER TABLE sejour_property DROP FOREIGN KEY FK_9814FB73549213EC');
  123. $this->addSql('ALTER TABLE sejour_saison DROP FOREIGN KEY FK_DAE2219D84CF0CF');
  124. $this->addSql('ALTER TABLE sejour_saison DROP FOREIGN KEY FK_DAE2219DF965414C');
  125. $this->addSql('ALTER TABLE sejour_session DROP FOREIGN KEY FK_5A3B2ECC84CF0CF');
  126. $this->addSql('ALTER TABLE sejour_session_equipier DROP FOREIGN KEY FK_69FDE3C744F84A46');
  127. $this->addSql('ALTER TABLE sejour_session_equipier DROP FOREIGN KEY FK_69FDE3C7E7A1254A');
  128. $this->addSql('ALTER TABLE sejour_session_equipier DROP FOREIGN KEY FK_69FDE3C7ED16FA20');
  129. $this->addSql('ALTER TABLE sejour_session_equipier DROP FOREIGN KEY FK_69FDE3C7A4502180');
  130. $this->addSql('ALTER TABLE sejour_session_majoration_transport DROP FOREIGN KEY FK_75BE2BC544F84A46');
  131. $this->addSql('ALTER TABLE sejour_session_majoration_transport DROP FOREIGN KEY FK_75BE2BC520D70607');
  132. $this->addSql('ALTER TABLE sejour_session_media_categorie DROP FOREIGN KEY FK_76EA427544F84A46');
  133. $this->addSql('ALTER TABLE sejour_session_media_categorie DROP FOREIGN KEY FK_76EA4275EA9FDD75');
  134. $this->addSql('ALTER TABLE sejour_session_media_categorie DROP FOREIGN KEY FK_76EA4275D5044DA1');
  135. $this->addSql('ALTER TABLE sejour_session_picture DROP FOREIGN KEY FK_CC069E4944F84A46');
  136. $this->addSql('ALTER TABLE sejour_session_picture DROP FOREIGN KEY FK_CC069E494014244');
  137. $this->addSql('ALTER TABLE sejour_session_picture DROP FOREIGN KEY FK_CC069E49F987D8A8');
  138. $this->addSql('ALTER TABLE sejour_theme DROP FOREIGN KEY FK_7F55811C84CF0CF');
  139. $this->addSql('ALTER TABLE sejour_theme DROP FOREIGN KEY FK_7F55811C59027487');
  140. $this->addSql('ALTER TABLE sejour_tranche_age DROP FOREIGN KEY FK_127BFB3684CF0CF');
  141. $this->addSql('ALTER TABLE sejour_tranche_age DROP FOREIGN KEY FK_127BFB36A43AD6F0');
  142. $this->addSql('ALTER TABLE sejour_whitelist DROP FOREIGN KEY FK_6372A1D6A76ED395');
  143. $this->addSql('ALTER TABLE sejour_whitelist DROP FOREIGN KEY FK_6372A1D684CF0CF');
  144. $this->addSql('ALTER TABLE temoignage DROP FOREIGN KEY FK_BDADBC4684CF0CF');
  145. $this->addSql('ALTER TABLE temoignage DROP FOREIGN KEY FK_BDADBC4644F84A46');
  146. $this->addSql('ALTER TABLE ticket DROP FOREIGN KEY FK_97A0ADA33E136988');
  147. $this->addSql('ALTER TABLE ticket DROP FOREIGN KEY FK_97A0ADA3B03A8386');
  148. $this->addSql('ALTER TABLE ticket_comment DROP FOREIGN KEY FK_98B80B3EA76ED395');
  149. $this->addSql('ALTER TABLE ticket_comment DROP FOREIGN KEY FK_98B80B3E700047D2');
  150. $this->addSql('ALTER TABLE tiers_de_confiance DROP FOREIGN KEY FK_EF8EBA24627EA78A');
  151. $this->addSql('ALTER TABLE tiers_de_confiance DROP FOREIGN KEY FK_EF8EBA245DAC5993');
  152. $this->addSql('ALTER TABLE tiers_de_confiance DROP FOREIGN KEY FK_EF8EBA2468B77723');
  153. $this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D649E7A1254A');
  154. }
  155. }