-- Classified Ads Package
--
-- @author Deds Castillo (deds@infiniteinfo.com)
-- @creation-date 2002-10-08
-- @cvs-id $Id: images-drop.sql,v 1.1 2003/07/16 04:52:31 rmello Exp $
--

-- DEDS: FIXME - drop objects
create function inline_0 ()
returns integer as '
begin
-- unregister child relations
    PERFORM content_type__unregister_child_type (
        ''ca_ad'',                  -- parent_type
        ''ca_image'',               -- child_type
        ''ad_images_rel''           -- relation_tag
    );

-- unregister the mime types
    PERFORM content_type__unregister_mime_type (
        ''ca_image'',                   -- content_type
	    ''image/gif''                   -- mime_type
    );

    PERFORM content_type__unregister_mime_type (
        ''ca_image'',                   -- content_type
	    ''image/jpeg''                  -- mime_type
    );

-- delete the content_type
    PERFORM content_type__drop_type (
        ''ca_image'',        -- object_type
        ''t'',               -- drop children?
        ''t''                -- drop table?
    );  

    return null;
end;' language 'plpgsql';

select inline_0();
drop function inline_0 ();