2 DROP FUNCTION IF EXISTS companies_owner_create;
5 CREATE FUNCTION companies_owner_create(in_code VARCHAR(32) , in_name VARCHAR(64)) RETURNS VARCHAR(64) DETERMINISTIC
9 #// check if person exists..
10 SELECT id INTO v_id FROM Companies
11 WHERE comptype='OWNER' LIMIT 1;
14 RETURN CONCAT('DUPE - Company', in_name);
17 INSERT INTO Companies (code, name, comptype, comptype_id) VALUES (
18 in_code,in_name,'OWNER', core_enum_id_by_name('COMPTYPE', 'OWNER' )