migrations/Version20221121173543.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\DBAL\Types\Type;
  9. use Doctrine\DBAL\Types\Types;
  10. use Doctrine\Migrations\AbstractMigration;
  12. final class Version20221121173543 extends AbstractMigration
  13. {
  14.     public function getDescription(): string
  15.     {
  16.         return 'Changes the avatar_image_url fields to text in company_user, health_mutual_user, mycmcm_user, public_api_user tables!';
  17.     }
  19.     public function up(Schema $schema): void
  20.     {
  21.         $this->skipIf(
  22.             $schema->getTable('company_user')->getColumn('avatar_image_url')->getType() === Type::getType(Types::TEXT),
  23.             'The company_user table\'s avatar_image_url field was already converted to text type!'
  24.         );
  26.         $schema->getTable('company_user')->getColumn('avatar_image_url')->setType(Type::getType(Types::TEXT));
  27.         $schema->getTable('health_mutual_user')->getColumn('avatar_image_url')->setType(Type::getType(Types::TEXT));
  28.         $schema->getTable('mycmcm_user')->getColumn('avatar_image_url')->setType(Type::getType(Types::TEXT));
  29.         $schema->getTable('public_api_user')->getColumn('avatar_image_url')->setType(Type::getType(Types::TEXT));
  30.     }
  32.     public function down(Schema $schema): void
  33.     {
  34.     }
  35. }