Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d19-0.1d20.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d19-0.1d20.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d19-0.1d20.sql	27 Sep 2005 18:32:41 -0000	1.1
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d19-0.1d20.sql	27 Sep 2005 19:12:47 -0000	1.2
@@ -46,7 +46,7 @@
      u.first_names||' '||u.last_name as purchaser,
      i.item_id, deo.participant_id, case when ao.object_type = 'group' then acs_group__name(deo.participant_id) else person__name(deo.participant_id) end as participant_name,
     deo.checked_out_by, u.user_id as purchaser_id, (deo.checked_out_by != u.user_id) 
-	as checked_out_by_admin_p
+	as checked_out_by_admin_p, o.authorized_date, o.confirmed_date as confirmed_date_date_column, ao.object_type
     from ec_orders o
     join ec_items i using (order_id)
     join ec_products p using (product_id)
@@ -55,11 +55,9 @@
     join dotlrn_ecommerce_transactions t using (order_id)
     left join dotlrn_ecommerce_section s on (i.product_id = s.product_id)
     left join cc_users u on (o.user_id=u.user_id)
-    where o.order_state in ('confirmed', 'authorized', 'fulfilled', 'returned')
+    where o.order_state in ('confirmed', 'authorized', 'fulfilled', 'returned'));
 
-);
 
-
 create view dlec_view_locations as (
 	select dlec_view_categories.category, dlec_view_categories.category_id
 	from dlec_view_categories, dlec_view_category_trees