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

index c603854..829293f 100644 (file)
@@ -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});