From d1dfb9c8abb1fe9d4bfe1d57a2bd8415aa218ed2 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:07:07 +0800 Subject: [PATCH] mysql/core_person_get_by_email.sql --- mysql/core_person_get_by_email.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) 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 $$ -- 2.39.2