Index: openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql	20 Jul 2006 16:24:57 -0000	1.7
+++ openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql	24 Oct 2006 10:09:50 -0000	1.8
@@ -453,18 +453,13 @@
                     on delete cascade
                     constraint imsld_semaildata_pk  
                     primary key,  
-    send_mail_id    integer
-                    constraint imsld_semaildata_smailid_fk
-                    references cr_items     --imsld_send_mail_services
-                    not null,
     role_id         integer
                     constraint imsld_semaildata_roleid_fk
                     references cr_items     --imsld_roles
                     not null,
     mail_data       text
 );
 
-create index imsld_sm_data_sm_id_idx on imsld_send_mail_data(send_mail_id);
 create index imsld_sm_data_role_id_idx on imsld_send_mail_data(role_id);
 
 create table imsld_conference_services (