<?php
declare(strict_types=1);

return [
    'up' => "
ALTER TABLE waiver_requests
    ADD COLUMN excess_dependent_count INT UNSIGNED NOT NULL DEFAULT 0 AFTER new_dependent_count,
    ADD COLUMN excess_fee_percentage DECIMAL(5,2) NULL AFTER excess_dependent_count,
    ADD COLUMN excess_fee_amount DECIMAL(15,2) NOT NULL DEFAULT 0.00 AFTER excess_fee_percentage,
    ADD COLUMN waiver_request_doc_path VARCHAR(500) NULL AFTER notes,
    ADD COLUMN target_form_doc_path VARCHAR(500) NULL AFTER waiver_request_doc_path,
    ADD COLUMN debts_cleared TINYINT(1) NOT NULL DEFAULT 0 AFTER annual_renewal_paid;
",
    'down' => "
ALTER TABLE waiver_requests
    DROP COLUMN excess_dependent_count,
    DROP COLUMN excess_fee_percentage,
    DROP COLUMN excess_fee_amount,
    DROP COLUMN waiver_request_doc_path,
    DROP COLUMN target_form_doc_path,
    DROP COLUMN debts_cleared;
",
];
