public function testCreateTables()
{
$this->cleanUpTables();
$createProductTable = new CreateTableQuery('products');
$createProductTable->column('id')->integer()->primary()->autoIncrement();
$createProductTable->column('name')->varchar(32);
$createProductTable->column('description')->text();
$createProductTable->column('created_by')->int();
$createProductTable->column('updated_by')->int();
$this->assertDriverQuery(new MySQLDriver(), $createProductTable);
$this->assertDriverQuery(new PgSQLDriver(), $createProductTable);
$createUserTable = new CreateTableQuery('users');
$createUserTable->column('id')->integer()->primary()->autoIncrement();
$this->assertDriverQuery(new MySQLDriver(), $createUserTable);
$this->assertDriverQuery(new PgSQLDriver(), $createUserTable);
$this->assertDriverQuery(new SQLiteDriver(), $createUserTable);
}