tequilarapido / appcli

        return static::$db_primarykeys[$table];

    }

    public static function textColumns($database)

    {

        $query = "SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS ";

        $query .= "WHERE 1 ";

        $query .= "AND TABLE_SCHEMA = ? ";

        $query .= "AND ( DATA_TYPE LIKE '%char%' OR DATA_TYPE LIKE '%text%' OR DATA_TYPE LIKE '%BLOB%' )";

        return Database::select($query, array($database));

    }

}

        }

    }

    public function getEngines($database)

    {

        $query = '';

        $query .= 'SELECT table_name, engine ';

        $query .= 'FROM   information_schema.tables ';

        $query .= 'WHERE table_schema = ? ';

        return Database::select($query, array($database));

    }

    /**

     * @param string $engine

        }

    }

    public function getCollations($database)

    {

        $query = '';

        $query .= 'SELECT table_name, table_collation ';

        $query .= 'FROM   information_schema.tables ';

        $query .= 'WHERE table_schema = ? ';

        return Database::select($query, array($database));

    }

    /**

     * @param string $collation