diff options
| author | emkael <emkael@tlen.pl> | 2015-02-17 16:58:09 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2015-02-17 16:58:09 +0100 |
| commit | 6759c31b658290b8558356cb9d1e7247797b5e31 (patch) | |
| tree | ff94c1ab3f089cd3c287cf16e3b7516d16323053 /import/01a_integrity_fixes.sql | |
| parent | 637542f594ae0fb1648ac7b20cc86ee82895731b (diff) | |
* integrity checks import
Diffstat (limited to 'import/01a_integrity_fixes.sql')
| -rw-r--r-- | import/01a_integrity_fixes.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/import/01a_integrity_fixes.sql b/import/01a_integrity_fixes.sql new file mode 100644 index 0000000..b42f117 --- /dev/null +++ b/import/01a_integrity_fixes.sql @@ -0,0 +1,10 @@ +UPDATE constructorResults SET constructorId = 7 WHERE constructorResultsId = 14128; -- Toyota, Spain 2005 +UPDATE constructorResults SET constructorId = 3 WHERE constructorResultsId = 14845; -- Williams, China 2014 + +UPDATE constructorStandings SET constructorId = 7 WHERE constructorStandingsId = 24518; -- Toyota, Spain 2005 + +UPDATE qualifying SET driverId = 42, constructorId = 17 WHERE qualifyId = 4019; -- Baumgartner (Jordan), Hungary 2003 +UPDATE qualifying SET driverId = 42, constructorId = 17 WHERE qualifyId = 4038; -- Baumgartner (Jordan), Italy 2003 +UPDATE qualifying SET driverId = 48, constructorId = 3 WHERE qualifyId = 4025; -- Gené (Williams), Italy 2003 +UPDATE qualifying SET constructorId = 164 WHERE qualifyId IN (3420, 3421); -- HRT, China 2010 +UPDATE qualifying SET constructorId = 3 WHERE qualifyId IN (4600, 4602); -- Williams, China 2011 |