Index: openacs-4/packages/categories/categories.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/categories.info,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/categories/categories.info	11 Dec 2003 21:40:00 -0000	1.2
+++ openacs-4/packages/categories/categories.info	11 Jan 2004 17:37:13 -0000	1.3
@@ -8,13 +8,13 @@
     <singleton-p>f</singleton-p>
     <auto-mount>categories</auto-mount>
 
-    <version name="0.1d" url="http://openacs.org/repository/apm/packages/categories">
+    <version name="1.0d1" url="http://openacs.org/repository/apm/packages/categories-1.0d1">
         <owner>thentschel@sussdorff-roy.com</owner>
         <summary>Manage categories in category trees and let users map objects to categories.</summary>
         <release-date>2003-04-16</release-date>
         <description format="text/html">Datamodel for category trees with supporting API and management pages.  Provides a widget for 
         general categorization of arbitrary objects and tracks which package instances use which category trees.  Also supports localization.</description>
-        <provides url="categories" version="0.1d"/>
+        <provides url="categories" version="1.0d1"/>
 
         <callbacks>
             <callback type="after-install"  proc="category::after_install"/>
Index: openacs-4/packages/categories/sql/oracle/categories-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/oracle/categories-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/categories/sql/oracle/categories-create.sql	23 Apr 2003 12:29:27 -0000	1.1
+++ openacs-4/packages/categories/sql/oracle/categories-create.sql	11 Jan 2004 17:37:14 -0000	1.2
@@ -181,6 +181,14 @@
   in queries
 ';
 
+create or replace view category_object_map_tree as
+  select c.category_id,
+         c.tree_id,
+         m.object_id
+  from   category_object_map m,
+         categories c
+  where  c.category_id = m.category_id;
+
 @@category-tree-package.sql
 @@category-package.sql
 
Index: openacs-4/packages/categories/sql/oracle/upgrade/upgrade-0.1d-1.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/oracle/upgrade/upgrade-0.1d-1.0d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/categories/sql/oracle/upgrade/upgrade-0.1d-1.0d1.sql	11 Jan 2004 17:37:14 -0000	1.1
@@ -0,0 +1,12 @@
+--
+-- Adding view useful when getting categories for a specific tree
+--
+
+create or replace view category_object_map_tree as
+  select c.category_id,
+         c.tree_id,
+         m.object_id
+  from   category_object_map m,
+         categories c
+  where  c.category_id = m.category_id;
+
Index: openacs-4/packages/categories/sql/postgresql/categories-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/categories-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql	19 May 2003 13:09:56 -0000	1.1
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql	11 Jan 2004 17:37:14 -0000	1.2
@@ -232,6 +232,14 @@
   in queries
 ';
 
+create or replace view category_object_map_tree as
+  select c.category_id,
+         c.tree_id,
+         m.object_id
+  from   category_object_map m,
+         categories c
+  where  c.category_id = m.category_id;
+
 \i category-tree-package.sql
 \i category-package.sql
 
Index: openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-0.1d-1.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-0.1d-1.0d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-0.1d-1.0d1.sql	11 Jan 2004 17:37:14 -0000	1.1
@@ -0,0 +1,12 @@
+--
+-- Adding view useful when getting categories for a specific tree
+--
+
+create or replace view category_object_map_tree as
+  select c.category_id,
+         c.tree_id,
+         m.object_id
+  from   category_object_map m,
+         categories c
+  where  c.category_id = m.category_id;
+