diff options
| author | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-05-20 21:52:23 +0000 |
|---|---|---|
| committer | linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-05-20 21:52:23 +0000 |
| commit | 0c6fe7bbe607724311f4a12924d979e39d71e13b (patch) | |
| tree | 2ad25077fe3cc0c8653234294420d6f93a9070bf /sql | |
| parent | b5d7ecbebba8178e67a3bb3fc132383ed43cae7f (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Pg-database.sql | 4 |
1 files changed, 0 insertions, 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); -- |