From: Alan Knowles <alan@roojs.com>
Date: Tue, 18 Apr 2017 08:57:41 +0000 (+0800)
Subject: mysql/core_notify_trigger_after_update.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=6bd4d9b011513c557a4edb6dd94b268df32b647e

mysql/core_notify_trigger_after_update.sql
---

diff --git a/mysql/core_notify_trigger_after_update.sql b/mysql/core_notify_trigger_after_update.sql
index bd8045f0..0d343cc1 100644
--- a/mysql/core_notify_trigger_after_update.sql
+++ b/mysql/core_notify_trigger_after_update.sql
@@ -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.