migrations/Version20250512164500.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 Version20250512164500 extends AbstractMigration
  12. {
  13.     public function getDescription(): string
  14.     {
  15.         return 'Drop tariff table as it is no longer needed';
  16.     }
  18.     public function up(Schema $schema): void
  19.     {
  20.         $this->skipIf(
  21.             false === $schema->hasTable('tariff'),
  22.             'The tariff table is already removed!'
  23.         );
  25.         $schema->dropTable('tariff');
  26.     }
  28.     public function down(Schema $schema): void
  29.     {
  30.         $this->skipIf(
  31.             true === $schema->hasTable('tariff'),
  32.             'The tariff table already exists!'
  33.         );
  35.         $table = $schema->createTable('tariff');
  36.         $table->addColumn('id', Types::STRING)
  37.             ->setNotnull(true);
  38.         $table->addColumn('cns_code', Types::STRING)
  39.             ->setLength(40)
  40.             ->setNotnull(true);
  41.         $table->addColumn('cns_tariff', Types::FLOAT)
  42.             ->setNotnull(true);
  43.         $table->addColumn('available_from', Types::DATETIME_IMMUTABLE)
  44.             ->setNotnull(false);
  45.         $table->addColumn('available_to', Types::DATETIME_IMMUTABLE)
  46.             ->setNotnull(false);
  47.         $table->addColumn('created_at', Types::DATETIME_IMMUTABLE)
  48.             ->setNotnull(true);
  49.         $table->addColumn('last_updated_at', Types::DATETIME_IMMUTABLE)
  50.             ->setNotnull(true);
  51.         $table->addColumn('cns_id', Types::INTEGER)
  52.             ->setNotnull(true);
  53.         $table->addColumn('label', Types::STRING)
  54.             ->setLength(255)
  55.             ->setNotnull(true);
  56.         $table->setPrimaryKey(['id']);
  57.     }
  58. }