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

[..hidden..]

Revision: 1260
          http://svn.sourceforge.net/ledger-smb/?rev=1260&view=rev
Author:   linuxpoet
Date:     2007-06-06 21:18:40 -0700 (Wed, 06 Jun 2007)

Log Message:
-----------
fix uniqueness on entity names

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-06-07 01:38:03 UTC (rev 1259)
+++ trunk/sql/Pg-database.sql	2007-06-07 04:18:40 UTC (rev 1260)
@@ -23,7 +23,7 @@
 COMMENT ON TABLE entity_class IS $$ Defines the class type such as vendor, customer, contact, employee $$;
 COMMENT ON COLUMN entity_class.id IS $$ The first 7 values are reserved and permanent $$;  
 
-CREATE UNIQUE index entity_class_unique_idx ON entity_class(lower(class));
+CREATE index entity_class_idx ON entity_class(lower(class));
 
 COMMENT ON INDEX entity_class_unique_idx IS $$ Helps truly define unique. Which we could do that with Primary Keys $$;
 
@@ -210,6 +210,7 @@
 CREATE UNIQUE INDEX invoice_note_class_idx ON note_class(lower(class));
 CREATE INDEX invoice_note_vectors_idx ON invoice_note USING gist(vector);
 ALTER TABLE invoice_note ADD CHECK (id = 2);
+
 -- END entity   
 
 --


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