diff options
| author | emkael <emkael@tlen.pl> | 2016-11-04 00:05:46 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2016-11-04 00:05:46 +0100 |
| commit | d26f49e4e4e898ed2b94e9aa9117b9417816d58f (patch) | |
| tree | 36a2a4537e3873113abd3a82aa9e9ae067982211 /import | |
| parent | 4594a8ddde8c50f27ffde2a4b8320d09f95c4a35 (diff) | |
* date of death goes to death_dates.sql
Diffstat (limited to 'import')
| -rw-r--r-- | import/10_fixes.sql | 2 | ||||
| -rw-r--r-- | import/11_death_dates.sql | 2 |
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 |