Index: openacs-4/packages/new-portal/sql/oracle/objects-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/objects-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/new-portal/sql/oracle/objects-drop.sql	28 Sep 2001 01:01:53 -0000	1.1
@@ -0,0 +1,33 @@
+--
+-- The New Portal Package
+-- copyright 2001, OpenForce, Inc.
+-- distributed under the GNU GPL v2
+--
+-- Arjun Sanyal (arjun@openforce.net)
+-- $Id: objects-drop.sql,v 1.1 2001/09/28 01:01:53 oracle Exp $
+--
+
+-- XXX - FIX ME Do this the "right way"
+
+delete from acs_permissions where object_id in (
+	(select object_id from acs_objects where object_type in (
+	'portal', 'portal_element_theme','portal_layout', 'portal_datasource'
+	))
+);
+
+delete from acs_permissions where object_id in (
+	(select package_id from apm_packages where package_key = 'portal')
+);
+
+delete from acs_objects where object_type in (
+	'portal', 'portal_element_theme','portal_layout', 'portal_datasource'
+);
+
+begin
+	acs_object_type.drop_type('portal');
+	acs_object_type.drop_type('portal_element_theme');
+	acs_object_type.drop_type('portal_layout');
+	acs_object_type.drop_type('portal_datasource');
+end;
+/
+show errors