INSERT INTO `horses` (`id`, `name`, `run_style`, `average_speed`, `back_speed`, `speed_last_race`, `prime_power`, `average_class`, `days_off`, `jockey_win_pct`, `trainer_win_pct`, `earnings`, `win_count`, `race_count`, `form`, `morale`, `last_result`) VALUES
(1, 'Citizen Bull', 'E8', 97, 97, 97, 146, 120, 28, 11.00, 29.00, 1500000.00, 5, 7, 'WWLWW', 8, 'W'),
(2, 'Neoequos', 'E8', 91, 91, 91, 141, 119, 35, 23.00, 24.00, 291000.00, 3, 6, 'LWLWL', 6, 'L'),
(3, 'Final Gambit', 'S3', 101, 101, 101, 138, 116, 42, 14.00, 26.00, 521000.00, 4, 8, 'WLWWL', 7, 'L'),
(4, 'Rodriguez', 'E7', 105, 105, 105, 147, 119, 28, 16.00, 29.00, 523000.00, 6, 9, 'WWWWW', 10, 'W'),
(5, 'American Promise', 'E5', 98, 105, 105, 143, 118, 49, 9.00, 9.00, 445000.00, 2, 6, 'LLWWL', 5, 'L'),
(6, 'Luxor Cafe', 'NA0', NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, 379000.00, 0, 1, 'L', 4, 'L'),
(7, 'Journalism', 'E/P5', 108, 108, 108, 147, 121, 28, 20.00, 18.00, 639000.00, 5, 8, 'WLWWL', 8, 'L'),
(8, 'Burnham Square', 'P2', 97, 97, 97, 144, 120, 25, 16.00, 13.00, 978000.00, 3, 6, 'WWLLW', 6, 'W'),
(9, 'Grande', 'E6', 94, 101, 101, 144, 119, 28, 14.00, 17.00, 228000.00, 1, 5, 'LLLLW', 3, 'W'),
(10, 'Flying Mohawk', 'P3', 97, 97, 97, 137, 116, 42, 17.00, 16.00, 296000.00, 2, 5, 'LLWLW', 5, 'W'),
(11, 'East Avenue', 'E5', 89, 97, 97, 146, 117, 25, 19.00, 17.00, 654000.00, 4, 7, 'WWWLW', 9, 'W'),
(12, 'Publisher', 'P0', 98, 98, 98, 143, 119, 35, 21.00, 17.00, 408000.00, 3, 5, 'WLWWL', 6, 'L'),
(13, 'Render Judgment', 'P3', 95, 96, 93, 139, 116, 25, 12.00, 15.00, 251000.00, 2, 6, 'LWLWL', 4, 'L'),
(14, 'Coal Battle', 'E/P4', 93, 93, 93, 146, 119, 35, 12.00, 20.00, 1200000.00, 5, 9, 'WWWWW', 10, 'W'),
(15, 'Sandman', 'S0', 101, 101, 101, 149, 120, 35, 21.00, 16.00, 1300000.00, 6, 10, 'WWLWW', 9, 'W'),
(16, 'Sovereignty', 'S0', 94, 94, 94, 144, 120, 35, 16.00, 14.00, 573000.00, 2, 5, 'WLWLW', 6, 'W'),
(17, 'Owen Almighty', 'E7', 92, 92, 92, 142, 119, 50, 12.00, 16.00, 500000.00, 3, 7, 'LWLWW', 7, 'W'),
(18, 'Baeza', 'E/P7', 107, 107, 107, 142, 118, 28, 23.00, 12.00, 149000.00, 1, 4, 'LLLW', 3, 'W'),
(19, 'Chunk of Gold', 'S2', 96, 98, 98, 142, 118, 42, 14.00, 12.00, 349000.00, 2, 5, 'LLWWL', 5, 'L'),
(20, 'Tiztastic', 'S1', 100, 100, 100, 145, 119, 42, 14.00, 17.00, 1500000.00, 4, 7, 'WLWLW', 7, 'W');
/*
INSERT INTO horses (id, name, run_style, average_speed, average_distance, best_speed, speed_last_race, last_class, average_class, days_off, prime_power, jockey_win_pct, trainer_win_pct, earnings) VALUES
(1, 'Citizen Bull', 'E8', 97, 97, 97, 97, 120, 120, 28, 146, 11.0, 29.0, 1500000.0),
(2, 'Neoequos', 'E8', 91, 91, 91, 91, 119, 119, 35, 141, 23.0, 24.0, 291000.0),
(3, 'Final Gambit', 'S3', 101, 101, 101, 101, 116, 116, 42, 138, 14.0, 26.0, 521000.0),
(4, 'Rodriguez', 'E7', 105, 105, 105, 105, 119, 119, 28, 147, 16.0, 29.0, 523000.0),
(5, 'American Promise', 'E5', 98, 105, 105, 105, 118, 118, 49, 143, 9.0, 9.0, 445000.0),
(6, 'Admire Daytona', 'NA0', NULL, NULL, NULL, NULL, NULL, NULL, 28, NULL, NULL, NULL, 672000.0),
(7, 'Luxor Cafe', 'NA0', NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, 379000.0),
(8, 'Journalism', 'E/P5', 108, 108, 108, 108, 121, 121, 28, 147, 20.0, 18.0, 639000.0),
(9, 'Burnham Square', 'P2', 97, 97, 97, 97, 120, 120, 25, 144, 16.0, 13.0, 978000.0),
(10, 'Grande', 'E6', 94, 101, 101, 101, 119, 119, 28, 144, 14.0, 17.0, 228000.0),
(11, 'Flying Mohawk', 'P3', 97, 97, 97, 97, 116, 116, 42, 137, 17.0, 16.0, 296000.0),
(12, 'East Avenue', 'E5', 89, 97, 97, 97, 117, 117, 25, 146, 19.0, 17.0, 654000.0),
(13, 'Publisher', 'P0', 98, 98, 98, 98, 119, 119, 35, 143, 21.0, 17.0, 408000.0),
(14, 'Render Judgment', 'P3', 95, 96, 93, 93, 116, 116, 25, 139, 12.0, 15.0, 251000.0),
(15, 'Coal Battle', 'E/P4', 93, 93, 93, 93, 119, 119, 35, 146, 12.0, 20.0, 1200000.0),
(16, 'Sandman', 'S0', 101, 101, 101, 101, 120, 120, 35, 149, 21.0, 16.0, 1300000.0),
(17, 'Sovereignty', 'S0', 94, 94, 94, 94, 120, 120, 35, 144, 16.0, 14.0, 573000.0),
(18, 'Owen Almighty', 'E7', 92, 92, 92, 92, 119, 119, 25, 142, 12.0, 16.0, 500000.0),
(19, 'Baeza', 'E/P7', 107, 107, 107, 107, 118, 118, 28, 142, 23.0, 12.0, 149000.0),
(20, 'Chunk of Gold', 'S2', 96, 98, 98, 98, 118, 118, 42, 142, 14.0, 12.0, 349000.0);
*/