Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	9 Dec 2001 04:21:58 -0000	1.7
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	9 Dec 2001 21:08:31 -0000	1.8
@@ -67,6 +67,7 @@
 create index acs_messages_tree_skey_idx on acs_messages (tree_sortkey);
 create index acs_messages_reply_to_idx on acs_messages (reply_to);
 create index acs_messages_sender_idx on acs_messages (sender);
+create index acs_messages_sent_idx on acs_messages (sent_date);
 
 comment on table acs_messages is '
     A generic message which may be attached to any object in the system.