From: Alan Knowles Date: Thu, 16 Apr 2015 05:40:23 +0000 (+0800) Subject: mysql/core_enum_trigger_check.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=db7c8f734ec71d21754b8257b95d294a9132b966 mysql/core_enum_trigger_check.sql --- diff --git a/mysql/core_enum_trigger_check.sql b/mysql/core_enum_trigger_check.sql index e40cc858..65171c2d 100644 --- a/mysql/core_enum_trigger_check.sql +++ b/mysql/core_enum_trigger_check.sql @@ -12,7 +12,7 @@ CREATE PROCEDURE core_enum_trigger_check (i_etype VARCHAR(128) , i_id INT) 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 Does is Invalid` SET x = 1; END IF; END; $$