<?php
require_once __DIR__ . '/config/database.php';
$db = getDBConnection();

$sql = "CREATE TABLE IF NOT EXISTS `system_bank_accounts` (
  `id`             INT           AUTO_INCREMENT PRIMARY KEY,
  `bank_name`      VARCHAR(100)  NOT NULL,
  `account_number` VARCHAR(50)   NOT NULL,
  `account_name`   VARCHAR(100)  NOT NULL,
  `qr_code_image`  VARCHAR(255)  DEFAULT NULL,
  `is_active`      TINYINT(1)    DEFAULT 1,
  `sort_order`     INT           DEFAULT 0,
  `created_at`     DATETIME      DEFAULT CURRENT_TIMESTAMP,
  `updated_at`     DATETIME      DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";

$db->exec($sql);

$check = $db->query("SELECT COUNT(*) FROM system_bank_accounts")->fetchColumn();
if ($check == 0) {
    $db->exec("INSERT INTO `system_bank_accounts` (`bank_name`, `account_number`, `account_name`, `is_active`, `sort_order`) VALUES 
    ('ธนาคารกสิกรไทย (K-Bank)', '123-4-56789-0', 'บริษัท 41Shop จำกัด', 1, 1),
    ('ธนาคารไทยพาณิชย์ (SCB)', '987-6-54321-0', 'บริษัท 41Shop จำกัด', 1, 2)");
}

echo "MIGRATION SUCCESSFUL! Total accounts: " . $db->query("SELECT COUNT(*) FROM system_bank_accounts")->fetchColumn() . "\n";