X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=sql-ledger%2Fsql%2FOracle-indices.sql;fp=sql-ledger%2Fsql%2FOracle-indices.sql;h=0000000000000000000000000000000000000000;hp=409b89139f64529b337c9df52aa64892799ea448;hb=86b1b489a4ed2f9bc0cba6cafeab0d6eca5584dc;hpb=948b8acdd4b9b3864342062d0c397a11f57c5700

diff --git a/sql-ledger/sql/Oracle-indices.sql b/sql-ledger/sql/Oracle-indices.sql
deleted file mode 100644
index 409b89139..000000000
--- a/sql-ledger/sql/Oracle-indices.sql
+++ /dev/null
@@ -1,65 +0,0 @@
-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 (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_customer_id_key on customertax (customer_id);
-create index customer_customernumber_key on customer (customernumber);
-create index customer_name_key on customer (name);
-create index customer_contact_key on customer (contact);
-create index employee_id_key on employee (id);
-create unique index employee_login_key on employee (login);
-create index employee_name_key on employee (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 (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 (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);
-create index oe_employee_id_key on oe (employee_id);
-create index orderitems_trans_id_key on orderitems (trans_id);
-create index parts_id_key on parts (id);
-create index parts_partnumber_key on parts (partnumber);
-create index parts_description_key on parts (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 (name);
-create index vendor_vendornumber_key on vendor (vendornumber);
-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);