Index: openacs-4/packages/mail-tracking/sql/postgresql/mail-tracking-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/mail-tracking/sql/postgresql/mail-tracking-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/mail-tracking/sql/postgresql/mail-tracking-create.sql	14 May 2006 16:11:19 -0000	1.7
+++ openacs-4/packages/mail-tracking/sql/postgresql/mail-tracking-create.sql	14 Nov 2006 07:17:55 -0000	1.8
@@ -54,6 +54,20 @@
 create index acs_mail_log_recipient_map_recipient_idx on acs_mail_log_recipient_map(recipient_id);
 create index acs_mail_log_um_log_rec_idx on acs_mail_log_recipient_map(log_id,recipient_id,type);
 
+-- file_mapping_table
+create table acs_mail_log_attachment_map (
+	log_id 			integer
+				constraint acs_mail_log_log_id2_fk
+				references acs_mail_log(log_id),
+	file_id			integer
+				constraint acs_mail_log_file_id_fk
+				references cr_items(item_id)
+);
+
+create index acs_mail_log_att_map_file_idx on acs_mail_log_attachment_map(file_id);	
+create index acs_mail_log_att_map_log_idx on acs_mail_log_attachment_map(log_id);	
+
+
 -- create the content type
 select acs_object_type__create_type (
    'mail_log',              -- content_type
