<?php

class Migration_20250820023557_property_balances
{
    public static function up(PDO $pdo)
    {
        $pdo->exec("
            CREATE TABLE property_balances (
                id INT AUTO_INCREMENT PRIMARY KEY,
                property_id INT NOT NULL,
                balance VARCHAR(20) DEFAULT '0',
                minimum_balance VARCHAR(20) DEFAULT '0',
                is_active Boolean DEFAULT 1,
                created_at DATETIME DEFAULT CURRENT_TIMESTAMP
            )
        ");
    }

    public static function down(PDO $pdo)
    {
        $pdo->exec("DROP TABLE IF EXISTS property_balances");
    }
}