Index: openacs-4/packages/categories/sql/postgresql/category-tree-package.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-tree-package.sql,v diff -u -r1.9 -r1.10 --- openacs-4/packages/categories/sql/postgresql/category-tree-package.sql 31 Jul 2006 20:31:11 -0000 1.9 +++ openacs-4/packages/categories/sql/postgresql/category-tree-package.sql 16 Sep 2007 10:35:35 -0000 1.10 @@ -243,7 +243,8 @@ integer, -- tree_id integer, -- subtree_category_id char, -- assign_single_p - char -- require_category_p + char, -- require_category_p + varchar -- widget ) returns integer as ' declare @@ -252,6 +253,7 @@ p_subtree_category_id alias for $3; p_assign_single_p alias for $4; p_require_category_p alias for $5; + p_widget alias for $6; v_map_count integer; begin @@ -264,9 +266,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) + assign_single_p, require_category_p, widget) values (p_tree_id, p_subtree_category_id, p_object_id, - p_assign_single_p, p_require_category_p); + p_assign_single_p, p_require_category_p, p_widget); end if; return 0; end;