summaryrefslogtreecommitdiff
path: root/sql/DB2-indices.sql
diff options
context:
space:
mode:
authorlinuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-09 17:20:12 +0000
committerlinuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-09 17:20:12 +0000
commitea383fecc03ff242fe7e0b6b64e2ace82aa8f5d8 (patch)
tree276730ab4803f3f9b6bc6695f42d74898b1a78e9 /sql/DB2-indices.sql
parent6599a872c186b3be1b4e9c14200bf623f9f2c4a3 (diff)
Remove all non Pg Ports, they were unsupported and LedgerSMB is a Pg only project now.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@47 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/DB2-indices.sql')
-rwxr-xr-xsql/DB2-indices.sql57
1 files changed, 0 insertions, 57 deletions
diff --git a/sql/DB2-indices.sql b/sql/DB2-indices.sql
deleted file mode 100755
index 6242935f..00000000
--- a/sql/DB2-indices.sql
+++ /dev/null
@@ -1,57 +0,0 @@
-create index ac_trns_trans_id on acc_trans (trans_id)@
-create index ac_trns_chart_id on acc_trans (chart_id)@
-create index ac_trns_transdate on acc_trans (transdate)@
-create index ac_trns_source on acc_trans (source)@
-create index ap_id_x on ap (id)@
-create index ap_transdate_x on ap (transdate)@
-create index ap_invnumber_x on ap (invnumber)@
-create index ap_ordnumber_x on ap (ordnumber)@
-create index ap_vendor_id_x on ap (vendor_id)@
-create index ap_emp_id_x on ap (employee_id)@
-create index ar_id_x on ar (id)@
-create index ar_transdate_x on ar (transdate)@
-create index ar_invnumber_x on ar (invnumber)@
-create index ar_ordnumber_x on ar (ordnumber)@
-create index ar_cust_id_x on ar (customer_id)@
-create index ar_emp_id_x on ar (employee_id)@
-create index assembly_id_x on assembly (id)@
-create index chart_id_x on chart (id)@
-create unique index chart_accno_x on chart (accno)@
-create index chart_category_x on chart (category)@
-create index chart_link_x on chart (link)@
-create index chart_gifi_accno on chart (gifi_accno)@
-create index cust_id_x on customer (id)@
-create index cust_customer_id_x on customertax (customer_id)@
-create index cust_custnum_x on customer (customernumber)@
-create index cust_name_x on customer (name)@
-create index cust_contact_x on customer (contact)@
-create index employee_id_x on employee (id)@
-create unique index employee_login_x on employee (login)@
-create index employee_name_x on employee (name)@
-create index exchrate_ct_x on exchangerate (curr, transdate)@
-create unique index gifi_accno_x on gifi (accno)@
-create index gl_id_x on gl (id)@
-create index gl_transdate_x on gl (transdate)@
-create index gl_reference_x on gl (reference)@
-create index gl_description_x on gl (description)@
-create index gl_employee_id_x on gl (employee_id)@
-create index invoi_id_x on invoice (id)@
-create index invoi_trans_id_x on invoice (trans_id)@
-create index makmod_parts_id on makemodel (parts_id)@
-create index oe_id_x on oe (id)@
-create index oe_transdate_x on oe (transdate)@
-create index oe_ordnumber_x on oe (ordnumber)@
-create index oe_emp_id_x on oe (employee_id)@
-create index orditems_trans_id on orderitems (trans_id)@
-create index parts_id_x on parts (id)@
-create index parts_partnumber on parts (partnumber)@
--- create index parts_desc on parts (description)@
-create index partstax_parts_id on partstax (parts_id)@
-create index vend_id_x on vendor (id)@
-create index vend_name_x on vendor (name)@
-create index vend_vendnum_x on vendor (vendornumber)@
-create index vend_contact_x on vendor (contact)@
-create index vendtax_vendor_id on vendortax (vendor_id)@
-create index shipto_trans_id on shipto (trans_id)@
-create index project_id_x on project (id)@
-create index partsgroup_id_x on partsgroup (id)@