Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql,v
diff -u -r1.16 -r1.17
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	30 Jul 2005 22:17:00 -0000	1.16
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	3 Aug 2005 22:44:45 -0000	1.17
@@ -89,5 +89,14 @@
 alter table membership_rels drop constraint membership_rel_mem_ck;
 alter table membership_rels add CONSTRAINT membership_rel_mem_ck CHECK ((((((((member_state)::text = 'merged'::text) OR ((member_state)::text = 'approved'::text)) OR ((member_state)::text = 'needs approval'::text)) OR ((member_state)::text = 'banned'::text)) OR ((member_state)::text = 'rejected'::text)) OR ((member_state)::text = 'deleted'::text) OR ((member_state)::text = 'request approval'::text) OR ((member_state)::text = 'request approved'::text) OR ((member_state)::text = 'waitinglist approved'::text) OR ((member_state)::text = 'awaiting payment'::text) OR ((member_state)::text = 'payment received'::text)));
 
+-- 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
+);
+
 \i dotlrn-ecommerce-memberships-create.sql
 \i dotlrn-ecommerce-admin-portlet-create.sql
