summaryrefslogtreecommitdiff
path: root/import
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2015-03-03 11:40:29 +0100
committeremkael <emkael@tlen.pl>2015-03-03 11:40:29 +0100
commit6c73fedbaad194fa47d92182f4005b963313a114 (patch)
tree660e3352bd47aeffe0ba86c58e310256d3e42bad /import
parentceed9e1056698cc3e1d1a34b35bc8c9af280f23d (diff)
* setting finishing position to NULL where it's zeroed
Diffstat (limited to 'import')
-rw-r--r--import/01a_integrity_fixes.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/import/01a_integrity_fixes.sql b/import/01a_integrity_fixes.sql
index e36367a..560ab62 100644
--- a/import/01a_integrity_fixes.sql
+++ b/import/01a_integrity_fixes.sql
@@ -1,2 +1,4 @@
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;