Ergast MySQL indices

ergast-indices.sql

-- Constructor Standings
alter table constructorstandings add index (constructorid);
alter table constructorstandings add index (raceid);
alter table constructorstandings add unique index constructorrace (constructorid, raceid);

-- Drivers
alter table drivers add unique index driverref (driverref);

-- Driver Standings
alter table driverstandings add index (driverid);
alter table driverstandings add index (raceid);
alter table driverstandings add uniqueindex driverrace (driverid, raceid);

-- Races
alter table races modify column `date` DATE not null default '1900-01-01';
alter table races add unique index yearround (year, round);

-- Results
alter table results add index (position);
alter table results add index (grid);
alter table results add index (driverid);
alter table results add index (constructorid);
alter table results add index (raceid);
alter table results add index driverrace (driverid, raceid);