Index: openacs-4/packages/forums/sql/postgresql/forums-messages-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-drop.sql,v diff -u -r1.1 -r1.1.1.1 --- openacs-4/packages/forums/sql/postgresql/forums-messages-drop.sql 1 Jun 2002 19:02:29 -0000 1.1 +++ openacs-4/packages/forums/sql/postgresql/forums-messages-drop.sql 28 Jun 2006 20:30:28 -0000 1.1.1.1 @@ -1,4 +1,3 @@ - -- -- The Forums Package -- @@ -9,22 +8,19 @@ -- lifted from Gilbert. Thanks Orchard Labs! -- --- privileges --- NO PRIVILEGES FOR MESSAGES --- we don't individually permission messages - --- --- The Data Model --- - +drop view forums_messages_pending; +drop view forums_messages_approved; drop table forums_messages; --- --- Object Type --- - +create function inline_0 () +returns integer as ' begin - select acs_object_type__drop_type ( - 'forums_message', 'f' - ); -end; + perform acs_object_type__drop_type ( + ''forums_message'', ''f'' + ); + + return null; +end;' language 'plpgsql'; + +select inline_0(); +drop function inline_0 ();