migrations/Version20250728105738.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 Version20250728105738 extends AbstractMigration
  12. {
  13.     public function getDescription(): string
  14.     {
  15.         return 'Add my_cmcm_user_id column to inquiry table';
  16.     }
  18.     public function up(Schema $schema): void
  19.     {
  20.         $this->skipIf(
  21.             $schema->getTable('inquiry')->hasColumn('my_cmcm_user_id'),
  22.             'The my_cmcm_user_id column already exists in the inquiry table'
  23.         );
  25.         $table = $schema->getTable('inquiry');
  26.         $table->addColumn('my_cmcm_user_id', Types::STRING)
  27.             ->setLength(255)
  28.             ->setNotnull(false)
  29.             ->setDefault(null);
  31.         $table->addForeignKeyConstraint(
  32.             'mycmcm_user',
  33.             ['my_cmcm_user_id'],
  34.             ['id'],
  35.             ['onDelete' => 'SET NULL'],
  36.             'fk_inquiry_mycmcm_user'
  37.         );
  38.     }
  40.     public function down(Schema $schema): void
  41.     {
  42.         $this->skipIf(
  43.             !$schema->getTable('inquiry')->hasColumn('my_cmcm_user_id'),
  44.             'The my_cmcm_user_id column does not exist in the inquiry table'
  45.         );
  47.         $table = $schema->getTable('inquiry');
  49.         // Drop the foreign key constraint first
  50.         if ($table->hasForeignKey('fk_inquiry_mycmcm_user')) {
  51.             $table->removeForeignKey('fk_inquiry_mycmcm_user');
  52.         }
  54.         // Then drop the column
  55.         $table->dropColumn('my_cmcm_user_id');
  56.     }
  57. }