ifsnop / mysqldump-php

        return $ret;

    }

    public function show_tables()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "SELECT TABLE_NAME AS tbl_name " .

            "FROM INFORMATION_SCHEMA.TABLES " .

            "WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='${args[0]}'";

    }

    public function show_views()

    {

            "WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='${args[0]}'";

    }

    public function show_views()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "SELECT TABLE_NAME AS tbl_name " .

            "FROM INFORMATION_SCHEMA.TABLES " .

            "WHERE TABLE_TYPE='VIEW' AND TABLE_SCHEMA='${args[0]}'";

    }

    public function show_triggers()

    {

        return "SHOW COLUMNS FROM `${args[0]}`;";

    }

    public function show_procedures()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "SELECT SPECIFIC_NAME AS procedure_name " .

            "FROM INFORMATION_SCHEMA.ROUTINES " .

            "WHERE ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA='${args[0]}'";

    }

    /**

     * Get query string to ask for names of events from current database.

     * @param string Name of database

     * @return string

     */

    public function show_events()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "SELECT EVENT_NAME AS event_name " .

            "FROM INFORMATION_SCHEMA.EVENTS " .

            "WHERE EVENT_SCHEMA='${args[0]}'";

    }

    public function setup_transaction()

    {

        return "UNLOCK TABLES;" . PHP_EOL;

    }

    public function start_add_disable_keys()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "/*!40000 ALTER TABLE `${args[0]}` DISABLE KEYS */;" .

            PHP_EOL;

    }

    public function end_add_disable_keys()

    {

            PHP_EOL;

    }

    public function end_add_disable_keys()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "/*!40000 ALTER TABLE `${args[0]}` ENABLE KEYS */;" .

            PHP_EOL;

    }

    public function start_disable_autocommit()

    {

        return "COMMIT;" . PHP_EOL;

    }

    public function add_drop_database()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "/*!40000 DROP DATABASE IF EXISTS `${args[0]}`*/;" .

            PHP_EOL . PHP_EOL;

    }

    public function add_drop_trigger()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        return "DROP TABLE IF EXISTS `${args[0]}`;" . PHP_EOL;

    }

    public function drop_view()

    {

        $this->check_parameters(func_num_args(), $expected_num_args = 1, __METHOD__);

        $args = func_get_args();

        return "DROP TABLE IF EXISTS `${args[0]}`;" . PHP_EOL .

                "/*!50001 DROP VIEW IF EXISTS `${args[0]}`*/;" . PHP_EOL;

    }

    public function getDatabaseHeader()

    {