summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2019-06-04 01:32:34 +0200
committeremkael <emkael@tlen.pl>2019-06-04 01:32:34 +0200
commitdecb32ee078bec7ca412a0dd702c6913191251d7 (patch)
treec2ec8faa0dc515d27fed0e542456580da36fc588
parentf7a72e4778787a90f823a4b21d28982997b95e59 (diff)
http://ergast.com/mrd/bugs/comment-page-6/#comment-33193
-rw-r--r--import/10_fixes.sql20
1 files changed, 0 insertions, 20 deletions
diff --git a/import/10_fixes.sql b/import/10_fixes.sql
index 74b03cc..ab1cded 100644
--- a/import/10_fixes.sql
+++ b/import/10_fixes.sql
@@ -1,23 +1,3 @@
--- 1961 US GP, Gendebien/Gregory shared drive
-INSERT INTO results(raceId, driverId, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId) (SELECT raceId, 418, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId FROM results WHERE raceId = 745 AND number = 21);
-
--- 1964 US GP, Spence/Clark shared drive
-INSERT INTO results(raceId, driverId, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId) (SELECT raceId, 373, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId FROM results WHERE raceId = 717 AND number = 2);
-
--- 1971 Italian GP, Andrea de Adamich
-UPDATE results SET positionOrder = positionOrder+1 WHERE positionOrder > 16 AND raceId = 633;
-INSERT INTO results(raceId, driverId, constructorId, `number`, grid, `position`, positionText, positionOrder, points, laps, `time`, fastestLap, rank, fastestLapTime, fastestLapSpeed, statusId) VALUES(633, 333, 199, 17, 18, NULL, 'R', 17, 0, 26, NULL, NULL, NULL, NULL, NULL, 7);
-
--- 1978 US and Canadian GP, Arnoux's number
-UPDATE results SET number = 18 WHERE number = 31 AND raceId IN (541, 542);
-
--- 1984 British GP, Corrado Fabi -> Teo Fabi
-UPDATE results SET driverId = 170 WHERE driverId = 190 AND raceId = 445;
-
--- 2017 US GP, Ferrari numbers
-UPDATE results SET `number` = 5 WHERE resultId = 23703;
-UPDATE results SET `number` = 7 WHERE resultId = 23704;
-
-- Q1
-- 2008 Bahrain GP, Vettel, Sutil
UPDATE qualifying SET q1 = '1:33.562' WHERE qualifyId = 63;