Index: openacs-4/packages/invoices/sql/postgresql/invoices-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/sql/postgresql/invoices-create.sql,v diff -u -r1.10 -r1.11 --- openacs-4/packages/invoices/sql/postgresql/invoices-create.sql 15 Mar 2006 17:05:06 -0000 1.10 +++ openacs-4/packages/invoices/sql/postgresql/invoices-create.sql 2 Apr 2006 22:08:02 -0000 1.11 @@ -98,6 +98,7 @@ references organizations, -- who pays? comment text, + reservation text, amount_total numeric(12,2), amount_sum numeric(12,2), currency char(3) @@ -203,7 +204,7 @@ vat numeric(12,2) default 0, -- VAT amount status varchar(10) default 'new', - -- new, cancelled, billed, paid + -- new, sent, cancelled, billed, paid cancelled_p char(1) default 'f' constraint iv_invoices_cancelled_p check (cancelled_p in ('t','f'))