summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2019-12-09 18:55:31 +0100
committeremkael <emkael@tlen.pl>2019-12-09 18:55:31 +0100
commit36221ecc1a6237243b1cb1c00e29e661aacd9f24 (patch)
treeadf3a5064be7db240befe3cf5ef2a2df2b7d19d3
parent2836ebf541fdcae401c0fa345e143d37db719ce0 (diff)
2019 Abu Dhabi GP + 2019 WDC standings
-rw-r--r--rate.log54
-rw-r--r--sql/championship.sql23
-rw-r--r--sql/results.sql82
3 files changed, 158 insertions, 1 deletions
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 (<Lewis Hamilton (#1140)>) 1[1] 2510.42 2513.9
+#77 (<Valtteri Bottas (#1161)>) 2[2] 2549.07 2550.15
+#33 (<Max Verstappen (#1172)>) 3[3] 2468.11 2469.41
+#16 (<Charles Leclerc (#1184)>) 4[4] 2189.78 2200.37
+#5 (<Sebastian Vettel (#1135)>) 5[5] 2242.28 2248.73
+#23 (<Alexander Albon (#1187)>) 6[6] 2251.22 2255.66
+#4 (<Lando Norris (#1186)>) 7[7] 2229.75 2233.6
+#3 (<Daniel Ricciardo (#1157)>) 8[8] 2207.83 2211.14
+#55 (<Carlos Sainz (#1170)>) 9[9] 2255.62 2255.05
+#27 (<Nico Hülkenberg (#1148)>) 10[10] 2044.85 2052.77
+#11 (<Sergio Pérez (#1155)>) 11[11] 2185.17 2184.79
+#10 (<Pierre Gasly (#1182)>) 12[12] 2230.9 2226.69
+#18 (<Lance Stroll (#1181)>) 13[13] 2059.86 2062.31
+#26 (<Daniil Kvyat (#1166)>) 14[14] 2136.09 2133.33
+#20 (<Kevin Magnussen (#1165)>) 15[15] 2057.71 2057.06
+#8 (<Romain Grosjean (#1144)>) 16[16] 2052.59 2050.57
+#99 (<Antonio Giovinazzi (#1180)>) 17[17] 2195.36 2184.88
+#7 (<Kimi Räikkönen (#1141)>) 18[18] 2200.68 2188.34
+#63 (<George Russell (#1188)>) 19[19] 1956.05 1950.53
+#88 (<Robert Kubica (#1136)>) 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 (<Lewis Hamilton (#1140)>) 1[1] 2513.9 2547.68
+#33 (<Max Verstappen (#1172)>) 2[2] 2469.41 2489.64
+#16 (<Charles Leclerc (#1184)>) 3[2] 2200.37 2320.91
+#77 (<Valtteri Bottas (#1161)>) 4[3] 2550.15 2520.59
+#5 (<Sebastian Vettel (#1135)>) 5[3] 2248.73 2315.19
+#23 (<Alexander Albon (#1187)>) 6[4] 2255.66 2295.05
+#11 (<Sergio Pérez (#1155)>) 7[5] 2184.79 2156.58
+#4 (<Lando Norris (#1186)>) 8[5] 2233.6 2182.87
+#26 (<Daniil Kvyat (#1166)>) 9[5] 2133.33 2129.03
+#55 (<Carlos Sainz (#1170)>) 10[5] 2255.05 2194.71
+#3 (<Daniel Ricciardo (#1157)>) 11[5] 2211.14 2170.69
+#27 (<Nico Hülkenberg (#1148)>) 12[5] 2052.77 2083.9
+#7 (<Kimi Räikkönen (#1141)>) 13[5] 2188.34 2158.48
+#20 (<Kevin Magnussen (#1165)>) 14[5] 2057.06 2086.41
+#8 (<Romain Grosjean (#1144)>) 15[5] 2050.57 2082.61
+#99 (<Antonio Giovinazzi (#1180)>) 16[5] 2184.88 2156.63
+#63 (<George Russell (#1188)>) 17[5] 1950.53 2048.72
+#10 (<Pierre Gasly (#1182)>) 18[6] 2226.69 2067.1
+#88 (<Robert Kubica (#1136)>) 19[6] 1905.25 1865.42
+#18 (<Lance Stroll (#1181)>) 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);