summaryrefslogtreecommitdiff
path: root/import
diff options
context:
space:
mode:
Diffstat (limited to 'import')
-rw-r--r--import/01a_integrity_fixes.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/import/01a_integrity_fixes.sql b/import/01a_integrity_fixes.sql
index 559a576..1a57c1e 100644
--- a/import/01a_integrity_fixes.sql
+++ b/import/01a_integrity_fixes.sql
@@ -1,3 +1,6 @@
UPDATE qualifying SET q1 = NULL WHERE q1 = '';
UPDATE qualifying SET q2 = NULL WHERE q2 = '';
UPDATE qualifying SET q3 = NULL WHERE q3 = '';
+
+DELETE FROM constructorStandings WHERE raceId NOT IN (SELECT raceId FROM races);
+DELETE FROM driverStandings WHERE raceId NOT IN (SELECT raceId FROM races);