From 93f9bf8351832dec4e8c584a4ac3cec2fbb6dd68 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:03:47 +0800 Subject: [PATCH] MOVED mysql/companies_owner_create.sql to mysql/core_company_owner_create.sql --- mysql/core_company_owner_create.sql | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 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 -- 2.39.2