ifsnop / mysqldump-php

        return $ret;

    }

    public function create_view($row)

    {

        $ret = "";

        if (!isset($row['Create View'])) {

                throw new Exception("Error getting view structure, unknown output");

        }

        $viewStmt = $row['Create View'];

        $definerStr = $this->dumpSettings['skip-definer'] ? '' : '/*!50013 \2 */'.PHP_EOL;

        if ($viewStmtReplaced = preg_replace(

            '/^(CREATE(?:\s+ALGORITHM=(?:UNDEFINED|MERGE|TEMPTABLE))?)\s+('

            .self::DEFINER_RE.'(?:\s+SQL SECURITY DEFINER|INVOKER)?)?\s+(VIEW .+)$/',

            '/*!50001 \1 */'.PHP_EOL.$definerStr.'/*!50001 \3 */',

            $viewStmt,

            1

        )) {

            $viewStmt = $viewStmtReplaced;

        };

        $ret .= $viewStmt . ';' . PHP_EOL . PHP_EOL;

        return $ret;

    }

    public function create_trigger($row)

    {

        return $ret;

    }

    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'];

        $definerStr = $this->dumpSettings['skip-definer'] ? '' : '/*!50017 \2*/ ';

        if ($triggerStmtReplaced = preg_replace(

            '/^(CREATE)\s+('.self::DEFINER_RE.')?\s+(TRIGGER\s.*)$/s',

            '/*!50003 \1*/ '.$definerStr.'/*!50003 \3 */',

            $triggerStmt,

            1

        )) {

            $triggerStmt = $triggerStmtReplaced;

        }

        $ret .= "DELIMITER ;;" . PHP_EOL .

            $triggerStmt . ";;" . PHP_EOL .

            "DELIMITER ;" . PHP_EOL . PHP_EOL;

        return $ret;

    }

    public function create_procedure($row)

    {