/**
* Set up the test database table.
*
* @param PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection $connection
*/
protected function setUpTable($connection)
{
$pdo = $connection->getConnection();
$sql = 'CREATE TABLE IF NOT EXISTS simple_table (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
address VARCHAR(100)
)';
$pdo->exec($sql);
$sql = 'CREATE TABLE IF NOT EXISTS books_array (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
book_id VARCHAR(50) NOT NULL,
info TEXT NOT NULL
)';
$pdo->exec($sql);
$sql = 'CREATE TABLE IF NOT EXISTS books_columns (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
author VARCHAR(100) NOT NULL,
title VARCHAR(100) NOT NULL,
genre VARCHAR(100) NOT NULL,
price VARCHAR(50) NOT NULL,
publish_date VARCHAR(50) NOT NULL,
description TEXT NOT NULL
)';
$pdo->exec($sql);
}