Index: openacs-4/packages/categories/sql/oracle/category-tree-package.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/oracle/category-tree-package.sql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/categories/sql/oracle/category-tree-package.sql 6 Feb 2005 18:42:19 -0000 1.7 +++ openacs-4/packages/categories/sql/oracle/category-tree-package.sql 16 Sep 2007 10:35:35 -0000 1.8 @@ -57,7 +57,8 @@ tree_id in category_trees.tree_id%TYPE, subtree_category_id in categories.category_id%TYPE default null, assign_single_p in category_tree_map.assign_single_p%TYPE default 'f', - require_category_p in category_tree_map.require_category_p%TYPE default 'f' + require_category_p in category_tree_map.require_category_p%TYPE default 'f', + require_category_p in category_tree_map.widget%TYPE ); PROCEDURE unmap ( @@ -266,7 +267,8 @@ tree_id in category_trees.tree_id%TYPE, subtree_category_id in categories.category_id%TYPE default null, assign_single_p in category_tree_map.assign_single_p%TYPE default 'f', - require_category_p in category_tree_map.require_category_p%TYPE default 'f' + require_category_p in category_tree_map.require_category_p%TYPE default 'f', + widget in category_tree_map.widget%TYPE ) is v_map_count integer; BEGIN @@ -278,9 +280,9 @@ if v_map_count = 0 then insert into category_tree_map - (tree_id, subtree_category_id, object_id, assign_single_p, require_category_p) + (tree_id, subtree_category_id, object_id, assign_single_p, require_category_p,widget) values (map.tree_id, map.subtree_category_id, map.object_id, - map.assign_single_p, map.require_category_p); + map.assign_single_p, map.require_category_p,map.widget); end if; END map;