From: Alan Knowles <alan@roojs.com>
Date: Thu, 16 Apr 2015 05:32:37 +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=65848a00a62d114a6e6fceae7db20d3f581418c6

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 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;
 $$