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 -N -r1.5 -r1.6 --- 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 22 Apr 2008 16:04:37 -0000 1.6 @@ -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 -N -r1.10 -r1.11 --- 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 22 Apr 2008 16:04:38 -0000 1.11 @@ -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