Index: openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql	1 Apr 2004 20:03:52 -0000	1.3
+++ openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql	27 Apr 2004 12:11:02 -0000	1.4
@@ -55,3 +55,41 @@
 create trigger forums_message_search__utrg after update on forums_messages
 for each row execute procedure forums_message_search__utrg (); 
 
+
+
+-- forums_forums indexing trigger
+create or replace function forums_forums_search__itrg ()
+returns opaque as '
+begin
+    perform search_observer__enqueue(new.forum_id,''INSERT'');
+
+    return new;
+end;' language 'plpgsql';
+
+create or replace function forums_forums_search__utrg ()
+returns opaque as '
+begin
+    perform search_observer__enqueue(new.forum_id,''UPDATE'');
+
+    return new;
+end;' language 'plpgsql';
+
+create or replace function forums_forums_search__dtrg ()
+returns opaque as '
+begin
+    perform search_observer__enqueue(old.forum_id,''DELETE'');
+
+    return old;
+end;' language 'plpgsql';
+
+
+
+create trigger forums_forums_search__itrg after insert on forums_forums
+for each row execute procedure forums_forums_search__itrg (); 
+
+create trigger forums_forums_search__utrg after update on forums_forumss
+for each row execute procedure forums_forums_search__utrg (); 
+
+create trigger forums_forums_search__dtrg after delete on forums_forums
+for each row execute procedure forums_forums_search__dtrg (); 
+
Index: openacs-4/packages/forums/tcl/forums-sc-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/forums-sc-procs.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/forums/tcl/forums-sc-procs.tcl	2 Apr 2004 00:59:24 -0000	1.6
+++ openacs-4/packages/forums/tcl/forums-sc-procs.tcl	27 Apr 2004 12:11:02 -0000	1.7
@@ -107,7 +107,8 @@
           name as title,
           charter as content,
           'text/plain' as mime,
-          'text' as storage_type
+          'text' as storage_type,
+          '' as keywords
         from forums_forums
         where forum_id = :forum_id
     } -column_array datasource]} {