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.2 -r1.3
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql	11 Jan 2004 17:37:14 -0000	1.2
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql	1 Feb 2004 19:12:51 -0000	1.3
@@ -176,6 +176,12 @@
                                 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')),
 	primary key (object_id, tree_id)
 );
 
@@ -196,6 +202,13 @@
   If a subtree is mapped, then this is the ID of the category on top
   of the subtree, null otherwise.
 ';
+comment on column category_tree_map.assign_single_p is '
+  Are the users allowed to assign multiple or only a single category
+  to objects?
+';
+comment on column category_tree_map.require_category_p is '
+  Do the users have to assign at least one category to objects?
+';
 
 create table category_object_map (
        category_id		integer
