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.5 -r1.5.12.1
--- openacs-4/packages/categories/sql/oracle/categories-create.sql	11 Feb 2004 13:25:27 -0000	1.5
+++ openacs-4/packages/categories/sql/oracle/categories-create.sql	23 Apr 2008 09:44:13 -0000	1.5.12.1
@@ -135,6 +135,7 @@
 	subtree_category_id	integer default null constraint cat_tree_map_subtree_id_fk references categories,
 	assign_single_p		char(1) default 'f' constraint cat_tree_map_single_p_ck check (assign_single_p in ('t','f')),
 	require_category_p	char(1) default 'f' constraint cat_tree_map_categ_p_ck check (require_category_p in ('t','f')),
+	widget                  varchar2(20),
 	primary key (object_id, tree_id)
 ) organization index;
 
@@ -162,6 +163,9 @@
 comment on column category_tree_map.require_category_p is '
   Do the users have to assign at least one category to objects?
 ';
+comment on column category_tree_map.widget is '
+  What widget do we want to use for this cateogry?
+';
 
 create table category_object_map (
        category_id		     integer constraint cat_object_map_category_id_fk references categories on delete cascade,
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.10 -r1.10.2.1
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql	16 Sep 2007 10:35:35 -0000	1.10
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql	23 Apr 2008 09:44:13 -0000	1.10.2.1
@@ -200,7 +200,11 @@
 comment on column category_tree_map.require_category_p is '
   Do the users have to assign at least one category to objects?
 ';
+comment on column category_tree_map.widget is '
+  What widget do we want to use for this cateogry?
+';
 
+
 create table category_object_map (
        category_id		integer
                                 constraint cat_object_map_category_id_fk