-DROP FUNCTION IF EXISTS person_get_company;
+DROP FUNCTION IF EXISTS core_person_get_company;
DELIMITER $$
-CREATE FUNCTION person_get_company(
+CREATE FUNCTION core_person_get_company(
in_id INT(11)
) RETURNS INT(11) DETERMINISTIC
BEGIN
DECLARE v_id INT(11);
SET v_id = 0;
- SELECT company_id INTO v_id FROM Person WHERE id = in_id LIMIT 1;
+ SELECT company_id INTO v_id FROM core_person WHERE id = in_id LIMIT 1;
RETURN v_id;
END $$
DELIMITER ;