migrations/Version20240207093320.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 Version20240207093320 extends AbstractMigration
  12. {
  13.     public function getDescription(): string
  14.     {
  15.         return 'Create initial tables with INT id for cmcm_request and resource_id field';
  16.     }
  18.     public function up(Schema $schema): void
  19.     {
  20.         // Create process table first (referenced by other tables)
  21.         $processTable = $schema->createTable('process');
  22.         $processTable->addColumn('id', Types::STRING, ['length' => 255]);
  23.         $processTable->addColumn('process_type', Types::STRING, ['length' => 255]);
  24.         $processTable->setPrimaryKey(['id']);
  26.         // Create cmcm_request table
  27.         $cmcmRequestTable = $schema->createTable('cmcm_request');
  28.         $cmcmRequestTable->addColumn('id', Types::INTEGER, ['autoincrement' => true]);
  29.         $cmcmRequestTable->addColumn('process_id', Types::STRING, ['length' => 255]);
  30.         $cmcmRequestTable->addColumn('resource_id', Types::STRING, ['length' => 255, 'notnull' => false]);
  31.         $cmcmRequestTable->addColumn('document_id', Types::STRING, ['length' => 255, 'notnull' => false]);
  32.         $cmcmRequestTable->addColumn('created_at', Types::DATETIME_IMMUTABLE);
  33.         $cmcmRequestTable->addColumn('updated_at', Types::DATETIME_IMMUTABLE, ['notnull' => false]);
  34.         $cmcmRequestTable->addColumn('status', Types::STRING, ['length' => 255]);
  35.         $cmcmRequestTable->addColumn('title', Types::STRING, ['length' => 255, 'notnull' => false]);
  36.         $cmcmRequestTable->setPrimaryKey(['id']);
  37.         $cmcmRequestTable->addUniqueIndex(['process_id'], 'uniq_cmcm_request_process_id');
  38.         $cmcmRequestTable->addUniqueIndex(['resource_id'], 'uniq_resource_id');
  39.         $cmcmRequestTable->addForeignKeyConstraint('process', ['process_id'], ['id'], [], 'FK_258CBA37EC2F574');
  41.         // Create extranet_member_leaving_process table
  42.         $leavingProcessTable = $schema->createTable('extranet_member_leaving_process');
  43.         $leavingProcessTable->addColumn('id', Types::STRING, ['length' => 255]);
  44.         $leavingProcessTable->addColumn('leaving_at', Types::DATETIME_IMMUTABLE);
  45.         $leavingProcessTable->addColumn('leaving_reason', Types::STRING, ['length' => 255]);
  46.         $leavingProcessTable->setPrimaryKey(['id']);
  47.         $leavingProcessTable->addForeignKeyConstraint('process', ['id'], ['id'], ['onDelete' => 'CASCADE'], 'FK_1EA2C397BF396750');
  48.     }
  50.     public function down(Schema $schema): void
  51.     {
  52.         $schema->dropTable('cmcm_request');
  53.         $schema->dropTable('extranet_member_leaving_process');
  54.         $schema->dropTable('process');
  55.     }
  56. }