X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=mysql%2Fcompanies_owner_create.sql;h=6ba25a40abb281b5bd54b9109a1c0a287779159c;hb=d2b3aaf2bc829b180b0028de4bda58b9c1ff1fef;hp=e69de29bb2d1d6434b8b29ae775ad8c2e48c5391;hpb=c5b133c91b11974922cd455e934476eab26cbdd9;p=Pman.Core

diff --git a/mysql/companies_owner_create.sql b/mysql/companies_owner_create.sql
index e69de29b..6ba25a40 100644
--- a/mysql/companies_owner_create.sql
+++ b/mysql/companies_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