summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-09 23:01:04 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-05-09 23:01:04 +0000
commit2c97137b280c14b6e4f6ef914de8816c99edd3e8 (patch)
treef9ef45aa629085c6c99bf52ba3283e37ec094d3d /sql/Pg-database.sql
parent7d9e94796fb4e4b76ae739088dc15c858272a90a (diff)
Adding ability to force closed transactions (via db only) to prevent them from showing up on the outstanding report.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2131 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/Pg-database.sql')
-rw-r--r--sql/Pg-database.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 757567ed..b93f47f4 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -691,6 +691,7 @@ CREATE TABLE ar (
reverse bool default false,
approved bool default true,
entity_credit_account int references entity_credit_account(id) not null,
+ force_closed bool,
description text
);
@@ -726,6 +727,7 @@ CREATE TABLE ap (
reverse bool default false,
terms int2 DEFAULT 0,
description text,
+ force_closed bool,
entity_credit_account int references entity_credit_account(id)
);