--
-- 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 2002/03/29 17:02:45 ben 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'
);


select 	acs_object_type__drop_type('portal_page','f');
select acs_object_type__drop_type('portal','f');
select 	acs_object_type__drop_type('portal_element_theme','f');
select 	acs_object_type__drop_type('portal_layout','f');
select 	acs_object_type__drop_type('portal_datasource','f');