-- Sample INSERT statement for EventScores table
-- Test this in phpMyAdmin to verify the table structure

INSERT INTO EventScores (
    eventId, 
    flight, 
    player1_name, 
    player1_hcp, 
    player1_slope,
    player2_name, 
    player2_hcp, 
    player2_slope,
    front9_stableford, 
    back9_stableford, 
    total_stableford,
    club, 
    marked
) VALUES (
    2639,                           -- eventId (int) - your current event
    '1',                            -- flight (varchar(20)) - your current flight
    'John Smith',                   -- player1_name (varchar(255))
    12.5,                           -- player1_hcp (decimal(5,2)) - handicap
    125,                            -- player1_slope (int) - slope rating
    'Jane Doe',                     -- player2_name (varchar(255))
    15.2,                           -- player2_hcp (decimal(5,2)) - handicap
    118,                            -- player2_slope (int) - slope rating
    20,                             -- front9_stableford (int) - your debug test value
    20,                             -- back9_stableford (int) - your debug test value
    40,                             -- total_stableford (int) - your debug test value
    'La Hacienda',                  -- club (varchar(255)) - your current club
    'YES'                           -- marked (varchar(10)) - your current marked value
);

-- Alternative INSERT with different test data:
/*
INSERT INTO EventScores (
    eventId, flight, player1_name, player1_hcp, player1_slope,
    player2_name, player2_hcp, player2_slope,
    front9_stableford, back9_stableford, total_stableford,
    club, marked
) VALUES (
    2639, '1', 'Test Player 1', 10.0, 120, 'Test Player 2', 12.0, 115,
    18, 22, 40, 'Test Club', 'YES'
);
*/
