1create index acc_trans_trans_id_key on acc_trans (trans_id); 2create index acc_trans_chart_id_key on acc_trans (chart_id); 3create index acc_trans_transdate_key on acc_trans (transdate); 4create index acc_trans_source_key on acc_trans (lower(source)); 5-- 6create index ap_id_key on ap (id); 7create index ap_transdate_key on ap (transdate); 8create index ap_invnumber_key on ap (invnumber); 9create index ap_ordnumber_key on ap (ordnumber); 10create index ap_vendor_id_key on ap (vendor_id); 11create index ap_employee_id_key on ap (employee_id); 12create index ap_quonumber_key on ap (quonumber); 13-- 14create index ar_id_key on ar (id); 15create index ar_transdate_key on ar (transdate); 16create index ar_invnumber_key on ar (invnumber); 17create index ar_ordnumber_key on ar (ordnumber); 18create index ar_customer_id_key on ar (customer_id); 19create index ar_employee_id_key on ar (employee_id); 20create index ar_quonumber_key on ar (quonumber); 21-- 22create index assembly_id_key on assembly (id); 23-- 24create index chart_id_key on chart (id); 25create unique index chart_accno_key on chart (accno); 26create index chart_category_key on chart (category); 27create index chart_link_key on chart (link); 28create index chart_gifi_accno_key on chart (gifi_accno); 29-- 30create index customer_name_key on customer (lower(name)); 31create index customer_customernumber_key on customer (customernumber); 32create index customer_contact_key on customer (lower(contact)); 33create index customer_customer_id_key on customertax (customer_id); 34-- 35create unique index employee_login_key on employee (login); 36create index employee_name_key on employee (lower(name)); 37-- 38create index exchangerate_ct_key on exchangerate (curr, transdate); 39-- 40create unique index gifi_accno_key on gifi (accno); 41-- 42create index gl_id_key on gl (id); 43create index gl_transdate_key on gl (transdate); 44create index gl_reference_key on gl (reference); 45create index gl_description_key on gl (lower(description)); 46create index gl_employee_id_key on gl (employee_id); 47-- 48create index invoice_trans_id_key on invoice (trans_id); 49-- 50create index makemodel_parts_id_key on makemodel (parts_id); 51create index makemodel_make_key on makemodel (lower(make)); 52create index makemodel_model_key on makemodel (lower(model)); 53-- 54create index oe_id_key on oe (id); 55create index oe_transdate_key on oe (transdate); 56create index oe_ordnumber_key on oe (ordnumber); 57create index oe_employee_id_key on oe (employee_id); 58create index orderitems_trans_id_key on orderitems (trans_id); 59-- 60create index parts_id_key on parts (id); 61create index parts_partnumber_key on parts (lower(partnumber)); 62create index parts_description_key on parts (lower(description)); 63create index partstax_parts_id_key on partstax (parts_id); 64-- 65create index vendor_name_key on vendor (lower(name)); 66create index vendor_vendornumber_key on vendor (vendornumber); 67create index vendor_contact_key on vendor (lower(contact)); 68create index vendortax_vendor_id_key on vendortax (vendor_id); 69-- 70create index shipto_trans_id_key on shipto (trans_id); 71-- 72create index project_id_key on project (id); 73create unique index projectnumber_key on project (projectnumber); 74-- 75create index partsgroup_id_key on partsgroup (id); 76create unique index partsgroup_key on partsgroup (partsgroup); 77-- 78create index status_trans_id_key on status (trans_id); 79-- 80create index department_id_key on department (id); 81-- 82create index partscustomer_customer_id_key on partscustomer (customer_id); 83create index partscustomer_parts_id_key on partscustomer (parts_id); 84-- 85create index partsvendor_vendor_id_key on partsvendor (vendor_id); 86create index partsvendor_parts_id_key on partsvendor (parts_id); 87-- 88create index pricegroup_pricegroup_key on pricegroup (pricegroup); 89create index pricegroup_id_key on pricegroup (id); 90-- 91create index audittrail_trans_id_key on audittrail (trans_id); 92-- 93create index translation_trans_id_key on translation (trans_id); 94-- 95create unique index language_code_key on language (code); 96-- 97create index jcitems_id_key on jcitems (id); 98-- 99create index cargo_id_key on cargo (id, trans_id); 100-- 101create index inventory_parts_id_key on inventory (parts_id); 102 103