From dd4d2c38e5a0d943c02216a6b7e18ba25a798078 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 16 Apr 2015 13:26:00 +0800 Subject: [PATCH] mysql/core_enum_trigger_check.sql --- mysql/core_enum_trigger_check.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/mysql/core_enum_trigger_check.sql b/mysql/core_enum_trigger_check.sql index 2dac9b48..31422096 100644 --- a/mysql/core_enum_trigger_check.sql +++ b/mysql/core_enum_trigger_check.sql @@ -11,6 +11,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; + END; END; $$ -- 2.39.2