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

mysql/core_person_get_by_email.sql
---

diff --git a/mysql/core_person_get_by_email.sql b/mysql/core_person_get_by_email.sql
index a098e615..e272682a 100644
--- a/mysql/core_person_get_by_email.sql
+++ b/mysql/core_person_get_by_email.sql
@@ -1,8 +1,8 @@
 
-DROP FUNCTION IF EXISTS person_get_by_email;
+DROP FUNCTION IF EXISTS core_person_get_by_email;
 
 DELIMITER $$
-CREATE FUNCTION person_get_by_email(  
+CREATE FUNCTION core_person_get_by_email(  
         in_addr VARCHAR(254)
         
 
@@ -11,7 +11,7 @@ CREATE FUNCTION person_get_by_email(
         
         DECLARE v_id INT(11);
         SET v_id = 0;
-        SELECT id INTO v_id FROM Person WHERE email = in_addr LIMIT 1;
+        SELECT id INTO v_id FROM core_person WHERE email = in_addr LIMIT 1;
         RETURN v_id;
         
     END $$