Rafael, you should be able to do this to
fix the autosubscribe_p error:
alter table forums_forums add autosubscribe_p char(1)
constraint forums_autosubscribe_p_ck
check (autosubscribe_p in ('t','f'));
update forums_forums set autosubscribe_p = 'f'
where autosubscribe_p is null;
alter table forums_forums alter column autosubscribe_p SET DEFAULT 'f';
(I added this to dotlrn-forums-create.sql as well).
I will check one the other error as well...