summaryrefslogtreecommitdiff
path: root/import/01a_integrity_fixes.sql
blob: 1a57c1e13dec6251a89e92620bb13c43c6db6d30 (plain)
1
2
3
4
5
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);