summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2015-03-01 17:30:49 +0100
committeremkael <emkael@tlen.pl>2015-03-01 17:30:49 +0100
commit1a28a15c256ed87aa3d78f31e7c79cd8794e9b32 (patch)
treede4e5c4fc7038d65a236fea8015c6ef85965e0fe
parent3efa2d91641de5ffe79f30d2f4388afbf287b27a (diff)
* http://ergast.com/mrd/bugs/comment-page-2#comment-12118
-rw-r--r--import/10_fixes.sql8
1 files changed, 7 insertions, 1 deletions
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';