Index: openacs-4/contrib/obsolete-packages/bboard-portlets/bboard-portlets.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard-portlets/bboard-portlets.info,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/obsolete-packages/bboard-portlets/bboard-portlets.info	29 Jul 2001 23:16:50 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/bboard-portlets/bboard-portlets.info	10 Oct 2001 06:57:56 -0000	1.3
@@ -1,5 +1,5 @@
 <?xml version="1.0"?>
-<!-- Generated by the ACS Package Manager -->
+<!-- Generated by the OpenACS Package Manager -->
 
 <package key="bboard-portlets" url="http://www.arsdigita.com/acs-repository/apm/packages/bboard-portlets" type="apm_service">
     <package-name>Bboard portlets</package-name>
@@ -21,8 +21,6 @@
 
         <files>
             <file type="package_spec" path="bboard-portlets.info"/>
-            <file type="data_model_create" path="sql/bboard-portlets-create.sql"/>
-            <file type="data_model_drop" path="sql/bboard-portlets-drop.sql"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/bboard-portlets-create.sql"/>
             <file type="data_model_drop" db_type="oracle" path="sql/oracle/bboard-portlets-drop.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/bboard-portlets-create.sql"/>
Index: openacs-4/contrib/obsolete-packages/bboard-portlets/www/summarize-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard-portlets/www/summarize-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/bboard-portlets/www/summarize-postgresql.xql	28 Jul 2001 23:58:07 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/bboard-portlets/www/summarize-postgresql.xql	10 Oct 2001 06:57:56 -0000	1.2
@@ -11,12 +11,11 @@
            site_node__url(sn.node_id) as url,
            acs_object__name(sn.object_id) as bboard_name
       from bboard_forums b left join site_nodes sn on (sn.object_id = b.bboard_id), 
-           site_nodes sn, 
            apm_packages apm
      where sn.parent_id = :node_id
        and sn.object_id = apm.package_id
        and apm.package_key = 'bboard'
-     order by lower(bboard_name)
+     order by 4
 
       </querytext>
 </fullquery>