migrations/Version20220701124648.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 Version20220701124648 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 filtre_structures_types_structure (filtre_structure_id INT NOT NULL, type_structure_id INT NOT NULL, INDEX IDX_A3D6A649885E6E5 (filtre_structure_id), INDEX IDX_A3D6A649A277BA8E (type_structure_id), PRIMARY KEY(filtre_structure_id, type_structure_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('ALTER TABLE filtre_structures_types_structure ADD CONSTRAINT FK_A3D6A649885E6E5 FOREIGN KEY (filtre_structure_id) REFERENCES FiltreStructure (id) ON DELETE CASCADE');
  25. $this->addSql('ALTER TABLE filtre_structures_types_structure ADD CONSTRAINT FK_A3D6A649A277BA8E FOREIGN KEY (type_structure_id) REFERENCES TypeStructure (id) ON DELETE CASCADE');
  26. $this->addSql('ALTER TABLE FiltreStructure DROP FOREIGN KEY FK_342580CEA277BA8E');
  27. $this->addSql('DROP INDEX IDX_342580CEA277BA8E ON FiltreStructure');
  28. $this->addSql('ALTER TABLE FiltreStructure DROP type_structure_id');
  29. //fix bug création de question dans limesurvey
  30. $this->addSql('ALTER TABLE lime_surveys CHANGE autonumber_start autonumber_start INT(11) NOT NULL DEFAULT "0"');
  31. $this->addSql('ALTER TABLE lime_surveys CHANGE usetokens usetokens VARCHAR(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL');
  33. }
  35. public function down(Schema $schema): void
  36. {
  37. // this down() migration is auto-generated, please modify it to your needs
  38. $this->addSql('DROP TABLE filtre_structures_types_structure');
  39. $this->addSql('ALTER TABLE FiltreStructure ADD type_structure_id INT DEFAULT NULL, CHANGE nom nom VARCHAR(255) CHARACTER SET utf8 NOT NULL COLLATE `utf8_unicode_ci`, CHANGE description description VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_unicode_ci`, CHANGE communes communes LONGTEXT CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_unicode_ci`');
  40. $this->addSql('ALTER TABLE FiltreStructure ADD CONSTRAINT FK_342580CEA277BA8E FOREIGN KEY (type_structure_id) REFERENCES TypeStructure (id)');
  41. $this->addSql('CREATE INDEX IDX_342580CEA277BA8E ON FiltreStructure (type_structure_id)');
  42. }
  43. }