<?php

declare(strict_types=1);

namespace App\Database\Migrations;

use CodeIgniter\Database\Migration;

final class DropUnusedInvoiceOpeningPaidBalances extends Migration
{
    public function up(): void
    {
        if ($this->db->tableExists('invoice_opening_paid_balances')) {
            $this->forge->dropTable('invoice_opening_paid_balances', true);
            $this->db->resetDataCache();
        }
    }

    public function down(): void
    {
        if ($this->db->tableExists('invoice_opening_paid_balances')) {
            return;
        }

        $this->db->query(
            "CREATE TABLE `invoice_opening_paid_balances` (
                `invoice_id` INT UNSIGNED NOT NULL,
                `amount` DECIMAL(10,2) NOT NULL,
                `effective_before_payment_id` INT UNSIGNED DEFAULT NULL,
                `school_year` VARCHAR(9) NOT NULL,
                `evidence_reference` VARCHAR(255) NOT NULL,
                `approved_by` INT UNSIGNED NOT NULL,
                `approved_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
                `notes` TEXT,
                PRIMARY KEY (`invoice_id`)
            ) ENGINE=InnoDB"
        );
        $this->db->resetDataCache();
    }
}