<?php
declare(strict_types=1);

return [
    'up' => "
ALTER TABLE rental_contracts
    ADD COLUMN vat_percentage       decimal(5,2)  NOT NULL DEFAULT 1.00  AFTER total_amount,
    ADD COLUMN vat_amount           decimal(15,2) NOT NULL DEFAULT 0.00  AFTER vat_percentage,
    ADD COLUMN utilities_percentage decimal(5,2)  NOT NULL DEFAULT 0.00  AFTER vat_amount,
    ADD COLUMN utilities_amount     decimal(15,2) NOT NULL DEFAULT 0.00  AFTER utilities_percentage,
    ADD COLUMN grand_total          decimal(15,2) NOT NULL DEFAULT 0.00  AFTER utilities_amount,
    ADD COLUMN late_fee_type        varchar(10)   NOT NULL DEFAULT 'none' AFTER grand_total,
    ADD COLUMN late_fee_rate        decimal(5,2)  NOT NULL DEFAULT 0.00  AFTER late_fee_type;
",
    'down' => "
ALTER TABLE rental_contracts
    DROP COLUMN vat_percentage,
    DROP COLUMN vat_amount,
    DROP COLUMN utilities_percentage,
    DROP COLUMN utilities_amount,
    DROP COLUMN grand_total,
    DROP COLUMN late_fee_type,
    DROP COLUMN late_fee_rate;
",
];
