6 DROP PROCEDURE IF EXISTS core_notify_recur_trigger_core_before_insert_method_id;
7 DROP TRIGGER IF EXISTS `core_notify_recur_before_insert_core` ;
11 CREATE PROCEDURE core_notify_recur_trigger_core_before_insert_method_id ( i_id INT)
14 CALL core_enum_trigger_check('core_notify_recur', i_id);
20 -- see if this can be done as a trigger
22 CREATE DEFINER=`root`@`localhost` TRIGGER `core_notify_recur_before_insert_core`
23 BEFORE INSERT ON `core_notify_recur`
26 IF (NEW.method_id > 0) THEN
27 CALL core_enum_trigger_check('core_notify_recur', NEW.method_id);