ALTER TABLE job_categories ADD KEY idx_forecast (forecast);

ALTER TABLE job_types ADD KEY idx_forecast (forecast);

ALTER TABLE statuses ADD KEY idx_forecast (forecast);

ALTER TABLE requests ADD KEY idx_date_issued (date_issued);

ALTER TABLE requests ADD KEY idx_date_cancelled (date_cancelled);
