diff options
Diffstat (limited to 'sql/Pg-indices.sql')
| -rwxr-xr-x | sql/Pg-indices.sql | 100 |
1 files changed, 100 insertions, 0 deletions
diff --git a/sql/Pg-indices.sql b/sql/Pg-indices.sql new file mode 100755 index 00000000..1da593f6 --- /dev/null +++ b/sql/Pg-indices.sql @@ -0,0 +1,100 @@ +create index acc_trans_trans_id_key on acc_trans (trans_id); +create index acc_trans_chart_id_key on acc_trans (chart_id); +create index acc_trans_transdate_key on acc_trans (transdate); +create index acc_trans_source_key on acc_trans (lower(source)); +-- +create index ap_id_key on ap (id); +create index ap_transdate_key on ap (transdate); +create index ap_invnumber_key on ap (invnumber); +create index ap_ordnumber_key on ap (ordnumber); +create index ap_vendor_id_key on ap (vendor_id); +create index ap_employee_id_key on ap (employee_id); +create index ap_quonumber_key on ap (quonumber); +-- +create index ar_id_key on ar (id); +create index ar_transdate_key on ar (transdate); +create index ar_invnumber_key on ar (invnumber); +create index ar_ordnumber_key on ar (ordnumber); +create index ar_customer_id_key on ar (customer_id); +create index ar_employee_id_key on ar (employee_id); +create index ar_quonumber_key on ar (quonumber); +-- +create index assembly_id_key on assembly (id); +-- +create index chart_id_key on chart (id); +create unique index chart_accno_key on chart (accno); +create index chart_category_key on chart (category); +create index chart_link_key on chart (link); +create index chart_gifi_accno_key on chart (gifi_accno); +-- +create index customer_id_key on customer (id); +create index customer_customernumber_key on customer (customernumber); +create index customer_name_key on customer (lower(name)); +create index customer_contact_key on customer (lower(contact)); +create index customer_customer_id_key on customertax (customer_id); +-- +create index employee_id_key on employee (id); +create unique index employee_login_key on employee (login); +create index employee_name_key on employee (lower(name)); +-- +create index exchangerate_ct_key on exchangerate (curr, transdate); +-- +create unique index gifi_accno_key on gifi (accno); +-- +create index gl_id_key on gl (id); +create index gl_transdate_key on gl (transdate); +create index gl_reference_key on gl (reference); +create index gl_description_key on gl (lower(description)); +create index gl_employee_id_key on gl (employee_id); +-- +create index invoice_id_key on invoice (id); +create index invoice_trans_id_key on invoice (trans_id); +-- +create index makemodel_parts_id_key on makemodel (parts_id); +create index makemodel_make_key on makemodel (lower(make)); +create index makemodel_model_key on makemodel (lower(model)); +-- +create index oe_id_key on oe (id); +create index oe_transdate_key on oe (transdate); +create index oe_ordnumber_key on oe (ordnumber); +create index oe_employee_id_key on oe (employee_id); +create index orderitems_trans_id_key on orderitems (trans_id); +create index orderitems_id_key on orderitems (id); +-- +create index parts_id_key on parts (id); +create index parts_partnumber_key on parts (lower(partnumber)); +create index parts_description_key on parts (lower(description)); +create index partstax_parts_id_key on partstax (parts_id); +-- +create index vendor_id_key on vendor (id); +create index vendor_name_key on vendor (lower(name)); +create index vendor_vendornumber_key on vendor (vendornumber); +create index vendor_contact_key on vendor (lower(contact)); +create index vendortax_vendor_id_key on vendortax (vendor_id); +-- +create index shipto_trans_id_key on shipto (trans_id); +-- +create index project_id_key on project (id); +create unique index projectnumber_key on project (projectnumber); +-- +create index partsgroup_id_key on partsgroup (id); +create unique index partsgroup_key on partsgroup (partsgroup); +-- +create index status_trans_id_key on status (trans_id); +-- +create index department_id_key on department (id); +-- +create index partsvendor_vendor_id_key on partsvendor (vendor_id); +create index partsvendor_parts_id_key on partsvendor (parts_id); +-- +create index pricegroup_pricegroup_key on pricegroup (pricegroup); +create index pricegroup_id_key on pricegroup (id); +-- +create index audittrail_trans_id_key on audittrail (trans_id); +-- +create index translation_trans_id_key on translation (trans_id); +-- +create unique index language_code_key on language (code); +-- +create index jcitems_id_key on jcitems (id); + |