From 870e3ddfb5b77f55f586b3d67b11f510ae3df467 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:07:30 +0800 Subject: [PATCH] mysql/core_person_get_company.sql --- mysql/core_person_get_company.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/mysql/core_person_get_company.sql b/mysql/core_person_get_company.sql index a5dc09ec..3dcb8304 100644 --- a/mysql/core_person_get_company.sql +++ b/mysql/core_person_get_company.sql @@ -1,15 +1,15 @@ -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 ; -- 2.39.2