--
-- The Forums Package
--
-- @author gwong@orchardlabs.com,ben@openforce.biz
-- @creation-date 2002-05-16
--
-- This code is newly concocted by Ben, but with heavy concepts and heavy code
-- chunks lifted from Gilbert. Thanks Orchard Labs.
--

-- privileges
declare
begin

   delete from acs_permissions where privilege in ('forum_moderate','forum_post','forum_read','forum_create','forum_write','forum_delete');

   -- remove children
   acs_privilege.remove_child('read','forum_read');
   acs_privilege.remove_child('create','forum_create');
   acs_privilege.remove_child('write','forum_write');
   acs_privilege.remove_child('delete','forum_delete');
   acs_privilege.remove_child('admin','forum_moderate');
   acs_privilege.remove_child('forum_moderate','forum_read');
   acs_privilege.remove_child('forum_moderate','forum_post');
   acs_privilege.remove_child('forum_write','forum_read');
   acs_privilege.remove_child('forum_write','forum_post');
   
   acs_privilege.drop_privilege('forum_moderate');
   acs_privilege.drop_privilege('forum_post');
   acs_privilege.drop_privilege('forum_read');
   acs_privilege.drop_privilege('forum_create');
   acs_privilege.drop_privilege('forum_write');
   acs_privilege.drop_privilege('forum_delete');
end;
/
show errors


--
-- The Data Model
--

drop view forums_forums_enabled;

drop table forums_forums;

--
-- Object Type
--

declare
    v_object_id	    integer;
begin

   select MAX(object_id) into v_object_id from acs_objects where object_type='forums_forum';
   While (v_object_id > 0) loop
	delete from ncanotes where object_id=v_object_id;
   	acs_object.del(
		v_object_id -- object_id
  	);
	select MAX(object_id) into v_object_id from acs_objects where object_type='forums_forum';
   End loop;

   acs_object_type.drop_type (
	object_type => 'forums_forum'
   );

end;
/
show errors