migrations/Version20250428900000.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 PaperKite\MyCmcmApi\Entity\Enum\Method2FaType;
  11. use Symfony\Component\Uid\Uuid;
  13. final class Version20250428900000 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'Create mycmcm_user_2fa table';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->skipIf(
  23.             true === $schema->hasTable('mycmcm_user_2fa'),
  24.             'The mycmcm_user_2fa table already exists!'
  25.         );
  27.         $table = $schema->createTable('mycmcm_user_2fa');
  28.         $table->addColumn('id', Types::GUID)->setNotnull(true);
  29.         $table->addColumn('code', Types::STRING, ['notnull' => false, 'length' => 6]);
  30.         $table->addColumn('code_expires_at', Types::DATETIME_IMMUTABLE, ['notnull' => false]);
  31.         $table->addColumn('code_created_at', Types::DATETIME_IMMUTABLE, ['notnull' => false]);
  32.         $table->addColumn('method', Types::STRING, ['notnull' => true, 'length' => 20, 'default' => Method2FaType::TYPE_EMAIL]);
  33.         $table->addColumn('my_cmcm_user_id', Types::GUID)->setNotnull(true);
  34.         $table->setPrimaryKey(['id']);
  36.         $myCmcmUserTable = $schema->getTable('mycmcm_user');
  38.         $table->addForeignKeyConstraint(
  39.             $myCmcmUserTable,
  40.             ['my_cmcm_user_id'],
  41.             ['id'],
  42.             [],
  43.             'fk_2fa_my_cmcm_user'
  44.         );
  46.         $table->addIndex(['my_cmcm_user_id'], 'idx_2fa_my_cmcm_user_id');
  47.     }
  49.     public function postUp(Schema $schema): void
  50.     {
  51.         $connection = $this->connection;
  52.         $users = $connection->fetchAllAssociative('SELECT id FROM mycmcm_user');
  54.         foreach ($users as $user) {
  55.             $connection->insert('mycmcm_user_2fa', [
  56.                 'id' => Uuid::v4(),
  57.                 'my_cmcm_user_id' => $user['id'],
  58.                 'method' => Method2FaType::TYPE_EMAIL,
  59.             ]);
  60.         }
  61.     }
  63.     public function down(Schema $schema): void
  64.     {
  65.         $this->skipIf(
  66.             false === $schema->hasTable('mycmcm_user_2fa'),
  67.             'The mycmcm_user_2fa table is already removed !'
  68.         );
  70.         $schema->dropTable('mycmcm_user_2fa');
  71.     }
  72. }