<?php
// Create a proper SQLite database file
try {
    $db = new PDO('sqlite:database/database.sqlite');
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // Test the connection
    $db->exec("CREATE TABLE IF NOT EXISTS test (id INTEGER PRIMARY KEY)");
    $db->exec("DROP TABLE test");
    
    echo "SQLite database created successfully!\n";
} catch (PDOException $e) {
    echo "Error creating database: " . $e->getMessage() . "\n";
}