Index: dotlrn_packages/packages/forums/sql/postgresql/forums-forums-lams-create.sql =================================================================== diff -u --- dotlrn_packages/packages/forums/sql/postgresql/forums-forums-lams-create.sql (revision 0) +++ dotlrn_packages/packages/forums/sql/postgresql/forums-forums-lams-create.sql (revision 96b222fef4152577dcf61d05772abfb6b1a21101) @@ -0,0 +1,22 @@ + +-- +-- The Forums (LAMS integration) +-- +-- @author ErnieG@melcoe.mq.edu.au +-- @creation-date 2008-07-23 +-- +-- + +alter table forums_forums add column is_lams boolean; +alter table forums_forums alter column is_lams set default false; +update forums_forums set is_lams = false; + +drop view forums_forums_enabled; + +create view forums_forums_enabled +as + select * + from forums_forums + where enabled_p = 't' and + is_lams = 'f'; +