BEGIN
DECLARE v_cnt INT;
SET v_cnt = 0;
- SELECT count(*) INTO v_cnt WHERE etype = i_etype, id = i_id;
+ -- should this check active???
+
+ SELECT count(*) INTO v_cnt FROM core_enum WHERE etype = i_etype AND id = i_id;
+
IF (v_cnt < 1) THEN
- UPDATE `Core Enum Does not exist` SET x = 1;
+ UPDATE `Error: Refered Core Enum is Invalid` SET x = 1;
+ END IF;
END;
$$