migrations/Version20221209170512.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 Version20221209170512 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Add descriptive_id and is_default fields to the subscription_plan table - second part';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql('UPDATE subscription_plan SET descriptive_id="common"  WHERE name="Régime commun"');
  20.         $this->addSql('UPDATE subscription_plan SET descriptive_id="prestaplus" WHERE name="Presta plus"');
  21.         $this->addSql('UPDATE subscription_plan SET descriptive_id="complete" WHERE name="Denta opti plus"');
  23.         $schema->getTable('subscription_plan')->addIndex(
  24.             ['descriptive_id'],
  25.             'uniq_subscription_plan_descriptive_id'
  26.         );
  27.         $schema->getTable('subscription_plan')->getColumn('descriptive_id')->setNotnull(true);
  28.     }
  30.     public function down(Schema $schema): void
  31.     {
  32.     }
  33. }