CREATE INDEX joblines_jobid ON joblines (jobid);
CREATE INDEX jobs_bodyshopid ON jobs (bodyshopid);
CREATE INDEX jobs_close_date ON jobs (close_date);