Index: openacs-4/packages/forums/forums.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v diff -u -r1.45.2.4 -r1.45.2.5 --- openacs-4/packages/forums/forums.info 1 Dec 2015 13:38:55 -0000 1.45.2.4 +++ openacs-4/packages/forums/forums.info 14 May 2016 17:33:02 -0000 1.45.2.5 @@ -9,17 +9,17 @@ f t - + OpenACS Online discussion forums. - 2015-10-04 + 2016-05-14 OpenACS This online discussion board software is the successor of the original bboard package. The biggest improvement is a scalable datamodel. Forums supports threaded and flat view, moderation, a stand alone search function as well as integration with the OpenACS search package and integration with the notifications package for email alerts. It also supports reply via email. GPL version 2 2 #forums.Forums# - + Index: openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql,v diff -u -r1.10 -r1.10.2.1 --- openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql 25 Aug 2013 10:04:21 -0000 1.10 +++ openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql 14 May 2016 17:33:02 -0000 1.10.2.1 @@ -52,12 +52,10 @@ constraint forums_posting_policy_ck check (posting_policy in ('open','moderated','closed')), max_child_sortkey varbit, - enabled_p char(1) - default 't' + enabled_p boolean + default true constraint forums_enabled_p_nn - not null - constraint forums_enabled_p_ck - check (enabled_p in ('t','f')), + not null, package_id integer constraint forums_package_id_nn not null, @@ -76,7 +74,7 @@ as select * from forums_forums - where enabled_p = 't'; + where enabled_p = true; -- procedure inline_0/0 Index: openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql,v diff -u -r1.14 -r1.14.4.1 --- openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql 12 Aug 2013 09:34:30 -0000 1.14 +++ openacs-4/packages/forums/sql/postgresql/forums-messages-create.sql 14 May 2016 17:33:02 -0000 1.14.4.1 @@ -37,12 +37,10 @@ parent_id integer constraint forum_mess_parent_id_fk references forums_messages (message_id), - open_p char(1) - default 't' + open_p boolean + default true constraint forum_mess_open_p_nn - not null - constraint forum_mess_open_p_ck - check (open_p in ('t','f')), + not null, tree_sortkey varbit, max_child_sortkey varbit, last_child_post timestamptz, Index: openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql,v diff -u -r1.19 -r1.19.4.1 --- openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql 12 Aug 2013 09:34:30 -0000 1.19 +++ openacs-4/packages/forums/sql/postgresql/forums-messages-package-create.sql 14 May 2016 17:33:02 -0000 1.19.4.1 @@ -170,12 +170,12 @@ where message_id = p_message_id; update forums_messages - set open_p = 't' + set open_p = true where tree_sortkey between tree_left(v_sortkey) and tree_right(v_sortkey) and forum_id = v_forum_id; update forums_messages - set open_p = 't' + set open_p = true where message_id = p_message_id; return 0; @@ -203,12 +203,12 @@ where message_id = p_message_id; update forums_messages - set open_p = 'f' + set open_p = false where tree_sortkey between tree_left(v_sortkey) and tree_right(v_sortkey) and forum_id = v_forum_id; update forums_messages - set open_p = 'f' + set open_p = false where message_id = p_message_id; return 0; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.3d12-1.3d13.sql'. Fisheye: No comparison available. Pass `N' to diff?