migrations/Version20241110000000.php line 1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

final class Version20241110000000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Add detail, change set and session tracking fields to log table';
    }

    public function up(Schema $schema): void
    {
        $table = $schema->getTable('log');

        if (!$table->hasColumn('details')) {
            $table->addColumn('details', 'text', ['notnull' => false]);
        }

        if (!$table->hasColumn('change_set')) {
            $table->addColumn('change_set', 'json', ['notnull' => false]);
        }

        if (!$table->hasColumn('session_duration')) {
            $table->addColumn('session_duration', 'integer', ['notnull' => false]);
        }

        if (!$table->hasColumn('session_id')) {
            $table->addColumn('session_id', 'string', ['length' => 255, 'notnull' => false]);
        }
    }

    public function down(Schema $schema): void
    {
        $table = $schema->getTable('log');

        if ($table->hasColumn('details')) {
            $table->dropColumn('details');
        }

        if ($table->hasColumn('change_set')) {
            $table->dropColumn('change_set');
        }

        if ($table->hasColumn('session_duration')) {
            $table->dropColumn('session_duration');
        }

        if ($table->hasColumn('session_id')) {
            $table->dropColumn('session_id');
        }
    }
}