CREATE DEFINER=`jhise`@`localhost` PROCEDURE `get_default_organization`(in i_hostname varchar(255))
BEGIN

    select id as organization_id from organization where url = i_hostname;

END
