<?php
// Database setup script
require_once 'db.php';

try {
    // Read the SQL file
    $sql = file_get_contents('crm.sql');

    // Execute the SQL using mysqli
    if (mysqli_multi_query($conn, $sql)) {
        do {
            // Store first result set
            if ($result = mysqli_store_result($conn)) {
                mysqli_free_result($result);
            }
        } while (mysqli_next_result($conn));
    }

    if (mysqli_errno($conn)) {
        throw new Exception(mysqli_error($conn));
    }

    echo "Database setup completed successfully!\n";
} catch (Exception $e) {
    echo "Error setting up database: " . $e->getMessage() . "\n";
}
?>