diff options
| author | emkael <emkael@tlen.pl> | 2015-03-09 10:54:12 +0100 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2015-03-09 10:54:12 +0100 |
| commit | 1ed5cc6966c3351e851b7c90ec389517eae6dd74 (patch) | |
| tree | fe24e67d9b52d65107ec478ea9cb383d999edf5b /import | |
| parent | 67b65b0f032e01c737a15ad26f817cd7cd83c3c3 (diff) | |
* upstream DB update, 07.03.2015
Diffstat (limited to 'import')
| -rw-r--r-- | import/01a_integrity_fixes.sql | 4 | ||||
| -rw-r--r-- | import/10_fixes.sql | 10 |
2 files changed, 0 insertions, 14 deletions
diff --git a/import/01a_integrity_fixes.sql b/import/01a_integrity_fixes.sql index 370220b..e36367a 100644 --- a/import/01a_integrity_fixes.sql +++ b/import/01a_integrity_fixes.sql @@ -1,6 +1,2 @@ ALTER TABLE races CHANGE circuitId circuitId INT(11) NULL; UPDATE races SET circuitId = NULL WHERE raceId = 935; -- 2015 German GP, venue TBA - -UPDATE results SET position = NULL WHERE position = 0; - -UPDATE drivers SET dob = NULL WHERE driverId = 415; -- Ray Reed, date of birth unknown diff --git a/import/10_fixes.sql b/import/10_fixes.sql index 6735973..3f93241 100644 --- a/import/10_fixes.sql +++ b/import/10_fixes.sql @@ -1,11 +1 @@ -UPDATE circuits SET lng = 4.89913 WHERE circuitRef = 'dijon'; -UPDATE circuits SET lat = 19.40421, lng = -99.090714 WHERE circuitRef = 'rodriguez'; -UPDATE circuits SET lat = 33.7651, lng = -118.189 WHERE circuitRef = 'long_beach'; -UPDATE circuits SET lat = 36.11617, lng = -115.1745 WHERE circuitRef = 'las_vegas'; -UPDATE circuits SET lat = 47.95, lng = 0.2242312 WHERE circuitRef = 'lemans'; -UPDATE circuits SET lat = 28.3468, lng = 77.5331232 WHERE circuitRef = 'buddh'; -UPDATE circuits SET country = 'USA' WHERE country = 'United States'; - UPDATE results SET grid = 15 WHERE resultId = 2939; -- Nick Heidfeld, Australia 2000 - -UPDATE drivers SET dob = '1954-01-24' WHERE driverId = 189; -- Jo Gartner |