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 -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