Index: openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql,v
diff -u -r1.2.4.1 -r1.2.4.2
--- openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql	3 Feb 2003 16:08:00 -0000	1.2.4.1
+++ openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql	3 Feb 2003 16:12:39 -0000	1.2.4.2
@@ -251,7 +251,10 @@
         constraint acs_mail_links_body_id_fk references acs_mail_bodies
 );
 
+--RI Index
+create index acs_mail_links_body_id_idx ON acs_mail_links(body_id);
 
+
 -- API -----------------------------------------------------------------
 
 -- APIs for the datamodel in this file, separated out for future upgrades
Index: openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql	3 Feb 2003 16:08:12 -0000	1.1.2.1
+++ openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql	3 Feb 2003 16:13:11 -0000	1.1.2.2
@@ -4,3 +4,4 @@
 create index acs_mail_bodies_body_from_idx ON acs_mail_bodies(body_from);
 create index acs_mail_bodies_body_reply_idx ON acs_mail_bodies(body_reply_to);
 create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id);
+create index acs_mail_links_body_id_idx ON acs_mail_links(body_id);
Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql,v
diff -u -r1.3.4.1 -r1.3.4.2
--- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql	3 Feb 2003 16:08:29 -0000	1.3.4.1
+++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql	3 Feb 2003 16:13:25 -0000	1.3.4.2
@@ -260,7 +260,10 @@
 				 references acs_mail_bodies on delete cascade
 );
 
+-- RI Index
+create index acs_mail_links_body_id_idx ON acs_mail_links(body_id);
 
+
 -- API -----------------------------------------------------------------
 
 -- APIs for the datamodel in this file, separated out for future upgrades
Index: openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql	3 Feb 2003 16:09:03 -0000	1.1.2.1
+++ openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql	3 Feb 2003 16:13:37 -0000	1.1.2.2
@@ -1,6 +1,7 @@
--- RI Index 
+-- RI Indexes
 
 create index acs_mail_bodies_item_id_idx ON acs_mail_bodies(content_item_id);
 create index acs_mail_bodies_body_from_idx ON acs_mail_bodies(body_from);
 create index acs_mail_bodies_body_reply_idx ON acs_mail_bodies(body_reply_to);
 create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id);
+create index acs_mail_links_body_id_idx ON acs_mail_links(body_id);