From be2b4fb16b843cf52e14b5b3e3a36b3faf4df970 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 7 Nov 2008 21:17:59 +0000 Subject: Changing primary key for eca_to_location to make this testable. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2383 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 41775a39..45cfe827 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -175,7 +175,7 @@ CREATE TABLE company_to_location ( location_id integer references location(id) not null, location_class integer not null references location_class(id), company_id integer not null references company(id) ON DELETE CASCADE, - PRIMARY KEY(location_id,company_id)); + PRIMARY KEY(location_id,company_id, location_class)); COMMENT ON TABLE company_to_location IS $$ This table is used for locations generic to companies. For contract-bound -- cgit v1.2.3