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,