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

[..hidden..]

Revision: 2383
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2383&view=rev
Author:   einhverfr
Date:     2008-11-07 21:17:59 +0000 (Fri, 07 Nov 2008)

Log Message:
-----------
Changing primary key for eca_to_location to make this testable.

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2008-11-07 21:17:08 UTC (rev 2382)
+++ trunk/sql/Pg-database.sql	2008-11-07 21:17:59 UTC (rev 2383)
@@ -175,7 +175,7 @@
   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


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