summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2016-11-04 00:05:46 +0100
committeremkael <emkael@tlen.pl>2016-11-04 00:05:46 +0100
commitd26f49e4e4e898ed2b94e9aa9117b9417816d58f (patch)
tree36a2a4537e3873113abd3a82aa9e9ae067982211
parent4594a8ddde8c50f27ffde2a4b8320d09f95c4a35 (diff)
* date of death goes to death_dates.sql
-rw-r--r--import/10_fixes.sql2
-rw-r--r--import/11_death_dates.sql2
2 files changed, 2 insertions, 2 deletions
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