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.11 -r1.12
--- openacs-4/packages/categories/sql/postgresql/categories-create.sql	22 Apr 2008 16:04:38 -0000	1.11
+++ openacs-4/packages/categories/sql/postgresql/categories-create.sql	7 Aug 2017 23:48:05 -0000	1.12
@@ -36,9 +36,7 @@
        tree_id			integer primary key 
                                 constraint cat_trees_tree_id_fk 
                                 references acs_objects on delete cascade,
-       site_wide_p		char(1) default 't' 
-                                constraint cat_trees_site_wide_p_ck
-                                check (site_wide_p in ('t','f'))
+       site_wide_p		boolean default true
 );
 
 comment on table category_trees is '
@@ -91,9 +89,7 @@
                                 on delete cascade,
        parent_id		integer constraint cat_parent_id_fk 
                                 references categories,
-       deprecated_p		char(1) default 'f' 
-                                constraint cat_deprecated_p_ck 
-                                check (deprecated_p in ('t','f')),
+       deprecated_p		boolean default false,
        left_ind			integer,
        right_ind		integer
 );
@@ -166,12 +162,8 @@
                                 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')),
+	assign_single_p		boolean default false,
+	require_category_p	boolean default false,
         widget                  varchar(20),
 	primary key (object_id, tree_id)
 );
@@ -300,9 +292,7 @@
 			constraint category_synonyms_locale_fk
 			references ad_locales on delete cascade,
 	name		varchar(100) not null,
-	synonym_p	char(1) default 't'
-			constraint category_synonyms_synonym_p_ck
-			check (synonym_p in ('t','f'))
+	synonym_p	boolean default true
 );
 
 -- to get all synonyms in given locale
@@ -319,7 +309,7 @@
   Primary key.
 ';
 comment on column category_synonyms.category_id is '
-  Category the synonyms are refering to.
+  Category the synonyms are referring to.
 ';
 comment on column category_synonyms.locale is '
   Language of the synonym.
@@ -350,7 +340,7 @@
   to be used in search.
 ';
 comment on column category_synonym_index.synonym_id is '
-  Id of the synonym refered to.
+  Id of the synonym referred to.
 ';
 comment on column category_synonym_index.trigram is '
   3 character part of the synonym.
@@ -411,7 +401,7 @@
   to be used in search.
 ';
 comment on column category_search_index.query_id is '
-  Id of the search text refered to.
+  Id of the search text referred to.
 ';
 comment on column category_search_index.trigram is '
   3 character part of the search text.