UpdateDatabase/MysqlLinks.php
authorAlan Knowles <alan@roojs.com>
Thu, 16 Apr 2015 05:14:53 +0000 (13:14 +0800)
committerAlan Knowles <alan@roojs.com>
Thu, 16 Apr 2015 05:14:53 +0000 (13:14 +0800)
UpdateDatabase/MysqlLinks.php

index 32eb393..c603854 100644 (file)
@@ -253,7 +253,17 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
                        
                     END IF;
                 ";
+                
+                
+                
+            }
+              $ar = $this->listTriggerFunctions($tbl, 'update');
+            foreach($ar as $fn=>$col) {
+                $trigger .= "
+                    CALL $fn( NEW.{$col});
+                ";
             }
+            
             $trigger .= "
             END 
            
@@ -318,6 +328,13 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
                     END IF;
                 ";
             }
+            $ar = $this->listTriggerFunctions($tbl, 'update');
+            foreach($ar as $fn=>$col) {
+                $trigger .= "
+                    CALL $fn(OLD.{$col}, NEW.{$col});
+                ";
+            }
+            
             $trigger .= "
             END