public function testBasicCreateTableWithPrefixPrimaryAndForeignKeysWithCascadeDelete()
{
$blueprint = new Blueprint('users');
$blueprint->create();
$blueprint->integer('id')->primary();
$blueprint->string('email');
$blueprint->integer('foo_id');
$blueprint->foreign('foo_id')->references('id')->on('orders')->onDelete('cascade');
$grammar = $this->getGrammar();
$grammar->setTablePrefix('prefix_');
$conn = $this->getConnection();
$statements = $blueprint->toSql($conn, $grammar);
$this->assertEquals(1, count($statements));
$this->assertEquals('create table prefix_users ( id number(10,0) not null, email varchar2(255) not null, foo_id number(10,0) not null, constraint users_foo_id_foreign foreign key ( foo_id ) references prefix_orders ( id ) on delete cascade, constraint users_id_primary primary key ( id ) )', $statements[0]);
}
