diff options
author | ivan <ivan> | 2004-11-15 10:35:56 +0000 |
---|---|---|
committer | ivan <ivan> | 2004-11-15 10:35:56 +0000 |
commit | 32306b5f8ffe4ce594409aa6e89626740b225a39 (patch) | |
tree | 8dba82e8424ebe8d089b4e0ef579d87db06742a3 /sql-ledger/sql/Oracle-indices.sql | |
parent | 52072fcd26f2faf57923f598c358e7f47c4e2643 (diff) |
import sql-ledger 2.4.4SQL_LEDGER
Diffstat (limited to 'sql-ledger/sql/Oracle-indices.sql')
-rw-r--r-- | sql-ledger/sql/Oracle-indices.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql-ledger/sql/Oracle-indices.sql b/sql-ledger/sql/Oracle-indices.sql index e55915b..409b891 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); |