diff options
Diffstat (limited to 'import')
| -rw-r--r-- | import/10_fixes.sql | 81 |
1 files changed, 80 insertions, 1 deletions
diff --git a/import/10_fixes.sql b/import/10_fixes.sql index 6fa590e..6b04b4f 100644 --- a/import/10_fixes.sql +++ b/import/10_fixes.sql @@ -111,4 +111,83 @@ UPDATE drivers SET url = 'http://en.wikipedia.org/wiki/Carlos_Pace' WHERE driver -- http://ergast.com/mrd/bugs/comment-page-3#comment-15202 UPDATE qualifying SET driverId = 47, number = 12 WHERE qualifyId IN (4019, 4038); -- Baumgartner -UPDATE qualifying SET number = 4 WHERE qualifyId = 4025; -- Gene + + +UPDATE qualifying SET number = 4 WHERE qualifyId = 4025; -- 2003 Italian Grand Prix, Gene +UPDATE qualifying SET number = 21 WHERE qualifyId = 478; -- 2007 Monaco Grand Prix, Albers +UPDATE qualifying SET number = 10 WHERE qualifyId = 507; -- 2007 United States Grand Prix, Vettel +UPDATE qualifying SET number = 21 WHERE qualifyId = 588; -- 2007 European Grand Prix, Winkelhock +UPDATE qualifying SET number = 19 WHERE qualifyId = 608; -- 2007 Hungarian Grand Prix, Vettel +UPDATE qualifying SET number = 21 WHERE qualifyId = 610; -- 2007 Hungarian Grand Prix, Yamamoto +UPDATE qualifying SET number = 19 WHERE qualifyId = 628; -- 2007 Turkish Grand Prix, Vettel +UPDATE qualifying SET number = 21 WHERE qualifyId = 630; -- 2007 Turkish Grand Prix, Yamamoto +UPDATE qualifying SET number = 19 WHERE qualifyId = 648; -- 2007 Italian Grand Prix, Vettel +UPDATE qualifying SET number = 21 WHERE qualifyId = 654; -- 2007 Italian Grand Prix, Yamamoto +UPDATE qualifying SET number = 19 WHERE qualifyId = 670; -- 2007 Belgian Grand Prix, Vettel +UPDATE qualifying SET number = 21 WHERE qualifyId = 675; -- 2007 Belgian Grand Prix, Yamamoto +UPDATE qualifying SET number = 19 WHERE qualifyId = 684; -- 2007 Japanese Grand Prix, Vettel +UPDATE qualifying SET number = 21 WHERE qualifyId = 698; -- 2007 Japanese Grand Prix, Yamamoto +UPDATE qualifying SET number = 19 WHERE qualifyId = 715; -- 2007 Chinese Grand Prix, Vettel +UPDATE qualifying SET number = 21 WHERE qualifyId = 720; -- 2007 Chinese Grand Prix, Yamamoto +UPDATE qualifying SET number = 19 WHERE qualifyId = 733; -- 2007 Brazilian Grand Prix, Vettel +UPDATE qualifying SET number = 17 WHERE qualifyId = 739; -- 2007 Brazilian Grand Prix, Nakajima +UPDATE qualifying SET number = 21 WHERE qualifyId = 742; -- 2007 Brazilian Grand Prix, Yamamoto +UPDATE qualifying SET number = 7 WHERE qualifyId = 759; -- 2006 Bahrain Grand Prix, R. Schumacher +UPDATE qualifying SET number = 23 WHERE qualifyId = 852; -- 2006 European Grand Prix, Montagny +UPDATE qualifying SET number = 23 WHERE qualifyId = 873; -- 2006 Spanish Grand Prix, Montagny +UPDATE qualifying SET number = 23 WHERE qualifyId = 894; -- 2006 Monaco Grand Prix, Montagny +UPDATE qualifying SET number = 23 WHERE qualifyId = 917; -- 2006 British Grand Prix, Montagny +UPDATE qualifying SET number = 23 WHERE qualifyId = 940; -- 2006 Canadian Grand Prix, Montagny +UPDATE qualifying SET number = 23 WHERE qualifyId = 962; -- 2006 United States Grand Prix, Montagny +UPDATE qualifying SET number = 4 WHERE qualifyId = 970; -- 2006 French Grand Prix, de la Rosa +UPDATE qualifying SET number = 23 WHERE qualifyId = 983; -- 2006 French Grand Prix, Montagny +UPDATE qualifying SET number = 4 WHERE qualifyId = 993; -- 2006 German Grand Prix, de la Rosa +UPDATE qualifying SET number = 23 WHERE qualifyId = 1005; -- 2006 German Grand Prix, Yamamoto +UPDATE qualifying SET number = 4 WHERE qualifyId = 1011; -- 2006 Hungarian Grand Prix, de la Rosa +UPDATE qualifying SET number = 17 WHERE qualifyId = 1016; -- 2006 Hungarian Grand Prix, Kubica +UPDATE qualifying SET number = 23 WHERE qualifyId = 1028; -- 2006 Hungarian Grand Prix, Yamamoto +UPDATE qualifying SET number = 17 WHERE qualifyId = 1037; -- 2006 Turkish Grand Prix, Kubica +UPDATE qualifying SET number = 4 WHERE qualifyId = 1040; -- 2006 Turkish Grand Prix, de la Rosa +UPDATE qualifying SET number = 23 WHERE qualifyId = 1049; -- 2006 Turkish Grand Prix, Yamamoto +UPDATE qualifying SET number = 17 WHERE qualifyId = 1056; -- 2006 Italian Grand Prix, Kubica +UPDATE qualifying SET number = 4 WHERE qualifyId = 1057; -- 2006 Italian Grand Prix, de la Rosa +UPDATE qualifying SET number = 23 WHERE qualifyId = 1072; -- 2006 Italian Grand Prix, Yamamoto +UPDATE qualifying SET number = 4 WHERE qualifyId = 1079; -- 2006 Chinese Grand Prix, de la Rosa +UPDATE qualifying SET number = 17 WHERE qualifyId = 1081; -- 2006 Chinese Grand Prix, Kubica +UPDATE qualifying SET number = 15 WHERE qualifyId = 1082; -- 2006 Chinese Grand Prix, Doornbos +UPDATE qualifying SET number = 23 WHERE qualifyId = 1091; -- 2006 Chinese Grand Prix, Yamamoto +UPDATE qualifying SET number = 17 WHERE qualifyId = 1106; -- 2006 Japanese Grand Prix, Kubica +UPDATE qualifying SET number = 4 WHERE qualifyId = 1107; -- 2006 Japanese Grand Prix, de la Rosa +UPDATE qualifying SET number = 15 WHERE qualifyId = 1112; -- 2006 Japanese Grand Prix, Doornbos +UPDATE qualifying SET number = 23 WHERE qualifyId = 1116; -- 2006 Japanese Grand Prix, Yamamoto +UPDATE qualifying SET number = 17 WHERE qualifyId = 1125; -- 2006 Brazilian Grand Prix, Kubica +UPDATE qualifying SET number = 4 WHERE qualifyId = 1128; -- 2006 Brazilian Grand Prix, de la Rosa +UPDATE qualifying SET number = 15 WHERE qualifyId = 1131; -- 2006 Brazilian Grand Prix, Doornbos +UPDATE qualifying SET number = 23 WHERE qualifyId = 1137; -- 2006 Brazilian Grand Prix, Yamamoto +ALTER TABLE results CHANGE number number INT(11) NULL DEFAULT NULL; +UPDATE results SET number = NULL WHERE resultId = 20322; -- 1963 South African Grand Prix, Hailwood +UPDATE results SET number = NULL WHERE resultId = 17716; -- 1962 French Grand Prix, Marsh +UPDATE results SET number = NULL WHERE resultId = 17717; -- 1962 French Grand Prix, Davis +UPDATE results SET number = NULL WHERE resultId = 17718; -- 1962 French Grand Prix, Abate +UPDATE results SET number = NULL WHERE resultId = 17719; -- 1962 French Grand Prix, Burgess +UPDATE results SET number = NULL WHERE resultId = 17940; -- 1961 French Grand Prix, Bordeu +UPDATE results SET number = 12 WHERE resultId = 19941; -- 1951 British Grand Prix, González +UPDATE results SET number = 2 WHERE resultId = 19942; -- 1951 British Grand Prix, Fangio +UPDATE results SET number = 10 WHERE resultId = 19943; -- 1951 British Grand Prix, Villoresi +UPDATE results SET number = 4 WHERE resultId = 19944; -- 1951 British Grand Prix, Bonetto +UPDATE results SET number = 6 WHERE resultId = 19945; -- 1951 British Grand Prix, Parnell +UPDATE results SET number = 3 WHERE resultId = 19946; -- 1951 British Grand Prix, Sanesi +UPDATE results SET number = 7 WHERE resultId = 19947; -- 1951 British Grand Prix, Walker +UPDATE results SET number = 9 WHERE resultId = 19948; -- 1951 British Grand Prix, Shawe Taylor +UPDATE results SET number = 14 WHERE resultId = 19949; -- 1951 British Grand Prix, Whitehead +UPDATE results SET number = 22 WHERE resultId = 19950; -- 1951 British Grand Prix, Rosier +UPDATE results SET number = 8 WHERE resultId = 19951; -- 1951 British Grand Prix, Gerard +UPDATE results SET number = 18 WHERE resultId = 19952; -- 1951 British Grand Prix, Hamilton +UPDATE results SET number = 25 WHERE resultId = 19953; -- 1951 British Grand Prix, Claes +UPDATE results SET number = 1 WHERE resultId = 19954; -- 1951 British Grand Prix, Farina +UPDATE results SET number = 5 WHERE resultId = 19955; -- 1951 British Grand Prix, Kelly +UPDATE results SET number = 11 WHERE resultId = 19956; -- 1951 British Grand Prix, Ascari +UPDATE results SET number = 17 WHERE resultId = 19957; -- 1951 British Grand Prix, Fotheringham-Parker +UPDATE results SET number = 15 WHERE resultId = 19958; -- 1951 British Grand Prix, Murray +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 |