} $db = new PDO($dsn[0], $user, $pass); $conn = Doctrine_Manager::connection($db); $dbtable = $conn->fetchOne("SELECT schema_name FROM information_schema.schemata WHERE schema_name='" . $dbname . "'"); if (!$dbtable) { $sql = "CREATE DATABASE `" . $dbname . "` CHARACTER SET utf8;\n CREATE USER '" . $config['db.user'] . "'@'localhost' IDENTIFIED BY '" . $config['db.pass'] . "';\n GRANT ALL PRIVILEGES ON " . $dbname . ".* TO '" . $config['db.user'] . "'@'%' WITH GRANT OPTION;\n "; $db->exec($sql); } $conn->close(); $db = new PDO($config['db.dsn'], $config['db.user'], $config['db.pass']); $conn = Doctrine_Manager::connection($db); if (isset($google_user)) { echo 'user: '******'<br>'; } $migration = new Doctrine_Migration(__DIR__ . '/classes', $conn); $migration->setTableName('doctrine_migration_version'); if (isset($_REQUEST['ver']) && (!isset($google_user) || $google_user->getNickname() == '*****@*****.**')) { $version = 0 + intval($_REQUEST['ver']); } else { $classesKeys = array_keys($migration->getMigrationClasses()); $version = 0 + array_pop($classesKeys); } if (isset($_SERVER['HTTP_HOST'])) { echo '<h1>'; } if ($migration->getCurrentVersion() == $version) { echo 'Database at version ' . $version . PHP_EOL; } else { $migration->migrate($version); echo 'Migrated succesfully to version ' . $migration->getCurrentVersion() . PHP_EOL; }