-- drop the content-image type from the data model

-- Copyright (C) 20000 ArsDigita Corporation

-- $Id: content-image-drop.sql,v 1.4 2003/05/17 09:43:09 jeffd 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

-- unregister mime types from the image type

drop function image__delete (integer);

drop function image__new (varchar,integer,integer,integer,varchar,integer,varchar,integer,varchar,varchar,boolean,timestamptz,varchar,integer,integer,integer);

drop function image__new_revision(integer, integer, varchar, varchar, timestamptz, varchar, varchar,
                                    integer, varchar, integer, integer);

drop function image__new (varchar,integer,integer,integer,varchar,varchar,varchar,varchar,varchar,varchar,varchar,
                            varchar,timestamptz,integer, integer);
begin;

  select content_type__unregister_mime_type(
    'image',
    'image/jpeg'
  );

  select content_type__unregister_mime_type(
    'image',
    'image/gif'
  );

end;

-- remove image mime types

delete from cr_mime_types where mime_type like 'image%';



-- this should remove the attributes and table related to the 
-- the image type

begin;

  select content_type__drop_type (
    'image',
    'f',
    't');

end;