From d26f49e4e4e898ed2b94e9aa9117b9417816d58f Mon Sep 17 00:00:00 2001 From: emkael Date: Fri, 4 Nov 2016 00:05:46 +0100 Subject: * date of death goes to death_dates.sql --- import/10_fixes.sql | 2 +- import/11_death_dates.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'import') diff --git a/import/10_fixes.sql b/import/10_fixes.sql index 3f7a559..70bc411 100644 --- a/import/10_fixes.sql +++ b/import/10_fixes.sql @@ -192,7 +192,7 @@ UPDATE results SET number = 15 WHERE resultId = 19958; -- 1951 British Grand Pri UPDATE results SET number = 23 WHERE resultId = 19959; -- 1951 British Grand Prix, Chiron UPDATE results SET number = 16 WHERE resultId = 19960; -- 1951 British Grand Prix, James -UPDATE drivers SET url = NULL, dob = '1945-09-03', dod = '2009-03-19' WHERE driverId = 452; -- Thomas Monarch +UPDATE drivers SET url = NULL, dob = '1945-09-03' WHERE driverId = 452; -- Thomas Monarch UPDATE drivers SET dob = '1980-08-06' WHERE driverId = 24; -- Vitantonio Liuzzi UPDATE drivers SET dob = '1974-03-29' WHERE driverId = 48; -- Marc Gene UPDATE drivers SET dob = '1969-11-19' WHERE driverId = 113; -- Philippe Adams diff --git a/import/11_death_dates.sql b/import/11_death_dates.sql index ebb7a22..c7e7903 100644 --- a/import/11_death_dates.sql +++ b/import/11_death_dates.sql @@ -72,6 +72,7 @@ UPDATE drivers SET dod = "2009-04-26" WHERE driverId = 805; -- Danny Kladis UPDATE drivers SET dod = "2009-03-30" WHERE driverId = 334; -- Jackie Pretorius UPDATE drivers SET dod = "2009-03-24" WHERE driverId = 753; -- Hans Klenk UPDATE drivers SET dod = "2009-03-23" WHERE driverId = 494; -- Lloyd Ruby +UPDATE drivers SET dod = "2009-03-19" WHERE driverId = 452; -- Thomas Monarch UPDATE drivers SET dod = "2009-02-01" WHERE driverId = 535; -- Jim McWithey UPDATE drivers SET dod = "2009-01-28" WHERE driverId = 711; -- Oswald Karch UPDATE drivers SET dod = "2008-12-19" WHERE driverId = 368; -- Sam Tingle @@ -363,7 +364,6 @@ UPDATE drivers SET dod = "1965-05-20" WHERE driverId = 431; -- Edgar Barth UPDATE drivers SET dod = "1965-01-01" WHERE driverId = 415; -- Ray Reed UPDATE drivers SET dod = "1964-08-02" WHERE driverId = 430; -- Carel Godin de Beaufort UPDATE drivers SET dod = "1964-05-30" WHERE driverId = 527; -- Eddie Sachs -UPDATE drivers SET dod = "1964-04-01" WHERE driverId = 452; -- Thomas Monarch UPDATE drivers SET dod = "1964-02-28" WHERE driverId = 470; -- Timmy Mayer UPDATE drivers SET dod = "1964-01-07" WHERE driverId = 686; -- Reg Parnell UPDATE drivers SET dod = "1963-11-28" WHERE driverId = 766; -- Lee Wallard -- cgit v1.2.3