From 66cfba2b600db93db64378a582c5bfebf1d66a6c Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 21 Oct 2006 05:30:50 +0000
Subject: Modified parsing to return undef on empty string. Modified CT to use
 0 credit limit if none provided. Added On Hand column to invoices. Dropped
 foreign key constrant on acc_trans.trans_id due to limitations in current API
 (will be in a future version).

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

(limited to 'sql/Pg-tables.sql')

diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql
index 32dffb9a..59e60248 100755
--- a/sql/Pg-tables.sql
+++ b/sql/Pg-tables.sql
@@ -78,7 +78,7 @@ CREATE TABLE defaults (
 );
 --
 CREATE TABLE acc_trans (
-  trans_id int REFERENCES transactions(id),
+  trans_id int,
   chart_id int NOT NULL REFERENCES chart (id),
   amount NUMERIC,
   transdate date DEFAULT current_date,
-- 
cgit v1.2.3

