3 DROP TRIGGER IF EXISTS core_notify_trigger_after_update;
8 CREATE TRIGGER core_notify_trigger_after_update
9 AFTER UPDATE ON core_notify
12 -- make sure that act_start does not get modified if sent is set.
13 IF (OLD.sent IS NOT NULL AND OLD.sent != '0000-00-00 00:00:00')
14 AND ( NEW.act_start != OLD.act_start OR NEW.act_when != OLD.act_when ) THEN
15 UPDATE `Error: Can not update core_notify action dates after its sent` SET x = 1;