From 36221ecc1a6237243b1cb1c00e29e661aacd9f24 Mon Sep 17 00:00:00 2001 From: emkael Date: Mon, 9 Dec 2019 18:55:31 +0100 Subject: 2019 Abu Dhabi GP + 2019 WDC standings --- rate.log | 54 ++++++++++++++++++++++++++++++++++ sql/championship.sql | 23 ++++++++++++++- sql/results.sql | 82 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 158 insertions(+), 1 deletion(-) diff --git a/rate.log b/rate.log index 6e84ebb..b050a8c 100644 --- a/rate.log +++ b/rate.log @@ -76233,3 +76233,57 @@ Podium rating: 6614.1 6954.63 Average rating: 2196.728 Average rating change: 85.1072222222 +2019 Abu Dhabi Grand Prix - qualifying (2019-11-30) + +#44 () 1[1] 2510.42 2513.9 +#77 () 2[2] 2549.07 2550.15 +#33 () 3[3] 2468.11 2469.41 +#16 () 4[4] 2189.78 2200.37 +#5 () 5[5] 2242.28 2248.73 +#23 () 6[6] 2251.22 2255.66 +#4 () 7[7] 2229.75 2233.6 +#3 () 8[8] 2207.83 2211.14 +#55 () 9[9] 2255.62 2255.05 +#27 () 10[10] 2044.85 2052.77 +#11 () 11[11] 2185.17 2184.79 +#10 () 12[12] 2230.9 2226.69 +#18 () 13[13] 2059.86 2062.31 +#26 () 14[14] 2136.09 2133.33 +#20 () 15[15] 2057.71 2057.06 +#8 () 16[16] 2052.59 2050.57 +#99 () 17[17] 2195.36 2184.88 +#7 () 18[18] 2200.68 2188.34 +#63 () 19[19] 1956.05 1950.53 +#88 () 20[20] 1911.19 1905.25 + +Podium rating: 7527.6 7533.46 +Average rating: 2196.7265 +Average rating change: 4.487 + +2019 Abu Dhabi Grand Prix (2019-12-01) + +#44 () 1[1] 2513.9 2547.68 +#33 () 2[2] 2469.41 2489.64 +#16 () 3[2] 2200.37 2320.91 +#77 () 4[3] 2550.15 2520.59 +#5 () 5[3] 2248.73 2315.19 +#23 () 6[4] 2255.66 2295.05 +#11 () 7[5] 2184.79 2156.58 +#4 () 8[5] 2233.6 2182.87 +#26 () 9[5] 2133.33 2129.03 +#55 () 10[5] 2255.05 2194.71 +#3 () 11[5] 2211.14 2170.69 +#27 () 12[5] 2052.77 2083.9 +#7 () 13[5] 2188.34 2158.48 +#20 () 14[5] 2057.06 2086.41 +#8 () 15[5] 2050.57 2082.61 +#99 () 16[5] 2184.88 2156.63 +#63 () 17[5] 1950.53 2048.72 +#10 () 18[6] 2226.69 2067.1 +#88 () 19[6] 1905.25 1865.42 +#18 () R[0] 2062.31 2062.31 + +Podium rating: 7183.68 7358.23 +Average rating: 2196.7265 +Average rating change: 49.5910526316 + diff --git a/sql/championship.sql b/sql/championship.sql index da3e6b0..4acab10 100644 --- a/sql/championship.sql +++ b/sql/championship.sql @@ -1356,12 +1356,33 @@ INSERT INTO `championship` VALUES(1344, 2018, 17, 1167, 9); INSERT INTO `championship` VALUES(1345, 2018, 18, 1181, 6); INSERT INTO `championship` VALUES(1346, 2018, 19, 1183, 4); INSERT INTO `championship` VALUES(1347, 2018, 20, 1185, 1); +INSERT INTO `championship` VALUES(1348, 2019, 1, 1140, 413); +INSERT INTO `championship` VALUES(1349, 2019, 2, 1161, 326); +INSERT INTO `championship` VALUES(1350, 2019, 3, 1172, 278); +INSERT INTO `championship` VALUES(1351, 2019, 4, 1184, 264); +INSERT INTO `championship` VALUES(1352, 2019, 5, 1135, 240); +INSERT INTO `championship` VALUES(1353, 2019, 6, 1170, 96); +INSERT INTO `championship` VALUES(1354, 2019, 7, 1182, 95); +INSERT INTO `championship` VALUES(1355, 2019, 8, 1187, 92); +INSERT INTO `championship` VALUES(1356, 2019, 9, 1157, 54); +INSERT INTO `championship` VALUES(1357, 2019, 10, 1155, 52); +INSERT INTO `championship` VALUES(1358, 2019, 11, 1186, 49); +INSERT INTO `championship` VALUES(1359, 2019, 12, 1141, 43); +INSERT INTO `championship` VALUES(1360, 2019, 13, 1166, 37); +INSERT INTO `championship` VALUES(1361, 2019, 14, 1148, 37); +INSERT INTO `championship` VALUES(1362, 2019, 15, 1181, 21); +INSERT INTO `championship` VALUES(1363, 2019, 16, 1165, 20); +INSERT INTO `championship` VALUES(1364, 2019, 17, 1180, 14); +INSERT INTO `championship` VALUES(1365, 2019, 18, 1144, 8); +INSERT INTO `championship` VALUES(1366, 2019, 19, 1136, 1); +INSERT INTO `championship` VALUES(1367, 2019, 20, 1188, 0); + ALTER TABLE `championship` ADD PRIMARY KEY (`id`), ADD KEY `_driver` (`_driver`); ALTER TABLE `championship` -MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1271; +MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1368; ALTER TABLE `championship` ADD CONSTRAINT `championship_ibfk_1` FOREIGN KEY (`_driver`) REFERENCES `drivers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; diff --git a/sql/results.sql b/sql/results.sql index 9932a7b..73822b1 100644 --- a/sql/results.sql +++ b/sql/results.sql @@ -2683,6 +2683,8 @@ INSERT INTO `races` VALUES(2677, '2019 United States Grand Prix - qualifying', ' INSERT INTO `races` VALUES(2678, '2019 United States Grand Prix', '2019-11-03', 0, 4); INSERT INTO `races` VALUES(2679, '2019 Brazilian Grand Prix qualifying', '2019-11-16', 0, 3); INSERT INTO `races` VALUES(2680, '2019 Brazilian Grand Prix', '2019-11-17', 0, 4); +INSERT INTO `races` VALUES(2681, '2019 Abu Dhabi Grand Prix - qualifying', '2019-11-30', 0, 3); +INSERT INTO `races` VALUES(2682, '2019 Abu Dhabi Grand Prix', '2019-12-01', 0, 4); INSERT INTO `countries` VALUES(9, 'Argentina'); INSERT INTO `countries` VALUES(18, 'Australia'); @@ -61394,6 +61396,46 @@ INSERT INTO `entries` VALUES(57479, '17', 5, 7, 2680); INSERT INTO `entries` VALUES(57480, '18', 16, 7, 2680); INSERT INTO `entries` VALUES(57481, '19', 18, 0, 2680); INSERT INTO `entries` VALUES(57482, 'R', 77, 0, 2680); +INSERT INTO `entries` VALUES(57483, '1', 44, 1, 2681); +INSERT INTO `entries` VALUES(57484, '2', 77, 2, 2681); +INSERT INTO `entries` VALUES(57485, '3', 33, 3, 2681); +INSERT INTO `entries` VALUES(57486, '4', 16, 4, 2681); +INSERT INTO `entries` VALUES(57487, '5', 5, 5, 2681); +INSERT INTO `entries` VALUES(57488, '6', 23, 6, 2681); +INSERT INTO `entries` VALUES(57489, '7', 4, 7, 2681); +INSERT INTO `entries` VALUES(57490, '8', 3, 8, 2681); +INSERT INTO `entries` VALUES(57491, '9', 55, 9, 2681); +INSERT INTO `entries` VALUES(57492, '10', 27, 10, 2681); +INSERT INTO `entries` VALUES(57493, '11', 11, 11, 2681); +INSERT INTO `entries` VALUES(57494, '12', 10, 12, 2681); +INSERT INTO `entries` VALUES(57495, '13', 18, 13, 2681); +INSERT INTO `entries` VALUES(57496, '14', 26, 14, 2681); +INSERT INTO `entries` VALUES(57497, '15', 20, 15, 2681); +INSERT INTO `entries` VALUES(57498, '16', 8, 16, 2681); +INSERT INTO `entries` VALUES(57499, '17', 99, 17, 2681); +INSERT INTO `entries` VALUES(57500, '18', 7, 18, 2681); +INSERT INTO `entries` VALUES(57501, '19', 63, 19, 2681); +INSERT INTO `entries` VALUES(57502, '20', 88, 20, 2681); +INSERT INTO `entries` VALUES(57503, '1', 44, 1, 2682); +INSERT INTO `entries` VALUES(57504, '2', 33, 2, 2682); +INSERT INTO `entries` VALUES(57505, '3', 16, 2, 2682); +INSERT INTO `entries` VALUES(57506, '4', 77, 3, 2682); +INSERT INTO `entries` VALUES(57507, '5', 5, 3, 2682); +INSERT INTO `entries` VALUES(57508, '6', 23, 4, 2682); +INSERT INTO `entries` VALUES(57509, '7', 11, 5, 2682); +INSERT INTO `entries` VALUES(57510, '8', 4, 5, 2682); +INSERT INTO `entries` VALUES(57511, '9', 26, 5, 2682); +INSERT INTO `entries` VALUES(57512, '10', 55, 5, 2682); +INSERT INTO `entries` VALUES(57513, '11', 3, 5, 2682); +INSERT INTO `entries` VALUES(57514, '12', 27, 5, 2682); +INSERT INTO `entries` VALUES(57515, '13', 7, 5, 2682); +INSERT INTO `entries` VALUES(57516, '14', 20, 5, 2682); +INSERT INTO `entries` VALUES(57517, '15', 8, 5, 2682); +INSERT INTO `entries` VALUES(57518, '16', 99, 5, 2682); +INSERT INTO `entries` VALUES(57519, '17', 63, 5, 2682); +INSERT INTO `entries` VALUES(57520, '18', 10, 6, 2682); +INSERT INTO `entries` VALUES(57521, '19', 88, 6, 2682); +INSERT INTO `entries` VALUES(57522, 'R', 18, 0, 2682); INSERT INTO `driver_entries` VALUES(1, 1, 1); INSERT INTO `driver_entries` VALUES(2, 2, 2); @@ -119016,3 +119058,43 @@ INSERT INTO `driver_entries` VALUES(1135, 57479, 57618); INSERT INTO `driver_entries` VALUES(1184, 57480, 57619); INSERT INTO `driver_entries` VALUES(1181, 57481, 57620); INSERT INTO `driver_entries` VALUES(1161, 57482, 57621); +INSERT INTO `driver_entries` VALUES(1140, 57483, 57622); +INSERT INTO `driver_entries` VALUES(1161, 57484, 57623); +INSERT INTO `driver_entries` VALUES(1172, 57485, 57624); +INSERT INTO `driver_entries` VALUES(1184, 57486, 57625); +INSERT INTO `driver_entries` VALUES(1135, 57487, 57626); +INSERT INTO `driver_entries` VALUES(1187, 57488, 57627); +INSERT INTO `driver_entries` VALUES(1186, 57489, 57628); +INSERT INTO `driver_entries` VALUES(1157, 57490, 57629); +INSERT INTO `driver_entries` VALUES(1170, 57491, 57630); +INSERT INTO `driver_entries` VALUES(1148, 57492, 57631); +INSERT INTO `driver_entries` VALUES(1155, 57493, 57632); +INSERT INTO `driver_entries` VALUES(1182, 57494, 57633); +INSERT INTO `driver_entries` VALUES(1181, 57495, 57634); +INSERT INTO `driver_entries` VALUES(1166, 57496, 57635); +INSERT INTO `driver_entries` VALUES(1165, 57497, 57636); +INSERT INTO `driver_entries` VALUES(1144, 57498, 57637); +INSERT INTO `driver_entries` VALUES(1180, 57499, 57638); +INSERT INTO `driver_entries` VALUES(1141, 57500, 57639); +INSERT INTO `driver_entries` VALUES(1188, 57501, 57640); +INSERT INTO `driver_entries` VALUES(1136, 57502, 57641); +INSERT INTO `driver_entries` VALUES(1140, 57503, 57642); +INSERT INTO `driver_entries` VALUES(1172, 57504, 57643); +INSERT INTO `driver_entries` VALUES(1184, 57505, 57644); +INSERT INTO `driver_entries` VALUES(1161, 57506, 57645); +INSERT INTO `driver_entries` VALUES(1135, 57507, 57646); +INSERT INTO `driver_entries` VALUES(1187, 57508, 57647); +INSERT INTO `driver_entries` VALUES(1155, 57509, 57648); +INSERT INTO `driver_entries` VALUES(1186, 57510, 57649); +INSERT INTO `driver_entries` VALUES(1166, 57511, 57650); +INSERT INTO `driver_entries` VALUES(1170, 57512, 57651); +INSERT INTO `driver_entries` VALUES(1157, 57513, 57652); +INSERT INTO `driver_entries` VALUES(1148, 57514, 57653); +INSERT INTO `driver_entries` VALUES(1141, 57515, 57654); +INSERT INTO `driver_entries` VALUES(1165, 57516, 57655); +INSERT INTO `driver_entries` VALUES(1144, 57517, 57656); +INSERT INTO `driver_entries` VALUES(1180, 57518, 57657); +INSERT INTO `driver_entries` VALUES(1188, 57519, 57658); +INSERT INTO `driver_entries` VALUES(1182, 57520, 57659); +INSERT INTO `driver_entries` VALUES(1136, 57521, 57660); +INSERT INTO `driver_entries` VALUES(1181, 57522, 57661); -- cgit v1.2.3