Index: openacs-4/packages/forums/forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v
diff -u -N -r1.13.2.5 -r1.13.2.6
--- openacs-4/packages/forums/forums.info	17 Dec 2002 10:48:16 -0000	1.13.2.5
+++ openacs-4/packages/forums/forums.info	31 Jan 2003 23:02:58 -0000	1.13.2.6
@@ -7,14 +7,14 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
 
-    <version name="0.3d" url="http://openacs.org/repository/download/apm/forums-0.3d.apm">
+    <version name="0.4d" url="http://openacs.org/repository/download/apm/forums-0.4d.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
     </database-support>
         <owner url="mailto:ben@openforce.net">Ben Adida</owner>
 
-        <provides url="forums" version="0.3d"/>
+        <provides url="forums" version="0.4d"/>
         <requires url="acs-mail-lite" version="0.1d"/>
         <requires url="notifications" version="0.1"/>
 
@@ -37,6 +37,7 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-tree-create.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade-0.1d-0.2d.sql"/>
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade-0.2d-0.3d.sql"/>
+            <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade-0.3d-0.4d.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/forums-create.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/forums-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-forums-create.sql"/>
@@ -53,6 +54,7 @@
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-tree-drop.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade-0.1d-0.2d.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade-0.2d-0.3d.sql"/>
+            <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade-0.3d-0.4d.sql"/>
             <file type="tcl_procs" path="tcl/forum-message-reply-procs.tcl"/>
             <file type="query_file" db_type="oracle" path="tcl/forum-reply-procs-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="tcl/forum-reply-procs-postgresql.xql"/>
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.3.2.2 -r1.3.2.3
--- openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	17 Dec 2002 10:48:26 -0000	1.3.2.2
+++ openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	31 Jan 2003 23:03:18 -0000	1.3.2.3
@@ -58,6 +58,9 @@
 -- We do a some big queries on forum_id (thread count on index.tcl) so create a second index 
 -- 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 view forums_messages_approved as
     select *
Index: openacs-4/packages/forums/sql/oracle/upgrade-0.3d-0.4d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/Attic/upgrade-0.3d-0.4d.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/sql/oracle/upgrade-0.3d-0.4d.sql	31 Jan 2003 23:03:18 -0000	1.1.2.1
@@ -0,0 +1,3 @@
+-- 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);
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.5.2.2 -r1.5.2.3
--- openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	17 Dec 2002 10:48:35 -0000	1.5.2.2
+++ openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql	31 Jan 2003 23:03:38 -0000	1.5.2.3
@@ -58,7 +58,11 @@
 -- We do a some big queries on forum_id (thread count on index.tcl) so create a second index 
 -- 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 view forums_messages_approved
 as
     select *
Index: openacs-4/packages/forums/sql/postgresql/upgrade-0.3d-0.4d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/Attic/upgrade-0.3d-0.4d.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/sql/postgresql/upgrade-0.3d-0.4d.sql	31 Jan 2003 23:03:38 -0000	1.1.2.1
@@ -0,0 +1,3 @@
+-- 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);