From 5758dbb5fdf8e4428874465fd4c2a777e7c0c815 Mon Sep 17 00:00:00 2001 From: linuxpoet Date: Tue, 22 May 2007 19:07:28 +0000 Subject: 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 --- sql/Pg-database.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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 $$; -- cgit v1.2.3