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.8 -r1.9
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	23 Jun 2005 12:31:21 -0000	1.8
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	7 Jul 2005 18:17:22 -0000	1.9
@@ -65,10 +65,22 @@
 	internal_account text
 );
 
+-- user_field should point to person_info fields
+-- maybe the person_info fields should be object attributes
+create table dotlrn_ecommerce_prereq_map (
+	tree_id		integer references category_trees on delete cascade not null,
+	user_field	text
+);
+
+create table dotlrn_ecommerce_prereqs (
+	section_id	integer references dotlrn_ecommerce_section on delete cascade not null,
+	tree_id		integer references category_trees on delete cascade not null
+);
+
 -- Create custom ecommerce field
 insert into ec_custom_product_fields (field_identifier, field_name, default_value, column_type, last_modified,last_modifying_user, modified_ip_address) values ('maxparticipants', 'Max Participants', '', 'integer', now(), '0', '0.0.0.0');
 alter table ec_custom_product_field_values add maxparticipants integer;
 alter table ec_custom_p_field_values_audit add maxparticipants integer;
 
 \i dotlrn-ecommerce-memberships-create.sql
-\i dotlrn-ecommerce-admin-portlet-create.sql
\ No newline at end of file
+\i dotlrn-ecommerce-admin-portlet-create.sql
