Index: openacs-4/packages/forums/forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v
diff -u -N -r1.17 -r1.18
--- openacs-4/packages/forums/forums.info	17 May 2003 10:40:57 -0000	1.17
+++ openacs-4/packages/forums/forums.info	30 Sep 2003 05:19:19 -0000	1.18
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
 
-    <version name="0.4" url="http://openacs.org/repository/download/apm/forums-0.4.apm">
+    <version name="1.0d1" url="http://openacs.org/repository/download/apm/forums-1.0d1.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -16,9 +16,9 @@
         <summary>Online discussion boards with many configuration options.</summary>
         <description format="text/plain">This online discussion board software is the successor of the original bboard package. The biggest improvement is the new scalable datamodel. This package supports threaded and flat view, moderation, a stand alone search function as well as integration with the OpenACS search package and integration with the notifications package for email alerts. It also supports automatic posting of incoming email.</description>
 
-        <provides url="forums" version="0.4"/>
+        <provides url="forums" version="1.0d1"/>
         <requires url="acs-mail-lite" version="0.1d"/>
-        <requires url="notifications" version="0.1"/>
+        <requires url="notifications" version="4.6.2"/>
 
         <parameters>
             <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="table_border_color"  default="#dddddd" description="The color of the table borders and between the cells, try #ffffff for a cool look"/>
Index: openacs-4/packages/forums/sql/oracle/forums-messages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-messages-create.sql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	17 May 2003 10:41:35 -0000	1.6
+++ openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	30 Sep 2003 05:19:19 -0000	1.7
@@ -59,9 +59,11 @@
 -- ordered so it's useful for them
 create unique index forums_mess_forum_sk_un on forums_messages(forum_id, tree_sortkey);
 -- Need these for RI checks 
-create index forums_messages_user_id_idx ON forums_messages(user_id);
-create index forums_messages_parent_id_idx ON forums_messages(parent_id);
+create index forums_messages_user_id_idx on forums_messages(user_id);
+create index forums_messages_parent_id_idx on forums_messages(parent_id);
+create index forum_messages_date_idx on forums_messages (forum_id, posting_date) compress 1;
 
+
 create view forums_messages_approved as
     select *
     from forums_messages
Index: openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	17 May 2003 10:42:08 -0000	1.8
+++ openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	30 Sep 2003 05:19:19 -0000	1.9
@@ -59,10 +59,10 @@
 -- ordered so it's useful for them
 create unique index forums_mess_forum_sk_un on forums_messages(forum_id, tree_sortkey);
 -- Need these two for RI checks 
-create index forums_messages_user_id_idx ON forums_messages(user_id);
-create index forums_messages_parent_id_idx ON forums_messages(parent_id);
+create index forums_messages_user_id_idx on forums_messages(user_id);
+create index forums_messages_parent_id_idx on forums_messages(parent_id);
+create index forum_messages_date_idx on forums_messages (forum_id, posting_date);
 
-
 create view forums_messages_approved
 as
     select *