From: Alan Knowles <alan@roojs.com>
Date: Thu, 16 Apr 2015 05:33:04 +0000 (+0800)
Subject: mysql/core_notify_recur_trigger_core_before_insert_method_id.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=60d0993310f7c49d163a07d71690d92b1dfe889d

mysql/core_notify_recur_trigger_core_before_insert_method_id.sql
---

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 40c44682..d80fd62a 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
@@ -9,11 +9,9 @@ DELIMITER $$
  
 CREATE PROCEDURE core_notify_recur_trigger_core_before_insert_method_id ( i_id INT)
  BEGIN
-    IF (i_id< 1) THEN
-        RETURN
+    IF (i_id > 0) THEN
+        CALL core_enum_trigger_check('core_notify_recur', i_id);
     END IF;
-    CALL core_enum_trigger_check('core_notify_recur', i_id);
-    
     
  END;
 $$