Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-drop.sql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-drop.sql	16 Jul 2005 12:51:06 -0000	1.7
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-drop.sql	3 Sep 2005 00:56:34 -0000	1.8
@@ -15,3 +15,5 @@
 
 select acs_rel_type__drop_role('as_session_role');
 select acs_rel_type__drop_role('ec_product_role');
+
+\i dotlrn-ecommerce-views-drop.sql
\ No newline at end of file
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 -N -r1.1 -r1.2
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql	5 Aug 2005 10:40:01 -0000	1.1
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-create.sql	3 Sep 2005 00:56:34 -0000	1.2
@@ -9,23 +9,6 @@
 --- creating tables to be used for remote queries.
 -- denormalize as much as possible to make it easy for them
 
-drop view dlec_view_orders;
-drop view dlec_view_course_expenses;
-drop view dlec_view_sections_and_categories;
-drop view dlec_view_sections;
-drop view dlec_view_courses_and_categories;
-drop view dlec_view_courses;
-drop view dlec_view_users;
-drop view dlec_view_scholarship_funds;
-drop view dlec_view_grades;
-drop view dlec_view_course_types;
-drop view dlec_view_terms;
-drop view dlec_view_zones;
-drop view dlec_view_expense_codes;
-drop view dlec_view_patron_relationships;
-drop view dlec_view_category_trees;
-drop view dlec_view_categories;
-
 -- categories
 
 create view dlec_view_categories as (
Index: openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-drop.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-drop.sql	3 Sep 2005 00:56:34 -0000	1.1
@@ -0,0 +1,25 @@
+-- 
+-- packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-drop.sql
+-- 
+-- @author Roel Canicula (roelmc@pldtdsl.net)
+-- @creation-date 2005-09-03
+-- @arch-tag: d37fbac7-932c-4c2c-81a4-a2e8cd2cb0fe
+-- @cvs-id $Id: dotlrn-ecommerce-views-drop.sql,v 1.1 2005/09/03 00:56:34 roelc Exp $
+--
+
+drop view dlec_view_orders;
+drop view dlec_view_course_expenses;
+drop view dlec_view_sections_and_categories;
+drop view dlec_view_sections;
+drop view dlec_view_courses_and_categories;
+drop view dlec_view_courses;
+drop view dlec_view_users;
+drop view dlec_view_scholarship_funds;
+drop view dlec_view_grades;
+drop view dlec_view_course_types;
+drop view dlec_view_terms;
+drop view dlec_view_zones;
+drop view dlec_view_expense_codes;
+drop view dlec_view_patron_relationships;
+drop view dlec_view_category_trees;
+drop view dlec_view_categories;
\ No newline at end of file