Database.php

<?php
class ZendDbSchema_Db_Schema_Generator_Mysql_Database
    implements ZendDbSchema_Db_Schema_Generator_Database
{
    public function createDatabase(ZendDbSchema_Db_Schema_Database $schema)
    {
        $props = array();

        if ($schema->collate) {
            $props[] = "COLLATE " . $schema->collate;
        }
        if ($schema->getCharset()) {
            $props[] = "DEFAULT CHARACTER SET " . $schema->getCharset();
        }

        $name = $schema->getName();

        $query = array();
        $query[] = "DROP DATABASE IF EXISTS `{$name}`";
        $query[] = "CREATE DATABASE `{$name}` " . join(' ', $props);

        return join(';' . PHP_EOL, $query);
    }

    public function alterDatabase(ZendDbSchema_Db_Schema_Database $schema)
    {
        if (!$schema->isExist()) {
            return null;
        }

        $props = array();
        if ($schema->isDirty('collate')) {
            $props[] = "COLLATE " . $schema->collate;
        }
        if ($schema->getCharset()) {
            $props[] = "DEFAULT CHARACTER SET " . $schema->getCharset();
        }

        $query = '';
        if (!empty($props)) {
            $name = $schema->getName();
            $query = "ALTER DATABASE `{$name}` ".  join(' ', $props);
        }
        return $query;
    }

    public function dropDatabase(ZendDbSchema_Db_Schema_Database $schema)
    {
        if (!$schema->isExist()) {
            return null;
        }
        return "DROP DATABASE IF EXISTS {$schema->getOriginName()}";
    }
}