DROP FUNCTION IF EXISTS person_get_internal_id;

DELIMITER $$
CREATE FUNCTION person_get_internal_id(  
        in_addr VARCHAR(254)
        

    )  RETURNS INT(11) DETERMINISTIC
    BEGIN
        
        DECLARE v_id INT(11);
        DECLARE v_company_id INT(11);
        SET v_id = 0;
        SET v_company_id = 0;
        
        SELECT company_get_owner() INTO v_company_id;
        IF v_company_id < 1 THEN
            RETURN 0;
        END IF;
        
        SELECT id INTO v_id FROM Person WHERE
            company_id = v_company_id
            AND email = in_addr LIMIT 1;
        
        RETURN v_id;
        
    
        
        
    END $$
DELIMITER ;