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 -r1.5 -r1.6
--- openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	16 Jan 2003 13:48:49 -0000	1.5
+++ openacs-4/packages/forums/sql/oracle/forums-messages-create.sql	17 May 2003 10:41:35 -0000	1.6
@@ -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 *
