<?php
include 'includes/db.php';

// Create payment_options table
$sql = "CREATE TABLE IF NOT EXISTS payment_options (
    id INT AUTO_INCREMENT PRIMARY KEY,
    bank_name VARCHAR(100) NOT NULL,
    account_title VARCHAR(100) NOT NULL,
    account_number VARCHAR(100) NOT NULL,
    branch_code VARCHAR(50),
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

if ($conn->query($sql) === TRUE) {
    echo "Table payment_options created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}
?>
