<?php
require_once __DIR__ . '/config.php';

try {
    $pdo = db();
    $sql = <<<SQL
ALTER TABLE dealers
ADD COLUMN target DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN achievement DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN credit_limit DECIMAL(10, 2) DEFAULT 0.00,
ADD COLUMN credit_limit_utilisation DECIMAL(10, 2) DEFAULT 0.00;
SQL;
    $pdo->exec($sql);
    echo "Table 'dealers' updated successfully." . PHP_EOL;
} catch (PDOException $e) {
    die("DB ERROR: " . $e->getMessage());
}