X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=sql-ledger%2Fsql%2FOracle-indices.sql;h=409b89139f64529b337c9df52aa64892799ea448;hp=e55915b05b4a072df40042da7b7f97e8786aa032;hb=32306b5f8ffe4ce594409aa6e89626740b225a39;hpb=52072fcd26f2faf57923f598c358e7f47c4e2643

diff --git a/sql-ledger/sql/Oracle-indices.sql b/sql-ledger/sql/Oracle-indices.sql
index e55915b05..409b89139 100644
--- a/sql-ledger/sql/Oracle-indices.sql
+++ b/sql-ledger/sql/Oracle-indices.sql
@@ -8,12 +8,14 @@ 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);
@@ -38,6 +40,8 @@ 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 (make);
+create index makemodel_model_key on makemodel (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);
@@ -54,4 +58,8 @@ create index vendor_contact_key on vendor (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);