thetool/db/migrations/20250829090000_rmlworkorder_add_additional_info.php

<?php

declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class RmlworkorderAddAdditionalInfo extends AbstractMigration
{
    public function up(): void
    {
        $table = $this->table('RMLWorkorder');
        $table->addColumn('additionalInfo', 'text', [
            'null' => true,
            'default' => null,
        ])
            ->changeColumn('status', 'enum', [
                'values' => [
                    'new',
                    'assigned',
                    'scheduled',
                    'correction_requested',
                    'documented',
                    'completed',
                    'intervention_required',
                    'problem_solved',
                    'cancelled',
                ],
                'null' => false,
                'default' => 'new',
            ])
            ->save();
    }

    public function down(): void
    {
        $table = $this->table('RMLWorkorder');
        $table->removeColumn('additionalInfo')
            ->changeColumn('status', 'enum', [
                'values' => [
                    'new',
                    'assigned',
                    'scheduled',
                    'correction_requested',
                    'documented',
                    'completed',
                    'cancelled',
                ],
                'null' => false,
                'default' => 'new',
            ])
            ->save();
    }
}