public function create_trigger($row)
{
$ret = "";
if (!isset($row['SQL Original Statement'])) {
throw new Exception("Error getting trigger code, unknown output");
}
$triggerStmt = $row['SQL Original Statement'];
$triggerStmtReplaced = str_replace("CREATE DEFINER", "/*!50003 CREATE*/ /*!50017 DEFINER", $triggerStmt);
$triggerStmtReplaced = str_replace(" TRIGGER", "*/ /*!50003 TRIGGER", $triggerStmtReplaced);
if (false === $triggerStmtReplaced) {
$triggerStmtReplaced = $triggerStmt;
}
$ret .= "DELIMITER ;;" . PHP_EOL . $triggerStmtReplaced . "*/;;" . PHP_EOL . "DELIMITER ;" . PHP_EOL . PHP_EOL;
return $ret;
}