From ffd9d4fb6706e609a16b3a5a2fffe0959fd845d3 Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 3 Mar 2015 11:54:10 +0100 Subject: * career length stats * http://ergast.com/mrd/bugs/comment-page-2#comment-12128 --- import/01a_integrity_fixes.sql | 2 ++ import/10_fixes.sql | 1 + 2 files changed, 3 insertions(+) (limited to 'import') diff --git a/import/01a_integrity_fixes.sql b/import/01a_integrity_fixes.sql index 560ab62..370220b 100644 --- a/import/01a_integrity_fixes.sql +++ b/import/01a_integrity_fixes.sql @@ -2,3 +2,5 @@ ALTER TABLE races CHANGE circuitId circuitId INT(11) NULL; UPDATE races SET circuitId = NULL WHERE raceId = 935; -- 2015 German GP, venue TBA UPDATE results SET position = NULL WHERE position = 0; + +UPDATE drivers SET dob = NULL WHERE driverId = 415; -- Ray Reed, date of birth unknown diff --git a/import/10_fixes.sql b/import/10_fixes.sql index 6759298..6735973 100644 --- a/import/10_fixes.sql +++ b/import/10_fixes.sql @@ -8,3 +8,4 @@ UPDATE circuits SET country = 'USA' WHERE country = 'United States'; UPDATE results SET grid = 15 WHERE resultId = 2939; -- Nick Heidfeld, Australia 2000 +UPDATE drivers SET dob = '1954-01-24' WHERE driverId = 189; -- Jo Gartner -- cgit v1.2.3