2 DROP FUNCTION IF EXISTS core_person_get_internal_id;
5 CREATE FUNCTION core_person_get_internal_id(
9 ) RETURNS INT(11) DETERMINISTIC
13 DECLARE v_company_id INT(11);
17 SELECT core_person_get_owner() INTO v_company_id;
18 IF v_company_id < 1 THEN
22 SELECT id INTO v_id FROM core_person WHERE
23 company_id = v_company_id
24 AND email = in_addr LIMIT 1;