public function testTableOptions()
{
$provider = $this->getProvider(['tl_member' => ['TABLE_OPTIONS' => 'ENGINE=MyISAM DEFAULT CHARSET=utf8']]);
$schema = $provider->createSchema();
$this->assertCount(1, $schema->getTableNames());
$this->assertTrue($schema->hasTable('tl_member'));
$this->assertEquals('MyISAM', $schema->getTable('tl_member')->getOption('engine'));
$this->assertEquals('utf8', $schema->getTable('tl_member')->getOption('charset'));
$provider = $this->getProvider([], ['tl_member' => ['TABLE_OPTIONS' => 'ENGINE=MyISAM DEFAULT CHARSET=utf8']]);
$schema = $provider->createSchema();
$this->assertCount(1, $schema->getTableNames());
$this->assertTrue($schema->hasTable('tl_member'));
$this->assertEquals('MyISAM', $schema->getTable('tl_member')->getOption('engine'));
$this->assertEquals('utf8', $schema->getTable('tl_member')->getOption('charset'));
$provider = $this->getProvider(['tl_member' => ['TABLE_OPTIONS' => 'ENGINE=InnoDB DEFAULT CHARSET=Latin1']]);
$schema = $provider->createSchema();
$this->assertCount(1, $schema->getTableNames());
$this->assertTrue($schema->hasTable('tl_member'));
$this->assertEquals('InnoDB', $schema->getTable('tl_member')->getOption('engine'));
$this->assertEquals('Latin1', $schema->getTable('tl_member')->getOption('charset'));
}