

INSERT INTO `golfleague`.`golfers` (`golfer_id` ,`last_name` ,`first_name` ,`status`) VALUES 
(1, 'Callery', 'Joe', 'active'),
(2, 'Hughes', 'Mike', 'active'),
(3, 'DiGuilio', 'Ken', 'active'),
(4, 'Wholley', 'Kevin', 'active');

INSERT INTO `golfleague`.`handicaps` (`handicap_id`, `date`, `golfer_id`, `handicap`) VALUES
(1, '2008-04-10', 1, 9),
(2, '2008-04-17', 1, 10),
(3, '2008-04-24', 1, 7),
(4, '2008-04-10', 2, 16),
(5, '2008-04-10', 3, 12),
(6, '2008-04-17', 4, 13);



INSERT INTO `golfleague`.`rounds` (`round_id`, `golfer_id`, `date`, `handicap_id`, `course`, `score`, `points`) VALUES
(1, 1, '2008-04-10', 1, 'front', 46, 6),
(2, 1, '2008-04-17', 2, 'back', 49, 4),
(3, 2, '2008-04-10', 4, 'front', 53, 10),
(4, 3, '2008-04-10', 5, 'front', 51, 3),
(5, 4, '2008-04-10', 6, 'back', 41, 13),
(6, 1, '2008-04-24', 3, 'front', 42, 9),
(7, 1, '2008-04-30', 3, 'front', 47, 6),
(8, 1, '2008-05-01', 3, 'front', 41, 9),
(9, 1, '2008-05-05', 3, 'front', 39, 15),
(10, 1, '2008-05-08', 3, 'front', 42, 12),
(11, 1, '2008-05-12', 3, 'front', 48, 2),
(12, 1, '2008-05-15', 3, 'front', 52, 2),
(13, 1, '2008-05-18', 3, 'front', 45, 9),
(14, 1, '2008-05-20', 3, 'front', 46, 8),
(15, 1, '2008-05-22', 3, 'front', 43, 11);