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 dae31df..1b85d2c 100644 (file)
--- 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