SF.net SVN: ledger-smb: [1231] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1231
          http://svn.sourceforge.net/ledger-smb/?rev=1231&view=rev
Author:   linuxpoet
Date:     2007-05-20 14:52:23 -0700 (Sun, 20 May 2007)

Log Message:
-----------
fix some index creation where vendor and customer are now meta tables

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-05-20 21:43:59 UTC (rev 1230)
+++ trunk/sql/Pg-database.sql	2007-05-20 21:52:23 UTC (rev 1231)
@@ -816,8 +816,6 @@
 --
 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 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);
 --


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.