--
-- lars-blogger-drop.sql
-- 
-- @author Lars Pind
-- @author Yon (Yon@milliped.com) Oracle Port
-- @author Vinod Kurup (vinod@kurup.com)
-- 
-- @cvs-id $Id: lars-blogger-drop.sql,v 1.5 2003/10/17 00:39:22 lars Exp $
--

@@ notifications-drop
@@ rss-unregister

begin
    acs_object_type.drop_type('weblogger_channel', 't');
end;
/
show errors

drop table weblogger_channels;

begin

    for blog_entry in (select entry_id from pinds_blog_entries) loop
		-- delete comments (which are acs_message's)
		for comment in (select comment_id from general_comments 
							   where object_id = blog_entry.entry_id) loop
			acs_message.del(comment.comment_id);
		end loop;

        pinds_blog_entry.del(blog_entry.entry_id);
    end loop;

    acs_object_type.drop_type('pinds_blog_entry', 't');

end;
/
show errors


@@ lars-blogger-package-drop

drop table pinds_blog_entries;

@@ lars-blogger-categories-drop.sql