add primary key to entity_class_to_entity

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1236 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 2 insertions, 1 deletions

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 29adb6b8..22e87fca 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -39,7 +39,8 @@ SELECT setval('entity_class_id_seq',7);
 
 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 $$;