migrations/Version20250225130000.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;
  10. use RuntimeException;
  12. final class Version20250225130000 extends AbstractMigration
  13. {
  14.     public function getDescription(): string
  15.     {
  16.         return 'Add inquiry_cmcm_request table with INT cmcm_request_id';
  17.     }
  19.     public function up(Schema $schema): void
  20.     {
  21.         $this->skipIf($schema->hasTable('inquiry_cmcm_request'), 'Table inquiry_cmcm_request already exists');
  23.         // Ensure required tables exist
  24.         if (!$schema->hasTable('inquiry') || !$schema->hasTable('cmcm_request')) {
  25.             throw new RuntimeException('Required tables (inquiry or cmcm_request) do not exist. Run migrations in correct order.');
  26.         }
  28.         $table = $schema->createTable('inquiry_cmcm_request');
  29.         $table->addColumn('id', Types::GUID)->setNotnull(true);
  30.         $table->addColumn('inquiry_id', Types::STRING)->setLength(255)->setNotnull(true);
  31.         $table->addColumn('cmcm_request_id', Types::INTEGER)->setNotnull(true);
  32.         $table->addColumn('inquiry_assigned_pages', Types::JSON)->setNotnull(true);
  33.         $table->setPrimaryKey(['id']);
  35.         // Add indexes before foreign keys
  36.         $table->addIndex(['inquiry_id'], 'idx_inquiry_cmcm_request_inquiry');
  37.         $table->addIndex(['cmcm_request_id'], 'idx_inquiry_cmcm_request_cmcm_request');
  39.         // Add foreign keys with onDelete CASCADE to handle deletions properly
  40.         $table->addForeignKeyConstraint(
  41.             'inquiry',
  42.             ['inquiry_id'],
  43.             ['id'],
  44.             ['onDelete' => 'CASCADE'],
  45.             'fk_inquiry_cmcm_request_inquiry'
  46.         );
  47.         $table->addForeignKeyConstraint(
  48.             'cmcm_request',
  49.             ['cmcm_request_id'],
  50.             ['id'],
  51.             ['onDelete' => 'CASCADE'],
  52.             'fk_inquiry_cmcm_request_cmcm_request'
  53.         );
  54.     }
  56.     public function down(Schema $schema): void
  57.     {
  58.         $this->skipIf(!$schema->hasTable('inquiry_cmcm_request'), 'Table inquiry_cmcm_request does not exist');
  59.         $schema->dropTable('inquiry_cmcm_request');
  60.     }
  61. }