Index: openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql 8 Mar 2004 16:50:31 -0000 1.1 +++ openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-blogroll-drop.sql 8 Mar 2004 20:12:16 -0000 1.2 @@ -1,11 +1,24 @@ -- --- lars-blogger-categories-drop.sql +-- lars-blogger-blogroll-drop.sql -- -- @author Guan Yang (guan@unicast.org) +-- @author Andrew Grumet (aegrumet@alum.mit.edu) -- -drop function weblogger_blogroll_entry__delete(integer); -drop function weblogger_blogroll_entry__new(integer, integer, varchar, varchar, integer, varchar); -drop function weblogger_blogroll_entry__name(integer); +begin + + for blogroll_entry in (select link_id from weblogger_blogroll_entries) + loop + weblogger_blogroll_entry.del(blogroll_entry.link_id); + end loop; + + acs_object_type.drop_type('weblogger_blogroll_entry', 't'); + +end; +/ +show errors + drop table weblogger_blogroll_entries; -select acs_object_type__drop_type('weblogger_blogroll_entry', true); \ No newline at end of file +drop package body weblogger_blogroll_entry; +drop package weblogger_blogroll_entry; + Index: openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-drop.sql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-drop.sql 8 Dec 2003 05:15:04 -0000 1.6 +++ openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-drop.sql 8 Mar 2004 20:12:16 -0000 1.7 @@ -36,4 +36,5 @@ drop table pinds_blog_entries; +@@ lars-blogger-blogroll-drop.sql @@ lars-blogger-categories-drop.sql