END IF;
";
+
+
+
+ }
+ $ar = $this->listTriggerFunctions($tbl, 'update');
+ foreach($ar as $fn=>$col) {
+ $trigger .= "
+ CALL $fn( NEW.{$col});
+ ";
}
+
$trigger .= "
END
END IF;
";
}
+ $ar = $this->listTriggerFunctions($tbl, 'update');
+ foreach($ar as $fn=>$col) {
+ $trigger .= "
+ CALL $fn(OLD.{$col}, NEW.{$col});
+ ";
+ }
+
$trigger .= "
END