diff options
author | emkael <emkael@tlen.pl> | 2019-12-09 18:55:31 +0100 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2019-12-09 18:55:31 +0100 |
commit | 36221ecc1a6237243b1cb1c00e29e661aacd9f24 (patch) | |
tree | adf3a5064be7db240befe3cf5ef2a2df2b7d19d3 /sql | |
parent | 2836ebf541fdcae401c0fa345e143d37db719ce0 (diff) |
2019 Abu Dhabi GP + 2019 WDC standings
Diffstat (limited to 'sql')
-rw-r--r-- | sql/championship.sql | 23 | ||||
-rw-r--r-- | sql/results.sql | 82 |
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); |