<?php

declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class AddEventEmailOptions extends AbstractMigration
{
    public function change(): void
    {
        $this->table('option')
            ->addColumn('event_cc_booking',       'char',    ['limit' => 1, 'null' => false, 'default' => 'N', 'after' => 'event_terms_text'])
            ->addColumn('event_cc_promotion',     'char',    ['limit' => 1, 'null' => false, 'default' => 'N', 'after' => 'event_cc_booking'])
            ->addColumn('event_cc_user_cancel',   'char',    ['limit' => 1, 'null' => false, 'default' => 'N', 'after' => 'event_cc_promotion'])
            ->addColumn('event_cc_event_cancel',  'char',    ['limit' => 1, 'null' => false, 'default' => 'Y', 'after' => 'event_cc_user_cancel'])
            ->addColumn('event_cc_reminder',      'char',    ['limit' => 1, 'null' => false, 'default' => 'N', 'after' => 'event_cc_event_cancel'])
            ->addColumn('event_reminder_enabled', 'char',    ['limit' => 1, 'null' => false, 'default' => 'N', 'after' => 'event_cc_reminder'])
            ->addColumn('event_reminder_hours',   'integer', ['null' => false, 'default' => 24, 'after' => 'event_reminder_enabled'])
            ->update();

        $this->table('event_bookings')
            ->addColumn('offered_at', 'datetime', ['null' => true, 'comment' => 'promozione lista attesa in attesa di riconferma', 'after' => 'consent_at'])
            ->update();
    }
}