migrations/Version20220328094051.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 Version20220328094051 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 reset_password_request (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, selector VARCHAR(20) NOT NULL, hashed_token VARCHAR(100) NOT NULL, requested_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', expires_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_7CE748AA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES User (id)');
  25. $this->addSql('DROP TABLE StatMedian');
  26. $this->addSql('DROP TABLE filtre_structures_communes');
  27. $this->addSql('DROP TABLE listes_politique_villes');
  28. $this->addSql('ALTER TABLE actions_tag DROP FOREIGN KEY FK_3C32D772D7244331');
  29. $this->addSql('DROP INDEX IDX_3C32D772D7244331 ON actions_tag');
  30. $this->addSql('ALTER TABLE actions_tag DROP PRIMARY KEY');
  31. $this->addSql('ALTER TABLE actions_tag CHANGE actiontag_id action_tag_id INT NOT NULL');
  32. $this->addSql('ALTER TABLE actions_tag ADD CONSTRAINT FK_3C32D77278E2527A FOREIGN KEY (action_tag_id) REFERENCES ActionTag (id) ON DELETE CASCADE');
  33. $this->addSql('CREATE INDEX IDX_3C32D77278E2527A ON actions_tag (action_tag_id)');
  34. $this->addSql('ALTER TABLE actions_tag ADD PRIMARY KEY (action_id, action_tag_id)');
  35. $this->addSql('ALTER TABLE ficheAction_actionPartners DROP FOREIGN KEY FK_ADE5CBC0D5EC8FC4');
  36. $this->addSql('ALTER TABLE ficheAction_actionPartners DROP FOREIGN KEY FK_ADE5CBC0D03333EF');
  37. $this->addSql('DROP INDEX IDX_ADE5CBC0D5EC8FC4 ON ficheAction_actionPartners');
  38. $this->addSql('DROP INDEX IDX_ADE5CBC0D03333EF ON ficheAction_actionPartners');
  39. $this->addSql('ALTER TABLE ficheAction_actionPartners DROP PRIMARY KEY');
  40. $this->addSql('ALTER TABLE ficheAction_actionPartners ADD fiche_action_id INT NOT NULL, ADD partner_action_id INT NOT NULL, DROP ficheaction_id, DROP partneraction_id');
  41. $this->addSql('ALTER TABLE ficheAction_actionPartners ADD CONSTRAINT FK_ADE5CBC01A5C4DDD FOREIGN KEY (fiche_action_id) REFERENCES FicheAction (id) ON DELETE CASCADE');
  42. $this->addSql('ALTER TABLE ficheAction_actionPartners ADD CONSTRAINT FK_ADE5CBC0B6E56B21 FOREIGN KEY (partner_action_id) REFERENCES PartnerAction (id) ON DELETE CASCADE');
  43. $this->addSql('CREATE INDEX IDX_ADE5CBC01A5C4DDD ON ficheAction_actionPartners (fiche_action_id)');
  44. $this->addSql('CREATE INDEX IDX_ADE5CBC0B6E56B21 ON ficheAction_actionPartners (partner_action_id)');
  45. $this->addSql('ALTER TABLE ficheAction_actionPartners ADD PRIMARY KEY (fiche_action_id, partner_action_id)');
  46. $this->addSql('ALTER TABLE ficheAction_financialPartners DROP FOREIGN KEY FK_4043F29D5EC8FC4');
  47. $this->addSql('ALTER TABLE ficheAction_financialPartners DROP FOREIGN KEY FK_4043F29D03333EF');
  48. $this->addSql('DROP INDEX IDX_4043F29D5EC8FC4 ON ficheAction_financialPartners');
  49. $this->addSql('DROP INDEX IDX_4043F29D03333EF ON ficheAction_financialPartners');
  50. $this->addSql('ALTER TABLE ficheAction_financialPartners DROP PRIMARY KEY');
  51. $this->addSql('ALTER TABLE ficheAction_financialPartners ADD fiche_action_id INT NOT NULL, ADD partner_action_id INT NOT NULL, DROP ficheaction_id, DROP partneraction_id');
  52. $this->addSql('ALTER TABLE ficheAction_financialPartners ADD CONSTRAINT FK_4043F291A5C4DDD FOREIGN KEY (fiche_action_id) REFERENCES FicheAction (id) ON DELETE CASCADE');
  53. $this->addSql('ALTER TABLE ficheAction_financialPartners ADD CONSTRAINT FK_4043F29B6E56B21 FOREIGN KEY (partner_action_id) REFERENCES PartnerAction (id) ON DELETE CASCADE');
  54. $this->addSql('CREATE INDEX IDX_4043F291A5C4DDD ON ficheAction_financialPartners (fiche_action_id)');
  55. $this->addSql('CREATE INDEX IDX_4043F29B6E56B21 ON ficheAction_financialPartners (partner_action_id)');
  56. $this->addSql('ALTER TABLE ficheAction_financialPartners ADD PRIMARY KEY (fiche_action_id, partner_action_id)');
  57. $this->addSql('ALTER TABLE ficheAction_keyword DROP FOREIGN KEY FK_B4EA9512D5EC8FC4');
  58. $this->addSql('DROP INDEX IDX_B4EA9512D5EC8FC4 ON ficheAction_keyword');
  59. $this->addSql('ALTER TABLE ficheAction_keyword DROP PRIMARY KEY');
  60. $this->addSql('ALTER TABLE ficheAction_keyword CHANGE ficheaction_id fiche_action_id INT NOT NULL');
  61. $this->addSql('ALTER TABLE ficheAction_keyword ADD CONSTRAINT FK_B4EA95121A5C4DDD FOREIGN KEY (fiche_action_id) REFERENCES FicheAction (id) ON DELETE CASCADE');
  62. $this->addSql('CREATE INDEX IDX_B4EA95121A5C4DDD ON ficheAction_keyword (fiche_action_id)');
  63. $this->addSql('ALTER TABLE ficheAction_keyword ADD PRIMARY KEY (fiche_action_id, keyword_id)');
  64. $this->addSql('ALTER TABLE ficheAction_applicant DROP FOREIGN KEY FK_298C47EAD5EC8FC4');
  65. $this->addSql('ALTER TABLE ficheAction_applicant DROP FOREIGN KEY FK_298C47EA77E5BA48');
  66. $this->addSql('DROP INDEX IDX_298C47EAD5EC8FC4 ON ficheAction_applicant');
  67. $this->addSql('DROP INDEX IDX_298C47EA77E5BA48 ON ficheAction_applicant');
  68. $this->addSql('ALTER TABLE ficheAction_applicant DROP PRIMARY KEY');
  69. $this->addSql('ALTER TABLE ficheAction_applicant ADD fiche_action_id INT NOT NULL, ADD applicant_action_id INT NOT NULL, DROP ficheaction_id, DROP applicantaction_id');
  70. $this->addSql('ALTER TABLE ficheAction_applicant ADD CONSTRAINT FK_298C47EA1A5C4DDD FOREIGN KEY (fiche_action_id) REFERENCES FicheAction (id) ON DELETE CASCADE');
  71. $this->addSql('ALTER TABLE ficheAction_applicant ADD CONSTRAINT FK_298C47EAFEF08BE3 FOREIGN KEY (applicant_action_id) REFERENCES ApplicantAction (id) ON DELETE CASCADE');
  72. $this->addSql('CREATE INDEX IDX_298C47EA1A5C4DDD ON ficheAction_applicant (fiche_action_id)');
  73. $this->addSql('CREATE INDEX IDX_298C47EAFEF08BE3 ON ficheAction_applicant (applicant_action_id)');
  74. $this->addSql('ALTER TABLE ficheAction_applicant ADD PRIMARY KEY (fiche_action_id, applicant_action_id)');
  75. $this->addSql('ALTER TABLE FicheSynthetique ADD logo_original_name VARCHAR(255) DEFAULT NULL, ADD logo_mime_type VARCHAR(255) DEFAULT NULL, ADD logo_size INT DEFAULT NULL, ADD logo_dimensions LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\', CHANGE logo logo_name VARCHAR(255) DEFAULT NULL');
  76. $this->addSql('ALTER TABLE FiltreStructure DROP FOREIGN KEY FK_342580CE3174800F');
  77. $this->addSql('DROP INDEX IDX_342580CE3174800F ON FiltreStructure');
  78. $this->addSql('ALTER TABLE FiltreStructure CHANGE createdBy_id created_by_id INT DEFAULT NULL');
  79. $this->addSql('ALTER TABLE FiltreStructure ADD CONSTRAINT FK_342580CEB03A8386 FOREIGN KEY (created_by_id) REFERENCES User (id) ON DELETE SET NULL');
  80. $this->addSql('CREATE INDEX IDX_342580CEB03A8386 ON FiltreStructure (created_by_id)');
  81. $this->addSql('ALTER TABLE filtre_structures_politique_villes DROP FOREIGN KEY FK_3A415723C880518A');
  82. $this->addSql('ALTER TABLE filtre_structures_politique_villes DROP FOREIGN KEY FK_3A415723B23D1CD');
  83. $this->addSql('DROP INDEX IDX_3A415723C880518A ON filtre_structures_politique_villes');
  84. $this->addSql('DROP INDEX IDX_3A415723B23D1CD ON filtre_structures_politique_villes');
  85. $this->addSql('ALTER TABLE filtre_structures_politique_villes DROP PRIMARY KEY');
  86. $this->addSql('ALTER TABLE filtre_structures_politique_villes ADD filtre_structure_id INT NOT NULL, ADD politique_ville_id INT NOT NULL, DROP filtrestructure_id, DROP politiqueville_id');
  87. $this->addSql('ALTER TABLE filtre_structures_politique_villes ADD CONSTRAINT FK_3A415723885E6E5 FOREIGN KEY (filtre_structure_id) REFERENCES FiltreStructure (id) ON DELETE CASCADE');
  88. $this->addSql('ALTER TABLE filtre_structures_politique_villes ADD CONSTRAINT FK_3A415723A33C7213 FOREIGN KEY (politique_ville_id) REFERENCES PolitiqueVille (id) ON DELETE CASCADE');
  89. $this->addSql('CREATE INDEX IDX_3A415723885E6E5 ON filtre_structures_politique_villes (filtre_structure_id)');
  90. $this->addSql('CREATE INDEX IDX_3A415723A33C7213 ON filtre_structures_politique_villes (politique_ville_id)');
  91. $this->addSql('ALTER TABLE filtre_structures_politique_villes ADD PRIMARY KEY (filtre_structure_id, politique_ville_id)');
  92. $this->addSql('ALTER TABLE structures_adherentAutreFederation DROP FOREIGN KEY FK_E3699C8CB9667CFE');
  93. $this->addSql('DROP INDEX IDX_E3699C8CB9667CFE ON structures_adherentAutreFederation');
  94. $this->addSql('ALTER TABLE structures_adherentAutreFederation DROP PRIMARY KEY');
  95. $this->addSql('ALTER TABLE structures_adherentAutreFederation CHANGE adherentautrefederation_id adherent_autre_federation_id INT NOT NULL');
  96. $this->addSql('ALTER TABLE structures_adherentAutreFederation ADD CONSTRAINT FK_E3699C8CAD6691A3 FOREIGN KEY (adherent_autre_federation_id) REFERENCES AdherentAutreFederation (id) ON DELETE CASCADE');
  97. $this->addSql('CREATE INDEX IDX_E3699C8CAD6691A3 ON structures_adherentAutreFederation (adherent_autre_federation_id)');
  98. $this->addSql('ALTER TABLE structures_adherentAutreFederation ADD PRIMARY KEY (structure_id, adherent_autre_federation_id)');
  99. $this->addSql('ALTER TABLE structures_systemeAdhesionGoal DROP FOREIGN KEY FK_78CE484745000EF2');
  100. $this->addSql('DROP INDEX IDX_78CE484745000EF2 ON structures_systemeAdhesionGoal');
  101. $this->addSql('ALTER TABLE structures_systemeAdhesionGoal DROP PRIMARY KEY');
  102. $this->addSql('ALTER TABLE structures_systemeAdhesionGoal CHANGE systemeadhesiongoal_id systeme_adhesion_goal_id INT NOT NULL');
  103. $this->addSql('ALTER TABLE structures_systemeAdhesionGoal ADD CONSTRAINT FK_78CE4847B6EA5821 FOREIGN KEY (systeme_adhesion_goal_id) REFERENCES SystemeAdhesionGoal (id) ON DELETE CASCADE');
  104. $this->addSql('CREATE INDEX IDX_78CE4847B6EA5821 ON structures_systemeAdhesionGoal (systeme_adhesion_goal_id)');
  105. $this->addSql('ALTER TABLE structures_systemeAdhesionGoal ADD PRIMARY KEY (structure_id, systeme_adhesion_goal_id)');
  106. $this->addSql('ALTER TABLE structures_politique_villes DROP FOREIGN KEY FK_9E7BEA63B23D1CD');
  107. $this->addSql('DROP INDEX IDX_9E7BEA63B23D1CD ON structures_politique_villes');
  108. $this->addSql('ALTER TABLE structures_politique_villes DROP PRIMARY KEY');
  109. $this->addSql('ALTER TABLE structures_politique_villes CHANGE politiqueville_id politique_ville_id INT NOT NULL');
  110. $this->addSql('ALTER TABLE structures_politique_villes ADD CONSTRAINT FK_9E7BEA63A33C7213 FOREIGN KEY (politique_ville_id) REFERENCES PolitiqueVille (id) ON DELETE CASCADE');
  111. $this->addSql('CREATE INDEX IDX_9E7BEA63A33C7213 ON structures_politique_villes (politique_ville_id)');
  112. $this->addSql('ALTER TABLE structures_politique_villes ADD PRIMARY KEY (structure_id, politique_ville_id)');
  113. $this->addSql('DROP INDEX UNIQ_957A6479A0D96FBF ON User');
  114. $this->addSql('DROP INDEX UNIQ_957A6479C05FB297 ON User');
  115. $this->addSql('DROP INDEX UNIQ_957A647992FC23A8 ON User');
  116. $this->addSql('ALTER TABLE User DROP FOREIGN KEY FK_957A647998260155');
  117. $this->addSql('ALTER TABLE User DROP username_canonical, DROP email_canonical');
  118. $this->addSql('CREATE UNIQUE INDEX UNIQ_2DA17977F85E0677 ON User (username)');
  119. $this->addSql('CREATE UNIQUE INDEX UNIQ_2DA17977E7927C74 ON User (email)');
  120. $this->addSql('DROP INDEX idx_957a647998260155 ON User');
  121. $this->addSql('CREATE INDEX IDX_2DA1797798260155 ON User (region_id)');
  122. $this->addSql('DROP INDEX fos_user_tokens ON User');
  123. $this->addSql('CREATE INDEX user_tokens ON User (token)');
  124. $this->addSql('ALTER TABLE User ADD CONSTRAINT FK_957A647998260155 FOREIGN KEY (region_id) REFERENCES Region (id)');
  126. ## Recupération des données depuis bdd senacsV2 pour les manyoToMany
  127. $this->addSql('INSERT INTO senacsv3.ficheAction_actionPartners SELECT * FROM senacs.ficheAction_actionPartners;');
  128. $this->addSql('INSERT INTO senacsv3.ficheAction_applicant SELECT * FROM senacs.ficheAction_applicant;');
  129. $this->addSql('INSERT INTO senacsv3.ficheAction_financialPartners SELECT * FROM senacs.ficheAction_financialPartners;');
  130. $this->addSql('INSERT INTO senacsv3.ficheAction_keyword SELECT * FROM senacs.ficheAction_keyword;');
  131. $this->addSql('INSERT INTO senacsv3.filtre_structures_politique_villes SELECT * FROM senacs.filtre_structures_politique_villes;');
  133. ## modifs passord EVS / CSO : Senacs2022
  134. $this->addSql('UPDATE User u INNER JOIN Structure s ON s.user_id = u.id SET u.password="$2y$13$LzfRgTDOBrkh0nu15eYbTuYTlLFiURQaYo99uQ4gcgOc.c8p/h9PW" WHERE s.type_structure_id IN (2,4);');
  135. ## modifs passord CAF / FDD / RR / RGR : Campagne2022
  136. $this->addSql('UPDATE User u INNER JOIN Structure s ON s.user_id = u.id SET u.password="$2y$13$Cu0HR.d4wI5y/ejr1QW.9.djmu8YBLehClwlJylhuOQ5szy6h.D9C" WHERE s.type_structure_id IN (3,5,7,8,9,10,11);');
  137. ## modifs passord RN : SenacsCampagne2022
  138. $this->addSql('UPDATE User u INNER JOIN Structure s ON s.user_id = u.id SET u.password="$2y$13$wugtNDH8USIXMa2k2U5PqOPoKxnbODoZG2aoQOxserTBr3K2wuMs." WHERE s.type_structure_id=6;');
  139. ## Update admin user password: %claire_69
  140. $this->addSql('UPDATE User SET password="$2y$13$hEZvqWFhTE/n1COkZtOZ8.hJQHpyZ6G12zQIQSkGJ4CqYpHU6yZBS" WHERE id=1;');
  141. }
  143. public function down(Schema $schema): void
  144. {
  145. }
  146. }