From df9fe2386417df4b7e61f6fab006dbbb9a3ee7dc Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 16 Apr 2015 15:40:09 +0800 Subject: [PATCH] mysql/core_notify_recur_trigger_core_before_insert_method_id.sql --- ..._recur_trigger_core_before_insert_method_id.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) 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 d80fd62a..ee05f4b3 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 @@ -4,6 +4,7 @@ DROP PROCEDURE IF EXISTS core_notify_recur_trigger_core_before_insert_method_id; +DROP TRIGGER IF EXISTS `core_notify_recur_before_insert_core` ; DELIMITER $$ @@ -14,6 +15,19 @@ CREATE PROCEDURE core_notify_recur_trigger_core_before_insert_method_id ( i_id I END IF; END; + + +-- see if this can be done as a trigger + +CREATE DEFINER=`root`@`localhost` TRIGGER `core_notify_recur_before_insert_core` + BEFORE INSERT ON `core_notify_recur` + FOR EACH ROW + + IF (NEW.method_id > 0) THEN + CALL core_enum_trigger_check('core_notify_recur', NEW.method_id); + END IF; + + END; $$ DELIMITER ; -- 2.39.2