Index: openacs-4/packages/acs-mail/acs-mail.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/acs-mail.info,v
diff -u -r1.8.2.2 -r1.8.2.3
--- openacs-4/packages/acs-mail/acs-mail.info	17 Jan 2003 14:37:16 -0000	1.8.2.2
+++ openacs-4/packages/acs-mail/acs-mail.info	3 Feb 2003 16:07:43 -0000	1.8.2.3
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="4.6.1" url="http://www.arsdigita.com/acs-repository/download/apm/acs-mail-4.6.1.apm">
+    <version name="4.6.2" url="http://www.arsdigita.com/acs-repository/download/apm/acs-mail-4.6.2.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -19,7 +19,7 @@
         <vendor url="http://www.openacs.org/">OpenACS</vendor>
         <description format="text/html">Provides generic message services, with email sending.</description>
 
-        <provides url="acs-mail" version="4.6.1"/>
+        <provides url="acs-mail" version="4.6.2"/>
         <requires url="acs-content-repository" version="4.1"/>
         <requires url="acs-kernel" version="4.1"/>
 
@@ -35,6 +35,7 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/acs-mail-queue-create.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.5-4.6.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.6-4.6.1.sql"/>
+            <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.6.2-4.6.2.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/acs-mail-create.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/acs-mail-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/acs-mail-nt-create.sql"/>
@@ -43,6 +44,7 @@
             <file type="data_model" db_type="postgresql" path="sql/postgresql/acs-mail-queue-create.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.5-4.6.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql"/>
+            <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql"/>
             <file type="tcl_init" path="tcl/acs-mail-init.tcl"/>
             <file type="query_file" db_type="oracle" path="tcl/acs-mail-procs-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="tcl/acs-mail-procs-postgresql.xql"/>
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 -r1.2.4.1
--- openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql	13 Aug 2001 16:18:45 -0000	1.2
+++ openacs-4/packages/acs-mail/sql/oracle/acs-mail-create.sql	3 Feb 2003 16:08:00 -0000	1.2.4.1
@@ -196,6 +196,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
@@ -231,8 +236,10 @@
     constraint acs_mail_multipart_parts_pk
         primary key (multipart_id, sequence_number)
 );
+--RI Index
+create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id);
 
-  -- Mail Links
+-- Mail Links
 
 create table acs_mail_links (
     mail_link_id integer
Index: openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6-4.6.1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6-4.6.1.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6-4.6.1.sql	24 Jan 2003 03:46:48 -0000	1.1.2.2
+++ openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6-4.6.1.sql	3 Feb 2003 16:08:12 -0000	1.1.2.3
@@ -19,3 +19,4 @@
 insert into acs_mail_queue_outgoing select * from acs_mail_o_tmp;
 
 drop table acs_mail_o_tmp;
+
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-mail/sql/oracle/upgrade/upgrade-4.6.1-4.6.2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
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.3.4.1
--- 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	3 Feb 2003 16:08:29 -0000	1.3.4.1
@@ -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 
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);
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?