Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql 14 Sep 2005 17:45:49 -0000 1.4 +++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql 15 Sep 2005 16:27:49 -0000 1.5 @@ -166,7 +166,7 @@ group by o.order_id, o.confirmed_date, o.order_state, ec_total_price(o.order_id), o.user_id, u.first_names, u.last_name, o.in_basket_date, t.method, s.section_name, s.section_id, s.course_id, o.authorized_date, balance ); -create view dlec_sections as ( +create view dlec_view_section_report as ( select s.*, v.maxparticipants, (v.maxparticipants - s.attendees) as available_slots, @@ -181,7 +181,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,