From adcdb4574294942cee0efeeb7bc805a265b1c9d9 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Thu, 29 Nov 2007 07:37:44 +0000 Subject: Removing duplicate drawer open git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1917 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sql/Pg-database.sql') diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 61edb2e7..96dea912 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -614,6 +614,7 @@ CREATE TABLE ar ( on_hold bool default false, reverse bool default false, approved bool default true, + credit_account int references entity_credit_account(id) not null, description text ); @@ -649,7 +650,7 @@ CREATE TABLE ap ( reverse bool default false, terms int2 DEFAULT 0, description text, - credit_account int + credit_account int references entity_credit_account(id) ); COMMENT ON COLUMN ap.entity_id IS $$ Used to be customer_id, but customer is now metadata. You need to push to entity $$; -- cgit v1.2.3