migrations/Version20211228135523.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 Version20211228135523 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('SET foreign_key_checks = 0');
  24. //$this->addSql('RENAME TABLE `senacsv3`.`fos_user` TO `senacsv3`.`User`;');
  25. $this->addSql('RENAME TABLE fos_user TO User;');
  26. $this->addSql('DROP TABLE Liste');
  27. $this->addSql('DROP TABLE actions2');
  28. $this->addSql('DROP TABLE commune_manquante');
  29. $this->addSql('DROP TABLE commune_tmp');
  30. $this->addSql('DROP TABLE ext_translations');
  31. $this->addSql('DROP TABLE import_action');
  32. $this->addSql('DROP TABLE import_v1');
  33. $this->addSql('DROP TABLE lime_old_survey_836735_20210412104008');
  34. $this->addSql('DROP TABLE lime_old_survey_836735_20210412113915');
  35. $this->addSql('DROP TABLE lime_old_survey_886582_20210415153840');
  36. $this->addSql('DROP TABLE lime_old_survey_945397_20210412113343');
  37. $this->addSql('DROP TABLE lime_old_survey_997221_20190621113744');
  38. $this->addSql('DROP TABLE lime_old_tokens_997221_20190621113744');
  39. $this->addSql('DROP TABLE population');
  40. $this->addSql('DROP TABLE structures_temp');
  42. ## purge des tables manyToMany
  43. $this->addSql('DELETE FROM ficheAction_actionPartners;');
  44. $this->addSql('DELETE FROM ficheAction_applicant;');
  45. $this->addSql('DELETE FROM ficheAction_financialPartners;');
  46. $this->addSql('DELETE FROM ficheAction_keyword;');
  47. $this->addSql('DELETE FROM filtre_structures_communes;');
  48. $this->addSql('DELETE FROM filtre_structures_politique_villes;');
  49. }
  51. public function down(Schema $schema): void
  52. {
  53. // this down() migration is auto-generated, please modify it to your needs
  54. }
  55. }