From 0c6fe7bbe607724311f4a12924d979e39d71e13b Mon Sep 17 00:00:00 2001 From: linuxpoet Date: Sun, 20 May 2007 21:52:23 +0000 Subject: fix some index creation where vendor and customer are now meta tables git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1231 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 4 ---- 1 file changed, 4 deletions(-) diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 80cd9511..b0709629 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -816,8 +816,6 @@ create index chart_gifi_accno_key on chart (gifi_accno); -- create index customer_id_key on customer (id); create index customer_customernumber_key on customer (customernumber); -create index customer_name_key on customer (lower(name)); -create index customer_contact_key on customer (lower(contact)); create index customer_customer_id_key on customertax (customer_id); -- create index employee_id_key on employee (id); @@ -854,9 +852,7 @@ create index parts_description_key on parts (lower(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 (lower(name)); create index vendor_vendornumber_key on vendor (vendornumber); -create index vendor_contact_key on vendor (lower(contact)); -- create index shipto_trans_id_key on shipto (trans_id); -- -- cgit v1.2.3