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 -r1.4
--- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql	13 Aug 2001 17:28:19 -0000	1.3
+++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql	17 May 2003 09:52:12 -0000	1.4
@@ -176,7 +176,7 @@
     body_from			integer
 						constraint acs_mail_bodies_body_from_fk
 						references parties on delete set null,
-    body_date			timestamp,
+    body_date			timestamptz,
     header_message_id	varchar(1000)
 						constraint acs_mail_bodies_h_m_id_un 
 						unique
@@ -199,6 +199,11 @@
 						references acs_objects on delete cascade
 );
 
+-- 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 table acs_mail_body_headers (
     body_id				integer
 						constraint acs_mail_body_heads_body_id_fk
@@ -237,8 +242,11 @@
         primary key (multipart_id, sequence_number)
 );
 
-  -- Mail Links
+--RI Index
+create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id);
 
+-- Mail Links
+
 create table acs_mail_links (
     mail_link_id integer
 				 constraint acs_mail_links_ml_id_pk 
@@ -252,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