Index: openacs-4/packages/forums/forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v
diff -u -r1.32 -r1.32.2.1
--- openacs-4/packages/forums/forums.info	8 Apr 2005 08:28:08 -0000	1.32
+++ openacs-4/packages/forums/forums.info	13 Dec 2005 22:24:49 -0000	1.32.2.1
@@ -7,14 +7,14 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="1.2.0d2" url="http://openacs.org/repository/download/apm/forums-1.2.0d2.apm">
+    <version name="1.2.0d3" url="http://openacs.org/repository/download/apm/forums-1.2.0d3.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>Online discussion forums.</summary>
         <release-date>2003-11-10</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/plain">This online discussion board software is the successor of the original bboard package. The biggest improvement is a scalable datamodel. Forums 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 reply via email.</description>
 
-        <provides url="forums" version="1.2.0d2"/>
+        <provides url="forums" version="1.2.0d3"/>
         <requires url="acs-kernel" version="5.2.0d2"/>
         <requires url="acs-subsite" version="5.1.4"/>
         <requires url="acs-mail-lite" version="0.1d"/>
Index: openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql,v
diff -u -r1.7.2.1 -r1.7.2.2
--- openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql	26 Sep 2005 09:03:14 -0000	1.7.2.1
+++ openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql	13 Dec 2005 22:24:50 -0000	1.7.2.2
@@ -67,6 +67,11 @@
     last_post                       timestamptz
 );
 
+CREATE INDEX forums_forums_pkg_enable_idx
+  ON forums_forums
+  USING btree
+  (package_id, enabled_p);
+
 create view forums_forums_enabled
 as
     select *
Index: openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql,v
diff -u -r1.3.8.1 -r1.3.8.2
--- openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql	26 Sep 2005 09:03:14 -0000	1.3.8.1
+++ openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql	13 Dec 2005 22:24:50 -0000	1.3.8.2
@@ -31,6 +31,7 @@
 select inline_0();
 drop function inline_0 ();
 
+DROP INDEX forums_forums_pkg_enable_idx;
 drop view forums_forums_enabled;
 drop table forums_forums;
 
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.2d2-1.2d3.sql'.
Fisheye: No comparison available.  Pass `N' to diff?