migrations/Version20220930122048.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\Types;
  9. use Doctrine\Migrations\AbstractMigration;
  11. final class Version20220930122048 extends AbstractMigration
  12. {
  13.     public function getDescription(): string
  14.     {
  15.         return '';
  16.     }
  18.     public function up(Schema $schema): void
  19.     {
  20.         $this->skipIf(
  21.             true === $schema->getTable('message')->hasColumn('document_name')
  22.             ||
  23.             true === $schema->getTable('message')->hasColumn('document_url'),
  24.             'The document_name and document_url fields are already in the message table!'
  25.         );
  27.         $schema
  28.             ->getTable('message')
  29.             ->addColumn(
  30.                 'document_name',
  31.                 Types::STRING
  32.             )
  33.             ->setNotnull(false)
  34.             ->setDefault(null)
  35.         ;
  37.         $schema
  38.             ->getTable('message')
  39.             ->addColumn(
  40.                 'document_url',
  41.                 Types::TEXT
  42.             )
  43.             ->setNotnull(false)
  44.             ->setDefault(null)
  45.         ;
  46.     }
  48.     public function down(Schema $schema): void
  49.     {
  50.         $this->skipIf(
  51.             false === $schema->getTable('message')->hasColumn('document_name')
  52.             ||
  53.             false === $schema->getTable('message')->hasColumn('document_url'),
  54.             'The document_name and document_url fields are already removed from the message table!'
  55.         );
  57.         $schema->getTable('message')->dropColumn('document_name');
  58.         $schema->getTable('message')->dropColumn('document_url');
  59.     }
  60. }