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.23 -r1.24
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	23 Jan 2006 08:04:42 -0000	1.23
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	27 Jan 2006 23:10:32 -0000	1.24
@@ -90,6 +90,10 @@
 alter table ec_custom_product_field_values add show_description_p boolean;
 alter table ec_custom_p_field_values_audit add show_description_p boolean;
 
+insert into ec_custom_product_fields (field_identifier, field_name, default_value, column_type, last_modified,last_modifying_user, modified_ip_address) values ('display_section_p', 'Display Section', '', 'boolean', now(), '0', '0.0.0.0');
+alter table ec_custom_product_field_values add display_section_p boolean;
+alter table ec_custom_p_field_values_audit add display_section_p boolean;
+
 -- Add member states
 alter table membership_rels drop constraint membership_rel_mem_ck;
 alter table membership_rels add CONSTRAINT membership_rel_mem_ck CHECK ((((((((member_state)::text = 'merged'::text) OR ((member_state)::text = 'approved'::text)) OR ((member_state)::text = 'needs approval'::text)) OR ((member_state)::text = 'banned'::text)) OR ((member_state)::text = 'rejected'::text)) OR ((member_state)::text = 'deleted'::text) OR ((member_state)::text = 'request approval'::text) OR ((member_state)::text = 'request approved'::text) OR ((member_state)::text = 'waitinglist approved'::text) OR ((member_state)::text = 'application sent'::text) OR ((member_state)::text = 'application approved'::text)));
@@ -105,4 +109,4 @@
 
 \i dotlrn-ecommerce-memberships-create.sql
 \i dotlrn-ecommerce-admin-portlet-create.sql
-\i dotlrn-eccmmerce-views-create.sql
\ No newline at end of file
+\i dotlrn-eccmmerce-views-create.sql
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 -r1.1 -r1.2
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-drop.sql	3 Sep 2005 00:56:34 -0000	1.1
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-views-drop.sql	27 Jan 2006 23:10:32 -0000	1.2
@@ -10,7 +10,10 @@
 drop view dlec_view_orders;
 drop view dlec_view_course_expenses;
 drop view dlec_view_sections_and_categories;
+drop view dlec_view_sections_with_start;
+drop view dlec_view_section_report;
 drop view dlec_view_sections;
+drop view dlec_view_locations;
 drop view dlec_view_courses_and_categories;
 drop view dlec_view_courses;
 drop view dlec_view_users;
@@ -19,7 +22,9 @@
 drop view dlec_view_course_types;
 drop view dlec_view_terms;
 drop view dlec_view_zones;
+drop view dlec_view_expense_items;
 drop view dlec_view_expense_codes;
+drop view dlec_view_expense_terms;
 drop view dlec_view_patron_relationships;
 drop view dlec_view_category_trees;
 drop view dlec_view_categories;
\ No newline at end of file