2 DROP FUNCTION IF EXISTS core_person_get_action_type;
5 CREATE FUNCTION core_person_get_action_type(in_id INT(11)) RETURNS VARCHAR(32) DETERMINISTIC
8 DECLARE v_ret VARCHAR(32);
10 SELECT action_type INTO v_ret FROM core_person WHERE id = in_id LIMIT 1;