← Back to branch summary

~jlungo/zhris/trunk

« back to all changes in this revision

Viewing changes to classes/modules/install/sql/mysql/1018A.sql

  • Committer: Juma Lungo
  • Date: 2017-11-16 08:54:53 UTC
  • Revision ID: juma.lungo@zalongwa.com-20171116085453-q3jxht0gcab8jbya
codebase commit

Show diffs side-by-side

added added

removed removed

Lines of Context:
classes/modules/install/sql/mysql/1018A.sql
 
1
CREATE INDEX permission_control_company_id ON permission_control(company_id);
 
2
CREATE INDEX station_company_id_station_id ON station(company_id,station_id);
 
3
CREATE INDEX request_user_date_id ON request(user_date_id);
 
4
CREATE INDEX message_created_by ON message(created_by);
 
5
CREATE INDEX message_created_by_parent_id ON message(created_by,parent_id);
 
6
CREATE INDEX pay_period_time_sheet_verify_user_id_pay_period_id ON pay_period_time_sheet_verify(user_id,pay_period_id);