mysql/core_notify_trigger_after_update.sql
authorAlan Knowles <alan@roojs.com>
Tue, 18 Apr 2017 08:57:41 +0000 (16:57 +0800)
committerAlan Knowles <alan@roojs.com>
Tue, 18 Apr 2017 08:57:41 +0000 (16:57 +0800)
mysql/core_notify_trigger_after_update.sql

index bd8045f..0d343cc 100644 (file)
@@ -6,7 +6,7 @@ DELIMITER $$
  
 
 CREATE TRIGGER core_notify_trigger_after_update
-            BEFORE UPDATE ON core_notify
+            AFTER UPDATE ON core_notify
         FOR EACH ROW
         BEGIN
             -- make sure that act_start does not get modified if sent is set.