<gh_stars>1-10
INSERT INTO events(id, key, start_time, end_time, name)
VALUES ('00000000-0000-4000-a000-000000000000', 'current',
  NOW() - interval '3h45m', NOW() + interval '2h15m', 'Event in Progress');
-- Currently hole 5

INSERT INTO timeslots(event_id, order_num, duration_minutes)
VALUES
('00000000-0000-4000-a000-000000000000', 10, 60),
('00000000-0000-4000-a000-000000000000', 20, 30),
('00000000-0000-4000-a000-000000000000', 30, 30),
('00000000-0000-4000-a000-000000000000', 40, 90),
('00000000-0000-4000-a000-000000000000', 50, 30),
('00000000-0000-4000-a000-000000000000', 60, 30),
('00000000-0000-4000-a000-000000000000', 70, 30),
('00000000-0000-4000-a000-000000000000', 80, 30),
('00000000-0000-4000-a000-000000000000', 90, 30);

INSERT INTO venues(id, order_num, is_active, name, address, image_url, event_id)
VALUES
('00000000-0000-4000-a000-100000000000', 10, TRUE,  'House Rules',  '2227 Polk St, San Francisco, CA 94109',  '1.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000001', 20, TRUE, 'Green Sports Bar', '2239 Polk St, San Francisco, CA 94109', '2.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000002', 30, TRUE, 'Black Horse London Pub', '1514 Union St, San Francisco, CA 94123', '3.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000003', 40, TRUE, 'Roam', '1785 Union St, San Francisco, CA 94123', '4.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000004', 50, TRUE, 'The Brick Yard', '1787 Union St, San Francisco, CA 94123', '5.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000005', 60, TRUE, 'Hollow Cow', '1875 Union St, San Francisco, CA 94123', '6.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000006', 70, TRUE, 'Bus Stop', '1901 Union St, San Francisco, CA 94123', '7.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000007', 80, TRUE, 'The Blue Light', '1979 Union St, San Francisco, CA 94123', '8.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000008', 90, TRUE, 'Bar Non ', '1980 Union St, San Francisco, CA 94123', '9.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000009', 100, FALSE, 'Mauna Loa Club', '3009 Fillmore St, San Francisco, CA 94123', '10.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000010', 110, FALSE, 'Comet Club', '3111 Fillmore St, San Francisco, CA 94123', '11.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000011', 120, FALSE, 'Sabrosa', '3200 Fillmore St, San Francisco, CA 94123', '12.jpg', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-100000000012', 130, FALSE, 'Jaxson', '3231 Fillmore St, San Francisco, CA 94123', '13.jpg', '00000000-0000-4000-a000-000000000000');

INSERT INTO players(id, name, phone_number, league, phone_number_confirmed, auth_token, event_id)
VALUES
('00000000-0000-4000-a000-200000000000', '1-5, all hole-in-1',                        '+15550000000', 'PGA', TRUE, '00000000-0000-4000-a000-300000000000', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-200000000001', '1-5, all hole-in-1, except 2 strokes on 3', '+15550000001', 'PGA', TRUE, '00000000-0000-4000-a000-300000000001', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-200000000002', '1-5, all hole-in-1, +2 on 3',               '+15550000002', 'PGA', TRUE, '00000000-0000-4000-a000-300000000002', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-200000000003', '1-5, all hole-in-1, -1 on 3',               '+15550000003', 'PGA', TRUE, '00000000-0000-4000-a000-300000000003', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-200000000004', '1-5, all hole-in-1, missing 2',             '+15550000004', 'PGA', TRUE, '00000000-0000-4000-a000-300000000004', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-200000000005', '1-5, all hole-in-1, missing 3',             '+15550000005', 'PGA', TRUE, '00000000-0000-4000-a000-300000000005', '00000000-0000-4000-a000-000000000000'),
('00000000-0000-4000-a000-200000000006', '1-4, all hole-in-1',                        '+15550000006', 'PGA', TRUE, '00000000-0000-4000-a000-300000000006', '00000000-0000-4000-a000-000000000000');

-- Scores for player '1-9, all hole-in-1'
INSERT INTO scores(player_id, venue_id, strokes, adjustments)
VALUES
('00000000-0000-4000-a000-200000000000', '00000000-0000-4000-a000-100000000000', 1, 0),
('00000000-0000-4000-a000-200000000000', '00000000-0000-4000-a000-100000000001', 1, 0),
('00000000-0000-4000-a000-200000000000', '00000000-0000-4000-a000-100000000002', 1, 0),
('00000000-0000-4000-a000-200000000000', '00000000-0000-4000-a000-100000000003', 1, 0),
('00000000-0000-4000-a000-200000000000', '00000000-0000-4000-a000-100000000004', 1, 0);

-- Scores for player '1-9, all hole-in-1, except 2 strokes on 3'
INSERT INTO scores(player_id, venue_id, strokes, adjustments)
VALUES
('00000000-0000-4000-a000-200000000001', '00000000-0000-4000-a000-100000000000', 1, 0),
('00000000-0000-4000-a000-200000000001', '00000000-0000-4000-a000-100000000001', 1, 0),
('00000000-0000-4000-a000-200000000001', '00000000-0000-4000-a000-100000000002', 2, 0),
('00000000-0000-4000-a000-200000000001', '00000000-0000-4000-a000-100000000003', 1, 0),
('00000000-0000-4000-a000-200000000001', '00000000-0000-4000-a000-100000000004', 1, 0);

-- Scores for player '1-9, all hole-in-1, +2 on 3'
INSERT INTO scores(player_id, venue_id, strokes, adjustments)
VALUES
('00000000-0000-4000-a000-200000000002', '00000000-0000-4000-a000-100000000000', 1, 0),
('00000000-0000-4000-a000-200000000002', '00000000-0000-4000-a000-100000000001', 1, 0),
('00000000-0000-4000-a000-200000000002', '00000000-0000-4000-a000-100000000002', 1, 2),
('00000000-0000-4000-a000-200000000002', '00000000-0000-4000-a000-100000000003', 1, 0),
('00000000-0000-4000-a000-200000000002', '00000000-0000-4000-a000-100000000004', 1, 0);

-- Scores for player '1-9, all hole-in-1, -1 on 3'
INSERT INTO scores(player_id, venue_id, strokes, adjustments)
VALUES
('00000000-0000-4000-a000-200000000003', '00000000-0000-4000-a000-100000000000', 1, 0),
('00000000-0000-4000-a000-200000000003', '00000000-0000-4000-a000-100000000001', 1, 0),
('00000000-0000-4000-a000-200000000003', '00000000-0000-4000-a000-100000000002', 1, -1),
('00000000-0000-4000-a000-200000000003', '00000000-0000-4000-a000-100000000003', 1, 0),
('00000000-0000-4000-a000-200000000003', '00000000-0000-4000-a000-100000000004', 1, 0);

-- Scores for player '1-9, all hole-in-1, missing 2'
INSERT INTO scores(player_id, venue_id, strokes, adjustments)
VALUES
('00000000-0000-4000-a000-200000000004', '00000000-0000-4000-a000-100000000000', 1, 0),

('00000000-0000-4000-a000-200000000004', '00000000-0000-4000-a000-100000000002', 1, 0),
('00000000-0000-4000-a000-200000000004', '00000000-0000-4000-a000-100000000003', 1, 0),
('00000000-0000-4000-a000-200000000004', '00000000-0000-4000-a000-100000000004', 1, 0);

-- Scores for player '1-9, all hole-in-1, missing 3'
INSERT INTO scores(player_id, venue_id, strokes, adjustments)
VALUES
('00000000-0000-4000-a000-200000000005', '00000000-0000-4000-a000-100000000000', 1, 0),
('00000000-0000-4000-a000-200000000005', '00000000-0000-4000-a000-100000000001', 1, 0),

('00000000-0000-4000-a000-200000000005', '00000000-0000-4000-a000-100000000003', 1, 0),
('00000000-0000-4000-a000-200000000005', '00000000-0000-4000-a000-100000000004', 1, 0);

-- Scores for player '1-4, all hole-in-1'
INSERT INTO scores(player_id, venue_id, strokes, adjustments)
VALUES
('00000000-0000-4000-a000-200000000006', '00000000-0000-4000-a000-100000000000', 1, 0),
('00000000-0000-4000-a000-200000000006', '00000000-0000-4000-a000-100000000001', 1, 0),
('00000000-0000-4000-a000-200000000006', '00000000-0000-4000-a000-100000000002', 1, 0),
('00000000-0000-4000-a000-200000000006', '00000000-0000-4000-a000-100000000003', 1, 0);
