From 42617f7be58eeb8e63d82685609400a438697256 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 28 Nov 2016 11:58:44 +0800 Subject: [PATCH] mysql/core_notify_trigger_after_update.sql --- mysql/core_notify_trigger_after_update.sql | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) diff --git a/mysql/core_notify_trigger_after_update.sql b/mysql/core_notify_trigger_after_update.sql index 6f4a37df..71f65483 100644 --- a/mysql/core_notify_trigger_after_update.sql +++ b/mysql/core_notify_trigger_after_update.sql @@ -9,6 +9,15 @@ CREATE TRIGGER core_notify_trigger_after_update BEFORE UPDATE ON core_notify FOR EACH ROW BEGIN - DECLARE mid INT(11); - IF (@DISABLE_TRIGGER IS NULL AND @DISABLE_TRIGGER_{$tbl} IS NULL ) THEN - \ No newline at end of file + -- make sure that act_start does not get modified if sent is set. + IF OLD.sent IS NOT NULL AND NEW.act_start != OLD.act_start THEN + UPDATE `Error: Can not update core_notify act_start after its set` SET x = 1; + END IF; + END; + +$$ + + +DELIMITER ; + + \ No newline at end of file -- 2.39.2