setup.php

<?php
require_once 'db_connect.php';

try {
    $pdo->exec("ALTER TABLE members ADD COLUMN IF NOT EXISTS is_new_member TINYINT(1) DEFAULT 0");
    echo "Added is_new_member column.\n";
} catch(PDOException $e) {
    if(strpos($e->getMessage(), 'Duplicate column name') !== false) {
        echo "Column already exists.\n";
    } else {
        echo "Error: " . $e->getMessage() . "\n";
    }
}

try {
    $pdo->exec("CREATE TABLE IF NOT EXISTS destiny_chapel.attendance (
        id INT AUTO_INCREMENT PRIMARY KEY,
        member_id INT,
        attendance_date DATE,
        check_in_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (member_id) REFERENCES destiny_chapel.members(id) ON DELETE CASCADE
    )");
    echo "Created attendance table.\n";
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage() . "\n";
}
echo "Setup complete.\n";
?>