--
-- 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.7 2004/03/08 20:12:16 andrewg 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
        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-blogroll-drop.sql
@@ lars-blogger-categories-drop.sql
