From 1a28a15c256ed87aa3d78f31e7c79cd8794e9b32 Mon Sep 17 00:00:00 2001 From: emkael Date: Sun, 1 Mar 2015 17:30:49 +0100 Subject: * http://ergast.com/mrd/bugs/comment-page-2#comment-12118 --- import/10_fixes.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'import') diff --git a/import/10_fixes.sql b/import/10_fixes.sql index 91b7568..ac8b68a 100644 --- a/import/10_fixes.sql +++ b/import/10_fixes.sql @@ -1 +1,7 @@ -UPDATE `circuits` SET lng = 4.89913 WHERE circuitRef = 'dijon'; +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'; -- cgit v1.2.3