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

[..hidden..]

Revision: 1406
          http://svn.sourceforge.net/ledger-smb/?rev=1406&view=rev
Author:   einhverfr
Date:     2007-07-16 11:43:55 -0700 (Mon, 16 Jul 2007)

Log Message:
-----------
Adding foreign key to acc_trans.trans_id

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-07-16 18:33:04 UTC (rev 1405)
+++ trunk/sql/Pg-database.sql	2007-07-16 18:43:55 UTC (rev 1406)
@@ -368,7 +368,7 @@
 \.
 -- */
 CREATE TABLE acc_trans (
-  trans_id int,
+  trans_id int NOT NULL REFERENCES transactions(id),
   chart_id int NOT NULL REFERENCES chart (id),
   amount NUMERIC,
   transdate date DEFAULT current_date,


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