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 -N -r1.21 -r1.22
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	20 Aug 2005 18:27:54 -0000	1.21
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	1 Sep 2005 12:23:21 -0000	1.22
@@ -59,7 +59,8 @@
 	item_id		integer references ec_items on delete cascade not null,
 -- Can be a user or group
 	patron_id	integer	references users(user_id) on delete cascade not null,
-	participant_id	integer	references parties(party_id) on delete cascade not null
+	participant_id	integer	references parties(party_id) on delete cascade not null,
+	checked_out_by	integer references users(user_id) on delete cascade not null
 );
 
 create table dotlrn_ecommerce_transactions (
@@ -96,7 +97,7 @@
 -- 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,
+	method		text check (method in ('cc', 'internal_account', 'check', 'cash', 'invoice', 'scholarship', 'lockbox')) not null,
 	internal_account text,
 	amount		float not null,
 	payment_date	timestamp default current_timestamp not null