Index: openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.3d12-1.3d13.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.3d12-1.3d13.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.3d12-1.3d13.sql 14 May 2016 17:33:02 -0000 1.1.2.1 @@ -0,0 +1,18 @@ +-- +-- Alter caveman style booleans (type character(1)) to real SQL boolean types. +-- + +ALTER TABLE forums_forums + DROP constraint forums_enabled_p_ck, + ALTER COLUMN enabled_p DROP DEFAULT, + ALTER COLUMN enabled_p TYPE boolean + USING enabled_p::boolean, + ALTER COLUMN enabled_p SET DEFAULT true; + +ALTER TABLE forums_messages + DROP constraint forum_mess_open_p_ck, + ALTER COLUMN enabled_p DROP DEFAULT, + ALTER COLUMN enabled_p TYPE boolean + USING enabled_p::boolean, + ALTER COLUMN enabled_p SET DEFAULT true; +