Index: openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql,v diff -u -r1.3 -r1.4 --- openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql 29 Jun 2001 20:50:17 -0000 1.3 +++ openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-drop.sql 9 Mar 2002 02:00:02 -0000 1.4 @@ -23,9 +23,10 @@ create function inline_0 () returns integer as ' - - raise NOTICE ''currently it is impossible to delete multiple threads within a transaction. please ensure you have removed all forums through the admin interface before you try to drop the package.'' - + begin + raise NOTICE ''currently it is impossible to delete multiple threads within a transaction. please ensure you have removed all forums through the admin interface before you try to drop the package.''; + return 0; + end; ' language 'plpgsql'; select inline_0 (); @@ -47,6 +48,9 @@ delete from bboard_forums; delete from acs_objects where object_type = 'bboard_forum'; +-- Delete mime types we created +delete from cr_mime_types where mime_type='text/plain; format=flowed'; + -- Drop all schema objects drop function bboard_forum__forum_p (integer); @@ -89,11 +93,13 @@ drop table bboard_categories; drop table bboard_forum_message_map; drop table bboard_forums; +drop table bboard_messages; -- Drop object type metadata begin; select acs_object_type__drop_type ('bboard_forum', 'f'); select acs_object_type__drop_type ('bboard_category', 'f'); + select acs_object_type__drop_type ('bboard_message', 'f'); end;