From f06051951d52006d0027f995c1277e9439a36dd2 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Thu, 16 Apr 2015 13:15:23 +0800
Subject: [PATCH] UpdateDatabase/MysqlLinks.php

---
 UpdateDatabase/MysqlLinks.php | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php
index c6038542..829293f3 100644
--- a/UpdateDatabase/MysqlLinks.php
+++ b/UpdateDatabase/MysqlLinks.php
@@ -193,6 +193,14 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
                     END IF;
                 ";
             }
+            
+            $ar = $this->listTriggerFunctions($tbl, 'delete');
+            foreach($ar as $fn=>$col) {
+                $trigger .= "
+                    CALL $fn( OLD.{$col});
+                ";
+            }
+            
             $trigger .= "
             END 
            
@@ -257,7 +265,7 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
                 
                 
             }
-              $ar = $this->listTriggerFunctions($tbl, 'update');
+            $ar = $this->listTriggerFunctions($tbl, 'insert');
             foreach($ar as $fn=>$col) {
                 $trigger .= "
                     CALL $fn( NEW.{$col});
-- 
2.39.2