Adding discount_terms and threshold to entity_credit_account

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1594 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 2 insertions, 0 deletions

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 9b0d66d1..18cfb1d2 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -477,6 +477,7 @@ CREATE TABLE entity_credit_account (
   entity_id int not null references entity(id) ON DELETE CASCADE,
   entity_class int not null references entity_class(id) check ( entity_class in (1,2) ),
   discount numeric, 
+  discount_terms int default 0,
   taxincluded bool default 'f',
   creditlimit NUMERIC default 0,
   terms int2 default 0,
@@ -489,6 +490,7 @@ CREATE TABLE entity_credit_account (
   curr char(3),
   startdate date DEFAULT CURRENT_DATE,
   enddate date,
+  threshold numeric default 0,
   PRIMARY KEY(entity_id, meta_number)
 );