From: Alan Knowles <alan@roojs.com>
Date: Tue, 11 Oct 2016 03:07:54 +0000 (+0800)
Subject: mysql/core_person_get_internal_id.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a07d0e5525b5fe23548ec4004fd2ce1f24e6d0a4

mysql/core_person_get_internal_id.sql
---

diff --git a/mysql/core_person_get_internal_id.sql b/mysql/core_person_get_internal_id.sql
index ee673b86..906fae6e 100644
--- a/mysql/core_person_get_internal_id.sql
+++ b/mysql/core_person_get_internal_id.sql
@@ -1,8 +1,8 @@
 
-DROP FUNCTION IF EXISTS person_get_internal_id;
+DROP FUNCTION IF EXISTS core_person_get_internal_id;
 
 DELIMITER $$
-CREATE FUNCTION person_get_internal_id(  
+CREATE FUNCTION core_person_get_internal_id(  
         in_addr VARCHAR(254)
         
 
@@ -14,12 +14,12 @@ CREATE FUNCTION person_get_internal_id(
         SET v_id = 0;
         SET v_company_id = 0;
         
-        SELECT company_get_owner() INTO v_company_id;
+        SELECT core_person_get_owner() INTO v_company_id;
         IF v_company_id < 1 THEN
             RETURN 0;
         END IF;
         
-        SELECT id INTO v_id FROM Person WHERE
+        SELECT id INTO v_id FROM core_person WHERE
             company_id = v_company_id
             AND email = in_addr LIMIT 1;