Index: openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info,v
diff -u -r1.17 -r1.18
--- openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info	3 Aug 2005 22:35:36 -0000	1.17
+++ openacs-4/packages/dotlrn-ecommerce/dotlrn-ecommerce.info	3 Aug 2005 23:35:26 -0000	1.18
@@ -7,15 +7,15 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="0.1d2" url="http://openacs.org/repository/download/apm/dotlrn-ecommerce-0.1d2.apm">
+    <version name="0.1d3" url="http://openacs.org/repository/download/apm/dotlrn-ecommerce-0.1d3.apm">
         <owner url="mailto:roelmc@solutiongrove.com">Roel Canicula</owner>
         <summary>Package to tie the dotLRN, Ecommerce, Assessments and dotLRN Catalog packages together</summary>
         <release-date>2005-07-31</release-date>
         <vendor url="http://www.solutiongrove.com">Solution Grove</vendor>
         <description format="text/html">Package to tie the dotLRN, Ecommerce, Assessments and dotLRN Catalog packages together.  Initially intended for the MOS and MGH projects, the goal is to create a reusable module for similar projects.</description>
         <maturity>0</maturity>
 
-        <provides url="dotlrn-ecommerce" version="0.1d2"/>
+        <provides url="dotlrn-ecommerce" version="0.1d3"/>
 
         <callbacks>
             <callback type="after-install"  proc="dotlrn_ecommerce::install"/>
Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d2-0.1d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d2-0.1d3.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d2-0.1d3.sql	3 Aug 2005 23:35:26 -0000	1.1
@@ -0,0 +1,17 @@
+-- 
+-- packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d2-0.1d3.sql
+-- 
+-- @author Roel Canicula (roelmc@pldtdsl.net)
+-- @creation-date 2005-08-04
+-- @arch-tag: 68054edf-5b79-4e7e-a917-ef82cabe092c
+-- @cvs-id $Id: upgrade-0.1d2-0.1d3.sql,v 1.1 2005/08/03 23:35:26 roelc Exp $
+--
+
+-- Invoice payment method
+create table dotlrn_ecommerce_transaction_invoice_payments (
+	order_id	integer references ec_orders on delete cascade not null,
+	method		text check (method in ('cc', 'internal_account', 'check', 'cash', 'invoice', 'scholarship')) not null,
+	internal_account text,
+	amount		float not null,
+	payment_date	timestamp default current_timestamp not null
+);
\ No newline at end of file