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.2 -r1.1.2.3 --- 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 +++ openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql 26 Feb 2003 09:29:37 -0000 1.1.2.3 @@ -19,9 +19,3 @@ 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); 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.3 -r1.1.2.4 --- openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql 26 Feb 2003 09:05:21 -0000 1.1.2.3 +++ openacs-4/packages/acs-mail/sql/postgresql/upgrade/upgrade-4.6.1-4.6.2.sql 26 Feb 2003 09:29:37 -0000 1.1.2.4 @@ -1,3 +1,8 @@ -- RI Indexes create index acs_mail_links_body_id_idx ON acs_mail_links(body_id); +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); +