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

mysql/core_company_get_by_name.sql
---

diff --git a/mysql/core_company_get_by_name.sql b/mysql/core_company_get_by_name.sql
index dae31df9..1b85d2ca 100644
--- a/mysql/core_company_get_by_name.sql
+++ b/mysql/core_company_get_by_name.sql
@@ -1,12 +1,12 @@
 
  
-DROP FUNCTION IF EXISTS company_get_by_name;
+DROP FUNCTION IF EXISTS core_company_get_by_name;
 DELIMITER $$
-CREATE FUNCTION company_get_by_name(in_name VARCHAR(128))  RETURNS INT(11) DETERMINISTIC
+CREATE FUNCTION core_company_get_by_name(in_name VARCHAR(128))  RETURNS INT(11) DETERMINISTIC
     BEGIN
         DECLARE v_ret INT(11);
         SET v_ret= 0;
-        SELECT id    INTO v_ret  FROM Companies WHERE name = in_name LIMIT 1;
+        SELECT id    INTO v_ret  FROM core_company WHERE name = in_name LIMIT 1;
         RETURN v_ret;
     END $$
 DELIMITER ; 
\ No newline at end of file