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.24 -r1.25
--- openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	27 Jan 2006 23:10:32 -0000	1.24
+++ openacs-4/packages/dotlrn-ecommerce/sql/postgresql/dotlrn-ecommerce-create.sql	21 Feb 2006 12:50:36 -0000	1.25
@@ -107,6 +107,21 @@
 	payment_date	timestamp default current_timestamp not null
 );
 
+--Assessment Map
+create table dotlrn_ecommerce_application_assessment_map (
+	rel_id		integer references membership_rels on delete cascade not null,
+	session_id	integer references as_sessions on delete cascade not null
+);
+
+create index dotlrn_ecommerce_application_assessment_map_rel_id_idx
+on dotlrn_ecommerce_application_assessment_map (rel_id);
+
+create index dotlrn_ecommerce_application_assessment_map_session_id_idx
+on dotlrn_ecommerce_application_assessment_map (session_id);
+
+create unique index dotlrn_ecommerce_application_assessment_map_un
+on dotlrn_ecommerce_application_assessment_map (rel_id, session_id);
+
 \i dotlrn-ecommerce-memberships-create.sql
 \i dotlrn-ecommerce-admin-portlet-create.sql
 \i dotlrn-eccmmerce-views-create.sql
