private function get_create_schema_and_user_queries()
{
$db_host = $this->handler_vars['db_host'];
$db_type = $this->handler_vars['db_type'];
$db_schema = $this->handler_vars['db_schema'];
$db_user = $this->handler_vars['db_user'];
$db_pass = $this->handler_vars['db_pass'];
$queries = array();
switch ($db_type) {
case 'mysql':
$queries[] = 'CREATE DATABASE ' . $db_schema . ';';
$queries[] = 'GRANT ALL ON ' . $db_schema . '.* TO \'' . $db_user . '\'@\'' . $db_host . '\' ' . 'IDENTIFIED BY \'' . $db_pass . '\';';
break;
case 'pgsql':
$queries[] = 'CREATE DATABASE ' . $db_schema . ';';
$queries[] = 'GRANT ALL ON DATABASE ' . $db_schema . ' TO ' . $db_user . ';';
break;
default:
die(_t('currently unsupported.'));
}
return $queries;
}