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.             || true === $schema->getTable('message')->hasColumn('document_url'),
  23.             'The document_name and document_url fields are already in the message table!'
  24.         );
  26.         $schema
  27.             ->getTable('message')
  28.             ->addColumn(
  29.                 'document_name',
  30.                 Types::STRING
  31.             )
  32.             ->setNotnull(false)
  33.             ->setDefault(null)
  34.         ;
  36.         $schema
  37.             ->getTable('message')
  38.             ->addColumn(
  39.                 'document_url',
  40.                 Types::TEXT
  41.             )
  42.             ->setNotnull(false)
  43.             ->setDefault(null)
  44.         ;
  45.     }
  47.     public function down(Schema $schema): void
  48.     {
  49.         $this->skipIf(
  50.             false === $schema->getTable('message')->hasColumn('document_name')
  51.             || false === $schema->getTable('message')->hasColumn('document_url'),
  52.             'The document_name and document_url fields are already removed from the message table!'
  53.         );
  55.         $schema->getTable('message')->dropColumn('document_name');
  56.         $schema->getTable('message')->dropColumn('document_url');
  57.     }
  58. }