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

MOVED mysql/companies_owner_create.sql to mysql/core_company_owner_create.sql
---

diff --git a/mysql/core_company_owner_create.sql b/mysql/core_company_owner_create.sql
new file mode 100644
index 00000000..6ba25a40
--- /dev/null
+++ b/mysql/core_company_owner_create.sql
@@ -0,0 +1,23 @@
+
+DROP FUNCTION  IF EXISTS companies_owner_create;
+    
+DELIMITER $$
+CREATE FUNCTION companies_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
+        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 (
+        in_code,in_name,'OWNER', core_enum_id_by_name('COMPTYPE', 'OWNER' )
+    );
+        
+    RETURN 'ADDED';
+END $$
+DELIMITER ;
\ No newline at end of file