-- Classified Ads Package
--
-- @author Deds Castillo (deds@infiniteinfo.com)
-- @creation-date 2002-10-08
-- @cvs-id $Id: ads-create.sql,v 1.3 2003/07/25 23:53:19 rmello Exp $
--

create function inline_0 ()
returns integer as'
declare 
    v_attribute_id      ca_attributes.attribute_id%TYPE;
begin

-- create the content type
    PERFORM content_type__create_type (
        ''ca_ad'',                      -- object_type
	    ''content_revision'',           -- supertype
        ''Classified Ad'',              -- pretty_name
        ''Classified Ads'',             -- pretty_plural
        ''cr_ca_ads'',                  -- table_name
        ''ad_id'',                      -- id_column
        ''ca_ads__name''                -- name_method
    );
    
-- register mime_types

    PERFORM content_type__register_mime_type (
        ''ca_ad'',                      -- content_type
	    ''text/plain''                  -- mime_type
    );

    PERFORM content_type__register_mime_type (
        ''ca_ad'',                      -- content_type
	    ''text/html''                   -- mime_type
    );

    return null;
end;' language 'plpgsql';

select inline_0();
drop function inline_0();