summaryrefslogtreecommitdiff
path: root/sql
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 /sql
parent2836ebf541fdcae401c0fa345e143d37db719ce0 (diff)
2019 Abu Dhabi GP + 2019 WDC standings
Diffstat (limited to 'sql')
-rw-r--r--sql/championship.sql23
-rw-r--r--sql/results.sql82
2 files changed, 104 insertions, 1 deletions
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);