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

mysql/core_company_owner_create.sql
---

diff --git a/mysql/core_company_owner_create.sql b/mysql/core_company_owner_create.sql
index 6ba25a40..0313cf78 100644
--- a/mysql/core_company_owner_create.sql
+++ b/mysql/core_company_owner_create.sql
@@ -1,20 +1,20 @@
 
-DROP FUNCTION  IF EXISTS companies_owner_create;
+DROP FUNCTION  IF EXISTS core_company_owner_create;
     
 DELIMITER $$
-CREATE FUNCTION companies_owner_create(in_code  VARCHAR(32) , in_name VARCHAR(64)) RETURNS VARCHAR(64) DETERMINISTIC
+CREATE FUNCTION core_company_owner_create(in_code  VARCHAR(32) , in_name VARCHAR(64)) RETURNS VARCHAR(64) DETERMINISTIC
 BEGIN
     DECLARE v_id INT(11);
     SET v_id = 0;
     #// check if person exists..
-    SELECT id INTO v_id FROM Companies
+    SELECT id INTO v_id FROM core_company
         WHERE comptype='OWNER' LIMIT 1;
 
     IF v_id  != 0 THEN
         RETURN CONCAT('DUPE - Company', in_name);
     END IF;
     
-    INSERT INTO Companies (code, name, comptype, comptype_id) VALUES (
+    INSERT INTO core_company (code, name, comptype, comptype_id) VALUES (
         in_code,in_name,'OWNER', core_enum_id_by_name('COMPTYPE', 'OWNER' )
     );