--  packages/static-pages/sql/static-pages-sws-drop.sql
--
--  /**
--   *  Remove site-wide-search interface for static-pages.
--   *  
--   *  Copyright (C) 2001 ArsDigita Corporation
--   *  Author:  Brandoch Calef (bcalef@arsdigita.com)
--   *  Creation: 2001-02-02
--   *
--   *  $Id: static-pages-sws-drop.sql,v 1.1.1.1 2001/04/20 20:51:22 donb Exp $
--   *  
--   *  This is free software distributed under the terms of the GNU Public
--   *  License.  Full text of the license is available from the GNU Project:
--   *  http://www.fsf.org/copyleft/gpl.html
--   **/


begin
    pot_service.delete_obj_type_attr_value (
	package_key		=> 'static-pages',
	object_type		=> 'content_revision',
	attribute		=> 'cr_revision_in_package_id'
    );    

    pot_service.delete_obj_type_attr_value (
	package_key		=> 'static-pages',
	object_type		=> 'content_revision',
	attribute		=> 'display_page'
    );    

    pot_service.unregister_object_type (
	package_key		=> 'static-pages',
	object_type		=> 'content_revision'
    );

    sws_service.update_content_obj_type_info ('content_revision');
end;
/

drop function sp_cr_revision_in_package_id;