summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-11-07 21:17:59 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-11-07 21:17:59 +0000
commitbe2b4fb16b843cf52e14b5b3e3a36b3faf4df970 (patch)
tree930c6c1ffa528caf9aec8f7a8c5cbdc4dc8ec878 /sql
parente9be327c853a73b7dbc517b9a63eff85444a3d7f (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/Pg-database.sql2
1 files changed, 1 insertions, 1 deletions
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