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

mysql/core_person_get_project_id.sql
---

diff --git a/mysql/core_person_get_project_id.sql b/mysql/core_person_get_project_id.sql
index 90fab7bb..a8934ac1 100644
--- a/mysql/core_person_get_project_id.sql
+++ b/mysql/core_person_get_project_id.sql
@@ -1,16 +1,16 @@
 
 
-DROP FUNCTION IF EXISTS person_get_project_id;
+DROP FUNCTION IF EXISTS core_person_get_project_id;
 
 DELIMITER $$
-CREATE FUNCTION person_get_project_id(  
+CREATE FUNCTION core_person_get_project_id(  
        in_id INT(11)
     )  RETURNS INT(11) DETERMINISTIC
     BEGIN
         
         DECLARE v_id INT(11);
         SET v_id = 0;
-        SELECT project_id INTO v_id FROM Person WHERE id  = in_id LIMIT 1;
+        SELECT project_id INTO v_id FROM core_person WHERE id  = in_id LIMIT 1;
         RETURN v_id;
     END $$