From bed3e5383fb0415a2418839c3be7dd8ae0eea46e Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Mon, 16 Jul 2007 18:43:55 +0000
Subject: Adding foreign key to acc_trans.trans_id

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1406 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql')

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index bcd6ce5d..deaf3f5a 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -368,7 +368,7 @@ projectnumber|1
 \.
 -- */
 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,
-- 
cgit v1.2.3