Index: openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql	17 Jan 2003 14:37:17 -0000	1.1.2.1
+++ openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql	3 Feb 2003 16:09:03 -0000	1.1.2.2
@@ -19,3 +19,9 @@
 insert into acs_mail_queue_outgoing select * from acs_mail_o_tmp;
 
 drop table acs_mail_o_tmp;
+
+-- RI Index 
+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);