-- 
-- packages/forums/sql/postgresql/upgrade/upgrade-1.2.0d3-1.2.0d4.sql
-- 
-- @author Deds Castillo (deds@i-manila.com.ph)
-- @creation-date 2006-05-10
-- @cvs-id $Id: upgrade-1.2.0d3-1.2.0d4.sql,v 1.3 2018/08/15 16:53:10 gustafn Exp $
--

-- increase charter to 4000 chars

alter table forums_forums add charter_temp varchar(4000);
update forums_forums set charter_temp = charter;
drop view forums_forums_enabled;
alter table forums_forums drop charter;
alter table forums_forums rename charter_temp to charter;

create view forums_forums_enabled
as
    select *
    from forums_forums
    where enabled_p = 't';