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

[..hidden..]

Revision: 1236
          http://svn.sourceforge.net/ledger-smb/?rev=1236&view=rev
Author:   linuxpoet
Date:     2007-05-22 12:07:28 -0700 (Tue, 22 May 2007)

Log Message:
-----------
add primary key to entity_class_to_entity

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-05-22 17:11:20 UTC (rev 1235)
+++ trunk/sql/Pg-database.sql	2007-05-22 19:07:28 UTC (rev 1236)
@@ -39,7 +39,8 @@
 
 CREATE TABLE entity_class_to_entity (
   entity_class_id integer not null references entity_class(id),
-  entity_id integer not null references entity(id)
+  entity_id integer not null references entity(id),
+  PRIMARY KEY(entity_class_id,entity_id)
   );
 
 COMMENT ON TABLE entity_class_to_entity IS $$ Relation builder for classes to entity $$;


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