create index client_client_id on client (client_id);

create index hours_date_entered on hours (date_entered);
create index hours_del on hours (del);
create index hours_downloaded on hours (downloaded);
create index hours_fkclient_id on hours (fkclient_id);
create index hours_fkjob_id on hours (fkjob_id);
create index hours_fkpersonnel_id on hours (fkpersonnel_id);
create index hours_approval_date on hours (approval_date);
// unsure about this one, i.e., why it existed
// create index hours_fkpersonnel_id on hours using hash ( fkpersonnel_id text_ops);
create index hours_hours_id on hours (hours_id);
create index hours_id_index on hours (hours_id);

create index job_downloaded on job (downloaded);
create index job_fkclient_id on job (fkclient_id);
create index job_fksupervisor_id on job (fksupervisor_id);
create index job_job_id on job (job_id);

create index personnel_personnel_id on personnel (personnel_id);
create index personnel_super_user on personnel (super_user);