Index: openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	8 Aug 2006 21:26:22 -0000	1.5
+++ openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	7 Aug 2017 23:48:09 -0000	1.6
@@ -66,10 +66,8 @@
     description                 varchar(4000),
     active_start_date           date,
     active_end_date             date,
-    archived_p                  char(1)
-                                default 'f'
-                                constraint dotlrn_c_archived_p_ck
-                                check (archived_p in ('t', 'f'))
+    archived_p                  boolean
+                                default false
                                 constraint dotlrn_c_archived_p_nn
                                 not null,
     portal_id                   integer 
@@ -104,7 +102,7 @@
 as
     select dotlrn_communities_all.*
     from dotlrn_communities_all
-    where dotlrn_communities_all.archived_p = 'f';
+    where dotlrn_communities_all.archived_p = false;