Index: openacs-4/packages/dotlrn/dotlrn.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/dotlrn.info,v
diff -u -N -r1.141.2.4 -r1.141.2.5
--- openacs-4/packages/dotlrn/dotlrn.info	1 Dec 2015 13:38:53 -0000	1.141.2.4
+++ openacs-4/packages/dotlrn/dotlrn.info	15 May 2016 18:34:04 -0000	1.141.2.5
@@ -7,18 +7,18 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="2.9.0" url="http://openacs.org/repository/download/apm/dotlrn-2.9.0.apm">
+    <version name="2.9.1d1" url="http://openacs.org/repository/download/apm/dotlrn-2.9.1d1.apm">
         <owner url="http://openacs.org">OpenACS</owner>
         <summary>A Course Management System</summary>
         <release-date>2015-10-04</release-date>
         <vendor url="http://dotlrn.org">DotLRN Consortium</vendor>
 	<maturity>2</maturity>
         <description format="text/html">Course Management</description>
 
-        <provides url="dotlrn" version="2.9.0"/>
+        <provides url="dotlrn" version="2.9.1d1"/>
         <requires url="acs-kernel" version="5.9.0"/>
         <requires url="acs-subsite" version="5.9.0"/>
-        <requires url="acs-admin" version="5.9.0"/>
+	<requires url="acs-admin" version="5.9.1d2"/>
         <requires url="acs-mail-lite" version="5.9.0"/>
         <requires url="acs-lang" version="5.9.0"/>
         <requires url="attachments" version="0.10"/>
Index: openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql,v
diff -u -N -r1.4 -r1.4.10.1
--- openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql	8 Aug 2006 21:26:22 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/postgresql/applets-create.sql	15 May 2016 18:34:04 -0000	1.4.10.1
@@ -36,10 +36,8 @@
     package_key                     varchar(100)
                                     constraint dotlrn_applets_package_key_fk
                                     references apm_package_types (package_key),
-    active_p                        char(1)
-                                    default 't'
-                                    constraint dotlrn_applets_active_p_ck
-                                    check (active_p in ('t', 'f'))
+    active_p                        boolean
+                                    default true
                                     constraint dotlrn_applets_active_p_nn
                                     not null
 );
@@ -57,10 +55,8 @@
                                     not null,
     -- this is the package_id of the package this applet represents
     package_id                      integer,
-    active_p                        char(1)
-                                    default 't'
-                                    constraint dotlrn_ca_active_p_ck
-                                    check (active_p in ('t', 'f'))
+    active_p                        boolean
+                                    default true
                                     constraint dotlrn_ca_active_p_nn
                                     not null,
     constraint dotlrn_community_applets_pk
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 -N -r1.5 -r1.5.10.1
--- 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	15 May 2016 18:34:04 -0000	1.5.10.1
@@ -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;
 
 
 
Index: openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql	15 May 2016 18:34:05 -0000	1.1.2.1
@@ -0,0 +1,134 @@
+--
+-- Alter caveman style booleans (type character(1)) to real SQL boolean types.
+--
+-- Unforunately, all attributes of the three tables affected are used
+-- (blindly) in a bunch of views, which are as well used in other
+-- views. So we have to drop and recreate many dotlrn views.  If your
+-- installation have modifications to these views, make sure to
+-- recreate these later correctly.
+--
+
+drop view dotlrn_communities_full;
+drop view dotlrn_clubs_full;
+drop view dotlrn_class_instances_current;
+drop view dotlrn_class_instances_not_old;
+drop view dotlrn_class_instances_full;
+drop view dotlrn_communities_not_closed;
+drop view dotlrn_active_comms_not_closed;
+drop view dotlrn_active_communities;
+drop view dotlrn_communities;
+
+ALTER TABLE dotlrn_applets
+      DROP constraint IF EXISTS dotlrn_applets_active_p_ck,
+      ALTER COLUMN active_p DROP DEFAULT,
+      ALTER COLUMN active_p TYPE boolean
+      USING active_p::boolean,
+      ALTER COLUMN active_p SET DEFAULT true;
+
+ALTER TABLE dotlrn_community_applets
+      DROP constraint IF EXISTS dotlrn_ca_active_p_ck,
+      ALTER COLUMN active_p DROP DEFAULT,
+      ALTER COLUMN active_p TYPE boolean
+      USING active_p::boolean,
+      ALTER COLUMN active_p SET DEFAULT true;
+
+ALTER TABLE dotlrn_communities_all
+      DROP constraint IF EXISTS dotlrn_c_archived_p_ck,
+      ALTER COLUMN archived_p DROP DEFAULT,
+      ALTER COLUMN archived_p TYPE boolean
+      USING archived_p::boolean,
+      ALTER COLUMN archived_p SET DEFAULT false;
+
+create view dotlrn_communities
+as
+    select dotlrn_communities_all.*
+    from dotlrn_communities_all
+    where dotlrn_communities_all.archived_p = false;
+
+create view dotlrn_communities_not_closed
+as
+    select dotlrn_communities.*,
+           groups.join_policy
+    from dotlrn_communities,
+         groups
+    where dotlrn_communities.community_id = groups.group_id
+    and groups.join_policy <> 'closed';
+    
+create view dotlrn_active_communities
+as
+    select *
+    from dotlrn_communities
+    where (active_start_date is null or active_start_date < now())
+    and (active_end_date is null or active_end_date > now());
+
+create view dotlrn_active_comms_not_closed
+as
+    select dotlrn_communities.*,
+           groups.join_policy
+    from dotlrn_active_communities dotlrn_communities,
+         groups
+    where dotlrn_communities.community_id = groups.group_id
+    and groups.join_policy <> 'closed';
+
+create view dotlrn_communities_full
+as
+    select dotlrn_communities.*,
+           dotlrn_community__url(dotlrn_communities.community_id) as url,
+           groups.group_name,
+           groups.join_policy
+    from dotlrn_communities,
+         groups
+    where dotlrn_communities.community_id = groups.group_id;
+
+create view dotlrn_class_instances_full
+as
+    select dotlrn_class_instances.class_instance_id,
+           dotlrn_class_instances.class_key,
+           dotlrn_class_instances.term_id,
+           dotlrn_terms.term_name,
+           dotlrn_terms.term_year,
+           dotlrn_terms.start_date,
+           dotlrn_terms.end_date,
+           dotlrn_communities.*,
+           dotlrn_community__url(dotlrn_communities.community_id) as url,
+           dotlrn_classes_full.pretty_name as class_name,
+           dotlrn_classes_full.url as class_url,
+           dotlrn_classes_full.department_key,
+           dotlrn_departments_full.pretty_name as department_name,
+           dotlrn_departments_full.url as department_url,
+           groups.join_policy
+    from dotlrn_communities,
+         dotlrn_class_instances,
+         dotlrn_terms,
+         dotlrn_classes_full,
+         dotlrn_departments_full,
+         groups
+    where dotlrn_communities.community_id = dotlrn_class_instances.class_instance_id
+    and dotlrn_class_instances.term_id = dotlrn_terms.term_id
+    and dotlrn_communities.community_type = dotlrn_classes_full.class_key
+    and dotlrn_classes_full.department_key = dotlrn_departments_full.department_key
+    and dotlrn_communities.community_id = groups.group_id;
+
+create view dotlrn_class_instances_current
+as
+    select *
+    from dotlrn_class_instances_full
+    where now() between active_start_date and active_end_date;
+
+create view dotlrn_class_instances_not_old
+as
+    select *
+    from dotlrn_class_instances_full
+    where active_end_date >= now();
+
+create view dotlrn_clubs_full
+as
+    select dotlrn_clubs.club_id,
+	   dotlrn_communities.*,
+           dotlrn_community__url(dotlrn_communities.community_id::integer) as url,
+           groups.join_policy
+    from dotlrn_communities,
+         dotlrn_clubs,
+         groups
+    where dotlrn_communities.community_id = dotlrn_clubs.club_id
+    and dotlrn_communities.community_id = groups.group_id;