Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d17-0.1d18.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d17-0.1d18.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d17-0.1d18.sql 14 Sep 2005 17:45:49 -0000 1.2 +++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/upgrade/upgrade-0.1d17-0.1d18.sql 15 Sep 2005 16:27:48 -0000 1.3 @@ -7,7 +7,7 @@ -- @cvs-id $Id$ -- -create view dlec_sections as ( +create view dlec_view_section_report as ( select s.*, v.maxparticipants, (v.maxparticipants - s.attendees) as available_slots, @@ -22,7 +22,7 @@ on (s.product_id = v.product_id) ); -create view dlec_members as ( +create view dlec_view_membership_orders as ( select to_char(o.authorized_date, 'yyyy-mm-dd hh:miam') as authorized_date, p.product_name, u.user_id, u.first_names, u.last_name, u.email, a.line1 as address1, a.line2 as address2, a.city, a.usps_abbrev as state_code, a.full_state_name, a.zip_code, a.phone from ec_items i, ec_orders o,