From 65848a00a62d114a6e6fceae7db20d3f581418c6 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 16 Apr 2015 13:32:37 +0800 Subject: [PATCH] mysql/core_notify_recur_trigger_core_before_insert_method_id.sql --- ...r_trigger_core_before_insert_method_id.sql | 19 +++++++------------ 1 file changed, 7 insertions(+), 12 deletions(-) diff --git a/mysql/core_notify_recur_trigger_core_before_insert_method_id.sql b/mysql/core_notify_recur_trigger_core_before_insert_method_id.sql index f57d2027..40c44682 100644 --- a/mysql/core_notify_recur_trigger_core_before_insert_method_id.sql +++ b/mysql/core_notify_recur_trigger_core_before_insert_method_id.sql @@ -1,25 +1,20 @@ -core_notify_recur_trigger_core_before_insert - - + -DROP PROCEDURE IF EXISTS core_notify_recur_trigger_core_before_insert; +DROP PROCEDURE IF EXISTS core_notify_recur_trigger_core_before_insert_method_id; DELIMITER $$ -CREATE PROCEDURE core_enum_trigger_check (i_etype VARCHAR(128) , i_id INT) +CREATE PROCEDURE core_notify_recur_trigger_core_before_insert_method_id ( i_id INT) BEGIN - DECLARE v_cnt INT; - SET v_cnt = 0; - -- should this check active??? + IF (i_id< 1) THEN + RETURN + END IF; + CALL core_enum_trigger_check('core_notify_recur', i_id); - 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 IF; END; $$ -- 2.39.2