--
-- Implementation of the profile provider interface for users.
--
-- @author <a href="mailto:yon@openforce.net">yon@openforce.net</a>
-- @version $Id: user-profile-provider-drop.sql,v 1.3 2014/10/27 16:42:00 victorg Exp $
--

CREATE OR REPLACE FUNCTION inline_0() RETURNS integer AS $$
BEGIN

    -- drop the binding between this implementation and the interface it
    -- implements.
    perform acs_sc_binding__delete (
        'profile_provider',
        'user_profile_provider'
    );

    -- drop the bindings to the method implementations

    -- name method
    perform acs_sc_impl_alias__delete (
        'profile_provider',
        'user_profile_provider',
        'name'
    );

    -- prettyName method
    perform acs_sc_impl_alias__delete (
        'profile_provider',
        'user_profile_provider',
        'prettyName'
    );

    -- render method
    perform acs_sc_impl_alias__delete (
        'profile_provider',
        'user_profile_provider',
        'render'
    );

    -- drop the implementation
    perform acs_sc_impl__delete(
        'profile_provider',
        'user_profile_provider'
    );

    return 0;

END;
$$ LANGUAGE plpgsql;

select inline_0();
drop function inline_0();