Index: openacs-4/packages/dotlrn/dotlrn.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/dotlrn.info,v diff -u -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 @@ f f - + OpenACS A Course Management System 2015-10-04 DotLRN Consortium 2 Course Management - + - + 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 -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 -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; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql'. Fisheye: No comparison available. Pass `N' to diff?