From d2b3aaf2bc829b180b0028de4bda58b9c1ff1fef Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 17 Nov 2014 14:51:53 +0800 Subject: [PATCH] mysql/companies_owner_create.sql --- mysql/companies_owner_create.sql | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) 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 -- 2.39.2