SqlToSchema.php

<?php
class ZendDbSchema_Filter_Db_Schema_Database_Mysql_SqlToSchema
    implements Zend_Filter_Interface
{
    protected $_asObject;

    public function __construct($asObject = true)
    {
        $this->_asObject = (bool) $asObject;
    }

    public function filter($value)
    {
        $schema = array();
        if (!empty($value)) {
            if (preg_match('|CREATE DATABASE `([\w\d\_\-]+)|i', $value, $matches)) {
                $schema[ZendDbSchema_Db_Schema_Database::NAME_KEY] = $matches['1'];
            }
            if (preg_match('|DEFAULT CHARACTER SET ([\w\d\_\-]+)|i', $value, $matches)) {
                $schema[ZendDbSchema_Db_Schema_Database::CHARSET_KEY] = $matches['1'];
            }
        }
        if (!$this->_asObject) {
            return $schema;
        }
        return new ZendDbSchema_Db_Schema_Database($schema[ZendDbSchema_Db_Schema_Database::NAME_KEY], $schema);
    }
}