protected function getConnection($db = 'shim_test')
{
$mysql = mysql_connect(static::$host, 'root');
$this->assertConnection($mysql);
mysql_query("SET NAMES latin1");
$result = mysql_query("CREATE DATABASE IF NOT EXISTS `{$db}` CHARACTER SET latin1;");
$this->assertTrue($result);
$result = mysql_select_db($db);
$this->assertTrue($result);
$result = mysql_query("CREATE TABLE IF NOT EXISTS testing (\n id int AUTO_INCREMENT,\n one varchar(255),\n two varchar(255),\n three varchar(255),\n four varchar(255),\n five varchar(255),\n six varchar(255),\n seven varchar(255),\n eight varchar(255),\n nine ENUM('one', 'two', '\\'three'),\n ten SET('one', 'two', '\\'\\'three'),\n eleven MEDIUMTEXT,\n INDEX one_idx (one),\n UNIQUE INDEX two_unq (two),\n INDEX three_four_idx (three, four),\n UNIQUE INDEX four_five_unq (four, five),\n INDEX seven_eight_idx (seven, eight),\n UNIQUE INDEX seven_eight_unq (seven, eight),\n PRIMARY KEY (id)\n ) CHARACTER SET latin1;");
$result = mysql_query("CREATE TABLE IF NOT EXISTS testing2 (\n id int AUTO_INCREMENT,\n one varchar(255),\n two varchar(255),\n three varchar(255),\n four varchar(255),\n five varchar(255),\n six varchar(255),\n seven varchar(255),\n eight varchar(255),\n nine ENUM('one', 'two', '\\'three'),\n ten SET('one', 'two', '\\'\\'three'),\n eleven MEDIUMTEXT,\n INDEX one_idx (one),\n UNIQUE INDEX two_unq (two),\n INDEX three_four_idx (three, four),\n UNIQUE INDEX four_five_unq (four, five),\n INDEX seven_eight_idx (seven, eight),\n UNIQUE INDEX seven_eight_unq (seven, eight),\n PRIMARY KEY (id)\n ) CHARACTER SET latin1;");
if ($db !== null) {
$this->assertTrue(mysql_select_db($db));
}
return $mysql;
}