SF.net SVN: ledger-smb: [100] trunk/sql/Pg-tables.sql

[..hidden..]

Revision: 100
          http://svn.sourceforge.net/ledger-smb/?rev=100&view=rev
Author:   einhverfr
Date:     2006-09-15 07:50:28 -0700 (Fri, 15 Sep 2006)

Log Message:
-----------
Added the foreign key constraint to pg_tables too...

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

Modified: trunk/sql/Pg-tables.sql
===================================================================
--- trunk/sql/Pg-tables.sql	2006-09-15 14:49:17 UTC (rev 99)
+++ trunk/sql/Pg-tables.sql	2006-09-15 14:50:28 UTC (rev 100)
@@ -74,7 +74,7 @@
 --
 CREATE TABLE acc_trans (
   trans_id int,
-  chart_id int NOT NULL,
+  chart_id int NOT NULL REFERENCES chart (id),
   amount numeric(10,2),
   transdate date DEFAULT current_date,
   source text,


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