migrations/Version20221222113506.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. final class Version20221222113506 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Add short_code and export_id to health_insurance';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->skipIf(
  20.             true === $schema->getTable('health_insurance')->hasIndex('uniq_health_insurance_short_code'),
  21.             'The short_code field already exists in the health_insurance table!'
  22.         );
  24.         $schema->getTable('health_insurance')
  25.             ->getColumn('short_code')
  26.             ->setNotnull(true);
  28.         $schema->getTable('health_insurance')->addIndex(
  29.             ['short_code'],
  30.             'uniq_health_insurance_short_code'
  31.         );
  33.         $schema->getTable('health_insurance')
  34.             ->getColumn('export_id')
  35.             ->setNotnull(true);
  37.         $schema->getTable('health_insurance')->addIndex(
  38.             ['export_id'],
  39.             'uniq_health_insurance_export_id'
  40.         );
  41.     }
  43.     public function down(Schema $schema): void
  44.     {
  45.         $this->skipIf(
  46.             false === $schema->getTable('health_insurance')->hasIndex('uniq_health_insurance_short_code'),
  47.             'The short_code field already exists in the health_insurance table!'
  48.         );
  50.         $schema->getTable('health_insurance')->dropIndex('uniq_health_insurance_short_code');
  51.         $schema->getTable('health_insurance')->dropIndex('uniq_health_insurance_export_id');
  52.     }
  53. }