mysql/core_person_get_company.sql

diff --git a/mysql/core_person_get_company.sql b/mysql/core_person_get_company.sql
index a5dc09e..3dcb830 100644 (file)
--- 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 ;