migrations/Version20251118065724.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. * Remove unique constraint from psid field
  12. */
  13. final class Version20251118065724 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return 'Remove unique constraint from psid field';
  18. }
  20. public function up(Schema $schema): void
  21. {
  22. // Check if index exists before dropping
  23. $schemaManager = $this->connection->createSchemaManager();
  24. $indexes = $schemaManager->listTableIndexes('gemeinde');
  26. if (isset($indexes['uniq_bb1494e7e22cdc26'])) {
  27. $this->addSql('DROP INDEX UNIQ_BB1494E7E22CDC26 ON gemeinde');
  28. }
  29. }
  31. public function down(Schema $schema): void
  32. {
  33. $this->addSql('CREATE UNIQUE INDEX UNIQ_BB1494E7E22CDC26 ON gemeinde (psid)');
  34. }
  35. }